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
Council Bluffs
Lost: 12/6/2017
ID: 7591
Name: Sid
Type: Cat
Color: Orange
Breed:
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!
Des Moines - Central
Lost: 12/3/2017
ID: 7561
Name: Buttercup
Type: Cat
Color: Black and brown and tan
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
She was last seen this morning at 1428 7th seventh apt 2 she very friendly she would come up to you if you call her name
Grimes
Lost: 12/2/2017
ID: 7555
Name: Gus
Type: Dog
Color: White with brown liver spots
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Sneaking and running out our door toward Cutty's Campground. He is fast and may think it's a game if you try to chase him, but very food-motivated! He's very friendly and loves everyone!
Des Moines - North
Lost: 12/2/2017
ID: 7551
Name: Nikka
Type: Dog
Color: Tan and black
Breed: Belgian Shepherd Malinois
Gender: Female
Fixed: Not Neutered
Age: Young
5590 NE 3rd Street. She loves squeaky toys.
Ankeny
Lost: 12/2/2017
ID: 7550
Name: Nikka
Type: Dog
Color: Brown and black
Breed: Belgian Shepherd Malinois
Gender: Female
Fixed: Not Neutered
Age: Young
5590 NE 3rd Street. She loves squeaky toys
Des Moines - East
Lost: 12/1/2017
ID: 7834
Name:
Type: Cat
Color: Stripped
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Young
1544 Royer st Des Moines Iowa 50316
Des Moines - East
Lost: 12/1/2017
ID: 7829
Name:
Type: Cat
Color: Stripped
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
1544 Royer st Des Moines Iowa 50316
Des Moines - East
Lost: 12/1/2017
ID: 7713
Name: Bella
Type: Cat
Color: White with orange and black with white tipped tail
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around hickory hill ln in valley high manor. She may have been with babies. Please call 5155547473!
Ankeny
Lost: 12/1/2017
ID: 7625
Name: Cinders
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Baby
On N.W. Wesrwood St. Ankeny, ia
Des Moines - East
Lost: 12/1/2017
ID: 7560
Name: Newnew
Type: Cat
Color: Yellow orange
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Young
Last seen Saturday morning. He’s an indoor outdoor cat, very friendly will let you pet and hold him. Responds to the name newnew.