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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 2/2/2016
ID: 2298
Name: Elliott
Type: Cat
Color: grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
On back step at 2912 Dean ave fairgrounds in des Moines is
Oskaloosa
Lost: 2/1/2016
ID: 4623
Name: Myer
Type: Dog
Color: White/Red
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Last seen using the bathroom in the yard off highway 92.
Des Moines - East
Lost: 2/1/2016
ID: 2288
Name: fajita
Type: Cat
Color: orange striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
last seen late 1/31/16. he didn't come in when called like usual. he has all his claws, is fat, and a huge lover cat. he may have been fighting with a coon.
Des Moines - West
Lost: 1/31/2016
ID: 2377
Name: Cookie
Type: Dog
Color: Blackish brown
Breed: Poodle Toy
Gender: Female
Fixed: Not Neutered
Age: Adult
Beaverdale area.
Des Moines - West
Lost: 1/31/2016
ID: 2376
Name: Swagger
Type: Dog
Color: White and brown
Breed: Yorkie Poo
Gender: Male
Fixed: Unknown
Age: Adult
Beaverdale area.
Des Moines - West
Lost: 1/31/2016
ID: 2282
Name: Swagger
Type: Dog
Color: White
Breed: Yorkie Poo
Gender: Male
Fixed: Not Neutered
Age: Adult
Des Moines - West
Lost: 1/31/2016
ID: 2281
Name: Cookie
Type: Dog
Color: Blackish brown
Breed: Poodle
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen in the house. She has four puppies who need her so please help me find my dog. We miss and love her.
Des Moines - Central
Lost: 1/31/2016
ID: 2274
Name: Romeo
Type: Dog
Color: Black
Breed: Poodle
Gender: Male
Fixed: Neutered
Age: Adult
Sherman Hill area. MLK and Woodland/Ingrosoll Ave.
Klemme
Lost: 1/30/2016
ID: 2287
Name: Duke
Type: Dog
Color: Brindle (brown with black stripes)
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
There was a green pickup truck loitering around our farm the morning he didn't come home. I am offering a reward - no questions asked. I just need him back.
Des Moines - East
Lost: 1/30/2016
ID: 2273
Name: Ginger
Type: Dog
Color: Gold/Yellow
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Baby
By 14th and Guthrie, very friendly dog. 15 years old
Mason City
Lost: 1/30/2016
ID: 2272
Name: Garbo
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
217 6th street
Mason City
Lost: 1/30/2016
ID: 2271
Name: Garbo
Type: Dog
Color: Black
Breed: Beagle
Gender: Unknown
Fixed: Not Neutered
Age: Adult
217 6th street
Des Moines - East
Lost: 1/30/2016
ID: 2266
Name: Kane
Type: Dog
Color: White
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at E.23rd and Des Moines St.
Des Moines - North
Lost: 1/29/2016
ID: 2264
Name: Jax
Type: Dog
Color: Black and White
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around 9pm near Firestone on 2nd Ave, he is a small black and white dog and he should come if you call out his name.
Des Moines - East
Lost: 1/24/2016
ID: 2246
Name: Onyx
Type: Dog
Color: Blue and white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - North
Lost: 1/23/2016
ID: 2270
Name: Lady
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Senior
16th and Lincoln 5154903517
Des Moines - South
Lost: 1/22/2016
ID: 3136
Name: Russo
Type: Dog
Color: Black with brown
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Young
He is a really nice dog !! He's been gone for a while , if you know where I could find him or have info please contact me !
Des Moines - South
Lost: 1/22/2016
ID: 2602
Name: Russo
Type: Dog
Color: Black and brown in mouth chest legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog ! If you seen him or may know where he is at please call me!
Des Moines - South
Lost: 1/22/2016
ID: 2364
Name: Russo
Type: Dog
Color: Black with brown around his mouth , legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Adult
He's a really nice and loving dog !! our family miss him so much , he's been gone for while now . If you have any information of where he is at or seen him , please call me !
Des Moines - North
Lost: 1/22/2016
ID: 2269
Name: Lady
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Senior
at the corner of 16th and lincoln 5154903517 please call if you've seen Lady I've very worried about her.
Des Moines - South
Lost: 1/22/2016
ID: 2262
Name: Russo
Type: Dog
Color: Black with brown on his chest , around his mouth , legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog. If you have any info please call me !
Des Moines - West
Lost: 1/22/2016
ID: 2237
Name: Unknown
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 1/22/2016
ID: 1971
Name: Russo
Type: Dog
Color: Black with brown on top of his eyes , around his mouth and on his legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog . If you know any info about him please call my number !
Des Moines - South
Lost: 1/22/2016
ID: 1951
Name: Russo
Type: Dog
Color: Black with brown no top of his eyes, around his mouth and legs and paws
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a really nice dog ! If you have any info please call my number .
Des Moines - East
Lost: 1/21/2016
ID: 2236
Name: Boo Boo
Type: Cat
Color: orange
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Adult
On the 21st of January eating in the morning at home I live in a red barn house on se 26th court she's orange tiger strip with orange eyes with a pink harley davidson collar on she very lovable she was given to me by my daughter tasha who has passed away she's very very precious to me