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
West Des Moines
Lost: 10/3/2017
ID: 6977
Name: Meika
Type: Dog
Color: Grey/White
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
Springs apts on Bridgewood. Has pink bandana and ran off with leash still around her neck.
Windsor Heights
Lost: 10/3/2017
ID: 6975
Name: Max
Type: Dog
Color: Tri color: Black brown and chest is mainly white
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Baby
He’s very friendly! Loves food especially chicken and likes squeaky toys
Des Moines - East
Lost: 10/3/2017
ID: 6974
Name: Ace
Type: Dog
Color: Brindle
Breed: Mountain Cur
Gender: Male
Fixed: Neutered
Age: Adult
E 16th St Behind Grandview College
Windsor Heights
Lost: 10/3/2017
ID: 6973
Name: Sock
Type: Cat
Color: Orange and white
Breed: Mountain Cur
Gender: Male
Fixed: Neutered
Age: Senior
Front paws declawed, friendly cat. Probably scared.
Windsor Heights
Lost: 10/3/2017
ID: 6972
Name: Sock
Type: Cat
Color: Orange and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Senior
Front paws declawed, friendly cat. Probably scared.
Urbandale
Lost: 10/2/2017
ID: 6988
Name: Rowdy
Type: Cat
Color: Black (short hair)
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Baby
71st and Prairie. Had a lump at tip of tail.
Ankeny
Lost: 10/2/2017
ID: 6982
Name: Baby boy
Type: Cat
Color: White/orange
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Baby boy got out about 9 pm. Has gotten out before, but always returned in morning.
West Des Moines
Lost: 10/2/2017
ID: 6976
Name: Meika
Type: Dog
Color: White, multicolored top coat. Diamond marking.
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Young
Retracatble leash was still on when she escaped my grip. Super friendly, doesn't like rain, and loves to cuddle.
Des Moines - East
Lost: 10/1/2017
ID: 7317
Name: Daddy Poppins
Type: Cat
Color: Striped Grays
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
DP is extremely friendly, our favorite barn kitten, about 6 months old. A little white under chin. We are heartbroken :( Norwoodville area, NE 29th & Broadway area.
Urbandale
Lost: 10/1/2017
ID: 6989
Name: Rowdy. Answers to kitty kitty
Type: Cat
Color: Black (short hair)
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
71st and Prairie Urbandale
Dedham
Lost: 9/30/2017
ID: 7011
Name: Amber
Type: Dog
Color: White with Orange Spots
Breed: English Setter
Gender: Female
Fixed: Unknown
Age: Adult
Waukee
Lost: 9/30/2017
ID: 6953
Name: Falen
Type: Dog
Color: Black, white chest and feet
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Neutered
Age: Adult
4:30 In our backyard
Waukee
Lost: 9/30/2017
ID: 6951
Name: Falen
Type: Dog
Color: Black, white chest and feet
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Neutered
Age: Adult
4:30 In our backyard
Ankeny
Lost: 9/29/2017
ID: 7045
Name: Whiskey
Type: Cat
Color: Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
All black with white patch on his lower belly. Almost in the shape of a heart. Afraid of most people. Lost around Ankeny high school.
Ankeny
Lost: 9/29/2017
ID: 7043
Name: Whiskey
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
All black with white patch on his lower belly. Almost in the shape of a heart. Afraid of most people. Lost around Ankeny high school.
Clarion
Lost: 9/29/2017
ID: 6959
Name: BUSTER
Type: Dog
Color: Red
Breed: Dachshund
Gender: Male
Fixed: Not Neutered
Age: Adult
By hospital, in Clarion Iowa
Des Moines - North
Lost: 9/29/2017
ID: 6957
Name: Casper
Type: Cat
Color: White
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
38th and Adams. Very shy and may not let anybody get her.
West Des Moines
Lost: 9/29/2017
ID: 6941
Name: Kitty
Type: Cat
Color: Dark Grey Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at Cambridge Courts Apartments. Pink collar says ‘little trooper’ Has a clipped ear. 2 years old
Ottumwa
Lost: 9/29/2017
ID: 6934
Name: BANDIT
Type: Dog
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
5pm milner stteet
Ottumwa
Lost: 9/29/2017
ID: 6933
Name: BANDIT
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
5pm milner stteet
Des Moines - North
Lost: 9/29/2017
ID: 6932
Name: Lily
Type: Dog
Color: Reverse brindle/white
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 9/29/2017
ID: 6931
Name: Lily
Type: Dog
Color: Reverse brindle/white
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Near Madison Elementary School
Des Moines - North
Lost: 9/29/2017
ID: 6926
Name: Rajah
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Escaped from my backyard. Highland Park Area
Des Moines - North
Lost: 9/29/2017
ID: 6923
Name: Barkley
Type: Dog
Color: White
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Senior
8th and Franklin
Des Moines - West
Lost: 9/28/2017
ID: 7114
Name: Willow
Type: Dog
Color: Brown
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Baby
She was last seen on the 27 of sept 27 but went missing on the 28 of sept she is brown and black