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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Lost: 12/23/2017
ID: 7688
Name: Georgia
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Urbandale
Lost: 12/22/2017
ID: 7695
Name: Phoebe
Type: Cat
Color:
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Adult
Ogden
Lost: 12/22/2017
ID: 7684
Name: buggy
Type: Dog
Color: beige
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Young
274 se 2nd st. ogden ia
Jewell Junction
Lost: 12/21/2017
ID: 7750
Name: Cleo
Type: Cat
Color: grey tabby
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
We had just taken in Cleo. Not chipped. At the time she has just been to Vet 3 days prior and they shaved a small portion of her lower belly to look for Spay scars, none found but very small hernia noted on exam. She has a slight imperfection on her right ear. House trained likes to try to get outside, will meow more when wants out. Did not like other pets yet (cats and dog)(had only been 5 days) but good with people. She was in her 3rd home in less than 1 month so probably a bit anxious. She had first lived in Ankeny, Lost from Jewell.
West Des Moines
Lost: 12/21/2017
ID: 7709
Name: Black Kitten
Type: Cat
Color: Black with one tiny white spot on right ear
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Black male kitten about five months old with tiny, pin-sized white spot on right ear - he escaped his carrier in the Furry Friends parking lot when he was being taken in for neutering. There is a $200 reward being offered - if you've seen him please call Don at515-249-1352 - this pic is not him but looks just like him, thank you.
Iowa City
Lost: 12/20/2017
ID: 7766
Name: Tito
Type: Cat
Color: orange tabby with white patch on chest and white paws
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He's fairly skittish, but sweet. I miss my boy.
Elkhart
Lost: 12/20/2017
ID: 7678
Name: Indiana
Type: Dog
Color: Grey
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Our dog got excited and took off into a field off NE White Oak Drive. We are just moving to the area and Indy doesn’t know his way home. I thought I heard him barking last night, he is a big lover and extremely passive with regards to dominance. He’s friendly
Des Moines - South
Lost: 12/20/2017
ID: 7676
Name: izzy
Type: Cat
Color: gray, black, tan
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
last seen by park ave school. she is scared of cars.
Monroe
Lost: 12/19/2017
ID: 7889
Name: Mario
Type: Dog
Color: red
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Monroe IA area. Dog is skittish. He is a red min pin and he doesn't come when called. He has some dark hairs. Tall standing ears and cropped tail. He is the pup on the far right in the picture. Please help him come home.
Ankeny
Lost: 12/19/2017
ID: 7685
Name: Jax
Type: Cat
Color: Orange tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Front declawed, indoor cat only.
West Des Moines
Lost: 12/19/2017
ID: 7664
Name: Shadow
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
We found him he came home through the back door at 7:30 pm.
West Des Moines
Lost: 12/19/2017
ID: 7663
Name: Shadow
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Possibly got out through the garage between 7 am and 9 am. He is all black with bright yellow/green eyes. Will come by the name of Shadow if he is called.
Johnston
Lost: 12/19/2017
ID: 7662
Name: Dozer
Type: Dog
Color: Yellow
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Senior
Seen 4 house ago. Non aggressive
Des Moines - South
Lost: 12/19/2017
ID: 7661
Name: Minnie
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Unknown
Fixed: Neutered
Age: Young
Minnie likes to bark but she is not mean at all. She had a leopard sweater on but I found it in the backyard where she dug out. We are near SE 3rd and McKinley
Des Moines - East
Lost: 12/18/2017
ID: 7658
Name: ZoSo
Type: Dog
Color: Gray and white
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
My dog was last seen in my home. My daughters friends stole it. He is only 4 weeks old and needs a special diet. There are 6 little girls who will have a very sad Christmas if he is not found safe
Newton
Lost: 12/17/2017
ID: 7913
Name: Snow
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Snow was last seen south of Knoxville near Aliba. She was found by a lady named Amy Geogena who gave her to tje wrong family. We are trying to find out who has her and want our baby back. Amy and The Marion County Humane society has been very suspicious and not giving any answers and blocking us on fb. Please share!
Des Moines - South
Lost: 12/17/2017
ID: 7673
Name: Cookie
Type: Cat
Color: Tortie
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Southridge Estates, veru friendly
West Des Moines
Lost: 12/17/2017
ID: 7659
Name: Oreo
Type: Dog
Color: Black and white with black freckles
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - Central
Lost: 12/17/2017
ID: 7656
Name: Eva
Type: Dog
Color: Red
Breed: Irish Setter
Gender: Female
Fixed: Neutered
Age: Senior
Last seen in Sherman Hill around 18th & Pleasant. Eva is deaf so she will likely not answer to her name.
Des Moines - Central
Lost: 12/17/2017
ID: 7654
Name: Sawyer
Type: Dog
Color: Black
Breed: Irish Setter
Gender: Male
Fixed: Unknown
Age: Adult
Found wandering down Chamberlain by the Roosevelt baseball fields. Tags seem outdated or the phone number isn't working.
Waterloo
Lost: 12/16/2017
ID: 7651
Name:
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen around 9:00 pm near Lantern Square Apartments
Clive
Lost: 12/16/2017
ID: 7650
Name: Princess Fiona
Type: Cat
Color: White , black and orange
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Baby
Has identification tags
Des Moines - Central
Lost: 12/15/2017
ID: 7687
Name: Bruce
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Over by Union park area
Oskaloosa
Lost: 12/15/2017
ID: 7679
Name: Kolby
Type: Dog
Color: Black and Gray
Breed: Schnauzer Miniature
Gender: Male
Fixed: Neutered
Age: Young
Wearing a red shock collar with no tags. very shy and timid
West Des Moines
Lost: 12/15/2017
ID: 7657
Name: Droogie
Type: Cat
Color: Gray, white and spots of buff
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last seen Friday, 12/15/17 around 6-6:30 PM. She likes to hang out south in the alley between 4th and 5th Street close to Vine Street. See her every morning and evening, so I think she may be in a garage around that area.