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: 3/28/2021
ID: 16308
Name: Brantley
Type: Dog
Color: Tan
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 3/27/2021
ID: 16302
Name: Kona
Type: Dog
Color: Brown
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - Central
Found: 3/27/2021
ID: 16300
Name: Kona
Type: Dog
Color: Brown
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
Last seen near Drake University and drake neighborhoods
Indianola
Found: 3/27/2021
ID: 16298
Name: Tara
Type: Dog
Color: white gray brown
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen 7pm March 27. Lost dog. 10 miles South of Indianola, Ia. Off of highway 69. Name Tara. Contact number 308.991.3092. Thanks.
Des Moines - South
Found: 3/26/2021
ID: 16301
Name: Pickles
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Not Neutered
Age: Baby
E Edison Ave south side of Des Moines near St Anthony’s/Columbus park please call 515-447-1702
West Des Moines
Found: 3/26/2021
ID: 16296
Name:
Type: Bird
Color: Blue
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/25/2021
ID: 16292
Name:
Type: Dog
Color: Grey and White
Breed: Parakeet
Gender: Male
Fixed: Unknown
Age: Baby
2421 Meadow Lane
Des Moines - Central
Found: 3/24/2021
ID: 16291
Name: Yuuki
Type: Dog
Color: White
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Adult
He return a hour ago!!! Very muddy!!!! He’s very tired!! Thank you everyone for sharing
Des Moines - North
Found: 3/24/2021
ID: 16281
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
West Des Moines
Found: 3/24/2021
ID: 16275
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
105 Grand Ave
Clive
Found: 3/23/2021
ID: 16267
Name:
Type: Cat
Color: White and Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
declawed in the front
West Des Moines
Found: 3/22/2021
ID: 16264
Name:
Type: Cat
Color: Brown Tabby
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
3811 NW 128th street
West Des Moines
Found: 3/22/2021
ID: 16259
Name:
Type: Cat
Color: Brown Tabby
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/22/2021
ID: 16253
Name: Beni
Type: Dog
Color: Brown
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/20/2021
ID: 16274
Name:
Type: Dog
Color: Black, White and tan tricolor
Breed: Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
1320 42nd Plaza-Washington Heights Apartments
Urbandale
Found: 3/20/2021
ID: 16246
Name: Santos
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
152nd St / Prairie Ave
Urbandale
Found: 3/20/2021
ID: 16244
Name:
Type: Dog
Color: black and white
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
7030 Northview Dr
West Des Moines
Found: 3/20/2021
ID: 16243
Name:
Type: Dog
Color: Tricolor-Black, brown, & White
Breed: Shepherd
Gender: Male
Fixed: Unknown
Age: Young
1320 42nd Plaza-Washington Heights Apartments
Des Moines - Central
Found: 3/19/2021
ID: 16241
Name:
Type: Dog
Color: Tan and white
Breed: Shepherd
Gender: Male
Fixed: Unknown
Age: Adult
Found on Beaver Ave and Aurora Ave this morning. Was able to get a leash on him and a lady in the neighborhood is keeping him at her house. I have her contact info.
Urbandale
Found: 3/17/2021
ID: 16235
Name:
Type: Dog
Color: Brown brindle and white
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Adult
4565 86th St
Urbandale
Found: 3/16/2021
ID: 16230
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Mother with kittens
West Des Moines
Found: 3/15/2021
ID: 16228
Name: Unknown
Type: Cat
Color: Black/White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 3/14/2021
ID: 16322
Name:
Type: Cat
Color: orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
reposting - Found in alley Des Moines, not microchipped, not neutered, ear mites and fleas at time of found; has all claws. Treated for fleas and ear mites, now is neutered and has all vaccinations/tests.
Urbandale
Found: 3/14/2021
ID: 16224
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 3/14/2021
ID: 16223
Name: Unknown
Type: Dog
Color: White and Orange
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Young