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
Des Moines - Central
Lost: 11/1/2015
ID: 1995
Name: Jinku
Type: Cat
Color: Grey
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He is an inside/outside cat, very loving to everyone.
Pella
Lost: 11/1/2015
ID: 1888
Name: Pumpkin Cutie
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He normally responds to Pumpkin and snapping. He was last seen around Liberty St.
Des Moines - East
Lost: 11/1/2015
ID: 1791
Name: lola
Type: Dog
Color: blue
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
She was let outside and the gate was open. My kids love her and will be devastated. Please help get her home.
Des Moines - North
Lost: 11/1/2015
ID: 1790
Name: cooper
Type: Dog
Color: blonde
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
last seen at home on merceed street,off of 56ths st near merle hay road. behind the strip mall big lots is located in.
Portsmouth
Lost: 10/31/2015
ID: 1883
Name: Buddy
Type: Dog
Color: yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Senior
Last seen rural Portsmouth 1100 and Elmwood Rds. Usually with smaller brown lab named Bear. We found bear safe and sound, but cannot find Buddy. Very friendly dog.
Marshalltown
Lost: 10/31/2015
ID: 1783
Name: Ittty Bitty
Type: Dog
Color: Brown with white chest and white on paws, 60 lbs but thin looking, Pit Bull mix
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
Marshalltown Iowa Country Club Area.Had leash and collar on. Vet tags on collar.n
Des Moines - North
Lost: 10/30/2015
ID: 2129
Name: Stella
Type: Cat
Color: Tabby and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - North
Lost: 10/30/2015
ID: 1826
Name: Stella
Type: Cat
Color: Tabby/white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Winterset
Lost: 10/30/2015
ID: 1797
Name: Orangey
Type: Cat
Color: Orange & White
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
11 years old, 15 pounds, very friendly! I let him out in the morning, and he disappeared.
Des Moines - East
Lost: 10/30/2015
ID: 1796
Name: Chita
Type: Cat
Color: Gray and white with black strips
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
On the corner of e 14th st and Jefferson. Never leaves .but now missing.
West Des Moines
Lost: 10/30/2015
ID: 1792
Name: Tina
Type: Cat
Color: Coon colors
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
In yard.at end of cul-de-sac..however, lots of construction activity in neighborhood. I worry she might have jumped in truck or perhaps was taken by someone....I hope not...:(
Des Moines - West
Lost: 10/29/2015
ID: 1785
Name: Howie
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Adult
Last seen at 56th and Kingman ave
Des Moines - Central
Lost: 10/28/2015
ID: 1813
Name: Sammy
Type: Cat
Color: All Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Declawed in the front. Not mean. She is very deeply loved.
Johnston
Lost: 10/28/2015
ID: 1769
Name: Ozzie
Type: Dog
Color: Black/Silver
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Young
Last seen around 86th & Meredith. Large black spot on his side. Please call 515-371-8851 or 515-371-8403 if found. Thanks!
Davenport
Lost: 10/28/2015
ID: 1767
Name: Storm
Type: Dog
Color: Black brown white brindle white chest
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
last seen on 13th between Arlington and Grand. Very people friendly, and she loves kids. She played with the kids up the street but they didn't know who dog she was. If found please contact Leo (309)738-2223 Paradise (309)738-6917 or Katherine (563)265-4461
Cedar Rapids
Lost: 10/28/2015
ID: 1765
Name: Meika
Type: Cat
Color: Beige, white, grey, black multicolor
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
2165 Wolf Creek Trail Hiawatha. Two white pouches hang down underneath her belly. She has a small black spot on her inner left eye.
Perry
Lost: 10/27/2015
ID: 1795
Name: Oakley
Type: Dog
Color: Black, with white on chest and some on feet
Breed: Great Dane
Gender: Female
Fixed: Not Applicable
Age: Adult
The picture we have used is a likeness, her ears are not that large but stand up like this Dane's does. She is going to have puppies any time and it's important that we find her. We have been searching by foot and by car in the Dawson, Perry area. I am sure she is very scared. Please help us find her.
Dawson
Lost: 10/27/2015
ID: 1794
Name: Oakley
Type: Dog
Color: Black, white on chest and some on feet
Breed: Great Dane
Gender: Female
Fixed: Not Applicable
Age: Adult
She resembles this picture, a petite Dane. She is getting ready to have puppies. We do have a reward offered with no questions asked. Her ears are cropped, like in this picture, but smaller than normal. Please help us find her. Thank You.
Des Moines - South
Lost: 10/24/2015
ID: 1753
Name: Figaro
Type: Cat
Color: Tiger stripes gray and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Figaro is been with me for 7 years. He have a freckle on his right eye
Tripoli
Lost: 10/24/2015
ID: 1744
Name: Diesel
Type: Dog
Color: Red
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
T-intersection of Highway 63 & 93 near car dealership
Ankeny
Lost: 10/23/2015
ID: 1756
Name: Rupert
Type: Cat
Color: White
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Urbandale
Lost: 10/23/2015
ID: 1746
Name: Fraiser/Roo
Type: Dog
Color: Black/Grey/Pepper
Breed: Schnauzer Standard
Gender: Male
Fixed: Neutered
Age: Young
He was last seen running north on 66th and Roseland in Urbandale. He just had surgery a couple months ago on his hip so he only uses three legs to walk/run. Responds to whistling. White patch on his chest with some more white on his beard. He is very afraid of most people.
Des Moines - North
Lost: 10/22/2015
ID: 1742
Name: FOUND!! Clancy
Type: Cat
Color: Solid grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
After 2 1/2 months our sweet Clancy has come home :)
Clive
Lost: 10/21/2015
ID: 1787
Name: Munchkin (goes by Kitty)
Type: Cat
Color: white with gray markings and blue eyes
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Senior
She is very sweet and shy. May be hesitant to come to anyone. But very sweet.
Des Moines - South
Lost: 10/21/2015
ID: 1748
Name: Jax
Type: Cat
Color: Brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Around park ave. And south union