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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Cherokee
Lost: 9/26/2016
ID: 3971
Name: DeDe
Type: Cat
Color: Grey Tabby
Breed:
Gender: Female
Fixed: Neutered
Age: Adult
She is an indoor/outdoor cat and comes in every night; But she hasn't been home for three nights. She does prowl and explore quite a bit, so she may have strayed far away as the neighboring towns. She is a small cat with big ears, green eyes, her nose is mostly grey/black with a little bit of pink
Ankeny
Lost: 9/26/2016
ID: 3951
Name: Daisy
Type: Dog
Color: White/orange
Breed: Brittany Spaniel
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 9/25/2016
ID: 4283
Name: Snickers
Type: Dog
Color: Brindle
Breed: Pit Bull Terrier
Gender: Unknown
Fixed: Not Neutered
Age: Young
He was taken by a alleged friend
Ankeny
Lost: 9/25/2016
ID: 3949
Name: Hank
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
In Ankeny on NW Hickory. He's very loving, but is declawed in the front. He is NOT an outside cat, broke the window screen out. Microchip is not registered to us either. Please help! His brother misses him!
Des Moines - Central
Lost: 9/25/2016
ID: 3946
Name: Bubble
Type: Cat
Color: White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 9/25/2016
ID: 3945
Name: Buuble
Type: Cat
Color: White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
While I was putting her in my car, Bubble run away. I tried my best to catch her but I couldn't.
Des Moines - South
Lost: 9/24/2016
ID: 3930
Name: Buddy
Type: Dog
Color: Red
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Applicable
Age: Young
Des Moines - South
Lost: 9/23/2016
ID: 3963
Name: creed
Type: Dog
Color: white body with black face brwn spots
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
On se 3rd and Thornton.
Ankeny
Lost: 9/23/2016
ID: 3929
Name: Juyles
Type: Cat
Color: Brown head tail and paws
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Ankeny
Lost: 9/23/2016
ID: 3927
Name: Juyles
Type: Cat
Color: Siamese brow head tail and paws with blue eyes
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
She doesn't like to be picked up just call 209/482/7291
Ankeny
Lost: 9/23/2016
ID: 3917
Name: Julyes
Type: Cat
Color: Gray with black paws and head blue eyes
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Baby
Ankeny
Lost: 9/23/2016
ID: 3916
Name: Julyes
Type: Cat
Color: Gray with black head ant paws with blue eyes
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Baby
Bernard
Lost: 9/23/2016
ID: 3914
Name: Detroit
Type: Dog
Color: Brown/Black
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Huxley
Lost: 9/22/2016
ID: 4095
Name: Rocket
Type: Cat
Color: Black
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Last seen around E. 5th St. Huxley Iowa. Rocket had med. long hair, very friendly and he has a little girl that is missing her cat horribly.
Redfield
Lost: 9/22/2016
ID: 3936
Name: Callie
Type: Dog
Color: Black and White
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Adult
My friend was keeping her overnight and my dog was scared. She ran away out in the country at night. She was lost about three miles east of Redfield on Hwy 6.
Des Moines - Central
Lost: 9/21/2016
ID: 3913
Name: Steve
Type: Cat
Color: Brown tiger
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
41st and Rollins -- very sweet however is skittish until comfortable. Microchipped but under incorrect info... ARL has my contact info. Still has all claws.
Des Moines - South
Lost: 9/20/2016
ID: 3934
Name:
Type: Cat
Color: Black with white paws and white on her belly and her chin
Breed: Tiger
Gender: Female
Fixed: Not Neutered
Age: Baby
She jumped over our back door gate, we didn't think she could and now we can't find her. We live between se5th and 8th. On watrous. She has all her claws she is friendly! Her name is athena, she will come as long as she's not busy in doing something else.
Des Moines - South
Lost: 9/20/2016
ID: 3933
Name:
Type: Cat
Color: Black with white paws and white on her belly and her chin
Breed: Tiger
Gender: Female
Fixed: Not Neutered
Age: Baby
She jumped over our back door gate, we didn't think she could and now we can't find her. We live between se5th and 8th. On watrous. She has all her claws she is friendly! Her name is athena, she will come as long as she's not busy in doing something else.
Windsor Heights
Lost: 9/20/2016
ID: 3909
Name: Stormy, aka Sneezers
Type: Cat
Color: Grey
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
We just moved to Des Moines and a member of our family is lost! Please help bring her home to us. We rescued her a year ago and miss her very much!
Ankeny
Lost: 9/20/2016
ID: 3908
Name: Tootsie
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on NE Briarwood Drive in Ankeny. She is VERY loving and sweet, but probably VERY scared.
Marshalltown
Lost: 9/20/2016
ID: 3903
Name: Cocoa
Type: Dog
Color: Brown with black nose
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly.
Washington
Lost: 9/20/2016
ID: 3900
Name: Simba
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Adult
He's not friendly to strangers but please call me if seen.
Washington
Lost: 9/20/2016
ID: 3899
Name: Simba
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
He's not friedny to stranger
Des Moines - South
Lost: 9/19/2016
ID: 3939
Name: Krypto
Type: Dog
Color: White
Breed: Maltipoo
Gender: Male
Fixed: Neutered
Age: Senior
This is pic of dog when he's not dirty and wet. He is blind in one eye which is distinguishing way to identify him. Please contact 515-681-6599 of found.
Des Moines - South
Lost: 9/19/2016
ID: 3938
Name: Krypto
Type: Dog
Color: White
Breed: Maltipoo
Gender: Male
Fixed: Neutered
Age: Senior
This is a pic of a dog that could be one I'm looking for. Last seen on SE 14th by tasty tacos and Kum n go. Was lost in vicinity of SW 7th between Rose and Thornton.