Filter By
     
SELECT * FROM ipa_wp_posts LEFT JOIN ipa_wp_postmeta AS pm ON( ipa_wp_posts.ID = pm.post_id AND pm.meta_key = 'pet_listings_listing_type' ) LEFT JOIN ipa_wp_postmeta AS pm1 ON( ipa_wp_posts.ID = pm1.post_id AND pm1.meta_key = 'pet_listings_date_lost_found' ) LEFT JOIN ipa_wp_postmeta AS pm2 ON( ipa_wp_posts.ID = pm2.post_id AND pm2.meta_key = 'pet_listings_listing_status' ) LEFT JOIN ipa_wp_postmeta AS pm3 ON( ipa_wp_posts.ID = pm3.post_id AND pm3.meta_key = 'pet_listings_shelterid' ) WHERE ipa_wp_posts.post_status = 'publish' AND ipa_wp_posts.post_type = 'pet_listings' AND pm.meta_value = 'lost' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Dubuque
Lost: 6/8/2017
ID: 5836
Name: Coconut
Type: Cat
Color: Tortoiseshell (mostly black with brown mix)
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Last seen on Jessica Lane, off Old Dubuque Rd in Dubuque County south of Dubuque. She is a very curious, friendly, petite young cat.
West Des Moines
Lost: 6/8/2017
ID: 5812
Name: Casper
Type: Cat
Color: White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Accidentally let outside from Hamlet Apartments
Des Moines - North
Lost: 6/8/2017
ID: 5809
Name: King
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Baby
Over by Walgreens in Euclid and Cambridge
Des Moines - Central
Lost: 6/7/2017
ID: 6190
Name: Watermelon
Type: Cat
Color: Gray Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She's part of a barn and she's lost. Anything could have happened in the woods but we're hoping someone just thought she was lost and picked her up. Extremely friendly.
Altoona
Lost: 6/7/2017
ID: 5829
Name: Chopper Houdini
Type: Dog
Color: Brindle
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Wilton
Lost: 6/7/2017
ID: 5797
Name: Paulie
Type: Dog
Color: white
Breed: French Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
around 3:30 2146 Spicer Ave $500 reward
West Des Moines
Lost: 6/7/2017
ID: 3447
Name: Dezzie
Type: Dog
Color: Tan
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Dezzie has been missing since 7/17/16 Sunday morning early hours 3-5 AM. West of Valley Junction - Grand & Railroad. Pit bull mix, female, 2 years, light gold/yellow short-hair. Friendly, sweet and thinks she's a husky (like her house-dog-pal Gage) and mimics-howls at sirens. Gage and Dezzie got out our back fence and Gage came back alone. We have her collar and tags, so she is without any ID and does not have a chip. We really miss her. If you have any information, please let us know.
Altoona
Lost: 6/6/2017
ID: 5796
Name: Bear
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
Bear is 10 months old. Last seen in altoona behind medicap
Des Moines - East
Lost: 6/5/2017
ID: 5821
Name: Suzy Snowflake
Type: Cat
Color: Off white with dark ears
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Young
Photo shows cat younger, she's about a year older now
West Des Moines
Lost: 6/5/2017
ID: 5792
Name: Ronnie
Type: Cat
Color: Calico
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
805 28th street
Des Moines - East
Lost: 6/5/2017
ID: 5780
Name: Annie
Type: Dog
Color: Black
Breed: Cockapoo
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on lay st behind hyvee. She's a runner. Unless she wants to come to you if you run at her she will run. She loves car rides and food. Easiest way to get her to come. She's loving and loves children
Perry
Lost: 6/4/2017
ID: 5924
Name: Leah
Type: Cat
Color: BrownTabby
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Her home is on 3rd street.
Des Moines - South
Lost: 6/4/2017
ID: 5802
Name: Angel
Type: Cat
Color: Gray and peach
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Senior
1300 block of Leland Ave.
Urbandale
Lost: 6/4/2017
ID: 5776
Name: Pickles
Type: Dog
Color: White and Brown
Breed: Akita
Gender: Male
Fixed: Neutered
Age: Senior
Was last seen running in Urbandale off of 128th and Aurora. Pickles is very fearful and does not do well cornered. Did have collar with tags on. Do not chase.
Marion
Lost: 6/4/2017
ID: 5772
Name: Tony
Type: Cat
Color: Gray and black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Senior
Ankeny
Lost: 6/3/2017
ID: 5774
Name: Larry
Type: Cat
Color: Gray & Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Senior
Has all his claws, very friendly, loves his neck scratched.
Des Moines - East
Lost: 6/3/2017
ID: 5767
Name: Smiley
Type: Dog
Color: White and Gold missing part of her bottom lip
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen on E 34th Street
Waukee
Lost: 6/3/2017
ID: 5763
Name: Beacon
Type: Dog
Color: Black/White/Grey
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in Waukee in the Williams Pointe neighborhood. He is a senior dog and skiddish. Very sweet but has major separation anxiety and won't eat if not with his family. Microchipped and his vet is Broderick Animal Clinic in Waukee. Please call us 515-419-2721 if found.
Des Moines - Central
Lost: 6/2/2017
ID: 6057
Name: Lucy
Type: Dog
Color: White
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Very friendly. Has a brother who deeply misses her named kimbo. Loves to play.
Des Moines - East
Lost: 6/2/2017
ID: 5784
Name: Mowgli
Type: Cat
Color: Tan/brown/white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in our driveway. E 36th & University. My mom went to pick him up & he took off.
West Des Moines
Lost: 6/2/2017
ID: 5777
Name: Ashes
Type: Cat
Color: Solid Grey
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Very skiddish, likes to hint mice and birds. Name is Ashes. Has a broken tail - it has a bend in it.
Des Moines - East
Lost: 6/2/2017
ID: 5761
Name: Tator
Type: Dog
Color: Brown, black
Breed: Yorkie Poo
Gender: Male
Fixed: Unknown
Age: Adult
1800 Capitol Ave, Des Moines, ia
Altoona
Lost: 6/2/2017
ID: 5755
Name: Dink
Type: Cat
Color: Black and grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Pleasantville
Lost: 6/2/2017
ID: 5749
Name: Smalls
Type: Dog
Color: Wheaton
Breed: Irish Wolfhound
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 6/1/2017
ID: 10194
Name: Maestro
Type: Dog
Color: Gold and white
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Young
His hair had grown in. Very friendly dog. Lost on the East side of town, by the Union Park. Family has papers on dog and have been looking but recently moved making it harder for dog to find his way home.