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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Waukon
Lost: 1/16/2018
ID: 7811
Name: Daisy
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Adult
She is a black and white collie who is not very good about coming to her name. She was only wearing a flea collar when she was last seen near Dorchester, Iowa. If found, please call home phone at 563-497-3456 or cell at 507-450-0338. Thanks!
Des Moines - South
Lost: 1/15/2018
ID: 7818
Name: King
Type: Cat
Color: Black and Grey
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
Sunday Night before bed thinking he got out in morning
Ogden
Lost: 1/14/2018
ID: 7937
Name: FLATHEAD
Type: Dog
Color:
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Adult
847 170th st Ogden IA
Des Moines - East
Lost: 1/14/2018
ID: 7804
Name: Bro
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
E. Madison Ave and Lay
Des Moines - South
Lost: 1/14/2018
ID: 7800
Name: Louie & Saint
Type: Dog
Color: Louie is white & brown, Saint is white
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Young
They were last seen in the Fleur hyvee parking lot area
Des Moines - East
Lost: 1/14/2018
ID: 7799
Name: Spots Johnson
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen across from sleepy hollow
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.