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>='1500336000')) ORDER BY pm1.meta_value DESC, post_date DESC
Polk City
Lost: 7/23/2017
ID: 6257
Name: Wrigley
Type: Dog
Color:
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Little chubbier than in the pictured. Cataracts in both eyes.
Des Moines - South
Lost: 7/23/2017
ID: 6256
Name: Skip
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Our Boston Terrier ran off from our SW side home early this afternoon. Our mobile is 515-867-668. Thank you.
Ankeny
Lost: 7/23/2017
ID: 6254
Name: Toby
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Baby
We live in the villages off of deleware in ankeny. A friend thought she shut the door but it didn't get closed all the way, & a curious kitten snuck out!! Very loving baby. We miss him so much already!
Oskaloosa
Lost: 7/22/2017
ID: 6252
Name: Buster
Type: Dog
Color:
Breed: Saint Bernard
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen on A Avenue in Oskaloosa around 10 pm
West Des Moines
Lost: 7/21/2017
ID: 6248
Name: Jessie
Type: Dog
Color: Tri color
Breed: Treeing Walker Coonhound
Gender: Female
Fixed: Unknown
Age: Senior
Wiggled out of collar, last seen around noon. Around 42nd and Woodland Ave
Mingo
Lost: 7/21/2017
ID: 6247
Name: Bubba
Type: Cat
Color: Seal point mix
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Baby
210 Davenport St Mingo
Des Moines - South
Lost: 7/21/2017
ID: 6244
Name: Sunni
Type: Cat
Color: Grey
Breed: Siamese
Gender: Female
Fixed: Not Neutered
Age: Young
Near SE 2nd St/ Indianola Road
Des Moines - West
Lost: 7/21/2017
ID: 6240
Name: Logan
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Was in his pin, checked on him and he was gone. His name is Logan and he is very friendly.
Cedar Rapids
Lost: 7/20/2017
ID: 6239
Name: Olivia
Type: Cat
Color: Gray
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
We last saw her in that house around 4:30pm-5:00pm
Stuart
Lost: 7/19/2017
ID: 6250
Name: Joe
Type: Cat
Color: Gray
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young