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>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
Council Bluffs
Found: 5/4/2017
ID: 5532
Name:
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Young
Found along Interstate 29 S, approximately 35 miles north of Council Bluffs. Looks like he has been wandering for some time as was very hungry and skinny.
Des Moines - North
Found: 4/30/2017
ID: 5456
Name: Jersey
Type: Dog
Color: Black with White markings
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
Grateful appreciation to kind couple who found Jersey and scanned the neighborhood until they found us looking for her.
Des Moines - West
Found: 4/29/2017
ID: 5452
Name:
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
Update: Reunited with owner earlier this evening. Many thanks to all who helped in this effort!
Waukee
Found: 4/27/2017
ID: 5466
Name:
Type: Cat
Color: Orange/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Adult
Found Alice's Road and Douglas
Ankeny
Found: 4/27/2017
ID: 5435
Name:
Type: Dog
Color: Grey White Black
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
Van Meter
Found: 4/26/2017
ID: 5469
Name: Marley
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Badger Creek & Cumming area. Traveling with his chocolate lab sister.
Van Meter
Found: 4/26/2017
ID: 5468
Name: Bella
Type: Dog
Color: Dark Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen in Badger Creek & Cumming area. Traveling as a pair.
Waterloo
Found: 4/25/2017
ID: 5477
Name: Unknown
Type: Cat
Color: Black & White
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Very sweet cat, currently in my home. He behaves as if he has been domesticated.
Des Moines - North
Found: 4/25/2017
ID: 5421
Name: Jasper
Type: Dog
Color: Brown/Orange
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
Last seen escaping the backyard fence on Lynner Dr and running into the woods.
Des Moines - Central
Found: 4/23/2017
ID: 5394
Name: Patunia
Type: Dog
Color: Tan/cream
Breed: Pekingese
Gender: Female
Fixed: Neutered
Age: Adult
Last seen this morning we live between drake university and north high school she's friendly but I don't know if she would go up to anybody. We call her patunia or tuna fish and she listens to them.
Des Moines - South
Found: 4/23/2017
ID: 5393
Name:
Type: Dog
Color: Brown
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Found at Gray's Lake Apartments
Urbandale
Found: 4/22/2017
ID: 5384
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Unknown
Age: Baby
April 22, 2017 2:55 pm - Very nice long haired German Shepard with collar no tags found at 70th and Rocklyn Circle in Urbandale. If you are the owner call the Urbandale Police, they are sending animal control to pick her up.
Radcliffe
Found: 4/21/2017
ID: 5422
Name: Unknown
Type: Dog
Color: Black and brown
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
Ankeny
Found: 4/21/2017
ID: 5418
Name:
Type: Cat
Color:
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - Central
Found: 4/20/2017
ID: 5371
Name: Dewey
Type: Dog
Color: White with black
Breed: English Coonhound
Gender: Male
Fixed: Not Neutered
Age: Baby
Was last with me on scott street bridge
Des Moines - West
Found: 4/19/2017
ID: 5366
Name: 2 Dogs in the WATERBURY CIRCLE neighborhood
Type: Dog
Color: Spotted (medium and small dog)
Breed: Terrier
Gender: Male
Fixed: Unknown
Age: Young
They are fine. I kept them in my garage overnight as don't know way home. Please come get them if they belong to you.
Des Moines - East
Found: 4/16/2017
ID: 5315
Name:
Type: Dog
Color:
Breed: Chihuahua
Gender: Unknown
Fixed: Unknown
Age: Baby
if this is your dog please call 515 339 2105 this dog is lonely for its owners, please describe all aspects of the dog please
West Des Moines
Found: 4/16/2017
ID: 5306
Name:
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
28th & Vine Taken to Furry Friends Refuge
Ankeny
Found: 4/14/2017
ID: 5328
Name: Tigger
Type: Cat
Color: Light brown with black tiger striped.
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen 4/13 at 9:00 pm. Knows his name and is friendly. went missing by Saylorville visitors center.
Des Moines - East
Found: 4/14/2017
ID: 5289
Name:
Type: Dog
Color:
Breed: Bichon Frise
Gender: Male
Fixed: Not Neutered
Age: Adult
Polk City
Found: 4/12/2017
ID: 5279
Name:
Type: Cat
Color: Orange and white
Breed: Bichon Frise
Gender: Male
Fixed: Unknown
Age: Young
Has been hanging out on our deck for a few days, very friendly.
Des Moines - South
Found: 4/12/2017
ID: 5263
Name:
Type: Dog
Color:
Breed: Bichon Frise
Gender: Male
Fixed: Unknown
Age: Baby
East Hackley ave
Des Moines - West
Found: 4/12/2017
ID: 5260
Name:
Type: Cat
Color: Grey and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Adult
Found this precious baby! Call me 515-689-0033
Bondurant
Found: 4/11/2017
ID: 5254
Name: Unknown
Type: Dog
Color: Brown/White
Breed: German Wirehaired Pointer
Gender: Male
Fixed: Neutered
Age: Young
Contact 402 658 2784
Prairie City
Found: 4/10/2017
ID: 5275
Name:
Type: Dog
Color: White and brown
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Unknown
Age: Adult
Was found on the road near Goldie's in prairie city