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 = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1594080000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 7/11/2020
Animal ID: 189282
Urbandale
Found: 7/10/2020
ID: 14471
Name:
Type: Dog
Color: Brown and Tan
Breed: Hound
Gender: Female
Fixed: Unknown
Age: Adult
4800 Block of 78th Street
Long Grove
Found: 7/10/2020
ID: 14463
Name: Unknown
Type: Dog
Color: Black with a few white markings
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Found on St. Anns Rd, Long Grove. She's in good condition. Gentle, quiet, and calm personality.
Des Moines - Central
Found: 7/10/2020
Animal ID: 189268
This animal will be transferred to Des Moines Animal Services located at 1615 SE 14th Street Des Moines, Iowa 50320. Ph: 515-284-6905. Hours of operation: Monday - Saturday 9AM to 5PM.
Des Moines - North
Found: 7/10/2020
Animal ID: 189267
Des Moines - East
Found: 7/10/2020
Animal ID: 189268
Des Moines - North
Found: 7/10/2020
Animal ID: 189255
Des Moines - Central
Found: 7/10/2020
Animal ID: 189259
Des Moines - Central
Found: 7/10/2020
Animal ID: 189259
Des Moines - Central
Found: 7/10/2020
Animal ID: 189257
Des Moines - Central
Found: 7/10/2020
Animal ID: 189263
Des Moines - Central
Found: 7/10/2020
Animal ID: 189265
Rolfe
Found: 7/10/2020
ID: 14459
Name:
Type: Cat
Color: Black and White
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Showed up in my garage Very friendly towards people Skinny Yellow eyes Shorthair cat Has all claws
West Des Moines
Found: 7/9/2020
ID: 14462
Name:
Type: Cat
Color: Black and Orange Tortioseshell
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
Southwoods Park
Des Moines - Central
Found: 7/9/2020
Animal ID: 189258
Des Moines - Central
Found: 7/9/2020
Animal ID: 046680
Des Moines - Central
Found: 7/9/2020
Animal ID: 189252
Des Moines - Central
Found: 7/9/2020
Animal ID: 189253
Des Moines - Central
Found: 7/9/2020
Animal ID: 189247
Des Moines - Central
Found: 7/8/2020
Animal ID: 189152
Des Moines - Central
Found: 7/8/2020
Animal ID: 189223
Des Moines - Central
Found: 7/8/2020
Animal ID: 189206
Des Moines - Central
Found: 7/8/2020
Animal ID: 189174
Des Moines - Central
Found: 7/8/2020
Animal ID: 189182
West Des Moines
Found: 7/8/2020
ID: 14444
Name:
Type: Dog
Color: Tan
Breed: Chihuahua Long Haired
Gender: Unknown
Fixed: Unknown
Age: Adult