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
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
West Des Moines
Found: 8/17/2019
ID: 12141
Name:
Type: Dog
Color: Buff
Breed: GoldenDoodle
Gender: Female
Fixed: Unknown
Age: Young
Greenbelt Kennels
Des Moines - Central
Found: 8/16/2019
ID: 12260
Name: Susie Q
Type: Dog
Color: Black with little bit of white markings
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Young
Found at Drake University Apts. 36th and Forest.
Runnells
Found: 8/16/2019
ID: 12138
Name: Zoey
Type: Dog
Color: White and Brown
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Young
Runnells
Found: 8/16/2019
ID: 12137
Name: Zoey
Type: Dog
Color: White and Brown
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Young
Johnston
Found: 8/16/2019
ID: 12133
Name: unknown
Type: Dog
Color: tan
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
Found on N Winwood Drive. Please call the Johnston Public Works at 515-278-0822 during business hours, or call the Johnston Police at 515-278-2345 anytime to claim this dog.
Des Moines - South
Found: 8/15/2019
ID: 12131
Name:
Type: Dog
Color: Black/brown
Breed: Pug
Gender: Male
Fixed: Unknown
Age: Adult
Was roaming SW 5th and Emma area 10:30 pm. He’s small, mostly black, short haired muscular, energetic, and somewhat skittish. He is wearing a collar so guessing he has a family who is missing him.
Urbandale
Found: 8/15/2019
ID: 12130
Name:
Type: Cat
Color: Grey Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found on 6100 block of Oakwood
Plymouth
Found: 8/15/2019
ID: 12129
Name:
Type: Dog
Color: Brown and light brown
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Unknown
Age: Adult
330th st. Rural Plymouth 50464
Des Moines - Central
Found: 8/14/2019
ID: 12119
Name:
Type: Dog
Color: Blue or gray
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
51st and Douglas ave in DSM.
West Des Moines
Found: 8/13/2019
ID: 12128
Name:
Type: Dog
Color: Brown and Black
Breed: Shepherd
Gender: Male
Fixed: Unknown
Age: Adult
Found with German Shepherd
West Des Moines
Found: 8/13/2019
ID: 12127
Name:
Type: Dog
Color: Brown and Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Found with long-haired shepherd mix
Des Moines - South
Found: 8/12/2019
ID: 12120
Name:
Type: Cat
Color: black
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Came to my yard in SW DSM. Small, all-black female cat, appears to be about 6 months old. Polydactyl (extra toes), very friendly. Very thin, but seems in good condition otherwise, would appear to be from a good home.
West Des Moines
Found: 8/12/2019
ID: 12112
Name:
Type: Dog
Color: Black and White
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Found in the 1800 block of Bennett Drive