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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 1/14/2018
ID: 7796
Name: Tiramisu
Type: Dog
Color: Black and tan
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Not Neutered
Age: Young
Sweet tempered dog 1 year old. Wearing black pinch collar.
Des Moines - East
Lost: 1/14/2018
ID: 7795
Name: Ace
Type: Dog
Color: Tri-color. White, Black, brown
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
Collar was taken off.
Des Moines - South
Lost: 1/14/2018
ID: 7793
Name:
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Neutered
Age: Young
Madrid
Lost: 1/13/2018
ID: 7802
Name: MAX
Type: Dog
Color: Tan and red
Breed: Poodle Miniature
Gender: Male
Fixed: Neutered
Age: Young
Last seen at the corner of Market Street and 4th - south of the Madrid post office and along the High Trestle bike trail - he was heading west towards the trail. Max was wearing a dark blue dog sweater.
Reasnor
Lost: 1/13/2018
ID: 7792
Name: Dozer
Type: Dog
Color: Black with grey(silver) spots
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Senior
He is kinda deaf and going blind hes 14yrs old will be aggressive towards people he does not know espically men he is very overweight hes microchipped but info on it is incorrect as its to the address i was at while on active duty
North Liberty
Lost: 1/12/2018
ID: 7798
Name: Addie
Type: Dog
Color: Tan and white
Breed: Dachshund
Gender: Female
Fixed: Unknown
Age: Young
Addie is very shy, lost in North liberty Friday.
North Liberty
Lost: 1/12/2018
ID: 7797
Name: Addie
Type: Dog
Color: Tan and white
Breed: Dachshund
Gender: Unknown
Fixed: Unknown
Age: Young
Addie is very shy, lost in North liberty Friday.
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.