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>='1606003200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 6/23/2020
ID: 14315
Name: Buddy
Type: Cat
Color: Grey, dark brown, cream
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
He loves treats. We shake the bag to get him to come.
Des Moines - South
Lost: 6/23/2020
ID: 14309
Name: Zuri
Type: Dog
Color: White with tan spots
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
She was stolen from my friend’s backyard, wearing white and blue leash. Super friendly. Friend lives 5 minutes away from Grandview College in Des Moines.
Johnston
Lost: 6/23/2020
ID: 14304
Name: Beckett
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Trails/neighborhood behind apartments across street from middle school
Pleasant Hill
Lost: 6/22/2020
ID: 14374
Name: Pebbles
Type: Cat
Color: Black calico
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
830 sherrylynn boulevard
Runnells
Lost: 6/22/2020
ID: 14331
Name: Captain
Type: Cat
Color: Cream
Breed: Selkirk Rex
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by neighbor on 06/24/2020. Was recently groomed/shaved so is not as fuzzy.
Runnells
Lost: 6/22/2020
ID: 14330
Name: Captain
Type: Cat
Color: Cream
Breed: Selkirk Rex
Gender: Male
Fixed: Neutered
Age: Adult
Last sighted 06/24/2020 by a neighbor. Is not as fuzzy due to recently being groomed/shaved.
Des Moines - North
Lost: 6/22/2020
ID: 14317
Name: Ginger
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Her collar was broken so she doesn’t have one on. She will come to you if you call her name. She has green eyes and a black spot on her nose.
Pleasant Hill
Lost: 6/22/2020
ID: 14316
Name: Pebbles
Type: Cat
Color: Black calico
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Adult
Whoever brings our babygirl back home to us will receive a $50 reward....
Urbandale
Lost: 6/22/2020
ID: 14306
Name: Casper
Type: Cat
Color: Black n white
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Young
145th n Buena Vista St URBANDALE
Lamoni
Lost: 6/21/2020
ID: 14644
Name: Gina
Type: Cat
Color: Orange and white
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Senior
escaped from the highway rest area on I35 Lamoni Iowa (Decatur Rest area), ran in the forest towards Slip Bluff County Park. She was then 15 lbs. She is beautiful long hair with green eyes. She is very shy and best way to approach her would be to seat down with a bowl of wet food. It may take some time before she warms up to whoever finds her as she would be very scared.
Des Moines - East
Lost: 6/21/2020
ID: 14311
Name: Akira
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in 2200 block of York St. Very timid cat. Spooks easily. No claws front or back. Escaped through doggy door. Not an outdoor cat! Please call 641-780-7142 if you find her.
Des Moines - Central
Lost: 6/21/2020
ID: 14290
Name:
Type: Dog
Color: Brown/black/gray
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Clive
Lost: 6/21/2020
ID: 14285
Name: Cooper
Type: Dog
Color: Black and White
Breed: Hound
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in the KFC Parking Lot located on University Ave in Clive.
Altoona
Lost: 6/21/2020
ID: 14284
Name:
Type: Dog
Color:
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Wearing pinch collar and dragging black leash. Not from area, visiting family so he is not familiar with area. Friendly.
West Des Moines
Lost: 6/21/2020
ID: 14282
Name: Tinsel
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Lost in West Glen. He’s fluffy and has no front claws.
Des Moines - East
Lost: 6/20/2020
ID: 14389
Name: Akira
Type: Cat
Color: Black and white
Breed: Persian
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at 2202 York Street in Des Moines. Very skittish! Please call at 6417807142 if you see her.
Ames
Lost: 6/20/2020
ID: 14325
Name: Salem
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at Copper Beech in Ames. Microchipped and neutered. Desperate to find him as I am moving soon.
West Des Moines
Lost: 6/20/2020
ID: 14299
Name: Gracie
Type: Cat
Color: Dark gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She’s very timid and scared of people. She’s fast so very hard to catch. Tempt her with food I think that would be the best bet. Call at 515-537-3575
Ames
Lost: 6/20/2020
ID: 14293
Name: Salem
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at Copper Beech in Ames, IA. Copper Beech is situated between The Quarters and Old Orchard Mobile Home Park, and across the street from The Grove. He responds to Salem or Saley. He is very missed by his brother from the same litter and of course me.
Spring Hill
Lost: 6/20/2020
ID: 14291
Name: Lexi
Type: Dog
Color: Gray, black, blonde
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Senior
9pm. Ran away due to fireworks.
Waukee
Lost: 6/20/2020
ID: 14289
Name: Reposado (Repo0
Type: Cat
Color: Orange/White
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Misplaced and far from his regular home. Friendly & sweet. Orange/White cat last seen in 50325 area. (hickman/racoon river valley trail) Contact 515-771-6211 with any information. Thank you!
Clive
Lost: 6/20/2020
ID: 14288
Name: Repasado
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Last seen on 137th street in the country club neighborhood
Des Moines - West
Lost: 6/20/2020
ID: 14276
Name: Chapo
Type: Dog
Color: Black no top brown on bottoms
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Was at car wash right next to the McDonald’s on grand ave ran off last time I saw my little chapo $50 reward for anyone who find him call (515)528-1444
Des Moines - West
Lost: 6/19/2020
ID: 14483
Name: Bella
Type: Cat
Color: Black and white fluffy
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
On the west side university and mlk
Des Moines - Central
Lost: 6/19/2020
ID: 14361
Name: Blue
Type: Cat
Color: White and gray
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Baby
Lost kitten last seen des.moines and known of was Friday night surrounded area of Washington and franklin ave his name is blue if you have any information or have been seen please inbox me please and thank you god bless