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>='1610928000')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 12/28/2020
ID: 15771
Name:
Type: Dog
Color: Brown and white
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Adult
57th Court
Des Moines - South
Found: 12/26/2020
ID: 15761
Name:
Type: Dog
Color:
Breed: Siberian Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 12/25/2020
ID: 15759
Name:
Type: Dog
Color: brown
Breed: Shar Pei
Gender: Female
Fixed: Unknown
Age: Adult
Fort Dodge
Found: 12/24/2020
ID: 15782
Name:
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
She is spayed but no microchip. Found by Deer Creek Golf course
Des Moines - Central
Found: 12/24/2020
ID: 15769
Name: Unknown
Type: Dog
Color: White with Tan Spots
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen near 6th and University Avenue. Approximately one Block North of Mercy Hospital. Sweet dog. Well trained. Has been to my house every night since Christmas Eve.
Des Moines - North
Found: 12/24/2020
ID: 15755
Name: Unknown
Type: Dog
Color: Silver/grey
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Young
This dog was found around 38th street and Adams Ave. in Beaverdale. Dropped off at the ARL in Ankeny on 12/24
West Des Moines
Found: 12/23/2020
ID: 15752
Name:
Type: Cat
Color: grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Baby
6689 Vista Dr
Des Moines - South
Found: 12/23/2020
ID: 15751
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Baby
West Des Moines
Found: 12/23/2020
ID: 15745
Name:
Type: Cat
Color: Brown & Orange Torbie
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
900 block of 78th Place
Des Moines - Central
Found: 12/22/2020
ID: 15742
Name:
Type: Dog
Color: White and black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Senior
West Des Moines
Found: 12/22/2020
ID: 15741
Name:
Type: Cat
Color: black and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
4300 block of Aspen Drive
West Des Moines
Found: 12/22/2020
ID: 15739
Name:
Type: Cat
Color: Brown and Black Tabby
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
West Des Moines
Found: 12/22/2020
ID: 15738
Name:
Type: Dog
Color: black and white
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 12/21/2020
ID: 15731
Name:
Type: Dog
Color: Black
Breed: Retriever, Labrador
Gender: Female
Fixed: Unknown
Age: Adult
3801 Stonebridge
West Des Moines
Found: 12/21/2020
ID: 15730
Name:
Type: Dog
Color: Blond
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Adult
3801 Stonebridge
Des Moines - East
Found: 12/20/2020
ID: 15728
Name: Pecas
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Our cat came home last night!
Des Moines - Central
Found: 12/20/2020
ID: 15715
Name:
Type: Dog
Color:
Breed: Collie Rough
Gender: Male
Fixed: Unknown
Age: Adult
Clive
Found: 12/19/2020
ID: 15710
Name:
Type: Dog
Color: black and tan
Breed: Coonhound
Gender: Female
Fixed: Unknown
Age: Adult
73rd and Buffalo Road
Des Moines - West
Found: 12/19/2020
ID: 15709
Name: Chester
Type: Cat
Color: Brown/White/Black
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Urbandale
Found: 12/17/2020
ID: 15704
Name: Doodle
Type: Cat
Color: white
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
9405 Aurora Ave
West Des Moines
Found: 12/17/2020
ID: 15700
Name:
Type: Cat
Color: Black with white on chest
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - Central
Found: 12/16/2020
ID: 15720
Name:
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Victor
Found: 12/16/2020
ID: 15702
Name:
Type: Dog
Color: Black
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Young
I found her on i80. She’s currently with me in Illinois but I’m trying to get her the medical help she needs.
Ankeny
Found: 12/16/2020
ID: 15701
Name: Unsure
Type: Cat
Color:
Breed: Tortoiseshell
Gender: Unknown
Fixed: Unknown
Age: Young
Found in DQ parking lot in Ankeny.
West Des Moines
Found: 12/16/2020
ID: 15697
Name:
Type: Dog
Color: white
Breed: Maltese
Gender: Male
Fixed: Unknown
Age: Adult
29th Court