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
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
Garwin
Lost: 9/16/2016
ID: 3879
Name: Chesney
Type: Dog
Color: merle coat with ice blue eyes
Breed: Catahoula Leopard Dog
Gender: Female
Fixed: Not Applicable
Age: Young
IDC how u have been or how u know where she is. I will not ask questions. I just wanna get her home. Plz
Garwin
Lost: 9/16/2016
ID: 3878
Name: Chesney
Type: Dog
Color: merle coat with ice blue eyes
Breed: Catahoula Leopard Dog
Gender: Female
Fixed: Not Applicable
Age: Young
IDC how u have been or how u know where she is. I will not ask questions. I just wanna get her home. Plz
De Soto
Lost: 9/15/2016
ID: 3876
Name: Bella
Type: Dog
Color: White
Breed: Samoyed
Gender: Female
Fixed: Not Neutered
Age: Young
Last Seen on 9-15-16 at approximately 6:30 PM. Guthrie St and Spruce St in De Soto, IA Bella is friendly but a runner. She also has separation anxiety.
Lincoln
Lost: 9/15/2016
ID: 3870
Name: Rudy
Type: Dog
Color: Rust
Breed: Vizsla
Gender: Male
Fixed: Neutered
Age: Senior
Old, sweet dog. Has trouble hearing and seeing
Des Moines - South
Lost: 9/14/2016
ID: 3882
Name: Hellboy
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Corner of Sw9th and Loomis.. Possibly seen taken by a Caucasian woman in a white minivan.
Des Moines - East
Lost: 9/14/2016
ID: 3869
Name: Hunny
Type: Dog
Color: Blondish brown
Breed: Pomeranian
Gender: Unknown
Fixed: Neutered
Age: Adult
Menlo
Lost: 9/13/2016
ID: 4080
Name: Modi
Type: Dog
Color: Black and tan, some white
Breed: Shiba Inu
Gender: Male
Fixed: Not Neutered
Age: Adult
Possibly spotted recently ( 4/12/2017 ) in Casey. Very friendly, Modi likes kids, pets, car rides and potato chips. He has a home again microchip #985111000039881 He is greatly missed and we are offering a reward for his return.