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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Found: 11/25/2020
Animal ID: 194949
found with 194948
Ankeny
Found: 11/25/2020
Animal ID: 194948
Found with194949
Des Moines - North
Found: 11/25/2020
Animal ID: 194947
Des Moines - North
Found: 11/24/2020
Animal ID: 194943
found with blue and tan flower patterned collar. Possibly named Roxy.
Des Moines - Central
Found: 11/24/2020
Animal ID: 194939
Des Moines - Central
Found: 11/24/2020
Animal ID: 194896
Des Moines - North
Found: 11/24/2020
Animal ID: 194937
Des Moines - Central
Found: 11/24/2020
Animal ID: 168316
Altoona
Found: 11/24/2020
Animal ID: 194936
Berwick
Found: 11/23/2020
Animal ID: 163061
West Des Moines
Found: 11/23/2020
ID: 15541
Name:
Type: Cat
Color: Orange and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
128 1st street
Des Moines - Central
Found: 11/23/2020
Animal ID: 194895
Des Moines - Central
Found: 11/23/2020
Animal ID: 194892
Colfax
Found: 11/23/2020
Animal ID: 194903
Colfax
Found: 11/23/2020
Animal ID: 194904
Des Moines - South
Found: 11/23/2020
ID: 15538
Name:
Type: Dog
Color: Black, White
Breed: Hound
Gender: Male
Fixed: Not Neutered
Age: Baby
South of Wakonda Club, Wakonda Pkwy
Pleasant Hill
Found: 11/23/2020
Animal ID: 194902
Des Moines - Central
Found: 11/23/2020
Animal ID: 194891
Des Moines - North
Found: 11/23/2020
Animal ID: 194899
Ankeny
Found: 11/23/2020
Animal ID: 194898
Des Moines - North
Found: 11/23/2020
Animal ID: 194897
Pella
Found: 11/22/2020
ID: 15569
Name: Unknown
Type: Cat
Color: White/Fawn
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Young
Lawton
Found: 11/21/2020
ID: 15542
Name: Miles
Type: Cat
Color: White with tabby markings
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
In our backyard on 11/21 near a forest between neighbors’ yards. He is a timid cat who will probably run from strangers.
Urbandale
Found: 11/21/2020
ID: 15534
Name:
Type: Cat
Color: Calico
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Young
8200 block of Twana Drive
West Des Moines
Found: 11/21/2020
ID: 15533
Name:
Type: Rabbit
Color: Brown/Tan
Breed: Lionhead
Gender: Unknown
Fixed: Unknown
Age: Young
9000 block of Bridgewood Blvd