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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 8/3/2019
ID: 12028
Name: Tankers
Type: Dog
Color: Light brown white chest
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Lost: 8/2/2019
ID: 12044
Name: Nugget
Type: Cat
Color: Orange Tabby
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
north of Union Park. Has breakaway black collar. Front declawed. Friendly but might run at first. Likes to be scratched under the chin. Has freckles on his nose. Microchipped.
Ankeny
Lost: 8/2/2019
ID: 12023
Name: Tankers
Type: Dog
Color: Lights brown white chest
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Ankeny Four mile NE29th Ave He’s very friendly and he’s our baby please call 515 201-9042
Ankeny
Lost: 8/2/2019
ID: 12022
Name: Tankers
Type: Dog
Color: Light brown white chest
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Four mile NE 29th Ave He’s very friendly and gentle He’s our baby please call 515 201-9042
Des Moines - Central
Lost: 8/1/2019
ID: 12058
Name: Señor
Type: Cat
Color: Tabby brown striped
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
May have been in a fight with new cat in the neighborhood. I was on vacation.
Laurens
Lost: 8/1/2019
ID: 12035
Name: Jinxy
Type: Cat
Color: Orange/white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He will be scared .not use to noises please call asap if found...very gentle cat but again will be scared
Waukee
Lost: 8/1/2019
ID: 12014
Name: Piper
Type: Dog
Color: Tri color
Breed: Beagle
Gender: Unknown
Fixed: Neutered
Age: Adult
Seen around fox creek park. Small boys chased but couldn’t catch her.
Des Moines - Central
Lost: 8/1/2019
ID: 12013
Name: Liberty
Type: Dog
Color: Tan white
Breed: Siberian Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
Ankeny
Lost: 8/1/2019
ID: 12012
Name: Ivy
Type: Cat
Color: Tortie
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Young
Responds to Ivy and may run from strangers. Likes to hide in bushes. Does not get along with other cats.
Grand Mound
Lost: 7/31/2019
ID: 12025
Name: Max
Type: Dog
Color: Yellow
Breed: Tortoiseshell
Gender: Male
Fixed: Not Neutered
Age: Baby
On 225 th street Grandmound very friendly also very timid around men
Grand Mound
Lost: 7/31/2019
ID: 12024
Name: Max
Type: Dog
Color: Yellow
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
On 225 th street Grandmound very friendly also very timid around men
Spencer
Lost: 7/30/2019
ID: 12113
Name: Cooper
Type: Dog
Color: Chestnut
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Very friendly 3-year old dog. His favorite thing to do is play fetch, literally is always bringing something to you to throw for him. Last seen north of Spencer, Iowa.
Grand Mound
Lost: 7/30/2019
ID: 12027
Name: Max
Type: Dog
Color: Yellow
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
With other dog ash who was found this afternoon. last seen on 225th. very loveable and friendly tends to be very timid around men
Des Moines - North
Lost: 7/30/2019
ID: 12008
Name: Skippy
Type: Cat
Color: Black, grey belly
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Black, long hair, fluffy tail, grey fur on belly
Des Moines - East
Lost: 7/30/2019
ID: 12005
Name: Levi
Type: Dog
Color: Brown
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Senior
Missing from the AE Dairy area. Very good with other Dogs and Cats, not good with younger children.
Ames
Lost: 7/30/2019
ID: 12003
Name: Iro
Type: Cat
Color: White and Gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen out of SUV Complex in North Ames
Ames
Lost: 7/29/2019
ID: 12373
Name: Suerte
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Baby
Yellow eyes. Dark pigmentation on iris on left eye. Long canines. 3 white whiskers on right side, 1 on left side. Grayish hair on underside. castrated 10 year old male cat. bushy tail, loves flicking his tail. Name is Suerte really loves softcan food. He is microchipped. Suerte is very loved and missed! He doesn't like being held but appreciated being scratched under chin and behind ear.
Des Moines - West
Lost: 7/29/2019
ID: 12037
Name: Skittles
Type: Cat
Color: Tan multi
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Pleasant Hill
Lost: 7/29/2019
ID: 12032
Name: Buddy
Type: Dog
Color: Golden
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Wilton
Lost: 7/29/2019
ID: 12017
Name: Orion
Type: Cat
Color: White and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen around the rest stop he ran in the bushes near the fence area
Ankeny
Lost: 7/29/2019
ID: 12001
Name: Josie
Type: Cat
Color: White/black/gold. calico
Breed: Calico
Gender: Unknown
Fixed: Neutered
Age: Adult
Courtyards of Rock Creek Ankeny
Casey
Lost: 7/29/2019
ID: 11999
Name: Stanford
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He got out late in the afternoon. He is an indoor cat and doesn’t know his way around the neighborhood. Very friendly but he may be scared since he has never done this before.
Des Moines - West
Lost: 7/29/2019
ID: 9684
Name: Kiara
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Reposting this to see if anyone has seen this guy. Has been missing since 09/28/2018. Around Merle Hay and Holcomb. He is chipped. You can call or text me. Or email f.lynn@mchsi.com
North Liberty
Lost: 7/28/2019
ID: 11985
Name: Dahli
Type: Dog
Color: White w/ brown spots
Breed: Pit Bull
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in west lake area of north liberty. SUPER friendly.
Ankeny
Lost: 7/28/2019
ID: 11983
Name: Jonah
Type: Dog
Color: Tan
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
Jonah was found and returned to us. Thank you all for your sincere help with his safe return. THANKS SO MUCH