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>='1599868800')) ORDER BY pm1.meta_value DESC, post_date DESC
Grimes
Found: 9/14/2020
Animal ID: 191927
under vet care
Des Moines - Central
Found: 9/13/2020
Animal ID: 191972
Des Moines - South
Found: 9/13/2020
Animal ID: 191956
Des Moines - South
Found: 9/13/2020
Animal ID: 191955
Des Moines - Central
Found: 9/13/2020
Animal ID: 36452
Oskaloosa
Found: 9/13/2020
ID: 14940
Name: Unknown
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
West Des Moines
Found: 9/13/2020
ID: 14939
Name:
Type: Dog
Color: white
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
1200 block of Locus Street
Des Moines - South
Found: 9/13/2020
ID: 14937
Name:
Type: Dog
Color: Black with white on belly and feet
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Dog came in our garage dragging a chain. On Lacona Avenue. Please call 515-991-3547 if this is your pet.
Des Moines - South
Found: 9/13/2020
Animal ID: 191916
Des Moines - East
Found: 9/13/2020
Animal ID: 191915
Altoona
Found: 9/13/2020
Animal ID: 191911
Des Moines - South
Found: 9/12/2020
Animal ID: 191909
Des Moines - South
Found: 9/12/2020
Animal ID: 191954
Des Moines - Central
Found: 9/12/2020
Animal ID: 185356
Des Moines - Central
Found: 9/12/2020
Animal ID: 123973
Des Moines - Central
Found: 9/12/2020
Animal ID: 191909
Des Moines - North
Found: 9/12/2020
Animal ID: 191901
This cat will be transferred to Des Moines Animal Services located at 1615 SE 14th Street Des Moines, IA 50320. Phone: 515-284-6905. Hours of operation: Monday- Saturday 9AM-5PM
Grimes
Found: 9/12/2020
Animal ID: 191895
Grimes
Found: 9/12/2020
Animal ID: 191895
Des Moines - Central
Found: 9/12/2020
Animal ID: 191879
Grimes
Found: 9/12/2020
Animal ID: 191742
West Des Moines
Found: 9/12/2020
ID: 14931
Name: Nova Rain
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
5900 Block of Vista Drive
Des Moines - North
Found: 9/12/2020
Animal ID: 191865
West Des Moines
Found: 9/11/2020
ID: 14928
Name: Slate
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Jasper County
Des Moines - North
Found: 9/10/2020
ID: 14933
Name:
Type: Cat
Color: Black
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young