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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
Ames
Lost: 7/30/2018
ID: 9271
Name: Willow
Type: Dog
Color: Black/White/Tan
Breed: Australian Shepherd
Gender: Female
Fixed: Not Applicable
Age: Adult
Last seen running across from South River Park to North River/Carr park in Ames. Very sweet girl, timid dog, more shy with males. Food motivated
Des Moines - North
Lost: 7/30/2018
ID: 9269
Name: Scooby
Type: Dog
Color: Tan
Breed: Bullmastiff
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen on e12th got loose from my house
Des Moines - East
Lost: 7/30/2018
ID: 9267
Name: Ernie
Type: Dog
Color: Tan, white patch head chest
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Jumped out after accident, ran into bike path and fields north of army post. He lives 70 miles south in Ottumwa so he might head south
Des Moines - South
Lost: 7/30/2018
ID: 9265
Name: Simba
Type: Cat
Color: Orange(cream) with white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Southside near Jackson school , sweet as can be, front declawed
Ankeny
Lost: 7/30/2018
ID: 9255
Name: Gypsy
Type: Dog
Color: White and Yellow
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Young
She took off on us and we just want her home safe. She’s very shy so please be patient with her.
Ames
Lost: 7/29/2018
ID: 9298
Name: Oliver (Leo on chip registration)
Type: Cat
Color: Light Orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in West Ames by Ledges Apartments. He is a skiddish cat and will most likely run and hide when chased. He has a long bush tail and is aprox. 2 years old. Contact me at 563-554-9066 with any information.
West Branch
Lost: 7/29/2018
ID: 9264
Name: Milo
Type: Cat
Color: Brown and white
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Young
Last seen evening of 7/29. Friendly and may respond to “Kitty” and offer of food or catnip. Big fluffy tail.
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