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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 7/11/2017
ID: 6176
Name: Casper
Type: Cat
Color: Orange and white
Breed: Manx
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 7/10/2017
ID: 6742
Name: Asia
Type: Cat
Color: All grey
Breed: Manx
Gender: Female
Fixed: Neutered
Age: Young
She got out Monday morning around 2am-7am in north Ankeny. She's been missing for almost two months and is microchipped. If you see anything resembling her please contact the ARL! We miss her dearly and want her home safe.
Le Mars
Lost: 7/10/2017
ID: 6430
Name: Annie
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen playing in the backyard with her sister Bmo, a small calico shorthair. Both have been missing ever since. Offering reward for their safe return.
Le Mars
Lost: 7/10/2017
ID: 6429
Name: Bmo
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen playing in the backyard with her sister Annie, a small black shorthair female. Haven't seen either of them since. Offering reward for their safe return.
West Des Moines
Lost: 7/10/2017
ID: 6166
Name: Sammy
Type: Reptile
Color: Tan/Brown
Breed: Turtle
Gender: Male
Fixed: Unknown
Age: Young
Sammy was last seen in our fenced back yard on 7/10/17. When we checked on him in the early evening he was missing and there was a hole in the hurricane fence. The location is on 59th St in West Des Moines. Our yard backs up to 60th between Ashworth and Vista.
Ames
Lost: 7/10/2017
ID: 6160
Name: Hot Shell Rae
Type: Reptile
Color:
Breed: Turtle
Gender: Male
Fixed: Unknown
Age: Young
Last seen near the river down South Riverside Dr.
Ankeny
Lost: 7/10/2017
ID: 6157
Name: Asia
Type: Cat
Color: Gray
Breed: Turtle
Gender: Female
Fixed: Neutered
Age: Adult
May have seen her running around 49th street in North Ankeny. She is unlikely to walk up to anyone and will run away if you try to get her.
Garner
Lost: 7/9/2017
ID: 6173
Name: Peck
Type: Cat
Color: White with black and brown spots
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Senior
Last seen in Garner. Her right hind leg walks and sits a little funny.
Adair
Lost: 7/8/2017
ID: 6148
Name: Jazmine
Type: Dog
Color: Black and brow,
Breed: Rottweiler
Gender: Female
Fixed: Neutered
Age: Young
Rottweiler and lab mix, last seen north of 2736 state highway 25 in greenfield, ia headed to the corn fields. Fireworks scared her.
Des Moines - South
Lost: 7/8/2017
ID: 5823
Name: Diesal
Type: Cat
Color: Grey
Breed: Bombay
Gender: Male
Fixed: Unknown
Age: Baby
1424 e virginia in between e virgina and glenwood
Des Moines - Central
Lost: 7/7/2017
ID: 6162
Name: Johnny
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Baby
Arlington Ave and Clark St
Des Moines - Central
Lost: 7/7/2017
ID: 6140
Name: Hero
Type: Dog
Color: Light brown and dark brown with the white stripe
Breed: Groenendael
Gender: Female
Fixed: Not Neutered
Age: Adult
Last see at the north side library
Sheffield
Lost: 7/7/2017
ID: 6131
Name: Clayto
Type: Cat
Color: Black and WHITE
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Mear firshill cresent and home
Des Moines - North
Lost: 7/7/2017
ID: 6128
Name: Franklin
Type: Dog
Color: White and tan
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Off mondamin ave May have a blue bandana extremely friendly
Ankeny
Lost: 7/6/2017
ID: 6145
Name: Little Cat
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
We think she got out of the house the evening of 7/6 and we had the garage door open all night.
Indianola
Lost: 7/6/2017
ID: 6123
Name: Nin Nin
Type: Dog
Color: Black and tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
I am in need of help from the Indianola community! He is very skiddish, so if you find him, you might need to lure him with something!! He is wearing a tan collar with a red rabies tag.
Des Moines - North
Lost: 7/5/2017
ID: 6132
Name: Oliver
Type: Cat
Color: Black, grey and some white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
He may look grumpy, but he is sweet and lovable and we miss him a lot. My kids think he looks like a raccoon. If found, please call!!!
Des Moines - West
Lost: 7/5/2017
ID: 6118
Name: Charlie
Type: Cat
Color: White and Gray
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Loves being outside. Not declawed. Friendly. May nibble. Very chatty.
Osceola
Lost: 7/5/2017
ID: 6117
Name: Lizzy
Type: Dog
Color: Golden with white face
Breed: Golden Retriever
Gender: Female
Fixed: Not Applicable
Age: Senior
2718 Utah street Osceola Iowa Out side of New virginia
Des Moines - West
Lost: 7/5/2017
ID: 6106
Name: Charlie
Type: Cat
Color: White/Gray
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
May not come when called. Friendly and independent. Scared of cars.
Norwalk
Lost: 7/5/2017
ID: 6105
Name: Manny
Type: Dog
Color: Brindle
Breed: Greyhound
Gender: Male
Fixed: Neutered
Age: Adult
Scared by fireworks noise and ran off. Last seen at 30th Ave. and Harrison in Norwalk. Please call 912 665 4966.
Des Moines - Central
Lost: 7/4/2017
ID: 6546
Name: Johnny Baby
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Clark St And 4th, he is very vocal and responds to Johnny, John John, n Johnnybaby. He has poofy tale, medium/long hair, white spot on his lower tummy.
Mitchellville
Lost: 7/4/2017
ID: 6144
Name: Fergus
Type: Cat
Color: Black and White
Breed: Extra-Toes Cat (Hemingway Polydactyl)
Gender: Male
Fixed: Not Neutered
Age: Young
Fergus is the sweetest cat ever. Our family misses him dearly. He has 6 toes on his front paws and all 4 of his feet are white. He was last seen by 2 nd st NE and Arch.
Des Moines - West
Lost: 7/4/2017
ID: 6134
Name: princess
Type: Cat
Color: tortoise
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Ankeny
Lost: 7/4/2017
ID: 6122
Name: Phoenix
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in SW Ankeny