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>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 1/26/2020
ID: 13305
Name: Drake
Type: Dog
Color: Black
Breed:
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
West Des Moines
Lost: 1/16/2020
ID: 13251
Name: Sky
Type: Dog
Color: Brown
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
Junction area , close to 8th street
Malvern
Lost: 1/15/2020
ID: 13278
Name: Mash and murphy
Type: Dog
Color: Brown and black and white
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Seen last in Malvern Iowa near home
Hamburg
Lost: 1/15/2020
ID: 13259
Name: Òengus
Type: Dog
Color: Rust
Breed: Vizsla
Gender: Male
Fixed: Not Neutered
Age: Baby
Near Nemaha Cemetery, Brownville, Nebraska. Took off with older female vizsla but may have separated.
Hamburg
Lost: 1/15/2020
ID: 13258
Name: Rye
Type: Dog
Color: Rust
Breed: Vizsla
Gender: Female
Fixed: Not Applicable
Age: Senior
Near Nemaha Cemetery, Brownville, Nebraska. Took off with younger male vizsla. May no longer be together.
Des Moines - East
Lost: 1/15/2020
ID: 13257
Name: Bella
Type: Cat
Color:
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Senior
Around East Euclid Hy-Vee
Des Moines - Central
Lost: 1/14/2020
ID: 13273
Name: Joey
Type: Cat
Color: White
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Adult
Orange tipped ears, Male, named Joey
Des Moines - East
Lost: 1/14/2020
ID: 13271
Name: Trouble
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Fairgrounds area
Independence
Lost: 1/14/2020
ID: 13261
Name: LPB
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
My mom thinks he got out when she went to work. He’s nice and won’t hurt you if you go up to him. He may run though.
Des Moines - Central
Lost: 1/13/2020
ID: 13243
Name: Dixie
Type: Dog
Color: Gray and White
Breed: Schnauzer
Gender: Female
Fixed: Unknown
Age: Baby
Walmart SE 14th Parking Lot. Animal control is on way.