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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 7/27/2021
ID: 17331
Name:
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Pleasant Hill
Found: 7/27/2021
ID: 17328
Name:
Type: Cat
Color: Grey and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
My kids found this very sweet cat around midnight. Big eyes, white whiskers, vocal and ver affectionate.
West Des Moines
Found: 7/26/2021
ID: 17327
Name:
Type: Dog
Color: brown
Breed: Hound
Gender: Female
Fixed: Unknown
Age: Adult
2900 Giles Street, West Des Moines, IA, USA, Polk County, 50265
Des Moines - West
Found: 7/26/2021
ID: 17319
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
In our house.
Urbandale
Found: 7/25/2021
ID: 17326
Name:
Type: Cat
Color: black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
7101 Oak Brook Drive, Urbandale, IA, USA, Polk County, 50322
West Des Moines
Found: 7/25/2021
ID: 17320
Name:
Type: Cat
Color: White
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Urbandale
Found: 7/24/2021
ID: 17314
Name:
Type: Dog
Color: white
Breed: Pomeranian
Gender: Male
Fixed: Not Neutered
Age: Adult
109th and Aurora, 50322 Urbandale
West Des Moines
Found: 7/24/2021
ID: 17313
Name:
Type: Cat
Color: white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
1230 40th Plaza West Des Moines, 50266
Urbandale
Found: 7/24/2021
ID: 17306
Name:
Type: Dog
Color: grey and tan
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Adult
5000 Merle Hay Road, Polk County, 50322
Des Moines - West
Found: 7/23/2021
ID: 17312
Name:
Type: Cat
Color:
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Young
Clive
Found: 7/21/2021
ID: 17293
Name:
Type: Bird
Color: Cinnamon pied
Breed: Cockatiel
Gender: Unknown
Fixed: Unknown
Age: Young
This guy was found in Clive near NW 78th St.
Evansdale
Found: 7/20/2021
ID: 17283
Name:
Type: Cat
Color: White and grey
Breed: Cockatiel
Gender: Female
Fixed: Unknown
Age: Young
Is declawed in the front.
West Des Moines
Found: 7/20/2021
ID: 17278
Name:
Type: Cat
Color: brown tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
5861 Vista Drive, West Des Moines, IA 50266, United States of America, Polk County, 50266
Des Moines - South
Found: 7/20/2021
ID: 17276
Name: Paco
Type: Dog
Color: Black/grey
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - South
Found: 7/20/2021
ID: 17275
Name: Krypto
Type: Dog
Color: White
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Found: 7/19/2021
ID: 17273
Name: Lucifer
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Found: 7/19/2021
ID: 17272
Name:
Type: Dog
Color: tan
Breed: Shiba Inu
Gender: Male
Fixed: Neutered
Age: Adult
437 4th Street, West Des Moines, IA 50265, United States of America, Polk County, 50265
Clive
Found: 7/19/2021
ID: 17268
Name: Kona
Type: Dog
Color: White and Black
Breed: Great Dane
Gender: Female
Fixed: Neutered
Age: Adult
Large Black and White Great Dane. Answers to Kona. Very friendly but a barker.
West Des Moines
Found: 7/19/2021
ID: 17265
Name:
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 7/18/2021
ID: 17263
Name:
Type: Cat
Color: Brown and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Waterloo
Found: 7/18/2021
ID: 17259
Name:
Type: Cat
Color: Black brown white
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Found outside of university studios east in the bushes, someone said they saw her jump out of a car and the car left.
West Des Moines
Found: 7/16/2021
ID: 17252
Name:
Type: Dog
Color: Tan and white
Breed: Collie
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 7/16/2021
ID: 17251
Name:
Type: Dog
Color: Black with some brown
Breed: Coonhound
Gender: Female
Fixed: Unknown
Age: Adult
Urbandale
Found: 7/15/2021
ID: 17245
Name:
Type: Dog
Color: yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
4225 69th Street, Urbandale, IA 50322, United States of America, Polk County, 50322
Urbandale
Found: 7/15/2021
ID: 17244
Name:
Type: Dog
Color: brindle
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
4225 69th Street, Urbandale, IA 50322