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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 10/1/2016
ID:
Name: Bella
Type: Cat
Color:
Breed:
Gender: Female
Fixed: Neutered
Age: Adult
Please help our family find our Bella. She got out last night. She is 3 years old, fixed, declawed and I'm sure scared to death. Please call 515 577 8527. Last seen on Valdez dr
Des Moines - North
Lost: 10/1/2016
ID: 3985
Name: Reggie
Type: Dog
Color: Orange and white
Breed: Brittany Spaniel
Gender: Male
Fixed: Neutered
Age: Young
Has a long cropped tail that reminds one of a little flag. Very sweet, very hyper.
Des Moines - North
Lost: 9/30/2016
ID: 3979
Name: Baxter
Type: Dog
Color: Black
Breed: Schnauzer Standard
Gender: Male
Fixed: Unknown
Age: Adult
On 28th and Euclid near the taco casa area
Windsor Heights
Lost: 9/30/2016
ID: 3978
Name: Buster
Type: Dog
Color: Black/brown/ grey
Breed: Pinscher-Miniature
Gender: Male
Fixed: Unknown
Age: Baby
Windsor heights Colby Ave around 63-70th street.
Windsor Heights
Lost: 9/28/2016
ID: 4066
Name: Stormy
Type: Cat
Color: Gray
Breed: Pinscher-Miniature
Gender: Female
Fixed: Not Neutered
Age: Young
She is very, very loving and has a habit of nipping at your nose or fingers or chin. She will hold your hand with her paws to groom you. We miss her so much!
Des Moines - East
Lost: 9/28/2016
ID: 3989
Name: Demon
Type: Cat
Color: Grey tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 9/27/2016
ID: 4057
Name: trouble parker
Type: Dog
Color: brown
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Young
Woman with a white Sudan coming off of Dean (near the fairgrounds) picked him up either across the street from 2511 Logan ave or right next door to the property on the same street and drove off without looking for the owner has been gone for more than a week
Thayer
Lost: 9/27/2016
ID: 4006
Name: RC
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
This friendly guy was found out in the country over by Thayer. He's missing an eye (infected), limited sight in the other, scarred up, so we got him the medical care he needed, neutered/chipped/shots, got him home, and a day later he escapes out the window! We're hoping we'll find him since he had tags and is chipped, please contact us at: janel@doggonerescue.com, if you spot him, thank you!
Thayer
Lost: 9/27/2016
ID:
Name: RC
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
This friendly guy was found by one of our volunteers out in the country over by Thayer. He escaped out of a mud room thru a window/screen. We're hoping since he's missing an eye, has collar/tags and microchipped, that someone will spot him soon.
Des Moines - North
Lost: 9/27/2016
ID: 3962
Name: Reggie
Type: Dog
Color: Orange and white
Breed: Brittany Spaniel
Gender: Male
Fixed: Neutered
Age: Young
4042 Oxford Street, Des Moines, Iowa has microchip, 38 to 40 pounds, small Brittany.
Des Moines - East
Lost: 9/27/2016
ID: 3958
Name: Trouble
Type: Dog
Color: Red
Breed: Dachshund-Miniature
Gender: Male
Fixed: Neutered
Age: Adult
25th & Logan
Cherokee
Lost: 9/26/2016
ID: 3971
Name: DeDe
Type: Cat
Color: Grey Tabby
Breed: Dachshund-Miniature
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.