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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 5/22/2017
ID: 5654
Name: harley
Type: Dog
Color: white with few tan spots
Breed: Shih Tzu
Gender: Female
Fixed: Not Neutered
Age: Adult
minds well when told something . my son got him when his dad passed in jan. she has been lonesome for him and may have been looking for him.she also has cancer and was getting ready for surgery.Last seen around e. 14th and Guthrie 50316
What Cheer
Lost: 5/21/2017
ID: 5991
Name: Rosta
Type: Dog
Color: Dark Brindle and white on chest
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Young
Last seen west side of What Cheer at Skunk river bridge on Lacy rd
Des Moines - West
Lost: 5/21/2017
ID: 5649
Name: Kia
Type: Dog
Color: Tan
Breed: Husky
Gender: Female
Fixed: Neutered
Age: Senior
Des Moines - West
Lost: 5/21/2017
ID: 5645
Name: Sampson
Type: Dog
Color: Black and white
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Near Merle hay south neighborhood near glenwood cemetery
Des Moines - East
Lost: 5/20/2017
ID: 5650
Name: Company
Type: Dog
Color: White
Breed: Samoyed
Gender: Male
Fixed: Not Neutered
Age: Young
around Easton and Searle
Adel
Lost: 5/20/2017
ID: 5643
Name: Max
Type: Dog
Color: Brown/tan with black nose/ears
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - Central
Lost: 5/20/2017
ID: 5640
Name: Stellan
Type: Cat
Color: Grey tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
He goes outside regularly but doesn't usually stray far. Concerned he may be in someone's garage or trapped somewhere around Bowdoin Columbia Amherst area south of Euclid.
Des Moines - East
Lost: 5/20/2017
ID: 5634
Name: Stellan
Type: Cat
Color: Grey tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
He goes outside regularly but doesn't usually stray far, concerned he may be in someone's garage or trapped somewhere. He usually hangs around Bowdoin, Amherst, Columbia south of euclid
Eddyville
Lost: 5/19/2017
ID: 5659
Name: Cedric
Type: Cat
Color: Black/Brown Tabby (stripes)
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
He's a very friendly cat. Doesn't like loud noises. Had a cut on his tongue (Scar) He lives on the 500 block of 3rd Street on the North side of Eddyville.
Mitchellville
Lost: 5/19/2017
ID: 5632
Name: Piper
Type: Dog
Color: White with brownish reddish spots
Breed: Border Collie
Gender: Female
Fixed: Not Neutered
Age: Young
She's super timid. If you find her don't chase her. Let her come to you.
Des Moines - East
Lost: 5/18/2017
ID: 5773
Name: Tumor
Type: Dog
Color: Black and tan
Breed: Pinscher-Miniature
Gender: Male
Fixed: Not Neutered
Age: Adult
Manchester
Lost: 5/18/2017
ID: 5726
Name: Herky
Type: Dog
Color: White and brown brown face
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Senior
Last seen between ryan and Manchester near highway 13
Manchester
Lost: 5/18/2017
ID: 5670
Name: Herky
Type: Dog
Color: White and brown with some gray in the face
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen on 5/18 at home believe he ran off at some point during the day. We live south of Manchester by 275th St. and Hwy 13. He is a friendly dog and part of our family. Any information would be greatly appreciated. Thank you
Pleasant Hill
Lost: 5/18/2017
ID: 5639
Name: Mocha
Type: Dog
Color: Silver
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Pleasant Hill
Lost: 5/18/2017
ID: 5638
Name: Mocha
Type: Dog
Color: Silver
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Pleasant Hill
Lost: 5/18/2017
ID: 5637
Name: Mocha
Type: Dog
Color: Silver
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Young
Pleasant Hill
Lost: 5/18/2017
ID: 5636
Name: Mocha
Type: Dog
Color: Silver
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 5/18/2017
ID: 5633
Name: Stellan
Type: Cat
Color: Grey tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
He goes outside regularly but doesn't usually stray far, concerned he may be in someone's garage or trapped. He usually hangs around Bowdoin, Amherst, Columbia area south of Euclid.
Des Moines - Central
Lost: 5/18/2017
ID: 5631
Name: Lucy
Type: Cat
Color: Solid white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
I think she got disoriented in the storm and hopefully got taken in or she sought shelter in a garage or she'd
Des Moines - North
Lost: 5/18/2017
ID: 5624
Name: Coby
Type: Dog
Color: Black and tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
He doesn't have a tag just his green collar
Des Moines - East
Lost: 5/18/2017
ID: 5620
Name: Chapo
Type: Dog
Color: Grey and white
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
May 18th around 11:00 am
West Des Moines
Lost: 5/17/2017
ID: 5644
Name: Oscar
Type: Cat
Color: Orange and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Oscar has 3 legs. He is very skittish around new people.
Gravity
Lost: 5/17/2017
ID: 5642
Name: Bandit
Type: Small or Furry
Color: Yellow and brown
Breed: Ferret
Gender: Male
Fixed: Neutered
Age: Young
Maybe by school around 6 pm.he his nice hasn't bit anyone , likes our cat and dogs likes dry fruits
Ankeny
Lost: 5/16/2017
ID: 5653
Name: Pickles
Type: Cat
Color: White, black and brown
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Adult
705 NE Cambridge Ct is where she was last seen. Declawed with a couple shaved spots on her sides from a recent vet visit.
Pleasantville
Lost: 5/15/2017
ID: 5672
Name: Smalls
Type: Dog
Color: Wheaton or light grey brindle
Breed: Irish Wolfhound
Gender: Male
Fixed: Not Neutered
Age: Young
Was last seen in his outdoor kennel at Hwy 92, Hwy 5 & G40 intersections. Please help us bring him home