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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Pleasant Hill
Lost: 5/18/2017
ID: 5638
Name: Mocha
Type: Dog
Color: Silver
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Pleasant Hill
Lost: 5/18/2017
ID: 5637
Name: Mocha
Type: Dog
Color: Silver
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Young
Pleasant Hill
Lost: 5/18/2017
ID: 5636
Name: Mocha
Type: Dog
Color: Silver
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 5/18/2017
ID: 5633
Name: Stellan
Type: Cat
Color: Grey tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
He goes outside regularly but doesn't usually stray far, concerned he may be in someone's garage or trapped. He usually hangs around Bowdoin, Amherst, Columbia area south of Euclid.
Des Moines - Central
Lost: 5/18/2017
ID: 5631
Name: Lucy
Type: Cat
Color: Solid white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
I think she got disoriented in the storm and hopefully got taken in or she sought shelter in a garage or she'd
Des Moines - North
Lost: 5/18/2017
ID: 5624
Name: Coby
Type: Dog
Color: Black and tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
He doesn't have a tag just his green collar
Des Moines - East
Lost: 5/18/2017
ID: 5620
Name: Chapo
Type: Dog
Color: Grey and white
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
May 18th around 11:00 am
West Des Moines
Lost: 5/17/2017
ID: 5644
Name: Oscar
Type: Cat
Color: Orange and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Oscar has 3 legs. He is very skittish around new people.
Gravity
Lost: 5/17/2017
ID: 5642
Name: Bandit
Type: Small or Furry
Color: Yellow and brown
Breed: Ferret
Gender: Male
Fixed: Neutered
Age: Young
Maybe by school around 6 pm.he his nice hasn't bit anyone , likes our cat and dogs likes dry fruits
Ankeny
Lost: 5/16/2017
ID: 5653
Name: Pickles
Type: Cat
Color: White, black and brown
Breed: Calico
Gender: Female
Fixed: Not Applicable
Age: Adult
705 NE Cambridge Ct is where she was last seen. Declawed with a couple shaved spots on her sides from a recent vet visit.
Pleasantville
Lost: 5/15/2017
ID: 5672
Name: Smalls
Type: Dog
Color: Wheaton or light grey brindle
Breed: Irish Wolfhound
Gender: Male
Fixed: Not Neutered
Age: Young
Was last seen in his outdoor kennel at Hwy 92, Hwy 5 & G40 intersections. Please help us bring him home
Osceola
Lost: 5/15/2017
ID: 5635
Name: Mandy
Type: Cat
Color: Black white orange
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
Owners are truck drivers. She snuck out of an open window. Not sure what location exactly. Somewhere between Des Moines and Osceola.
Pleasantville
Lost: 5/15/2017
ID: 5594
Name: Smalls
Type: Dog
Color: Cream color/light gray
Breed: Irish Wolfhound
Gender: Male
Fixed: Not Neutered
Age: Young
Winterset
Lost: 5/15/2017
ID: 5592
Name: Princess
Type: Dog
Color: Black and tam
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Young
Last seen near hyvees. Winterset iowa j
Des Moines - West
Lost: 5/15/2017
ID: 5586
Name: Darling
Type: Cat
Color: Grey and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Lost 7/20/2016 I won't give up until she's home! She is my ESA... Any news is news... Jumped out of kennel in the car around Casey's on 22nd st. Ran off towards Culvers and disappeared near the school/daycare... Please help me find my babygirl she's 5 & 1/2, and if taken to Furry Friends refuge, they will contact me. Please help, my baby girl is still missing... :( 7738140142 is my cell. Text with any info.
Bondurant
Lost: 5/14/2017
ID: 5615
Name: Sammy
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Collar was found in the yard. He's 13yrs old. Black and white long haired.
Bondurant
Lost: 5/14/2017
ID: 5614
Name: Sammy
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Collar was found in the yard. He's 13yrs old. Black and white long haired.
Leon
Lost: 5/14/2017
ID: 5595
Name: Jackson
Type: Dog
Color: Black white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
White jeep with trailer unknown if they had anything to do with it. List just north of Davis city, south of leon
Des Moines - South
Lost: 5/14/2017
ID: 5588
Name: Chick a ling
Type: Dog
Color: Black
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen county line Rd
Des Moines - North
Lost: 5/14/2017
ID: 5587
Name: Rhurbarb
Type: Pig
Color: Blonde with black spots
Breed: Unknown
Gender: Female
Fixed: Not Applicable
Age: Baby
Beaver and Meredith Drive
Des Moines - East
Lost: 5/13/2017
ID: 5719
Name: Jemma
Type: Cat
Color: Grey black orange
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
E 42nd and Hull
Ackley
Lost: 5/13/2017
ID: 5716
Name: Onyx
Type: Cat
Color: Black with white spot on chest
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
Mel Ray mobile home Park (where I live)
Ackley
Lost: 5/13/2017
ID: 5715
Name: Onyx
Type: Cat
Color: Black with white spot on chest
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
Mel Ray mobile home Park (where I live)
Tama
Lost: 5/13/2017
ID: 5596
Name: Aida
Type: Dog
Color: blond/gold
Breed: Golden Retriever
Gender: Female
Fixed: Unknown
Age: Young
Note: photo is of Aida's litter mate, as the most recent picture I have is from the winter and she's grown a lot since then. Missing a 6 month old female Golden Retriever named Aida. Missing from H Ave Tama , around Ridge Rider/Outback Campground road and the Meskwaki Settlement. We dearly miss her so Please call with any information 641 751 3330.
Des Moines - Central
Lost: 5/13/2017
ID: 5585
Name: Caine
Type: Dog
Color: Tan
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Young
E elm with a puppy bulldog mix brown