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>='1430352000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 5/5/2015
ID: 473
Name: Rosy
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Female
Fixed: Neutered
Age: Adult
She has special medical needs. Please help us find her. She was last seen on our backyard. Near at Anthony Catholic Church, around the Indianola rd area
Des Moines - East
Lost: 5/5/2015
ID: 470
Name: Ol’Lady
Type: Dog
Color: white/brown/black
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Not Applicable
Age: Senior
got out this morning. Dog is hard of hearing and cannot see well.
Windsor Heights
Lost: 5/5/2015
ID: 467
Name: Gracie
Type: Dog
Color: Reddish, brown, white feet. Skinny. Very skittish and shy.
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen at 66th and Colby in WIndsor Heights. Very shy. Answers to Gracie.
Colfax
Lost: 5/4/2015
ID: 465
Name: Puppy
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Female
Fixed: Unknown
Age: Adult
She does have a bad eye she is blind in. She bolted out the door during the storm when she got scared.
West Des Moines
Lost: 5/3/2015
ID: 462
Name: Lexi
Type: Cat
Color: Black/Gray
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Near our home, evening of Sunday May 3rd. She is declawed in the front, spunky, no collar.
Des Moines - North
Lost: 5/3/2015
ID: 459
Name: Patches
Type: Cat
Color: Multi colored spots
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Senior
She is a tiny very light weight cat that has been shaved on her lower back for hair balls. She has hyperthyroid condition which is treated twice daily. Has not been here since Saturday night when she wanted to go out. She is a feral cat born here outside but has had all of her shots and has been treated by the vet recently. Very friendly in her elder years. She has been inside most of the time and only ventures out on occasion.
Bondurant
Lost: 5/3/2015
ID: 458
Name: Murphy
Type: Dog
Color: tan/cream
Breed: Wheaten Terrier
Gender: Male
Fixed: Neutered
Age: Adult
72nd st. on Altoona/Bondurant borders
Ankeny
Lost: 5/3/2015
ID: 456
Name: winston was found
Type: Dog
Color:
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 5/3/2015
ID: 455
Name: winston
Type: Dog
Color: brown white and a little black
Breed: Pekingese
Gender: Male
Fixed: Neutered
Age: Baby
in my backyard
Des Moines - North
Lost: 5/2/2015
ID: 466
Name: Posie
Type: Cat
Color: Tortoiseshell
Breed: Pekingese
Gender: Female
Fixed: Not Neutered
Age: Young
In the Drake neighborhood. She is an absolute sweetheart, and very talkative.