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
Pella
Found: 9/27/2017
ID: 6943
Name: Zeus
Type: Dog
Color: charcoal black and white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
highway163 by pella 40 exits
Johnston
Found: 9/27/2017
ID: 6898
Name: Bo
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
Found!
Clive
Found: 9/26/2017
ID: 6894
Name:
Type: Cat
Color: Gray and white
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
I found someone's cat that had been struck by a car and was laying in the road on 100th. Unfortunately the cat had passed away when I found it. I moved it off the road. If you think it's your cat I do have pictures. You must describe a key detail about the cat to get the pictures. Medium to large size.
Johnston
Found: 9/25/2017
ID: 6885
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Senior
Found in Greenwood Hills area in Johnston . Is safe with us while we look for the owner.
Des Moines - South
Found: 9/24/2017
ID: 6876
Name:
Type: Cat
Color: Grey
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
We have the cat at our house but was found at sw 9th & Virginia.
Des Moines - Central
Found: 9/24/2017
ID: 6874
Name: I
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Found at 4 way stop by Hoover Highschool
Des Moines - Central
Found: 9/24/2017
ID: 6873
Name: I
Type: Dog
Color: Golden
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Adult
Found at 4 way stop by Hoover Highschool
Des Moines - Central
Found: 9/24/2017
ID: 6872
Name: I
Type: Dog
Color: Golden
Breed: Pomeranian
Gender: Male
Fixed: Unknown
Age: Adult
Found at 4 way stop by Hoover Highschool
West Des Moines
Found: 9/24/2017
ID: 6868
Name:
Type: Cat
Color: Orange Tabby
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
Anita
Found: 9/23/2017
ID: 6875
Name: Unknown but we call him Roscoe
Type: Dog
Color: Black and tan with a white chest and front paws
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
found on highway 148 in Anita Iowa. He was very close to the busy street.
West Des Moines
Found: 9/23/2017
ID: 6864
Name: Unknown
Type: Dog
Color: Black
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Young
We took him to furry friends refuge on grand in west des moines
Huxley
Found: 9/21/2017
ID: 6857
Name:
Type: Dog
Color: Black
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Found south of Huxley, appears to have been traveling a while, thin. Camo collar with red broken leash attached.
Urbandale
Found: 9/20/2017
ID: 6960
Name:
Type: Cat
Color: Calico with tan tummy
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Adult
This cat has been seen in our neighborhood. It is front declawed, that I know. Very sweet. She is hanging out on the trail behind my house...8203 Alpine Drive, Urbandale. I see another listing for a lost cat that fits this kitty. I have called them and have never received a response. (ID 6713 named Bella)
Des Moines - Central
Found: 9/20/2017
ID: 6847
Name:
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
Has white markings on chest and feet are also white;Has a unique tail; Found near state Capitol
Des Moines - North
Found: 9/19/2017
ID: 6837
Name: N/A
Type: Dog
Color: Tan,brown,black,white
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
I saw two dogs wondering the streets over off ne 14th, one was a white boxer he looked to be a older and the other was a German shepherd male, only I could catch the German shepherd, the boxer kept running and I still have no clue where he is or who his owners are. But I currently am caring for the German shepherd.
Urbandale
Found: 9/18/2017
ID: 6831
Name:
Type: Cat
Color: Orange Tabby
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
Contact Westpointe Apartments Office Staff
Des Moines - South
Found: 9/18/2017
ID: 6828
Name:
Type: Dog
Color: Black
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Mediumish black lab mix. Wearing blue collar with polka dots. Has tattoo from spay.
Des Moines - South
Found: 9/17/2017
ID: 6819
Name: Unknown
Type: Cat
Color: Looks like a tiger cat.
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Found cat in Three Lakes Estates area. Cat is very friendly.
West Des Moines
Found: 9/16/2017
ID: 6811
Name:
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Cat found in Red Lobster Parking lot. Took to Furry Friends Refuge at 1211 Grand Ave.
Neola
Found: 9/16/2017
ID: 6807
Name:
Type: Dog
Color: Red
Breed: Dachshund
Gender: Male
Fixed: Unknown
Age: Adult
Call 402-689-5913 for more info.
West Des Moines
Found: 9/15/2017
ID: 6822
Name:
Type: Cat
Color: White and lite gray
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Senior
I have the cat home.
Windsor Heights
Found: 9/13/2017
ID: 6789
Name:
Type: Dog
Color: Tan/blonde
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Young
Found around 66th and University in the street with no collar on
Des Moines - North
Found: 9/11/2017
ID: 6780
Name:
Type: Dog
Color: Brown
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Found: 9/10/2017
ID: 6756
Name:
Type: Dog
Color:
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Adult
Windsor Heights
Found: 9/9/2017
ID: 6777
Name: Baby
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
His front right leg has a deformity from birth. It looks like he's hurt but he is not.