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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 8/29/2019
ID: 12231
Name: Blu
Type: Dog
Color:
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Motel 6 in West Des Moines
Des Moines - Central
Found: 8/28/2019
ID: 12230
Name:
Type: Dog
Color: Black with tan paws
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Young
Found south of Douglas on 56th
Des Moines - Central
Found: 8/28/2019
ID: 12229
Name:
Type: Dog
Color: Black with tan paws
Breed: Terrier
Gender: Unknown
Fixed: Unknown
Age: Young
Found on 56th south of Douglas
Ames
Found: 8/28/2019
ID: 12224
Name: Lyla
Type: Dog
Color: Mixed, Brown, Black, White
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Young
Update: Owner called Ames Animal Shelter before they came to pick it up, owner came by and got it from us. Horray! On Ross Road in West Ames near Sawyer Elementary. Ames Animal Shelter will pick up.
Urbandale
Found: 8/27/2019
ID: 12223
Name: Unknown
Type: Dog
Color: Black and white
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Senior
Sent this sweet guy off with Westpet after no microchip available.
Urbandale
Found: 8/27/2019
ID: 12222
Name:
Type: Dog
Color: Black and White
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Adult
3509 133rd Way, Urbandale
Windsor Heights
Found: 8/27/2019
ID: 12221
Name:
Type: Dog
Color: Grey, White, Black
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Found in Windsor Heights
West Des Moines
Found: 8/27/2019
ID: 12220
Name:
Type: Dog
Color: Brown
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Commerce Dr. by Hidden Creek Dr in West Des Moines, off of Grand Ave
Urbandale
Found: 8/27/2019
ID: 12215
Name:
Type: Cat
Color: Brown tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
found in the 4000 block of 83rd
Iowa City
Found: 8/26/2019
ID: 12266
Name:
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Norwalk
Found: 8/26/2019
ID: 12216
Name: Bailey
Type: Dog
Color: Tri
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Senior
Bailey was found and is back home!
Des Moines - North
Found: 8/26/2019
ID: 12212
Name:
Type: Dog
Color:
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 8/26/2019
ID: 12211
Name:
Type: Dog
Color:
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - South
Found: 8/26/2019
ID: 12209
Name:
Type: Dog
Color: Brown
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
West Des Moines
Found: 8/25/2019
ID: 12201
Name:
Type: Dog
Color: Gray, Black, White
Breed: Jack Russell Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Found near 1800 Grand Ave
West Des Moines
Found: 8/25/2019
ID: 12198
Name: Unknown
Type: Dog
Color: black and tan
Breed: Pinscher-Miniature
Gender: Male
Fixed: Not Neutered
Age: Adult
12th/Walnut
Swisher
Found: 8/24/2019
ID: 12205
Name:
Type: Cat
Color: dark grey striped
Breed: Pinscher-Miniature
Gender: Female
Fixed: Unknown
Age: Young
Found Small Kitten Cat at Jefferson Monroe Fire Department in Swisher, Ia
Des Moines - North
Found: 8/24/2019
ID: 12197
Name:
Type: Dog
Color:
Breed: Pinscher-Miniature
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 8/24/2019
ID: 12194
Name: Lucille
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Senior
Last seen near Franklin Ave
West Des Moines
Found: 8/24/2019
ID: 12193
Name:
Type: Cat
Color: Brown and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
344 Holiday Circle
West Des Moines
Found: 8/24/2019
ID: 12192
Name:
Type: Cat
Color: black
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
344 Holiday Circle
Waukee
Found: 8/23/2019
ID: 12188
Name: Olaf
Type: Cat
Color: Grey,brown,&Tan
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
We are camping at Timberline Campground. A storage door was left opened and he got out in the night
Newhall
Found: 8/22/2019
ID: 12207
Name: Unknown
Type: Dog
Color: Orangish brown & patches of whitewhite
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Dog was found in Newhall, Iowa. Taken to Cedar Valley Humane Society in Cedar Rapids, IA on 9/3/19.
West Des Moines
Found: 8/22/2019
ID: 12189
Name:
Type: Cat
Color: Orange, Grey, and White Torbie
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Baby
Found near Bridgewood, Jordan Creek Towncenter
Des Moines - East
Found: 8/21/2019
ID: 12177
Name:
Type: Cat
Color: Tabby -brown/black with some orange on face
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Baby
Found near Sargent Park bike trail on Eastbound aside of Des Moines