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 - East
Lost: 6/16/2017
ID: 5971
Name: Pickles
Type: Cat
Color: Black
Breed:
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around home by union park. Very talkative and skittish. Doesn't really like dogs at all.
West Des Moines
Lost: 6/16/2017
ID: 5896
Name: Lovey
Type: Cat
Color: White black
Breed:
Gender: Female
Fixed: Neutered
Age: Adult
Spirit Lake
Lost: 6/16/2017
ID: 5892
Name: Dixie (WinnDixie)
Type: Dog
Color: Blonde
Breed: Cairn Terrier
Gender: Female
Fixed: Neutered
Age: Adult
She was on a leash on the south shore of Big Spirit when she took off after a bunny and my daughter lost her grip on the leash.
Johnston
Lost: 6/16/2017
ID: 5889
Name: Miss fuzzy pants
Type: Cat
Color: Little of everything
Breed: Cairn Terrier
Gender: Female
Fixed: Neutered
Age: Young
She is super friendly and her front paws are declawed. She has a red spot on her head.
Polk City
Lost: 6/16/2017
ID: 5878
Name: Paco
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He will respond to his name.
West Des Moines
Lost: 6/15/2017
ID: 5884
Name: Patch
Type: Dog
Color: Brown/Black Brindle and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
He needs medicine for a medical condition everday.
West Des Moines
Lost: 6/15/2017
ID: 5883
Name: Patch
Type: Dog
Color: Brown/Black Brindle and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
He needs medication for a medical condition on a daily basis.
West Des Moines
Lost: 6/15/2017
ID: 5881
Name: Ben
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
We don't have a picture as we are cat sitting!! If you see any black and white cat around west Des Moines 50th-35th please let us know!!! He meows a lot at night
Des Moines - South
Lost: 6/15/2017
ID: 5880
Name:
Type: Dog
Color: Tan/Black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 6/15/2017
ID: 5879
Name:
Type: Dog
Color: Tan/Black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 6/15/2017
ID: 5872
Name: MJ
Type: Dog
Color: Black and white
Breed: Papillon
Gender: Female
Fixed: Unknown
Age: Adult
Last seen by Indianola ave and se 6th st
Pleasantville
Lost: 6/14/2017
ID: 5915
Name: CiCi
Type: Dog
Color: White with black ears and black nose
Breed: Jack Russell Terrier
Gender: Female
Fixed: Neutered
Age: Senior
CiCi is 12 years old and very friendly. She was last seen in her yard at 604 S Columbus St in Pleasantville, IA 50225 on 6/14/17. Her owner is Corey Christopherson and his number is 515-681-6073. Or you can call my cell at 515-554-5155. She has a red tag on her collar with her name and Corey's number. Reward for information leading to her being found.
Ames
Lost: 6/14/2017
ID: 5900
Name:
Type: Cat
Color: White and black
Breed: Jack Russell Terrier
Gender: Female
Fixed: Unknown
Age: Baby
Last seen at Sandcastle Dr. Ames IA
Des Moines - South
Lost: 6/13/2017
ID: 5898
Name: Snake eyes
Type: Cat
Color: Brown/black tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
In neighborhood between porter and Army post SW Des Moines south side
Harvey
Lost: 6/13/2017
ID: 5875
Name: Emma
Type: Dog
Color: white
Breed: Poodle Miniature
Gender: Female
Fixed: Neutered
Age: Senior
Lost Poodle, Emma. She was driven and left off and at 2030 Lowe Drive, Harvey iowa. She accidentally got out while we were not home and went over to our neighbors. He took her in his truck and dumped her off over a mile down the road. She is wearing a new blue color, she is microchipped. She has a short clipped haircut, she has several warts and she is somewhat deaf. We were babysitting our grand-dog because of their new baby and she is from Johnston, Iowa. So she has no idea where she is at or where home is but I am afraid she is headed back to Johnston. Please help find her, I am very afraid for her!
Ankeny
Lost: 6/13/2017
ID: 5859
Name:
Type: Cat
Color: Tan/brown/white
Breed: Poodle Miniature
Gender: Unknown
Fixed: Unknown
Age: Baby
Found on Sawgrass Pkwy. @ 9:30 PM on Tuesday 6/13.
Des Moines - South
Lost: 6/12/2017
ID: 6185
Name: Nosey
Type: Cat
Color: Dark grey and white with a distinctive grey nose
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
Apartments at Pioneer estates
Pleasant Hill
Lost: 6/12/2017
ID: 5870
Name: Kenneth
Type: Cat
Color: Brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Osceola
Lost: 6/12/2017
ID: 5865
Name:
Type: Dog
Color: Dapple white, black and tan
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Adult
Very friendly
Grimes
Lost: 6/12/2017
ID: 5858
Name: Chester
Type: Cat
Color: taffy/orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
around 9th ct/Shawver Dr,Grimes,IA,very friendly has a collar and an if found tag ,with his address .All 4 declawed.Very loud meow.
Des Moines - East
Lost: 6/11/2017
ID: 5871
Name: Gizmo aka baby girl
Type: Cat
Color: Black with white spot on chest and belly
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Very loving will come up to you and rub on you
Clive
Lost: 6/11/2017
ID: 5864
Name: Unknown
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
80th Ct and Harbach
Clive
Lost: 6/11/2017
ID: 5862
Name:
Type: Cat
Color: Orange and white
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Ankeny
Lost: 6/11/2017
ID: 5857
Name: William
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
William was last seen in our backyard. He's a very friendly, affectionate cat who can be chatty. He's not aggressive at all but doesn't like to be picked up.
Clive
Lost: 6/11/2017
ID: 5849
Name: SHADOW
Type: Cat
Color: GREY
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
VERY SHY. LAST SEEN AT WOODLANDS CREEK SENIOR RESIDENCE AT 12655 WOODLANDS PKW, CLIVE, IA