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 = 'lost' or pm.meta_value = 'found' or pm.meta_value = 'Spotted') AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1571270400')) ORDER BY pm1.meta_value DESC, post_date DESC
Defiance
Lost: 3/18/2018
ID: 8159
Name: Baby girl
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen in side think she slipped out when my.husband let the dog out
Des Moines - East
Lost: 3/18/2018
ID: 8157
Name: Pickles Henry
Type: Cat
Color: Brown black stripes white paws
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in our yard 3/18 evening
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
Stuart
Lost: 3/17/2018
ID: 8171
Name:
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Unknown
Fixed: Unknown
Age: Adult
Cedar Rapids
Lost: 3/17/2018
ID: 8165
Name: VJ
Type: Dog
Color: Black
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Young
Lost in wal-mart parking lot. Black with white belly
Urbandale
Lost: 3/17/2018
ID: 8154
Name: Cisco
Type: Cat
Color:
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Young
Last seen around Madison Avenue and Patricia drive. He’s friendly, fully clawed but they are trimmed.
Sutherland
Lost: 3/16/2018
ID: 8163
Name: Bridger
Type: Dog
Color: Black w/ some caramel and a touch of white
Breed: Bluetick Coonhound
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen Friday, March 16th close to our home. We live Northeast of Sutherland. He has been gone for a few days so we are sure he is scared to death by now! However, he is a total sweetheart and has never had a mean bone in his body around people so if you see him don't be afraid to try to help him and get a hold of us right away! Call 515-408-7085 or 712-346-7757..thank you!
Melcher-Dallas
Lost: 3/16/2018
ID: 8156
Name: Diesel
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on Perry Dr. between Melcher and Pleasantville. He broke his chain so most likely he is dragging it. He’s friendly but most likely scared.
Grimes
Lost: 3/16/2018
ID: 8145
Name: Molly
Type: Cat
Color: White & Tabby
Breed: Great Pyrenees
Gender: Female
Fixed: Not Neutered
Age: Young
Molly has a funky face and 6 toes on each paw. Our door blew open overnight & a few of our pets got out. Molly is the only one who hasn’t returned. Please help us find our baby! Last seen in our home in Grimes.
Ankeny
Lost: 3/15/2018
ID: 8149
Name: Capree Dawn
Type: Cat
Color: Buff (orange)
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Capree escaped outside when leaving out the door. We just moved to the area a couple months ago.
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
Des Moines - East
Lost: 3/14/2018
ID: 8153
Name: Teddy
Type: Cat
Color: Black
Breed: Siberian
Gender: Male
Fixed: Neutered
Age: Adult
Teddy is very much missed. He is a very handsome cat. May not like strangers but he is extremely lovable to his family. We are all sick with worry.
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 - South
Lost: 3/14/2018
ID: 8137
Name:
Type: Dog
Color: White and black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
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 - East
Lost: 3/14/2018
ID: 8134
Name: Luke
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Senior
**UPDATE LUKE HAS BEEN FOUND AND BACK WITH US**
Pleasant Hill
Lost: 3/14/2018
ID: 8133
Name: Maggie
Type: Dog
Color: red/golden
Breed: Golden Retriever
Gender: Female
Fixed: Unknown
Age: Young
ran out our back yard over to neighbors yard and beyond...then was gone!! she is extremely friendly and playful
Pleasant Hill
Lost: 3/14/2018
ID: 8132
Name: Maggie
Type: Dog
Color: red/golden
Breed: Golden Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
in the copper creek area, pleasant hill, iowa she is very playful and very friendly
Des Moines - West
Lost: 3/14/2018
ID: 8129
Name: Smoothie
Type: Cat
Color: Black/white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 3/13/2018
ID: 8131
Name: Shooter
Type: Dog
Color: Black Tri
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Adult
Lost in the Indianola area and last seen by Country Club Road, Indianola, IA and Hwy 5 area on Saturday. Shooter is shy of strangers - please do not chase - offer food and Call 641-504-0356 or 515-360-3698 0r 308-212-0380
Des Moines - North
Lost: 3/13/2018
ID: 8126
Name: Ben
Type: Dog
Color: Black and White
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
In Beaverdale on Clinton Ave (Between Beaver Ave and 38th; south of Douglas)
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