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>='1560988800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 10/4/2017
ID: 7059
Name: Tank
Type: Dog
Color: Brindle
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
On Sampson ST in Des Moines, Iowa Grandview College area. He's not very good with strangers. will bark but warms up to you immediately.
Gladbrook
Lost: 10/4/2017
ID: 7013
Name: Mimi
Type: Cat
Color: Brown,orange,black
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
She snuck on the door and never been seen since 10/04/17 shes an indoor cat and not familiar around town. If somebody has her or seen her please please let me know I miss her so bad.
Des Moines - East
Lost: 10/4/2017
ID: 7010
Name: Abe
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Last seen on John Patterson Road off of Easton Blvd. on the east side of Des Moines.
Solon
Lost: 10/4/2017
ID: 7009
Name: Nazareth
Type: Cat
Color: gray with black stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
His right eye is two colors, yellowish-orange and green. he is very sweet and will come if you call him. Lost in town in Solon, Iowa.
Des Moines - North
Lost: 10/4/2017
ID: 6992
Name: Jack
Type: Dog
Color: Golden
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Loves people young mabey will come up to you call 515-771-2038 or 515-771-1847
Urbandale
Lost: 10/4/2017
ID: 6990
Name: Fisher
Type: Dog
Color: chocolate
Breed: Golden Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Meredith and alices road...Fisher likes to show you he is aware you are there by his bark but as he runs to you he wants to smell you then love you. He loves playing fetch and fishes with the best of us. Fisher loves to be loved and is very well my best friend...515-322-9872
West Des Moines
Lost: 10/4/2017
ID: 6985
Name: Louie
Type: Dog
Color: Mixed
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Baby
White SUV or sedan seen at the house. Many things stolen We just want Louie back
West Des Moines
Lost: 10/4/2017
ID:
Name: Louie
Type: Dog
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Baby
West Des Moines
Lost: 10/4/2017
ID: 6983
Name: Louie
Type: Dog
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Baby
West Des Moines
Lost: 10/4/2017
ID: 6685
Name: Buddha
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Boo is still missing! He has his front and back claws, thin cat, very active (great tree climber). Very sweet! He has been missing for a month now.
Windsor Heights
Lost: 10/3/2017
ID: 7046
Name: Sock
Type: Cat
Color: Orange and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Senior
He is friendly, he has been out for 6 days. He loves tuna.
Des Moines - South
Lost: 10/3/2017
ID: 7019
Name: Andi
Type: Cat
Color: Gray and black striped pattern
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Young
She was last seen in the idianol hills area. She doesn't have a collar on and isnt a people person
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