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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Washington
Lost: 12/25/2017
ID: 7737
Name: Shelby
Type: Dog
Color: Black/white
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Senior
Last seen by the railroad tracks in Washington by N 12th ave
Pleasant Hill
Lost: 12/25/2017
ID: 7704
Name: Kimber
Type: Dog
Color: Tan and white
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Baby
Near southeast Polk area
Bloomfield
Lost: 12/24/2017
ID: 7719
Name: Nook
Type: Dog
Color: Black and white
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Young
He is friendly but will most likely not approach you unless he thinks you have food
Des Moines - East
Lost: 12/24/2017
ID: 7694
Name: Jingles
Type: Dog
Color: Black /white chest
Breed: Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
In the Oxford /Ovid area
Ackley
Lost: 12/23/2017
ID: 7746
Name: Majesty
Type: Cat
Color: Gray
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Last seen on State St. in Ackley, Iowa We miss her very much and are very worried about her.
Des Moines - East
Lost: 12/23/2017
ID: 7701
Name: Buddy
Type: Cat
Color: Blonde orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
2615 n.e. 44th ct
Des Moines - East
Lost: 12/23/2017
ID: 7700
Name: Goose
Type: Cat
Color: Black & Brown stripped with White chest
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
He snuck out of our home on Dubuque Ave and 42nd Street
Des Moines - East
Lost: 12/23/2017
ID: 7699
Name: Goose
Type: Cat
Color: Brown and black tiger striped
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly lost around east side of Des Moines maybe around Dubuque and university
Bettendorf
Lost: 12/23/2017
ID: 7692
Name: Stripe
Type: Cat
Color: grey striped
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Was wearing orange break-away as well as a locking blue collar with leash still attached when he got out of my arms at Frozen Landing next to Splash Landing on corner of Middle Rd. and 23rd St. in Bettendorf by Middle Park and west end of Palmer Hills Golf Course.
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!