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' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1579305600')) ORDER BY pm1.meta_value DESC, post_date DESC
Polk City
Found: 1/24/2020
Animal ID: 183271
Johnston
Found: 1/24/2020
Animal ID: 183268
Des Moines - Central
Found: 1/24/2020
Animal ID: 183264
Des Moines - Central
Found: 1/24/2020
Animal ID: 183262
Des Moines - Central
Found: 1/24/2020
Animal ID: 183261
Des Moines - East
Lost: 1/23/2020
ID: 13294
Name: Coco
Type: Dog
Color: golden
Breed: Golden Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Coco is friendly female. Lost 1-23-20 late morning. No collar. Responds well to her name Coco. Please call. Thank you.
Des Moines - East
Lost: 1/23/2020
ID: 13293
Name: Coco
Type: Dog
Color: golden
Breed: Golden Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
female named Coco. listens well, responds to Coco. No collar. Lost around East 18th & Hubbell.
West Des Moines
Found: 1/23/2020
ID: 13292
Name: Unknown
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on the Mountain Ave
Urbandale
Found: 1/23/2020
ID: 13290
Name:
Type: Dog
Color: Brown
Breed: Bulldog
Gender: Male
Fixed: Unknown
Age: Young
In Waterford road
Des Moines - Central
Found: 1/23/2020
Animal ID: 46807
This animal will be transferred to our Animal Care & Control location at 1615 SE 14th St, Des Moines, IA 50320
Des Moines - North
Found: 1/23/2020
Animal ID: 183240
This animal will be transferred to our Animal Care & Control location at 1615 SE 14th Street, Des Moines, IA 50320
Des Moines - Central
Lost: 1/23/2020
ID: 13289
Name: Winnie
Type: Dog
Color: Black with white chest
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen @330am. She goes by Winnie. She loves treats.
Des Moines - Central
Found: 1/22/2020
Animal ID: 183240
Des Moines - Central
Found: 1/22/2020
Animal ID: 183241
Des Moines - Central
Found: 1/22/2020
Animal ID: 183238
Des Moines - Central
Found: 1/22/2020
Animal ID: 183222
Des Moines - Central
Found: 1/22/2020
Animal ID: 183222
Des Moines - Central
Found: 1/22/2020
Animal ID: 183222
Truro
Found: 1/22/2020
Animal ID: 183224
Des Moines - Central
Found: 1/22/2020
Animal ID: 183219
This animal will be transferred to our Animal Care & Control location at 1615 SE 14th ST, Des Moines, 50320
Des Moines - North
Found: 1/22/2020
Animal ID: 183218
Des Moines - North
Found: 1/22/2020
Animal ID: 183217
Des Moines - South
Found: 1/22/2020
Animal ID: 183216
Des Moines - Central
Found: 1/22/2020
Animal ID: 183210
This animal will be transferred to our Animal Care & Control location at 1615 SE 14th ST, Des Moines, 50320
Des Moines - Central
Found: 1/22/2020
Animal ID: 183209