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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 10/3/2017
ID: 7014
Name: Meika
Type: Dog
Color: White/ multicolored top coat
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Young
Last seen around Waukee high school, after 5, 10/5/17. Very friendly, should come when called. Emotional Support Dog, very missed.
Polk City
Lost: 10/3/2017
ID: 6987
Name: Lucy Chisholm
Type: Cat
Color: Calico Torti-a lot of copper streaks on her
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Baby
7 months old, declawed in her front paws, strictly an indoor cat at our home, just snuck past me in the garage, setting the garbage out this morning and I haven't seen her since... She has little fuzzes at the tips of her ears and a white streak on her chest. She has a black streak down her forehead and beautiful green/yellow eyes... she DOES like people, but new people scare her. She does not bite unless she is being teased too much, comes from a home with 4 kids, so she will nibble once in a while.
Des Moines - East
Lost: 10/3/2017
ID: 6984
Name: Captain Jack
Type: Cat
Color: Orange & White
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Senior 10+ years orange / white stripped domestic tabby cat. Medium to large cat slightly but not overweight. Yellow/Greenish eyes. Small amount of orange on bottom of chin. He is neutered and I don't remember if he is chipped. I am not sure about the exact day time I last saw him, but I am pretty sure it was this weekend. He wanders outside sometimes, but always stays around the yard and comes in to sleep/eat. Answers to Jack or Jack Jack. To strangers he can either be friendly affectionate/person or grumpy/hisses and wants to be outside. May hop in or on cars.
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