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>='1568332800')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Found: 9/19/2019
ID: 12386
Name: Unknown
Type: Dog
Color: black, tan, and white
Breed: Akita
Gender: Female
Fixed: Unknown
Age: Young
Found roaming an apartment complex Contact Bree - (515) 802-0642
Des Moines - Central
Found: 9/19/2019
Animal ID: 178327
Des Moines - Central
Found: 9/19/2019
Animal ID: 178362
Des Moines - Central
Found: 9/19/2019
Animal ID: 178365
Des Moines - Central
Found: 9/19/2019
Animal ID: 178361
Des Moines - Central
Found: 9/19/2019
Animal ID: 178383
Ankeny
Found: 9/19/2019
Animal ID: 178377
Ankeny
Found: 9/19/2019
ID: 12384
Name: Unknown
Type: Dog
Color: Grey/Tan
Breed: Maltipoo
Gender: Unknown
Fixed: Unknown
Age: Adult
Found/ lost dog on NW 5th street. Dog was picked up by Ankeny PD to check for microchip
Des Moines - Central
Found: 9/18/2019
Animal ID: 178311
Des Moines - Central
Found: 9/18/2019
Animal ID: 178360
Des Moines - Central
Found: 9/18/2019
Animal ID: 178370
Des Moines - North
Found: 9/18/2019
Animal ID: 178345
Des Moines - Central
Found: 9/18/2019
Animal ID: 178310
Des Moines - Central
Found: 9/18/2019
Animal ID: 178317
Des Moines - East
Found: 9/18/2019
Animal ID: 178274
This animal has been transferred to our Animal Care and Control location at 1615 SE 14th Street, Des Moines IA
Des Moines - Central
Found: 9/17/2019
Animal ID: 178288
Des Moines - Central
Found: 9/17/2019
Animal ID: 176983
Des Moines - Central
Found: 9/17/2019
Animal ID: 178306
West Des Moines
Found: 9/17/2019
ID: 12377
Name:
Type: Dog
Color: White
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Found at Valley West Mall
Woodward
Found: 9/17/2019
ID: 12376
Name: Gus
Type: Dog
Color: White on chest and some white on face. Blotches of carmel, black and gray. Long fur
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Gus is VERY friendly and will run towards you for help. He is very sweet. Will not hurt you. Last seen southeast of Woodward, off R22 and 180th St. Could be in Woodward, Granger, Dallas Center, Minburn, or Grimes.
West Des Moines
Found: 9/17/2019
ID: 12375
Name:
Type: Cat
Color: Brown and Tan Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
3400 block of Maple Street
West Des Moines
Found: 9/17/2019
ID: 12374
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Found in bushes of Windsor Chateau Apartments
Winterset
Found: 9/17/2019
Animal ID: 178272
Des Moines - Central
Found: 9/17/2019
Animal ID: 178260
Des Moines - Central
Found: 9/17/2019
Animal ID: 178267