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>='1600473600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 8/20/2020
ID: 14765
Name:
Type: Cat
Color: Grey and yellow
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Ankeny
Found: 8/20/2020
ID: 14762
Name:
Type: Dog
Color: Grey black white
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Must provide proof of ownership with picture or other info
Defiance
Found: 8/19/2020
ID: 14836
Name: THIS IS A TEST ONLY – IGNORE!
Type: Bird
Color:
Breed: Duck
Gender: Male
Fixed: Unknown
Age: Baby
Urbandale
Found: 8/19/2020
ID: 14761
Name:
Type: Dog
Color: Tan and Black
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
77th ans Douglas
Pleasant Hill
Found: 8/19/2020
ID: 14757
Name:
Type: Dog
Color: Brown
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Person is keeping lost dog in the back yard until owner is found.
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.