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>='1575331200')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Des Moines - South
Lost: 9/19/2016
ID: 3937
Name: Krypto
Type: Dog
Color: White
Breed: Maltipoo
Gender: Male
Fixed: Unknown
Age: Senior
Potentially this dog has been seen on SE 14th by Aldis, tasty tacos, usually in apartment complex by next to tasty tacos. This dog runs every time anyone tries to get close and wouldn't come to me or my kids/family. Not sure it Is my dog but looks a lot like him if he was all wet and dirty. Please contact 515-681-6599 if found or seen.
Des Moines - South
Lost: 9/19/2016
ID: 3898
Name: Krypto
Type: Dog
Color: White
Breed: Maltipoo
Gender: Male
Fixed: Neutered
Age: Adult
Blind in one eye
Des Moines - West
Lost: 9/18/2016
ID: 3942
Name: Spunky
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
He is a very friendly cat and really good with people - hopefully someone will have seen him... my kids and I miss him so much. He is an indoor/outdoor cat, and has never wandered like this before.
Urbandale
Lost: 9/18/2016
ID: 3894
Name: george
Type: Cat
Color: yellow stripped tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
lost midday at 82nd and aurora... Name is George!
Des Moines - East
Lost: 9/18/2016
ID: 3887
Name:
Type: Dog
Color:
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 9/18/2016
ID: 3886
Name: onyx
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
east 38th n easton
Des Moines - South
Lost: 9/17/2016
ID: 4265
Name: Captain Jack
Type: Cat
Color: Black and White Tuxedo cat
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
on west street one block south of Army post Rd. Back right leg is black but others are white. back left paw has black spot on the bottom. pink nose with 3 black dots across the top. black mask, the white between the eyes doesn't point and squares leaning to the right, mask on left side comes up on nose bridge a tad. 10 pounds, has claws. Phone: 515-402-6962. reward. I need to know if he is alive at least. I love him So Much!
Vinton
Lost: 9/17/2016
ID: 3896
Name: Bailey
Type: Dog
Color: Black and brown
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Northern Benton County
Des Moines - East
Lost: 9/17/2016
ID: 3884
Name: Sprinkles
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at Park Winds apts, all black cat with green eyes. Mildly aggressive to strangers
Des Moines - North
Lost: 9/16/2016
ID: 3905
Name: Nala
Type: Dog
Color: Black, tan
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Not Neutered
Age: Young
Has Windsor heights registration on her collar very friendly
Des Moines - North
Lost: 9/16/2016
ID: 3904
Name: Nala
Type: Dog
Color: Black, tan
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Not Neutered
Age: Young
Very friendly, daughter left her on the porch and she got loose, has Windsor heights pet registration on her collar.
Des Moines - East
Lost: 9/16/2016
ID: 3881
Name: Josie
Type: Cat
Color: Black/orange
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Baby
East 43rd street and east Euclid area. She is very sweet but very shy. Doesn't want to be held. No collar she is about 2-3 months old. Very little