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
Des Moines - South
Found: 8/15/2019
ID: 12131
Name:
Type: Dog
Color: Black/brown
Breed:
Gender: Male
Fixed: Unknown
Age: Adult
Was roaming SW 5th and Emma area 10:30 pm. He’s small, mostly black, short haired muscular, energetic, and somewhat skittish. He is wearing a collar so guessing he has a family who is missing him.
Urbandale
Found: 8/15/2019
ID: 12130
Name:
Type: Cat
Color: Grey Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found on 6100 block of Oakwood
Plymouth
Found: 8/15/2019
ID: 12129
Name:
Type: Dog
Color: Brown and light brown
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Unknown
Age: Adult
330th st. Rural Plymouth 50464
Des Moines - Central
Found: 8/15/2019
Animal ID: 176793
Des Moines - Central
Found: 8/15/2019
Animal ID: 176800
Des Moines - Central
Found: 8/15/2019
Animal ID: 176794
Des Moines - Central
Found: 8/15/2019
Animal ID: 176795
Pleasant Hill
Found: 8/15/2019
Animal ID: 176789
Des Moines - Central
Found: 8/14/2019
Animal ID: 176777
Des Moines - Central
Found: 8/14/2019
Animal ID: 176773
Des Moines - Central
Found: 8/14/2019
Animal ID: 176776
Des Moines - Central
Found: 8/14/2019
Animal ID: 141280
Des Moines - East
Found: 8/14/2019
Animal ID: 176755
Runnells
Found: 8/14/2019
Animal ID: 176753
Under vet care
Des Moines - Central
Found: 8/14/2019
ID: 12119
Name:
Type: Dog
Color: Blue or gray
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
51st and Douglas ave in DSM.
Des Moines - South
Found: 8/14/2019
Animal ID: 176748
with 176747
Des Moines - South
Found: 8/14/2019
Animal ID: 176747
with 176748
Des Moines - West
Found: 8/14/2019
Animal ID: 176746
Des Moines - Central
Found: 8/14/2019
Animal ID: 176744
Des Moines - Central
Found: 8/14/2019
Animal ID: 176743
West Des Moines
Found: 8/13/2019
ID: 12128
Name:
Type: Dog
Color: Brown and Black
Breed: Shepherd
Gender: Male
Fixed: Unknown
Age: Adult
Found with German Shepherd
West Des Moines
Found: 8/13/2019
ID: 12127
Name:
Type: Dog
Color: Brown and Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Found with long-haired shepherd mix
Des Moines - Central
Found: 8/13/2019
Animal ID: 176692
Des Moines - South
Found: 8/12/2019
ID: 12120
Name:
Type: Cat
Color: black
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Came to my yard in SW DSM. Small, all-black female cat, appears to be about 6 months old. Polydactyl (extra toes), very friendly. Very thin, but seems in good condition otherwise, would appear to be from a good home.
Des Moines - Central
Found: 8/12/2019
Animal ID: 176677