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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Berwick
Found: 1/8/2017
ID: 4682
Name: Unknown
Type: Cat
Color: Black & White
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
Very friendly and sweet
Des Moines - Central
Found: 1/8/2017
ID: 4676
Name: ???
Type: Dog
Color: White
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Baby
Beaverdale area.
Des Moines - South
Found: 1/7/2017
ID: 4672
Name:
Type: Dog
Color:
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 1/2/2017
ID: 4643
Name: Unknown
Type: Dog
Color: Black/White
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Found: 1/2/2017
ID: 4642
Name: Unknown
Type: Dog
Color: Black/White
Breed: Boxer
Gender: Male
Fixed: Unknown
Age: Baby
Dubuque
Found: 12/31/2016
ID: 4666
Name: Tiger
Type: Cat
Color: Gray/striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He's very skiddish, frontal declaw, got out late Saturday and we are so worried with the cold weather and want him home please help by Broadlawn Rd near Belltower theater is where he was last seen
Des Moines - East
Found: 12/31/2016
ID: 4626
Name: Unknown
Type: Dog
Color: Light Brown, white on face, neck, belly
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Between Easton blvd and Sheridian Ave on E 39th Street
Des Moines - East
Found: 12/31/2016
ID: 4625
Name: Unknown
Type: Dog
Color: Light brow, white on neck, front belly, and face
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Found between Easton Blvd and Sheridian Avenue on E 39th street
Elkhart
Found: 12/30/2016
ID: 4629
Name: No idea
Type: Cat
Color: Black and white
Breed: Pit Bull
Gender: Unknown
Fixed: Unknown
Age: Young
White oak area
Des Moines - East
Found: 12/29/2016
ID: 4609
Name:
Type: Dog
Color: black and white
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Found around 4 p.m. trying to play with my dog through the fence. Im on E 40th between Sheridan and Hull. I brought him in and gave him some food and water. He is very playful and sweet.
Des Moines - East
Found: 12/29/2016
ID: 4602
Name: don’t know
Type: Dog
Color: brow with black patches
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - North
Found: 12/28/2016
ID: 4597
Name: Arnold
Type: Cat
Color: Brown, tan, black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Pleasant Hill
Found: 12/26/2016
ID: 4588
Name:
Type: Horse
Color:
Breed: Paint/Pinto
Gender: Male
Fixed: Not Applicable
Age: Adult
Altoona
Found: 12/24/2016
ID: 4592
Name: Unknown
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
This cat is very cute and very friendly. He appears to have been an inside cat. We are keeping him in our garage, as we have other cats.
West Des Moines
Found: 12/12/2016
ID: 4523
Name:
Type: Dog
Color: Grey and white
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Senior
Found by the UPS store on EP True PKWY. He is missing some teeth on the right side of his mouth. He is wearing an Iowa Hawkeyes harness.
Des Moines - West
Found: 12/9/2016
ID: 4504
Name: Gilbert
Type: Dog
Color: Piebald/black-brownish spotted
Breed: Dachshund
Gender: Male
Fixed: Neutered
Age: Adult
Found our little guy! Neighbor got him out of the cold!
Des Moines - South
Found: 12/6/2016
ID: 4481
Name:
Type: Cat
Color: Dark gray/charcoal & white
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Young
He had apparently been hanging out in 600 block of Creston, near Lincoln High, for several weeks. Neighbors were taking care of him. I have just learned that while I was typing this, he was picked up by ALR at around 8 pm on 12/6/16.
Des Moines - South
Found: 12/5/2016
ID: 4475
Name: Unknown
Type: Dog
Color: Black and white
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Baby
Super friendly, neutered male Husky found near Weeks Middle school around 4 pm. Very well cared for. Turned over to animal control. Good luck!
Des Moines - South
Found: 12/5/2016
ID: 4474
Name:
Type: Dog
Color: white
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Adult
Des Moines - East
Found: 12/1/2016
ID: 4525
Name: Unknown
Type: Cat
Color: Orange/Cream
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
Medium/Long hair Orange cat. Appears to be healthy. 20 plus pounds. Yellow eyes. Cat is a little skidish but Very friendly. No microchip could be found. Cat Found at NE 34TH Court and NE Aurora Ave., Des Moines. (Delaware township). If this could be your pet please call 515-554-3126 after 12:00 noon.
Des Moines - East
Found: 11/30/2016
ID: 4458
Name: Unknown
Type: Dog
Color: White
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
I found him on e30th and dean Wednesday morning about 6:15 am
Des Moines - West
Found: 11/30/2016
ID: 4456
Name:
Type: Cat
Color: Gray
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Baby
Found him in our parking lot at work on Hwy 28/Thornton Ave in Des Moines (Just south of Valley Junction). The kitty is gray medium to long hair with golden-brown eyes. I approximate it is about 6-8 months old. Has all of its claws.
Slater
Found: 11/26/2016
ID: 4424
Name: Unknown
Type: Dog
Color: Black
Breed: Shepherd
Gender: Male
Fixed: Unknown
Age: Senior
Was found crossing the street on Main St. in Slater. He is very obedient, I am guessing age is around 10+.
Des Moines - North
Found: 11/25/2016
ID: 4423
Name: Princess
Type: Cat
Color: Multicolor
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
Very friendly, stays in the area off Lower Beaver Road.
Des Moines - South
Found: 11/22/2016
ID: 4472
Name:
Type: Cat
Color: Grey Tabby
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Adult
Has chip but not registered. Is fully declawed. Found around SE 7th & Spring St. Call me to claim with chip number or other proof of ownership. 515-868-1132