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' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Madrid
Lost: 1/12/2018
ID: 7791
Name: Max
Type: Dog
Color: Golden
Breed: GoldenDoodle
Gender: Male
Fixed: Unknown
Age: Young
Max is a puppymill dog who is very shy & has anxiety. He was at his foster home in Madrid. When he went missing he was last seen heading towards the bike trail. I am posting for his mama who will be adopting him tomorrow. He is wearing the blue sweater.
Des Moines - East
Lost: 1/11/2018
ID: 7788
Name: Bella
Type: Dog
Color: Light brown dark brown and white on tip of tail and
Breed: Rat Terrier
Gender: Female
Fixed: Not Neutered
Age: Adult
E. 33rd and Mahaska. She is scared of people unless she knows you..she is not an outside dog she's got to be cold and scared ... Please help us find her ....asap she is a rat terrier with long hair white on the tip of her tail and all four paws are white, she kinda looks like a border collie and her hair sometimes looks like a reddish color ....
Des Moines - East
Lost: 1/11/2018
ID: 7787
Name: Gypse
Type: Dog
Color: Black and brown
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Unknown
Age: Baby
She a very loveable dog a year and a half old she's tall. She's gone missing off of Maury se 25th ct area behind titan tire.
Storm Lake
Lost: 1/10/2018
ID: 7817
Name: Gumbo
Type: Dog
Color: White with tan/brindle markings
Breed: Old English Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen on the southwest side of Storm Lake. Friendly. Believed to be stolen.
Des Moines - South
Lost: 1/10/2018
ID: 7805
Name: Rocky
Type: Cat
Color: Gray. White(ish) around his mouth.
Breed: Old English Bulldog
Gender: Male
Fixed: Unknown
Age: Adult
left the house around 5pm 01/10/18. he is an indoor/outdoor cat. He is very loving. He meows a lot. Especially when he hears canned food being opened.
Henderson
Lost: 1/10/2018
ID: 7803
Name: Trotter
Type: Dog
Color: Red Tri - 2 blue eyes
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on 120th between A and B Just East of Henderson on Saturday morning. Unfortunately, Trotter is still missing. Fresh tracks were seen Saturday. We were out all day Sunday and Monday after the new snow and saw NO fresh tracks. Please keep an eye out and call/text me at ANY time. Searched for 4 days North/South from Pioneer Trail to130th and East/West from 59 to M37/C ave East of Henderson and South of Carson. Ellie has not been seen since Wednesday.
Ankeny
Lost: 1/10/2018
ID: 7786
Name: Cookie
Type: Cat
Color:
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
1/10/18 SE side of Ankeny
Norwalk
Lost: 1/10/2018
ID: 7785
Name: Mario
Type: Cat
Color: Brown/ black
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 1/10/2018
ID: 7782
Name: Ziggy
Type: Dog
Color: Tan/White
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
He has a bowtie on. Last at home on SE SHARON DR in Ankeny IA
Lamoni
Lost: 1/9/2018
ID: 7789
Name: Maya
Type: Dog
Color: Brown and white
Breed: Saint Bernard
Gender: Female
Fixed: Not Neutered
Age: Young
She also responds to ‘Doof’.
Pleasantville
Lost: 1/9/2018
ID: 7778
Name: Jericho
Type: Dog
Color: Gray/white
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
This is my nephew and niece’s boy...he took off with his sister yesterday, she returned home, he has not...they’ve been out searching for him..if you spot him or are taking care of him, please let us know. They’re very worried and missing him.
Hartford
Lost: 1/8/2018
ID: 7779
Name: Canopy
Type: Cat
Color: Orange tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Canopy was last seen Monday at approx 5 pm. He got out as his family was leaving. He is a very sweet kitty. He was newly adopted and likely does not know his way back to his new home and is probably scared. If you find him he is chipped, his chip #is 98200041173667. If found please contact his owner Nick at 417-699-2721.
Dows
Lost: 1/6/2018
ID: 7790
Name: Diesel
Type: Dog
Color: Black & tan
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
By coop bins in Dows, his sister came back but not him
Des Moines - North
Lost: 1/6/2018
ID: 7759
Name: Brisoil
Type: Dog
Color: All white
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen Friday She is shy but very friendly
West Des Moines
Lost: 1/5/2018
ID: 7758
Name: Henry
Type: Cat
Color: White and orange on ears and tail
Breed: Turkish Van
Gender: Female
Fixed: Neutered
Age: Young
She is very shy and timid but if you crouch down and put your hand out she might come to you and smell you. Very small for a grown cat. Has orange markings on her ears, a spot in the back of her head, and has a striped tail.
Des Moines - South
Lost: 1/5/2018
ID: 7754
Name: Trapper
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Our dog Trapper got out of our fence today when he was let out to the bathroom. Please call if you find him! He is my sons dog and he will be crushed if we can't find his sleeping buddy :( Trapper is a very gentle dog that loves everyone so he will come if you call him.
Des Moines - East
Lost: 1/3/2018
ID: 7757
Name: Zeus
Type: Dog
Color: Ligth brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen between the Easton BLV and the 24th street.
Des Moines - East
Lost: 1/3/2018
ID: 7756
Name: Zeus
Type: Dog
Color: Ligth brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen between the Easton BLV ave and the 24th street.
Des Moines - East
Lost: 1/2/2018
ID: 7764
Name: Kimbo
Type: Dog
Color: Black with some gray around mouth
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
By 29th and East Euclid
Des Moines - Central
Lost: 1/2/2018
ID: 7762
Name: Luna
Type: Dog
Color: Red & white
Breed: English Bulldog
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 1/2/2018
ID: 7748
Name: Bear
Type: Dog
Color: Black
Breed: English Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
E 36th st and Dubuque
Grimes
Lost: 1/1/2018
ID: 7830
Name: test
Type: Rabbit
Color: test
Breed: American
Gender: Male
Fixed: Unknown
Age: Baby
this is just a test.
Des Moines - Central
Lost: 12/31/2017
ID: 7745
Name: Epic
Type: Cat
Color: Medium gray
Breed: American Shorthair
Gender: Female
Fixed: Not Applicable
Age: Adult
5th ave and indianna
Des Moines - North
Lost: 12/30/2017
ID: 7948
Name: Zues
Type: Cat
Color: Tri colored
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Not declawed. Very very nice. He has a cricked back from an accident when he was younger. Hes my sons cat just want him home safe.
Adair
Lost: 12/29/2017
ID: 8648
Name: Hope
Type: Dog
Color: Red Lab
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Lost along I-80 East of Adair near the rest stop. Very personable well trained dog.