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>='1549843200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Found: 10/8/2017
ID: 7033
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Birmingham
Found: 10/6/2017
ID: 7028
Name:
Type: Dog
Color: White with black spots
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Rides well in car, collar indent in fur. .
Johnston
Found: 10/5/2017
ID: 6994
Name: Unknown
Type: Cat
Color: White and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Today. Actually have seen him around since end of August. Very, very friendly, cuddly and needy but has been scaring off our own lost Tuxedo cat.
Pleasant Hill
Found: 10/2/2017
ID: 7153
Name:
Type: Cat
Color: Orange, White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Very friendly orange and white cat. Vet thinks it is neutered but could not find a microchip. Adult cat. Found in Pleasant Hill.
Des Moines - West
Found: 10/2/2017
ID: 6967
Name: Lightning
Type: Dog
Color: Black
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Baby
Winterset
Found: 10/1/2017
ID: 6965
Name:
Type: Dog
Color:
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Young
Found near W Buchanan Street around 11pm Sunday, 10/1.
Des Moines - Central
Found: 10/1/2017
ID: 6963
Name:
Type: Dog
Color:
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Indianola
Found: 10/1/2017
ID: 6952
Name: Unknown
Type: Dog
Color:
Breed: Blue Heeler
Gender: Female
Fixed: Unknown
Age: Young
Midway between Indianola, South Des Moines, Norwalk, Carlisle.
Des Moines - Central
Found: 9/30/2017
ID: 6991
Name:
Type: Cat
Color: Golden Tan and White
Breed: Blue Heeler
Gender: Female
Fixed: Unknown
Age: Baby
Front claws declawed, well groomed and very sweet Has been hanging around 51st and 52nd and Lincoln Ave area between Hickman and Franklin ave
Johnston
Found: 9/30/2017
ID: 6950
Name:
Type: Cat
Color: Blonde
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - North
Found: 9/30/2017
ID: 6938
Name:
Type: Cat
Color: Gray
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
Cat had no collar or tags, animal was turned over to Des Moines Animal Control. Cat was found in Beaverdale neighborhood.
West Des Moines
Found: 9/30/2017
ID: 6936
Name:
Type: Cat
Color: Orange/Tan
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found outside Culver's on Jordan Creek Parkway with no collar. Approachable cat and friendly. Has blue eyes. Contact 515-257-6314
Des Moines - North
Found: 9/28/2017
ID: 6918
Name:
Type: Dog
Color: White/brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
Found in Chautauqua neighborhood
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.