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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Ames
Lost: 6/19/2017
ID: 5916
Name: Nico
Type: Dog
Color: Black and White
Breed: Husky
Gender: Male
Fixed: Neutered
Age: Young
Very kind and healthy, last seen at 10:00am.
West Des Moines
Lost: 6/18/2017
ID: 5947
Name: Ray
Type: Bird
Color: yellow & grey
Breed: Cockatiel
Gender: Male
Fixed: Not Applicable
Age: Baby
Last seen/heard on Western Hills Drive. As of Wednesday, June 21st, we could not hear him. We have been walking around all day every day calling for him. He is very tame, so I am hoping he flew to a stranger because I'm sure he is very hungry and thirsty. If found, feel free to gently grab him as his bites do not hurt. He eats cooked pasta and rice, toast, and crackers (and water). He makes distressed, high-pitched squawks and also wolf whistles and makes kissing noises. He is my emotional support animal, so I am very depressed and distressed.I am offering a reward to anyone who can give me information about his whereabouts or return him to me.
Des Moines - North
Lost: 6/18/2017
ID: 5914
Name: Jerry
Type: Cat
Color: Ginger/orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Jerry slipped out through a screen in an open window overnight. He loves trying to dart outside and explore, but is an indoor cat. Lost near 52nd and Franklin.
Des Moines - Central
Lost: 6/18/2017
ID: 5913
Name: Dreamy
Type: Cat
Color: Orange tabby
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 6/17/2017
ID: 5941
Name: Pepè la Pew
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Comes to the name Pepè or Pepper
Windsor Heights
Lost: 6/17/2017
ID:
Name: Roxie
Type: Dog
Color: Black and brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Young
Windsor Heights
Lost: 6/17/2017
ID: 5905
Name: Roxie
Type: Dog
Color: Black and brown
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Young
She has a bald head and stomach. She is very sweet. only weighs about 3.5 and is very small.
Ankeny
Lost: 6/17/2017
ID: 5899
Name: Dudley
Type: Bird
Color: Grey/yellow head/ orange cheeks
Breed: Cockatiel
Gender: Male
Fixed: Unknown
Age: Adult
Around 5:00 pm. He whistles if your happy and you know it clap your hands, pretty boy, and jingle bells. Sometimes he just squawks repeatedly.
Des Moines - East
Lost: 6/16/2017
ID: 5971
Name: Pickles
Type: Cat
Color: Black
Breed: Cockatiel
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: Cockatiel
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