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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Pleasant Hill
Lost: 12/8/2017
ID: 7611
Name: Munchkin
Type: Cat
Color: Black and tan
Breed:
Gender: Female
Fixed: Not Neutered
Age: Young
She has a distinct marking on her chin that looks like a mustache. Last seen near townhomes near car dealership.
Altoona
Lost: 12/8/2017
ID: 7606
Name: Puti
Type: Cat
Color: Half black half yellow
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
She was originally feral when she was born. She is still skittish when she is scared.
Davenport
Lost: 12/8/2017
ID: 7602
Name: Gustav aka Goose
Type: Dog
Color: Brown
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Senior
Goose is a friendly but elderly min pin. He’s small, in bad health due to age and losing his eye sight. We’re worried sick and just want him back home.
Des Moines - Central
Lost: 12/8/2017
ID: 7599
Name: Vinny
Type: Dog
Color: Blonde
Breed: Dachshund Standard
Gender: Male
Fixed: Neutered
Age: Senior
56th and franklin around 1:30p heading west
Des Moines - East
Lost: 12/8/2017
ID: 7597
Name: Dreko & Aujeanae
Type: Dog
Color: Black and drak brown
Breed: Pit Bull
Gender: Male
Fixed: Not Applicable
Age: Young
In front yard someone took them out my front yard
Des Moines - East
Lost: 12/8/2017
ID: 7596
Name: Dreko & Aujeanae
Type: Dog
Color: Black and drak brown
Breed: Pit Bull
Gender: Male
Fixed: Not Applicable
Age: Young
In front yard someone took them out my front yard
Des Moines - East
Lost: 12/7/2017
ID: 7595
Name:
Type: Dog
Color: Black/white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 12/7/2017
ID: 7593
Name: Teddy
Type: Dog
Color: Brown, white and black
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Baby
Last seen around York and Washington street
Council Bluffs
Lost: 12/6/2017
ID: 7592
Name: Sid
Type: Cat
Color: Orange
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
Lost at Iowa Western community college Has three legs
Council Bluffs
Lost: 12/6/2017
ID: 7591
Name: Sid
Type: Cat
Color: Orange
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
Lost in Iowa Western Community college Sid is missing is back left leg.
Adel
Lost: 12/6/2017
ID: 7586
Name: Emmet
Type: Cat
Color: Black and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Emmet is blind. He was enjoying fresh air on the deck and someone opened our gate :/ not mean but if found wooo likely be very skittish due to his blindness (being picked up is very disorienting to him). Please try and catch him if you see him or alert me ASAP!
Des Moines - South
Lost: 12/5/2017
ID: 7627
Name: Buddy
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Ferral cat disappeared from SW 9th & Creston area
Des Moines - South
Lost: 12/5/2017
ID: 7626
Name: Buddy
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Ferral cat we have been taking care of for a year. Disappeared a week ago vicinity of SW 9th & Creston. He likely traveled a block or two both north and south of Creston.
Des Moines - East
Lost: 12/5/2017
ID: 7622
Name: Peter pan
Type: Cat
Color: Black white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
East side of des moines on 22nd and walnut street
Ankeny
Lost: 12/5/2017
ID: 7587
Name:
Type: Cat
Color: Orange with White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Our cat was last seen on Saturday Nov. 25th. We live in the Saylorville Lake Area. He has no collar or microchip. He is very friendly and may have wandered into a shed or garage. If you have seen him please call 515-975-9365.
Polk City
Lost: 12/5/2017
ID: 7582
Name: Bow
Type: Dog
Color: Black/white/gray
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Adult
2nd ave storage facility/ Smokey Ds
Des Moines - West
Lost: 12/4/2017
ID: 7777
Name: Jayde
Type: Dog
Color: Red with white chest
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
I left my dog with my sister for a night the next day she claimed the Princess got off her leash. She is my baby to help me when i have seizures.
Des Moines - West
Lost: 12/4/2017
ID: 7682
Name: Pebbles
Type: Cat
Color: Gray and white
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Very friendly loves to cuddle and use to dogs, I miss her very much please if anyone has seen her or keeping her safe I would love to see her again.
Des Moines - Central
Lost: 12/4/2017
ID: 7609
Name: Scooter
Type: Cat
Color:
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
Johnston
Lost: 12/4/2017
ID: 7585
Name: Fox
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Johnston
Lost: 12/4/2017
ID: 7573
Name: Fox
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Escaped out of the house sometime on 12/4/17. Declawed on the front, no collar.
Waukee
Lost: 12/4/2017
ID: 7562
Name: Coal
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Windsor Heights
Lost: 12/3/2017
ID: 7623
Name: Lucy
Type: Cat
Color: Tortoiseshell
Breed: Tortoiseshell
Gender: Male
Fixed: Not Applicable
Age: Adult
Windsor square apt.
Indianola
Lost: 12/3/2017
ID: 7598
Name: Oliver
Type: Cat
Color: Black with white spot on his belly, and a small patch of white on his beck
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen behind the Walmart in Indianola.
Windsor Heights
Lost: 12/3/2017
ID: 7567
Name: Lucy
Type: Cat
Color: Grey tortishell
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Lucy is front declawed! She is a very loving and gentle cat!