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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Council Bluffs
Found: 3/30/2018
ID: 8221
Name: Freedom
Type: Dog
Color: Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Senior
Last seen, was let out side in the backyard and left the yard @ around 6 AM.
Des Moines - South
Found: 3/28/2018
ID: 8208
Name: sadie
Type: Dog
Color: brindle and gray
Breed: Mix
Gender: Female
Fixed: Not Applicable
Age: Senior
Thank you she was found
Des Moines - South
Found: 3/27/2018
ID: 8205
Name: Bella
Type: Cat
Color: White
Breed: Norwegian Forest Cat
Gender: Female
Fixed: Neutered
Age: Young
She is declaw
Forest City
Found: 3/25/2018
ID: 8195
Name: Miracle
Type: Dog
Color: orange and white
Breed: Brittany Spaniel
Gender: Female
Fixed: Not Applicable
Age: Adult
Reunited at 11 p.m. tonight!!
Forest City
Found: 3/25/2018
ID: 8194
Name: Mason
Type: Dog
Color: orange and white
Breed: Brittany Spaniel
Gender: Male
Fixed: Not Neutered
Age: Adult
Reunited at 11 p.m. tonight!
Des Moines - South
Found: 3/25/2018
ID: 8192
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Spirit Lake
Found: 3/24/2018
ID: 8190
Name: Unknown
Type: Cat
Color: Black w/ green eyes
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Found: 3/22/2018
ID: 8215
Name: Butter
Type: Cat
Color: Orange And white chest
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Friendly but can be skittish he's very scared he's an indoor cat he's a polidactyl 1424 East Virginia Ave Des Moines
Des Moines - South
Found: 3/22/2018
ID: 8214
Name: Butter
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Friendly but can be skittish he's very scared. Last seen 1424 East Virginia Ave Des Moines southside
Norwalk
Found: 3/20/2018
ID: 8162
Name: N/A
Type: Rabbit
Color: dark grey
Breed: Unknown
Gender: Unknown
Fixed: Not Applicable
Age: Adult
FOUND DARK GREY PET BUNNY. UNFORTUNATELY THIS BUNNY DID NOT MAKE IT, THEREFORE I AM NOT POSTING ITS PHOTO. I do have a photo of its back legs if a potential owner wants to ID the bunny. I DO NOT have it's body, and I can explain that to potential owner, but if it is missed I want to be able to provide closure for the owner.
Urbandale
Found: 3/17/2018
ID: 8187
Name:
Type: Cat
Color: Brown/black/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Found on hickman by 63rd
Clive
Found: 3/15/2018
ID: 8147
Name: Murphy
Type: Dog
Color: White
Breed: Havanese
Gender: Male
Fixed: Unknown
Age: Adult
Today in Clive. Hawthorne and 142nd Street Very shy but sweet dog 515-240-3098
Clive
Found: 3/15/2018
ID: 8146
Name: Murphy
Type: Dog
Color: White
Breed: Havanese
Gender: Male
Fixed: Unknown
Age: Adult
Murphy ran out the door as my daughter was letting the dog out Very shy dog. Very Nice. 515-240-3098
New Virginia
Found: 3/15/2018
ID: 8143
Name:
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Exira
Found: 3/14/2018
ID: 8151
Name: Unkown
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Young
Very sweet, looking for her people!
Exira
Found: 3/14/2018
ID: 8148
Name: Unknown
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Very sweet, but very thin! I have her secure, looking to locate her people!
Des Moines - Central
Found: 3/14/2018
ID: 8136
Name:
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
46th and kingman area
Des Moines - West
Found: 3/13/2018
ID: 8111
Name: Kuma
Type: Dog
Color: Red and White
Breed: Shiba Inu
Gender: Female
Fixed: Neutered
Age: Adult
Lorimor
Found: 3/12/2018
ID: 8140
Name:
Type: Dog
Color:
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Baby
Call Jon at 515-360-1567
Lorimor
Found: 3/11/2018
ID: 8139
Name:
Type: Dog
Color: White black and brown
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Baby
Very sweet dog. Seems comfortable on a farm.
Urbandale
Found: 3/11/2018
ID: 8116
Name: Sassy
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
St. Charles
Found: 3/9/2018
ID: 8109
Name:
Type: Dog
Color: Brown and white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Young
Ames
Found: 3/9/2018
ID: 8106
Name: Unknown
Type: Cat
Color: Brown and Black
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
I found a cat near Carr Park in Ames, Iowa. Young, pretty friendly, obviously was a pet at some point but has been on his own for a while.
Swan
Found: 3/8/2018
ID: 8095
Name:
Type: Dog
Color:
Breed: German Shorthaired Pointer
Gender: Unknown
Fixed: Unknown
Age: Baby
Ames
Found: 3/8/2018
ID: 8084
Name:
Type: Dog
Color: Black and Grey
Breed: Schnauzer
Gender: Unknown
Fixed: Unknown
Age: Senior
In West Ames near the storage unit, train tracks, and James Place apartments. The dog lept into a stream so my roommate took them to our apartment to warm them up. Older, with several bumps on their chest.