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>='1600992000')) ORDER BY pm1.meta_value DESC, post_date DESC
Ames
Lost: 7/28/2018
ID: 9262
Name: Oliver or Leo on microchip
Type: Cat
Color: Orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Seen in between State street and west hyvee. He's very fast and agile and will most likely run away if you try to chase him. If spotted or found please contact me right away and try to approach him slowly. He goes by the name Oliver. He likes the woods so keep an eye out on trails, especially the on side by the middle school.
Des Moines - South
Lost: 7/28/2018
ID: 9260
Name: Jesse
Type: Cat
Color: Black with a few gray hairs near groin area and belly skin hangs
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Senior
Jesse is a very social cat and is not usually afraid of people or dogs. He often rolls over so that he can get his tummy rubbed. Jesse might have a few scabs on his ears due to allergies.
Waukee
Lost: 7/28/2018
ID: 9257
Name: Herky
Type: Dog
Color: White and Black
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
SE Prairie Creek Dr Waukee
North Liberty
Lost: 7/28/2018
ID: 9252
Name: Ben
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
Has small white patches on chest and near groin, some white whiskers, about 12 lbs., gentle but has claws, missing collar, but has microchip! Afraid of loud noises. Escaped from holiday lodge rd. Call 563.571.four six 17.
Ankeny
Lost: 7/28/2018
ID: 9249
Name: Halligan
Type: Dog
Color: Brown / Tan
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Baby
SW Ankeny - near NW 72nd Place. Very skiddish, please don’t chase. Non-aggressive. Call with sightings. She looks like a fox. Thank you!
Council Bluffs
Lost: 7/28/2018
ID: 9247
Name: Fancy
Type: Dog
Color: Apricot
Breed: Poodle Toy
Gender: Female
Fixed: Neutered
Age: Young
At a rest stop near York and Seward Nebraska.
Council Bluffs
Lost: 7/28/2018
ID: 9246
Name: Fancy
Type: Dog
Color: Apricot
Breed: Poodle Toy
Gender: Female
Fixed: Neutered
Age: Young
At a rest stop near York and Seward Nebraska.
Altoona
Lost: 7/28/2018
ID: 9243
Name: Navine
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 7/27/2018
ID: 9238
Name: Libby
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen on NE 44th street by Trilein. She is shy.
Urbandale
Lost: 7/26/2018
ID: 9240
Name: TK
Type: Reptile
Color: Brown
Breed: Turtle
Gender: Male
Fixed: Not Neutered
Age: Adult
I’m not sure when but our Russian tortoise escaped his outdoor enclosure. I know this is a long shot but if you see a tortoise in the urbandale area please contact us ASAP. He’s about 5 inches and likes to dig.
Des Moines - East
Lost: 7/26/2018
ID: 9239
Name: Momma
Type: Cat
Color: Tan and black
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen at E 23rd and Des Moines st. She's really friendly but does not like to be held. She had babies 3 months ago and we really want her back home!
Johnston
Lost: 7/26/2018
ID: 9234
Name:
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
On trail over by terra park in Johnston Iowa
Des Moines - East
Lost: 7/26/2018
ID: 9230
Name: Lyla
Type: Dog
Color:
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Young
Last seen in East Des Moines/ Pleasant hill/ Altoona area
Altoona
Lost: 7/26/2018
ID: 9228
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Reasnor
Lost: 7/26/2018
ID: 9226
Name: Wrigley
Type: Dog
Color: Black with white
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
In reasnor may have followed ragbrai riders very friendly dog
Des Moines - East
Lost: 7/26/2018
ID: 8880
Name: Boots
Type: Cat
Color: Tuxedo (Black & White)
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He has been missing since the beginning of June. He has green eyes.
Booneville
Lost: 7/25/2018
ID: 9325
Name: Chester
Type: Cat
Color: Gray and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He’s sweet and has white swirls on his side. He’s 1. He is declawed in the front.
Ankeny
Lost: 7/25/2018
ID: 9250
Name: Kitty
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Gladbrook
Lost: 7/25/2018
ID: 9233
Name: Sara
Type: Dog
Color: Light brown and white
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
Sara has her multicolored collar and an orange leash attached. She was scared and ran toward a field near Highway 96 on the south side of Gladbrook, Iowa. We caught another glimpse of her running in the same field, but she was still scared and ran back into the field.
Pleasant Hill
Lost: 7/23/2018
ID: 9222
Name: Delilah
Type: Cat
Color: Black and While
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen running around Pleasant Hill, don’t chase after her she will run. If you can catch her please call as soon as you can, thank you.
Hartford
Lost: 7/23/2018
ID: 9221
Name: Phoebe
Type: Dog
Color: Golden-red
Breed: Golden Retriever
Gender: Unknown
Fixed: Neutered
Age: Young
She left home with her sister, Chloe, who came home without her yesterday. She is very lovable and will get right in your car if you ask her to.
Altoona
Lost: 7/23/2018
ID: 9220
Name: Dezi
Type: Cat
Color: Gray Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
She was last seen while installing a new storm door. She is small and has had previous trauma (prior to our rescuing her) . One ear is pointed out rather than up, she has a foggy eye , shorter tail. She also has pink cat caps. She is very skittish.
Des Moines - South
Lost: 7/23/2018
ID: 9216
Name: fez
Type: Dog
Color: Black and white
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Neutered
Age: Senior
Last seen around Park Ave and Sw 12th st.
Des Moines - North
Lost: 7/22/2018
ID: 9312
Name: Digits
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
We just moved to NE 49th Ave when Digits took off out the door and hasnt been seen since, if you have any information please contact me. 515-241-3719
Des Moines - Central
Lost: 7/22/2018
ID: 9218
Name: Aries
Type: Dog
Color: White with black and white face
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at his home on 43rd and Ingersoll and must have gotten out of an open basement door.