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>='1565568000')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 8/17/2019
ID: 12153
Name:
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
1325 90th St.
Indianola
Found: 8/17/2019
ID: 12148
Name:
Type: Dog
Color: White and brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Had a snapped yard wire connected to collar
Clive
Found: 8/17/2019
ID: 12146
Name:
Type: Dog
Color: Black, Brown, and White
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Adult
Found Near Stonegate Crossing Apartments
Des Moines - Central
Found: 8/17/2019
Animal ID: 176890
Des Moines - Central
Found: 8/17/2019
Animal ID: 176881
Iowa City
Found: 8/17/2019
Animal ID: 176874
Des Moines - East
Found: 8/17/2019
Animal ID: 176875
West Des Moines
Found: 8/17/2019
ID: 12141
Name:
Type: Dog
Color: Buff
Breed: GoldenDoodle
Gender: Female
Fixed: Unknown
Age: Young
Greenbelt Kennels
Des Moines - East
Found: 8/17/2019
Animal ID: 176879
Hartford
Found: 8/16/2019
Animal ID: 176825
Hartford
Found: 8/16/2019
Animal ID: 176826
Pleasant Hill
Found: 8/16/2019
Animal ID: 176864
Pleasant Hill
Found: 8/16/2019
Animal ID: 176865
Runnells
Found: 8/16/2019
ID: 12138
Name: Zoey
Type: Dog
Color: White and Brown
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - Central
Found: 8/16/2019
Animal ID: 176854
Des Moines - Central
Found: 8/16/2019
Animal ID: 176845
Dexter
Found: 8/16/2019
Animal ID: 176851
Des Moines - Central
Found: 8/16/2019
Animal ID: 176846
Des Moines - Central
Found: 8/16/2019
Animal ID: 76035
Des Moines - Central
Found: 8/16/2019
Animal ID: 176823
Des Moines - Central
Found: 8/16/2019
Animal ID: 176820
Des Moines - Central
Found: 8/16/2019
Animal ID: 176829
Des Moines - Central
Found: 8/16/2019
Animal ID: 176828
Johnston
Found: 8/16/2019
ID: 12133
Name: unknown
Type: Dog
Color: tan
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
Found on N Winwood Drive. Please call the Johnston Public Works at 515-278-0822 during business hours, or call the Johnston Police at 515-278-2345 anytime to claim this dog.
Des Moines - Central
Found: 8/15/2019
Animal ID: 176802