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 = 'found' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - Central
Found: 11/8/2017
ID: 7356
Name:
Type: Cat
Color: Brown, white and gray
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found in the Beaverdale neighborhood near 46th and Hickman.
Norwalk
Found: 11/6/2017
ID: 7347
Name: Unknown
Type: Cat
Color: Orange and white
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on Mafred Street in Norwalk (by laundromat).
Urbandale
Found: 11/6/2017
ID: 7343
Name: Unknown
Type: Dog
Color: Black,white,grey
Breed: Alaskan Husky
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 11/5/2017
ID: 7348
Name:
Type: Cat
Color:
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Young
This cat was found by my neighbor Sunday night at 30th and Leado. I can't keep it for long; I hope a caring owner will turn up!
Des Moines - South
Found: 11/5/2017
ID: 7336
Name: Unknown
Type: Cat
Color: Siamese. Orange face, ears, and tail. Cream colored body. Blue eyes.
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
I found him in the neighborhood of SE Emma Ave., Des Moines, IA by Jackson Elementary School. He has 6 toes on his front paws and is front declawed. Siamese coloration with an orange tint on face, ears, and tail. Blue eyes.
Indianola
Found: 11/5/2017
ID: 7330
Name:
Type: Cat
Color:
Breed: Siamese
Gender: Male
Fixed: Unknown
Age: Young
Indianola
Found: 11/5/2017
ID: 7329
Name:
Type: Cat
Color:
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Ankeny
Found: 11/4/2017
ID: 7319
Name:
Type: Cat
Color: Gray
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Ankeny
Found: 11/4/2017
ID: 7318
Name: Sketcher
Type: Dog
Color: Black
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Senior
He escaped out of the backyard around 7pm Saturday evening
Des Moines - South
Found: 11/4/2017
ID: 7315
Name:
Type: Dog
Color: Black with white chest
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Found dog in Easter Lake area, north of the bypass by Earl May. Super sweet boy, has a collar but no tags.
West Des Moines
Found: 11/4/2017
ID: 7313
Name: Unknown
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Valley Junction near 8th & Vine. She ran out of the alley and in front of my car. She does have a collar, but no tags. Will not release to you unless you can tell me the color of the collar.
Des Moines - Central
Found: 11/2/2017
ID: 7297
Name:
Type: Dog
Color: Trinity color
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
In custody at downtown doggy daycare. Call 515-288-0957
Des Moines - North
Found: 11/1/2017
ID: 7752
Name: Unknown
Type: Cat
Color: Gray tiger
Breed: Tiger
Gender: Male
Fixed: Unknown
Age: Adult
Has been roaming the area around 39th and Brinkwood Road (Lower Beaver area west of Lower Beaver Road) for several weeks. Large gray male tiger cat. Have been putting food out for him and tried to catch him without any luck.
Urbandale
Found: 11/1/2017
ID: 7345
Name: Unknown
Type: Cat
Color: White/orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Comes thru my yard. Seems hungry, but tame
Des Moines - East
Found: 11/1/2017
ID: 7312
Name: Unknown
Type: Cat
Color: Grey/white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - South
Found: 11/1/2017
ID: 7308
Name: Bea
Type: Cat
Color: White with dark patches and dark tail
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Des Moines - Central
Found: 11/1/2017
ID: 7306
Name:
Type: Cat
Color: Striped
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He was hanging out on back porch - next to Tower Park!
Des Moines - Central
Found: 11/1/2017
ID: 7305
Name:
Type: Cat
Color: Striped
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He was hangin out on back porch - next to Tower Park!
Des Moines - South
Found: 11/1/2017
ID: 7303
Name: Bea
Type: Cat
Color: White and brown
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
She is not used to being outdoors and might be a bit scared of people.
Des Moines - North
Found: 10/30/2017
ID: 7292
Name: baby
Type: Cat
Color: black
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Young
She has a shaved area on her belly from her recent spay surgery. It can usually be seen when she is running . She also has Yellow eyes. Please help me find her I miss her so much. Sorry for the bad picture it was all I had.
Ankeny
Found: 10/30/2017
ID: 7287
Name: Kitty
Type: Cat
Color: Gray and Black. Long black tail. White on nose, under chin and front paws
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She is friendly and petite. No front claws
Windsor Heights
Found: 10/29/2017
ID: 7273
Name: Lewis
Type: Dog
Color: Black White
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near 66th Carpenter. Playing, will run. No collar, all vaccinations current. Beagle/Shorthair mix FOUND! and taken to emergency vet with a wound
Des Moines - Central
Found: 10/28/2017
ID: 7265
Name:
Type: Dog
Color:
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - West
Found: 10/28/2017
ID: 7264
Name: Unk
Type: Dog
Color: White and black
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Young
63rd and Creston
Des Moines - North
Found: 10/27/2017
ID: 7289
Name: Unknown
Type: Cat
Color: Grey and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young