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>='1471737600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 8/26/2016
ID: 3721
Name: Avery
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Last seen on NW 2nd pl Ankeny She's very loved and missed by her whole family but especially by my daughter. She is declawed in the front. Slipped out back door and escaped fenced in yard. Please let us know if u see her
Des Moines - North
Lost: 8/26/2016
ID: 3718
Name: Gus
Type: Dog
Color: Black
Breed: Dachshund Long Haired
Gender: Male
Fixed: Neutered
Age: Adult
Highland Memorial Cemetery. Might be with another brown dog named Lady
Des Moines - North
Lost: 8/26/2016
ID: 3717
Name: Lady
Type: Dog
Color: Brown/Tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Adult
Highland Memorial Cemetery. Might be with a small black dog named Gus
Waukee
Lost: 8/25/2016
ID: 3716
Name: Roxi
Type: Dog
Color: Black
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 8/25/2016
ID: 3712
Name: Evee
Type: Dog
Color: Brown, White, Grey, Black
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
She was last seen around the Harding Hills/MLK Jr Pkwy Hy-vee parking lot. Please contact me as she need eye drops daily! 515-729-9109
Bondurant
Lost: 8/25/2016
ID: 3709
Name: Emily
Type: Cat
Color: Grey
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
One of her eyes turn in to her nose.
Des Moines - East
Lost: 8/24/2016
ID: 3720
Name: Lucky
Type: Dog
Color: Black
Breed: Pinscher
Gender: Male
Fixed: Neutered
Age: Young
On Prospect Rd Des Moines, IA 50310
Des Moines - West
Lost: 8/24/2016
ID: 3719
Name: Lucky
Type: Dog
Color: Black
Breed: Pinscher
Gender: Male
Fixed: Neutered
Age: Young
On Prospect Rd Des Moines, IA. 50310
West Des Moines
Lost: 8/24/2016
ID: 3704
Name: Stella
Type: Dog
Color: White w brown markings
Breed: Jack Russell Terrier
Gender: Unknown
Fixed: Unknown
Age: Baby
Near Ashworth and 19th St
West Des Moines
Lost: 8/24/2016
ID: 3702
Name: Gage
Type: Dog
Color: Red/light & white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Senior
Vine & 22nd -- Gage has limp walking with hind legs. His talk sounds like a growl, its just his friendly Husky woo. Bi-eyes (one amber & one blue eye). 330-1512 .