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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Mount Pleasant
Lost: 6/1/2017
ID: 10106
Name: Usher
Type: Cat
Color: Tuxedo
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Altoona
Lost: 6/1/2017
ID: 5752
Name: Dink
Type: Cat
Color: Black and grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Last seen in Country Cove. Declawed and very loving.
West Des Moines
Lost: 5/31/2017
ID: 5742
Name: Bynx
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He has one eye with a red discoloration in it from a broken blood vessel as a baby, and he's extremely friendly and sweet to everyone
Des Moines - Central
Lost: 5/31/2017
ID: 5736
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Unknown
Age: Young
Collins
Lost: 5/30/2017
ID: 5962
Name: Bella
Type: Dog
Color: Brown/Gray/Silver
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Applicable
Age: Young
She was taken to a 3241 Mahaska In DSM. Individual Doug gave her to a family with 8YO girl and are unwilling to return. Bella is reported stolen please return her.
Cedar Rapids
Lost: 5/30/2017
ID: 5760
Name: Oshie
Type: Dog
Color: Brown/black
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
He was last seen on Wilson ave. By the hilltop kennels. He is a lab mix. He was a rescue so he is still very timid. He has some small scars on his face and a white stripe on his chest.
Ankeny
Lost: 5/30/2017
ID: 5738
Name: Stevie
Type: Cat
Color: black and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Lost in Saylor Township - Woodside Estates West - Please call 515-868-9041 if found. Her name is Stevie - she's about 2 years old. Thank you!
Ankeny
Lost: 5/30/2017
ID: 5737
Name: Stevie
Type: Cat
Color: Black and White
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Near Woodside Estates West, near 2nd Avenue and 6th.
Des Moines - East
Lost: 5/29/2017
ID: 5730
Name: Max
Type: Dog
Color: Brown
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on East 27th court at home
Des Moines - East
Lost: 5/29/2017
ID: 5712
Name: Bengi
Type: Dog
Color: Buff
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
Lost at E9th and Douglas headed toward E 8th Street
Des Moines - East
Lost: 5/29/2017
ID: 5711
Name: Bengi
Type: Dog
Color: Buff
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
Lost at E9th and Douglas headed toward E 8th Street
Des Moines - South
Lost: 5/28/2017
ID: 5925
Name: Odin
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 5/28/2017
ID: 5717
Name: kali
Type: Cat
Color: grey tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
7100 block of ne 14th st (south of ankeny)
Polk City
Lost: 5/28/2017
ID: 5706
Name: Blackie
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Senior
15+ years old. Mostly deaf. Very bow legged.
Altoona
Lost: 5/28/2017
ID: 5704
Name: Max
Type: Dog
Color: Dark Brown with Black markings. He is a wirehair doxie mix, but has long legs, not short
Breed: Dachshund Standard
Gender: Male
Fixed: Neutered
Age: Adult
Max will come to you if you coax him. He is a lover not a fighter. Won't bite.
Des Moines - South
Lost: 5/27/2017
ID: 5860
Name: Odin
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Storm Lake
Lost: 5/25/2017
ID: 5746
Name: Mango
Type: Bird
Color: Yellow with neon green
Breed: Budgie/Budgerigar
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen in Lakeside on a tree. I am still looking for him and will not lose hope. If anyone has seen my budgie please contact me. :,(
Storm Lake
Lost: 5/25/2017
ID: 5745
Name: Mango
Type: Bird
Color: Yellow with a green/neon green.
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen around lake side in Birch Street. Really heart broken and I'm still looking for it. Not losing hope. If someone has seen or know of this bird please contact me :(
Des Moines - East
Lost: 5/24/2017
ID: 5750
Name: Odie
Type: Cat
Color: tan/orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He was at my house, got out the front door.
Des Moines - East
Lost: 5/24/2017
ID: 5707
Name: Crow
Type: Cat
Color: Black
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on May 24, 2017 Small white spot on chest Also called "Kit Cat"
Des Moines - South
Lost: 5/24/2017
ID: 5682
Name: Pepper
Type: Dog
Color: White/Black/Brown
Breed: Rat Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Southwestern Hills neighborhood on SW 26th is where she escaped, last seen 5/26/17 at 6am near McKinley & Wakonda Pkwy
Pleasantville
Lost: 5/23/2017
ID: 5748
Name: Smalls
Type: Dog
Color: Wheaton
Breed: Irish Wolfhound
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 5/23/2017
ID: 5677
Name: Chico
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Senior
Lost around SE 14th and King
Fort Dodge
Lost: 5/23/2017
ID: 5663
Name: Charlotte
Type: Dog
Color: White and brown ears
Breed: Cockapoo
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen on south side. Doesn't have collar on
Des Moines - North
Lost: 5/22/2017
ID: 5655
Name: harley
Type: Dog
Color: white with tan spots
Breed: Shih Tzu
Gender: Female
Fixed: Not Neutered
Age: Adult
Possibly looking for my father who is deceased. Answers to Harley Warley woo. Very friendly