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>='1605657600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 11/18/2020
Animal ID: 194789
Des Moines - North
Found: 11/18/2020
Animal ID: 194767
Des Moines - Central
Found: 11/18/2020
Animal ID: 194470
Des Moines - East
Found: 11/18/2020
Animal ID: 194593
Ankeny
Found: 11/18/2020
Animal ID: 194759
Ankeny
Found: 11/18/2020
Animal ID: 194760
Des Moines - East
Found: 11/18/2020
Animal ID: 194734
Des Moines - Central
Found: 11/17/2020
ID: 15501
Name:
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Young
Found her in the middle of 30th near victoria dr
Norwalk
Found: 11/16/2020
ID: 15498
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Clive
Found: 11/15/2020
ID: 15497
Name:
Type: Cat
Color: Brown, Gray, Black streaks
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
This sweet lady has been hanging around our backyard for a few days. The vet said she is not microchipped, female, around 8-10 years old. She got used to our dog (black lab) fairly quickly but prefers to avoid him and is curious about our black cat. She is quite skinny, so much so that we thought she was a kitten at first. We've named her Josie while we see if she already has a place to call home and a family. Please text or call 515-422-1618 if you think Josie might be yours or you know she already has a home!
Clive
Found: 11/15/2020
ID: 15491
Name:
Type: Dog
Color: Yellow White
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Baby
Garner
Found: 11/15/2020
ID: 15489
Name:
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Found: 11/14/2020
ID: 15487
Name: Weezy
Type: Dog
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Senior
Des Moines - Central
Found: 11/13/2020
ID: 15482
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Senior
35th and Rollins
Waterloo
Found: 11/13/2020
ID: 15475
Name: Benji
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
Benji was found today and i want to say thank you to all that made it posible .
Des Moines - North
Found: 11/13/2020
ID: 15473
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
3800 block Valdez dr Des Moines Turned in to Blue Pearl Animal Hospital 5157274872
Des Moines - West
Found: 11/12/2020
ID: 15472
Name:
Type: Cat
Color: Yellow and white
Breed: Maine Coon
Gender: Unknown
Fixed: Unknown
Age: Young
He’s spending time in my neighborhood and has been seen frequently over the last week in the Kingman/Iola/38th/37th st area
Independence
Found: 11/12/2020
ID: 15469
Name:
Type: Cat
Color: Black with white on lower belly
Breed: Maine Coon
Gender: Female
Fixed: Not Neutered
Age: Young
Has been seen around our house for about 2 weeks.
Clive
Found: 11/12/2020
ID: 15466
Name:
Type: Dog
Color: black and white
Breed: Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
86th/Harbach
West Des Moines
Found: 11/12/2020
ID: 15461
Name:
Type: Cat
Color: Brown/Bronze and White Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
200 block of 23rd Street
West Des Moines
Found: 11/12/2020
ID: 15456
Name:
Type: Dog
Color: Brindle
Breed: Great Dane
Gender: Female
Fixed: Unknown
Age: Adult
Windsor Heights
Found: 11/9/2020
ID: 15439
Name:
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
West Des Moines
Found: 11/9/2020
ID: 15435
Name:
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Olds
Found: 11/8/2020
ID: 15464
Name:
Type: Cat
Color: Black - Tuxedo
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Found in the parking lot at the BP gas station in Olds - they said he'd been there for days and that someone had already taken him home once and brought him back. We brought him home so he wouldn't get run over. He's very friendly, OK with dogs, but doesn't really like other cats.
West Des Moines
Found: 11/7/2020
ID: 15422
Name:
Type: Dog
Color: Black & Brown
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Young
8900 block of Cascade Avenue