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>='1575331200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Found: 8/26/2019
ID: 12211
Name:
Type: Dog
Color:
Breed:
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
Des Moines - South
Found: 8/20/2019
ID: 12173
Name: Unknown
Type: Cat
Color: Dark Brown, Tan, Gray
Breed: Unknown
Gender: Female
Fixed: Not Applicable
Age: Young
We found this sweet girl wandering on the Southside of DSM behind Menards on SE 14th. She's very friendly and looks like she's been out on her own for awhile. No collar and is not declawed.
Des Moines - North
Found: 8/20/2019
ID: 12172
Name:
Type: Dog
Color: Brown and white
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Found at 2nd Ave and New York.
Carlisle
Found: 8/19/2019
ID: 12174
Name:
Type: Cat
Color: Black and white
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
Declawed Found owner!
Des Moines - North
Found: 8/19/2019
ID: 12169
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 8/19/2019
ID: 12168
Name:
Type: Dog
Color:
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Urbandale
Found: 8/19/2019
ID: 12164
Name:
Type: Cat
Color: Buff orange
Breed: Domestic Long Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found at 150th and Waterford - Front declawed
West Des Moines
Found: 8/18/2019
ID: 12159
Name:
Type: Dog
Color: Blue and white
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Found in the 8700 block of Urbandale
Des Moines - South
Found: 8/18/2019
ID: 12158
Name:
Type: Dog
Color: Tan and white
Breed: Shiba Inu
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 8/18/2019
ID: 12155
Name: Unknown
Type: Dog
Color: Reddish brown
Breed: Shiba Inu
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 8/17/2019
ID: 12153
Name:
Type: Dog
Color: White
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
1325 90th St.
Indianola
Found: 8/17/2019
ID: 12148
Name:
Type: Dog
Color: White and brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Had a snapped yard wire connected to collar
Clive
Found: 8/17/2019
ID: 12146
Name:
Type: Dog
Color: Black, Brown, and White
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Adult
Found Near Stonegate Crossing Apartments