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>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Found: 4/4/2018
ID: 8249
Name: Unknown
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Young
Woodburn
Found: 4/1/2018
ID: 8237
Name: Pearl
Type: Dog
Color: White With Reddish Tan Accents
Breed: Great Pyrenees
Gender: Female
Fixed: Neutered
Age: Young
Pearl is home! Thank you for all the shares. The person who found her did a google search and saw Pearl's info.
Johnston
Found: 3/31/2018
ID: 8231
Name: Bear
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
North part of town near Hyperion, Ritter's Oaks, NW Beaver Dr/Hyperion Point Dr. area
Mount Vernon
Found: 3/30/2018
ID: 8226
Name:
Type: Cat
Color: Grey
Breed: Unknown
Gender: Female
Fixed: Not Applicable
Age: Young
Followed us around for quite some time. Very friendly. Currently at cedar valley humane society.
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