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>='1579219200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 12/26/2019
ID: 13135
Name: ziggy
Type: Cat
Color: black and white tuxedo
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
east 10th and Madison by Madison elementary
Bondurant
Lost: 12/26/2019
ID: 13120
Name: Sniffy
Type: Dog
Color: Redbone
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Running on grant in bondurant
Bondurant
Lost: 12/26/2019
ID: 13119
Name: Sniffy
Type: Dog
Color: Redbone
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
Running on grant in bondurant
Norwalk
Lost: 12/25/2019
ID: 13156
Name: Bailey
Type: Dog
Color: Tri.. brown, black and white
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Senior
She went running in our fields like a normal day but did not come home. We live about 3 miles north from the Hitchin Post in Beavington in the country west of Hwy 35. She lost her collar with her rabies tag but has her grey flea/tic collar. Her vet is Winterset Vet and Bailey’s last name is Poe.
Urbandale
Lost: 12/25/2019
ID: 13118
Name: Sam
Type: Cat
Color: brown, black and white
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
153rd and Townsend Urbandale, IA
Clive
Lost: 12/25/2019
ID: 13117
Name:
Type: Cat
Color: grey/white
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Young
This sweet pea has been hanging around my yard for a few days, most recently been very hungry so he's been fed and loved upon! He is a just the friendliest little thing! Hoping he's got a home!
Des Moines - East
Lost: 12/25/2019
ID: 13116
Name: Frida
Type: Dog
Color:
Breed: Pug
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 12/25/2019
ID: 13115
Name:
Type: Dog
Color:
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Baby
Ames
Lost: 12/24/2019
ID: 13201
Name: Ace
Type: Cat
Color: Tuxedo
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Ralston
Lost: 12/24/2019
ID: 13133
Name: Chong
Type: Cat
Color: White tan
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Leave voicemail call od text if found. Hes the bigger cay in photo. Reward offered if found 515-979-9325 or 515-478-4806
Bagley
Lost: 12/24/2019
ID: 13132
Name: Chong
Type: Cat
Color: White and tan
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Ralston ia on green street. His brother cheech is devastated! Please help :( contact if found safe reward is offered! 515-979-9325 Leave a voice mail if no answer or text!!
Ankeny
Lost: 12/24/2019
ID: 13121
Name: Flynn
Type: Cat
Color: White with grey spots
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Polk City
Lost: 12/24/2019
ID: 13110
Name: Asteroid
Type: Dog
Color: Red, brown, & white
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Baby
Update - he is home and safe! Thank you everyone! Last seen near Prairie Flower Camp Grounds and Oak Grove Recreational Area near Polk City, Update - Last seen at 18th and Irvinedale in Ankeny.
Polk City
Lost: 12/23/2019
ID: 13114
Name: Sneakers
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Our cat Sneakers went missing on the 23rd. He is very friendly, but tends to be shy of strangers. He has a little white On his chest and a little white on his front feet. We really miss him so much and if spotted or found please don’t hesitate to call.
Des Moines - South
Lost: 12/23/2019
ID: 13103
Name: Euby
Type: Dog
Color: Grey w/ White streaks
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Senior
On Thorton Avenue south side
Des Moines - North
Lost: 12/22/2019
ID: 13099
Name: Charlie
Type: Dog
Color: Black and brown
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
Please call me 5153004397
Clive
Lost: 12/22/2019
ID: 13098
Name: Izzy
Type: Dog
Color: White and black
Breed: Poodle
Gender: Male
Fixed: Not Neutered
Age: Young
On back deck
Clive
Lost: 12/22/2019
ID: 13097
Name: Izzy
Type: Dog
Color: White and Black
Breed: Poodle
Gender: Female
Fixed: Not Neutered
Age: Young
120th street
Clive
Lost: 12/22/2019
ID: 13096
Name: Izzy
Type: Dog
Color: white and Black
Breed: Poodle
Gender: Female
Fixed: Not Neutered
Age: Young
on back deck
Des Moines - North
Lost: 12/22/2019
ID: 13095
Name: Scruffy
Type: Dog
Color: Whitt
Breed: Poodle
Gender: Male
Fixed: Neutered
Age: Senior
He has had a severe allergic reaction that has left his no Tom without fur
Des Moines - South
Lost: 12/22/2019
ID: 13094
Name: Suger
Type: Dog
Color: Tan and white
Breed: Poodle
Gender: Female
Fixed: Neutered
Age: Adult
Last seen near Riverwoods Elementary in South Des Moines. Please call Debbie at 515-608-3787 or Kyle at 515-422-6645,
Clive
Lost: 12/21/2019
ID: 13134
Name: Shilo
Type: Dog
Color: Black & white
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Young
Escaped from my son’s backyard
Des Moines - North
Lost: 12/21/2019
ID: 13106
Name: Jester
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Scar on his nose, and upper left front leg. Small notch in left ear
Ames
Lost: 12/21/2019
ID: 13101
Name: Goblin
Type: Cat
Color: dark grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Bolted out the door around 10pm in the SUV campus housing area. She is declawed and never been outside before.
Urbandale
Lost: 12/21/2019
ID: 13100
Name: Oliver
Type: Cat
Color: Black, white, light brown
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Around Sherwood Glen apartment area, his left pupil is fogged over, super friendly