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>='1565913600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Found: 8/21/2019
ID: 12177
Name:
Type: Cat
Color: Tabby -brown/black with some orange on face
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Baby
Found near Sargent Park bike trail on Eastbound aside of Des Moines
Altoona
Found: 8/21/2019
Animal ID: 177074
Des Moines - Central
Found: 8/21/2019
Animal ID: 177072
Des Moines - Central
Found: 8/21/2019
Animal ID: 177065
Des Moines - North
Found: 8/21/2019
Animal ID: 177055
This animal was found within the city limits of DSM and will be transferred to our Animal Care and Control Location- 1615 SE 14th St. Des Moines 50320 (515)-284-6905. If you are the owner of this cat, please first call our main location at (515) 473-9102 in case this cat's transfer has been delayed.
Des Moines - Central
Found: 8/20/2019
Animal ID: 177057
Des Moines - Central
Found: 8/20/2019
Animal ID: 177041
Des Moines - Central
Found: 8/20/2019
Animal ID: 177044
Des Moines - Central
Found: 8/20/2019
Animal ID: 177010
Des Moines - Central
Found: 8/20/2019
Animal ID: 176986
Des Moines - Central
Found: 8/20/2019
Animal ID: 177006
Des Moines - Central
Found: 8/20/2019
Animal ID: 177005
Des Moines - Central
Found: 8/20/2019
Animal ID: 177003
Des Moines - Central
Found: 8/20/2019
Animal ID: 122297
Des Moines - South
Found: 8/20/2019
ID: 12173
Name: Unknown
Type: Cat
Color: Dark Brown, Tan, Gray
Breed: Unknown
Gender: Female
Fixed: Not Applicable
Age: Young
We found this sweet girl wandering on the Southside of DSM behind Menards on SE 14th. She's very friendly and looks like she's been out on her own for awhile. No collar and is not declawed.
Des Moines - North
Found: 8/20/2019
Animal ID: 176999
Des Moines - North
Found: 8/20/2019
ID: 12172
Name:
Type: Dog
Color: Brown and white
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Found at 2nd Ave and New York.
Carlisle
Found: 8/19/2019
ID: 12174
Name:
Type: Cat
Color: Black and white
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Declawed
Des Moines - Central
Found: 8/19/2019
Animal ID: 176982
Des Moines - Central
Found: 8/19/2019
Animal ID: 176966
Des Moines - Central
Found: 8/19/2019
Animal ID: 176939
Des Moines - Central
Found: 8/19/2019
Animal ID: 176971
Des Moines - Central
Found: 8/19/2019
Animal ID: 176976
Des Moines - Central
Found: 8/19/2019
Animal ID: 176961
Des Moines - Central
Found: 8/19/2019
Animal ID: 176968