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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Found: 9/1/2021
ID: 17602
Name:
Type: Dog
Color: Gray and White
Breed: Alaskan Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
West Des Moines
Found: 8/31/2021
ID: 17598
Name:
Type: Cat
Color: grey
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
West Des Moines
West Des Moines
Found: 8/30/2021
ID: 17590
Name:
Type: Dog
Color: brown
Breed: Pit Bull Terrier
Gender: Female
Fixed: Unknown
Age: Adult
608 Valhigh Road, West Des Moines, IA, USA, Polk County, 50265
Pleasantville
Found: 8/30/2021
ID: 17589
Name: ?
Type: Dog
Color: White black brown
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Baby
Found south of pleasantville. Corner of Nevada and highway S45
West Des Moines
Found: 8/30/2021
ID: 17587
Name:
Type: Cat
Color: orange and white
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
50th Street, West Des Moines, IA, USA, Polk County, 50322
West Des Moines
Found: 8/30/2021
ID: 17585
Name:
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - West
Found: 8/29/2021
ID: 17576
Name:
Type: Cat
Color: Gray and White
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - East
Found: 8/28/2021
ID: 17575
Name: Unknown
Type: Dog
Color: White
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Young
Found walking in the middle of Hubbell just east of E.29th St
Urbandale
Found: 8/28/2021
ID: 17571
Name: Anges
Type: Cat
Color: orange
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Northview Estates Park, 50322
Des Moines - South
Found: 8/28/2021
ID: 17570
Name:
Type: Dog
Color: Tan
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Baby
South Union are south of McKinley
Bridgewater
Found: 8/27/2021
ID: 17566
Name:
Type: Cat
Color: White
Breed: Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Such a sweet, young guy. Has been hanging out on & around our front porch.
Des Moines - East
Found: 8/26/2021
ID: 17569
Name: Sadie
Type: Cat
Color:
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Declawed front
West Des Moines
Found: 8/26/2021
ID: 17567
Name:
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Carlisle
Found: 8/25/2021
ID: 17561
Name:
Type: Dog
Color: Tan
Breed: Pug
Gender: Unknown
Fixed: Unknown
Age: Baby
Found on 1st street near north park in the middle of the road with a collar and broken retractable leash still on.
West Des Moines
Found: 8/25/2021
ID: 17555
Name: Unknown
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
Found around Colt Dr in West Des Moines It’s safe in my fenced in back yard
Ankeny
Found: 8/23/2021
ID: 17551
Name:
Type: Cat
Color: Yellow/buff white on chest
Breed: Munchkin
Gender: Unknown
Fixed: Unknown
Age: Adult
We took it to ARL. They scanned and found microchip, were going to try and track down last known owners.
Urbandale
Found: 8/23/2021
ID: 17550
Name:
Type: Cat
Color: white and brown
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
3820 64th Street, Urbandale, IA, USA, Polk County, 50322
West Des Moines
Found: 8/22/2021
ID: 17536
Name:
Type: Dog
Color: tan
Breed: Chihuahua
Gender: Female
Fixed: Unknown
Age: Adult
301 Vine Street, West Des Moines, IA, USA, Polk County, 50265
West Des Moines
Found: 8/22/2021
ID: 17534
Name:
Type: Cat
Color: white
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
2nd St, West Des Moines, IA, USA, Locust St, Polk County, 50265
West Des Moines
Found: 8/22/2021
ID: 17533
Name:
Type: Dog
Color: brown
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Senior
98th St and Bishop Dr, 50265
West Des Moines
Found: 8/22/2021
ID: 17532
Name:
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
98th St and Bishop Dr, 50265
West Des Moines
Found: 8/21/2021
ID: 17548
Name: Geronimo
Type: Cat
Color: Geronimo
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Found: 8/21/2021
ID: 17527
Name:
Type: Dog
Color: black
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Adult
92nd St / Aster Dr, 50266
Runnells
Found: 8/20/2021
ID: 17541
Name: Tuxedo
Type: Cat
Color: Black and white
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Young
Acts like he used to be an indoor cat. Nice soft fur. Has a bit of a cold.
Ankeny
Found: 8/20/2021
ID: 17524
Name:
Type: Cat
Color: Gray
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Adult
Found on sidewalk west of 2nd Ave across from Hardee's.