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>='1571270400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 10/19/2019
Animal ID: 179766
Des Moines - South
Found: 10/19/2019
ID: 12642
Name: FOUND DOG
Type: Dog
Color: tricolor
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Found at 6:20 am SS DSM was wearning a collar amd leash. Identify these items.
Carlisle
Found: 10/19/2019
Animal ID: 179746 / 179747
Found together
Carlisle
Found: 10/19/2019
Animal ID: 179746 / 179747
Found together
Des Moines - South
Found: 10/19/2019
Animal ID: 179745
This animal will be transferred to our Animal Care and Control location located at 1615 SE 14th St Des Moines, IA 50320
Urbandale
Found: 10/19/2019
ID: 12634
Name:
Type: Cat
Color: White and grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Found near 4500 block of 86th Street, Urbandale
West Des Moines
Found: 10/18/2019
ID: 12633
Name:
Type: Dog
Color: Red and White
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
517 3rd St., in alley
West Des Moines
Found: 10/18/2019
ID: 12631
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Quad Park S 50th St
Des Moines - Central
Found: 10/18/2019
Animal ID: 179724
Des Moines - Central
Found: 10/18/2019
Animal ID: 179714
Des Moines - Central
Found: 10/18/2019
Animal ID: 179706
Des Moines - Central
Found: 10/18/2019
Animal ID: 179708
Mitchellville
Found: 10/18/2019
Animal ID: 179712/179713
Des Moines - Central
Found: 10/18/2019
Animal ID: 179707
Des Moines - North
Found: 10/18/2019
Animal ID: 179689
Des Moines - South
Found: 10/18/2019
ID: 12621
Name:
Type: Cat
Color: Tabby brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Applicable
Age: Young
Found a smaller tabby cat on south side of Des Moines on 3rd and E Park avenue. Very friendly
Des Moines - Central
Found: 10/17/2019
Animal ID: 179704
Des Moines - Central
Found: 10/17/2019
Animal ID: 179686
Des Moines - Central
Found: 10/17/2019
Animal ID: 179691
Des Moines - Central
Found: 10/17/2019
Animal ID: 179690
Des Moines - Central
Found: 10/17/2019
Animal ID: 179702
Urbandale
Found: 10/17/2019
ID: 12622
Name:
Type: Cat
Color: Black with white spot
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Found on Waterford Rd. in Urbandale
Urbandale
Found: 10/17/2019
ID: 12618
Name:
Type: Dog
Color: White and Orange
Breed: Hound
Gender: Male
Fixed: Neutered
Age: Adult
4300 block Parkview Dr.
Des Moines - Central
Found: 10/17/2019
Animal ID: 179651
Des Moines - Central
Found: 10/17/2019
Animal ID: 179654