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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Found: 2/28/2018
ID: 8056
Name: Buddy
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Adult
He has all of his claws and he has never been outside.
Des Moines - Central
Found: 2/28/2018
ID: 8021
Name:
Type: Dog
Color: Black
Breed: Great Dane
Gender: Unknown
Fixed: Unknown
Age: Young
Dog is extremely skinny!! Planning to surrender to animal control for veterinary care.
Des Moines - North
Found: 2/21/2018
ID: 7995
Name:
Type: Dog
Color: White / Brown / Black
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 2/21/2018
ID: 7993
Name: Collar number – 137305
Type: Dog
Color: Tri Color
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
I found him walking down the middle of 48th street in Beaverdale in Des Moines. He is very nice. We are keeping him warm in the cold weather.
Ankeny
Found: 2/18/2018
ID: 7983
Name: Sheebah
Type: Dog
Color: brown with a little black on her back and a bear coat
Breed: Chinese Shar-Pei
Gender: Female
Fixed: Neutered
Age: Young
last seen in the area of the ARL in Ankeny. she can be skiddish and may bolt from a stranger. doesn't like other small animals.
Norwalk
Found: 2/16/2018
ID: 7986
Name:
Type: Cat
Color: White, Gray
Breed: Chinese Shar-Pei
Gender: Male
Fixed: Neutered
Age: Adult
Found in Norwalk,IOWA off HWY 28.
Des Moines - Central
Found: 2/16/2018
ID: 7974
Name:
Type: Dog
Color: One black and one brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Adult
Found South of University and just North of 235 on East 8th.
Bevington
Found: 2/16/2018
ID: 7965
Name:
Type: Cat
Color:
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Baby
Pleasant Hill
Found: 2/15/2018
ID: 7967
Name: Unknown
Type: Dog
Color: White/yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
I have him, and would like to get him returned to his owner! No name tags on collar. I’m calling him Moose.
Ankeny
Found: 2/14/2018
ID: 7962
Name: Ron Jags
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Adult
We live in SW Ankeny
Bevington
Found: 2/14/2018
ID: 7955
Name:
Type: Dog
Color:
Breed: Retriever, Labrador
Gender: Unknown
Fixed: Unknown
Age: Baby
Near Bevington/Martensdale area
Des Moines - South
Found: 2/12/2018
ID: 7951
Name: Mary
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Helena Industries 3525 Vandalia Road Des Moines, IA
Johnston
Found: 2/8/2018
ID: 7939
Name:
Type: Cat
Color: Gray striped
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
This kitten was found in the area of the Johnston Public Library. If you have any information regarding this kitten please call the Johnston Public Works during business hours at 278-0822 or call the Johnston Police Department at 278-2345 anytime.
West Union
Found: 2/7/2018
ID: 7935
Name: Shona
Type: Dog
Color: Tri colored
Breed: Collie Rough
Gender: Female
Fixed: Unknown
Age: Young
Last seen with large male collie.. Near Iris & Great River Rd. The picture is of a collie that looks like shona..
Des Moines - East
Found: 2/7/2018
ID: 7929
Name: Roxy
Type: Dog
Color: Brown/White
Breed: Bulldog
Gender: Female
Fixed: Not Applicable
Age: Adult
Des Moines - East
Found: 2/7/2018
ID: 7928
Name: Kash
Type: Dog
Color: Brindle
Breed: Bulldog
Gender: Male
Fixed: Neutered
Age: Senior
Urbandale
Found: 2/6/2018
ID: 7930
Name: unknown
Type: Cat
Color: Tiger
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Witnessed cat getting hit by car on 86th St bridge over I-80 in Urbandale/Johnston. Cat disappeared under by truck. Apparently in the under carriage because he appeared again in my garage many hours and many miles later. Unharmed. Very friendly and happy.
Sioux City
Found: 2/6/2018
ID: 7923
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Baby
Female pup around five or six months old. I found her running through heavy traffic.
Des Moines - South
Found: 2/4/2018
ID: 7911
Name:
Type: Cat
Color: White, brown, black
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - South
Found: 2/2/2018
ID: 7905
Name: Milo
Type: Dog
Color: Gray
Breed: Blue Heeler
Gender: Male
Fixed: Not Neutered
Age: Baby
Disappeared after going potty.
Des Moines - North
Found: 2/1/2018
ID: 7903
Name:
Type: Dog
Color: black and white
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Adult
north of Madison and south of Aurora on Beaver Road
Des Moines - East
Found: 1/30/2018
ID: 7893
Name: Absol
Type: Cat
Color: White with grey striped tail face legs
Breed: Siamese
Gender: Male
Fixed: Not Applicable
Age: Adult
Last seen on e pleasant view drive . She is a mix Siamese cat. She is my son's cat and She snuck out when they got home yesteday.
Des Moines - Central
Found: 1/29/2018
ID: 7883
Name:
Type: Dog
Color: Tan and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Baby
FOUND on 45th north of Kingman Blvd, 1100. Blue collar no tags.
Des Moines - East
Found: 1/26/2018
ID: 7871
Name: Lopez
Type: Cat
Color: Gray
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen in 4-Mile area. Bolted out the door when I let my dogs out. Microchip ID: 985113000957682
West Des Moines
Found: 1/25/2018
ID: 7862
Name:
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Unknown
Age: Senior
Found on Century Dr in West Des Moines near elementary school. Two dogs Bichon and shitzuh maybe. Both have collars and leashes on.