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: 10/3/2019
ID: 12503
Name: Unknown
Type: Dog
Color: Grey/Cream/White
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on 8600 block of westown prkwy. Microchip is unregistered.
West Des Moines
Found: 10/3/2019
ID: 12502
Name: Unknown
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
Found on prarieview and ashworth
West Des Moines
Found: 10/2/2019
ID: 12498
Name:
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Found near 500 block of 13th Street, West Des Moines
West Des Moines
Found: 10/2/2019
ID: 12496
Name: Unknown
Type: Cat
Color: Brown and Black Tabby
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
2400 block of 71st
Oakland
Found: 10/1/2019
ID: 12624
Name: We named him Theon Greyjoy for now
Type: Cat
Color: Grey
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
He still hangs around our house. Very skittish at first but now more approachable. Still swats and nips so once in a while.
West Des Moines
Found: 10/1/2019
ID: 12495
Name: Calypso
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Found on 8600 block of westown prkwy
Keokuk
Found: 9/30/2019
ID: 12482
Name:
Type: Dog
Color: Tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
She was found near the Simmons plant area on highway 61
West Des Moines
Found: 9/30/2019
ID: 12478
Name:
Type: Cat
Color: Buff and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Found on 88th St. in West Des Moines
West Des Moines
Found: 9/30/2019
ID: 12473
Name:
Type: Dog
Color: White and Grey
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Young
Found in Walmart parking lot near Jordan Creek
Des Moines - North
Found: 9/29/2019
ID: 12480
Name:
Type: Cat
Color: Black White
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Taken to ARL
Brandon
Found: 9/28/2019
ID: 12468
Name: unknown
Type: Cat
Color: white with tan ears and tail, light blue eyes
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
He is hanging out around our house. He is a very sweet cat, a young male. Would love to return him but only to a loving home. We are feeding him, in case you are worried.
West Des Moines
Found: 9/27/2019
ID: 12451
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Found near 5500 block of Vista
Urbandale
Found: 9/26/2019
ID: 12448
Name: Unknown
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found in Urbandale on the 7400 block of Cavanbury Rd
Urbandale
Found: 9/26/2019
ID: 12447
Name: Unknown
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Found in Walker Johnson Park
West Des Moines
Found: 9/26/2019
ID: 12443
Name: Unknown
Type: Cat
Color: Tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Adult
West Des Moines
Found: 9/26/2019
ID: 12442
Name: Unknown
Type: Dog
Color: Tan and brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Adult
Grimes
Found: 9/25/2019
ID: 12441
Name:
Type: Cat
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Young
Animal control took it.
West Des Moines
Found: 9/25/2019
ID: 12437
Name: Charmaine (Molly on Chip)
Type: Cat
Color: dilute tortie
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
West Des Moines
Found: 9/25/2019
ID: 12436
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
West Des Moines
Found: 9/25/2019
ID: 12432
Name: Chesty
Type: Dog
Color: White with Black Spots
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Found in Clive on the 156th block.
West Des Moines
Found: 9/24/2019
ID: 12431
Name: Kizer
Type: Dog
Color: Brown and Black Brindle
Breed: Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
Found in the 1700 block of Railroad Ave
Des Moines - East
Found: 9/23/2019
ID: 12430
Name:
Type: Dog
Color: Tan body with black face,German she roses like undercoat and moles on sides of face
Breed: Bulldog
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - Central
Found: 9/23/2019
ID: 12424
Name: Unknown
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Found at 2125 Indianola Ave.
Des Moines - East
Found: 9/22/2019
ID: 12419
Name: Leo
Type: Cat
Color: Tricolor
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Leo has been found with deep heartfelt breaking news. He is dead I buried him today along with my heart
Urbandale
Found: 9/22/2019
ID: 12414
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Found on 8600 block of Sweetbriar Ln. in Urbandale - found without collar