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>='1606089600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 8/19/2020
ID: 14756
Name:
Type: Cat
Color: Brown Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Ames
Found: 8/18/2020
ID: 14795
Name: Garfield
Type: Cat
Color: Orange/yellow
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Last seen 8/18 around 10pm. He is 16 and in failing health (oral cancer and kidney disease). He is missing 1 front du-claw. He is very light colored and his stripes are barely visible, but he does have tabby stripes and the tabby "M" on his forehead. He is friendly and will probably come to treats. Lost from 1019 6th St in Ames, near downtown and Brookside park.
West Des Moines
Found: 8/18/2020
ID: 14754
Name:
Type: Cat
Color: Black, grey, Light tan/brown
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
No front claws, west Des Moines picked up the cat and states they were going to take him/her To furry friends. Friendly cat, offered it cat treats and wet food but wasn’t interested. It allowed myself to Pick it up but it was scared and cried and did not want to be held much.
West Des Moines
Found: 8/18/2020
ID: 14753
Name:
Type: Bird
Color: black and white
Breed: Chicken
Gender: Female
Fixed: Unknown
Age: Adult
500 block of 53rd Street
Des Moines - Central
Found: 8/18/2020
ID: 14747
Name: Max
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
We live on High street around the 26th block he came up to the back door. He is an excellent dog. He is calm, well mannered, gentle, and responds to commands. There was a telephone number on the back of the tag but it only takes certain calls.
West Des Moines
Found: 8/17/2020
ID: 14749
Name: Albus
Type: Cat
Color: Black
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on Dakota Drive. Cat is very shy, his name Albus. Has claws front and back.
Urbandale
Found: 8/17/2020
ID: 14746
Name:
Type: Cat
Color:
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
Meredith in Urbandale
West Des Moines
Found: 8/17/2020
ID: 14741
Name:
Type: Cat
Color: grey & white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
8000 block of Cody drive
West Des Moines
Found: 8/17/2020
ID: 14254
Name:
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
500 block 7th street
Des Moines - Central
Found: 8/15/2020
ID: 14728
Name:
Type: Dog
Color: Black and white spots
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Found on Hickman Rd
West Des Moines
Found: 8/15/2020
ID: 14724
Name:
Type: Rabbit
Color: Black
Breed: Havana
Gender: Unknown
Fixed: Unknown
Age: Adult
10th Street & Vine
Pleasant Hill
Found: 8/15/2020
ID: 14721
Name:
Type: Dog
Color:
Breed: Havana
Gender: Male
Fixed: Unknown
Age: Baby
Found 2 dogs in Pleasant Hill
Pleasant Hill
Found: 8/15/2020
ID: 14720
Name:
Type: Dog
Color:
Breed: Havana
Gender: Male
Fixed: Unknown
Age: Baby
Picked these two up walking down S.E. 6th Ave in pleasant hil
West Des Moines
Found: 8/14/2020
ID: 14716
Name:
Type: Cat
Color: Tan and Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
600 block 8th street
Des Moines - North
Found: 8/14/2020
ID: 14715
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Baby
Cornell and Aurora
Des Moines - East
Found: 8/14/2020
ID: 14713
Name:
Type: Dog
Color:
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
He was found in the oak park/highland park neighborhood. The 14th st rescue league had him now.
Des Moines - West
Found: 8/13/2020
ID: 14709
Name:
Type: Dog
Color: Grey
Breed: Shih Tzu
Gender: Male
Fixed: Unknown
Age: Young
Urbandale
Found: 8/13/2020
ID: 14702
Name:
Type: Cat
Color: Brown tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
4000 block 86th street
Urbandale
Found: 8/13/2020
ID: 14696
Name:
Type: Cat
Color: Orange, Black, White chin
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Declawed
Runnells
Found: 8/12/2020
ID: 14695
Name: Unknown
Type: Bird
Color: Green, black, blue, red
Breed: Conure
Gender: Unknown
Fixed: Unknown
Age: Adult
Has band on leg.
West Des Moines
Found: 8/12/2020
ID: 14692
Name:
Type: Cat
Color: Black & White and Brown & White Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Both found together in a laundry room at Jordan Creek Apartments
Clive
Found: 8/12/2020
ID: 14691
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
8400 Block of Alice Avenue
West Des Moines
Found: 8/12/2020
ID: 14690
Name:
Type: Dog
Color: brown
Breed: Labradoodle
Gender: Male
Fixed: Not Neutered
Age: Baby
Jordan Creek Mall
Des Moines - North
Found: 8/12/2020
ID: 14688
Name: Hemi
Type: Dog
Color: Choclate
Breed: Labradoodle
Gender: Male
Fixed: Not Neutered
Age: Senior
Hemi has been located by the Polk County Sheriff's department & was turned into the Main ARL office. He has been retrieved.
Des Moines - East
Found: 8/12/2020
ID: 14684
Name:
Type: Dog
Color: Light brown/white
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Adult
Found on Capitol between East 29th and East 30th