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>='1585008000')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Found: 10/19/2019
ID: 12634
Name:
Type: Cat
Color: White and grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Found near 4500 block of 86th Street, Urbandale
West Des Moines
Found: 10/18/2019
ID: 12633
Name:
Type: Dog
Color: Red and White
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
517 3rd St., in alley
West Des Moines
Found: 10/18/2019
ID: 12631
Name:
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Quad Park S 50th St
Des Moines - South
Found: 10/18/2019
ID: 12621
Name:
Type: Cat
Color: Tabby brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Applicable
Age: Young
Found a smaller tabby cat on south side of Des Moines on 3rd and E Park avenue. Very friendly
Urbandale
Found: 10/17/2019
ID: 12622
Name:
Type: Cat
Color: Black with white spot
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Found on Waterford Rd. in Urbandale
Urbandale
Found: 10/17/2019
ID: 12618
Name:
Type: Dog
Color: White and Orange
Breed: Hound
Gender: Male
Fixed: Neutered
Age: Adult
4300 block Parkview Dr.
Des Moines - Central
Found: 10/16/2019
ID: 12617
Name:
Type: Cat
Color: Orange
Breed: Extra-Toes Cat (Hemingway Polydactyl)
Gender: Male
Fixed: Unknown
Age: Adult
Super tame cat came up our driveway. We let him inside and he is very calm with our dogs and cat so we think he must have a home. He has mitten toes. Orange male. No collar. We have him safe and secure just want to find his family.
Urbandale
Found: 10/15/2019
ID: 12609
Name:
Type: Dog
Color: Brown and Black
Breed: Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Found on 86th ramp of Interstate 80/35
Urbandale
Found: 10/15/2019
ID: 12608
Name: Xander
Type: Dog
Color: Black, Brown, and White
Breed: Collie
Gender: Male
Fixed: Unknown
Age: Adult
Found on the 86th ramp on Interstate 80/35
West Des Moines
Found: 10/14/2019
ID: 12602
Name:
Type: Cat
Color: White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Found at Chow's Olympic Ave. in West Des Moines
West Des Moines
Found: 10/14/2019
ID: 12600
Name: 2 Black Rabbits
Type: Rabbit
Color: Black
Breed: American
Gender: Male
Fixed: Unknown
Age: Young
found on the 2300 block of westown prkwy
Dubuque
Found: 10/14/2019
ID: 12599
Name: Josie
Type: Dog
Color: White w/black spots
Breed: Brittany Spaniel
Gender: Female
Fixed: Neutered
Age: Senior
Dubuque - South Grandview near Plymouth Ct.
Des Moines - East
Found: 10/13/2019
ID: 12594
Name:
Type: Dog
Color: Tan
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
St. Marys
Found: 10/13/2019
ID: 12591
Name:
Type: Dog
Color:
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Unknown
Age: Adult
County road r57 by iron bridge
Des Moines - South
Found: 10/12/2019
ID: 12588
Name:
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Urbandale
Found: 10/12/2019
ID: 12587
Name:
Type: Cat
Color: Orange tabby
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Found at Colby Woods Park
West Des Moines
Found: 10/12/2019
ID: 12585
Name: Peaches
Type: Cat
Color: Tortoiseshell
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Found on 8th St. in West Des Moines
West Des Moines
Found: 10/11/2019
ID: 12603
Name:
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
2200 block of Grand Ave
West Des Moines
Found: 10/11/2019
ID: 12576
Name:
Type: Cat
Color: black
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
4100 University Ave.
Des Moines - South
Found: 10/11/2019
ID: 12573
Name:
Type: Dog
Color: Tan
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
South Des Moines Park ave/Fleur Dr
Des Moines - North
Found: 10/8/2019
ID: 12557
Name:
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Found around mchenry park and oak park apts on 8th st
West Des Moines
Found: 10/8/2019
ID: 12547
Name:
Type: Cat
Color: White and Grey
Breed: Siamese
Gender: Unknown
Fixed: Unknown
Age: Adult
400 block of 6th St
Pella
Found: 10/7/2019
ID: 12543
Name: Teddy
Type: Dog
Color: Deadgrass
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Teddy is home safe. Thank you!
West Des Moines
Found: 10/7/2019
ID: 12541
Name: Unknown
Type: Bird
Color: Grey,Yellow, and white
Breed: Cockatiel
Gender: Unknown
Fixed: Unknown
Age: Adult
Found at maple grove elementary school.
Clive
Found: 10/6/2019
ID: 12540
Name: Raven
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
On the 2100 Block of NW 90th