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>='1585526400')) ORDER BY pm1.meta_value DESC, post_date DESC
Bloomfield
Lost: 1/31/2020
ID: 13369
Name: Ramsey
Type: Dog
Color: Black with dappled color on chest
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Dissapeared from my home outside of Bloomfield ia, without a trace. It's not normal he doesnt come home..
New Virginia
Lost: 1/30/2020
ID: 13323
Name: Max
Type: Dog
Color: Black
Breed: Dachshund Long Haired
Gender: Male
Fixed: Neutered
Age: Adult
Runnells
Lost: 1/30/2020
ID: 13321
Name: Cosmo
Type: Dog
Color: White
Breed: West Highland White Terrier Westie
Gender: Male
Fixed: Neutered
Age: Senior
Last seen at home at 11am. He was let out to use the restroom. He is 15 years old and blind. Sweet but, timid. Lives at 4037 SE 98th Street Runnells, Iowa. Call Marla at 515-238-8199.
Osceola
Lost: 1/28/2020
ID: 13320
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen SW of OSCEOLA
Grimes
Lost: 1/28/2020
ID: 13317
Name: Unknown
Type: Dog
Color: White & Cream
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Found on the side of 141 in Grimes.
Des Moines - South
Lost: 1/28/2020
ID: 13314
Name: Master Chief/ or goes by Chief
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Got out in the area of se 19th st and Amry Post
Urbandale
Lost: 1/27/2020
ID: 13313
Name: Kitty
Type: Cat
Color: White, brown, black
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Young
We think he must have gotten out last night. He is normally an indoor cat and is probably hiding, he is probably very scared and shy. He's my daughter's baby, we have had him since he was a kitten. Please help us bring him home. 515-227-2713
Altoona
Lost: 1/27/2020
ID: 13310
Name: Cashew
Type: Dog
Color: Tan little bit of white
Breed: American Bulldog
Gender: Female
Fixed: Neutered
Age: Young
I’m Altoona around the Walgreens area she is timad but she does not bite please if you find her get in contact she’s a emotional support dog
Waterloo
Lost: 1/27/2020
ID: 13306
Name: Keanu
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Not declawed
Des Moines - South
Lost: 1/26/2020
ID: 13305
Name: Drake
Type: Dog
Color: Black
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Senior
Very friend and loves to hug does not bark much very quiet
Des Moines - North
Lost: 1/26/2020
ID: 13303
Name: Groot
Type: Dog
Color: Brown and black
Breed: Bloodhound
Gender: Male
Fixed: Unknown
Age: Young
Broadway Ave between East 14th and 2nd ave.
Des Moines - North
Lost: 1/26/2020
ID: 13302
Name:
Type: Dog
Color:
Breed: Bloodhound
Gender: Male
Fixed: Unknown
Age: Baby
On Broadway Ave between E. 14th and 2nd ave
Marshalltown
Lost: 1/25/2020
ID: 13309
Name: Peluche
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Unknown
Age: Young
Lost near the cemetery near Riverview park. He is taken on walks daily at Riverview park so he is familar with the area
Waukee
Lost: 1/24/2020
ID: 13330
Name: Benny
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Lives on South School Street. No reports of being seen.
Waukee
Lost: 1/24/2020
ID: 13295
Name: Benny
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
South School Street in Waukee.
Des Moines - East
Lost: 1/23/2020
ID: 13294
Name: Coco
Type: Dog
Color: golden
Breed: Golden Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Coco is friendly female. Lost 1-23-20 late morning. No collar. Responds well to her name Coco. Please call. Thank you.
Des Moines - East
Lost: 1/23/2020
ID: 13293
Name: Coco
Type: Dog
Color: golden
Breed: Golden Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
female named Coco. listens well, responds to Coco. No collar. Lost around East 18th & Hubbell.
Des Moines - Central
Lost: 1/23/2020
ID: 13289
Name: Winnie
Type: Dog
Color: Black with white chest
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen @330am. She goes by Winnie. She loves treats.
Mount Pleasant
Lost: 1/22/2020
ID: 13301
Name: Spot
Type: Dog
Color: Tri-colored (tan,black &white)
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Senior
Southeast of Mount Pleasant, by Boyelston Bridge area,between salem stub and lowell. With our Charcoal Labradore.
Mount Pleasant
Lost: 1/22/2020
ID: 13300
Name: Luna
Type: Dog
Color: Charcoal
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Adult
Southeast of Mt. Pleasant. By Boyelston Bridge area between salem stub and lowell, with our Male Beagle.
Mediapolis
Lost: 1/22/2020
ID: 13299
Name: Grizzly Bear
Type: Dog
Color: Red/Brown
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Seven ponds road South of Mediapolis. Just vanished.
Pleasant Hill
Lost: 1/17/2020
ID: 13260
Name: Bo
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
He has no collar on, big black male. Last seen in my back yard .
Des Moines - Central
Lost: 1/16/2020
ID: 13274
Name: Monroe
Type: Cat
Color: Black and white
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Woodland and 31st area
Des Moines - North
Lost: 1/16/2020
ID: 13255
Name: Bob
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Highland Park Area. Broken tail and fur on nose.
Perry
Lost: 1/16/2020
ID: 13254
Name: Pip
Type: Dog
Color: Blonde
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in the yard at 1323 6th St