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
Des Moines - South
Found: 7/30/2019
ID: 12033
Name: Huey
Type: Cat
Color: All gray
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
4131 SE24th. St.
Des Moines - Central
Found: 7/29/2019
ID: 11998
Name:
Type: Dog
Color: Grey
Breed: Schnauzer Miniature
Gender: Female
Fixed: Unknown
Age: Adult
Found near Windsor elementary school
Des Moines - North
Found: 7/29/2019
ID: 11996
Name: Emmy
Type: Dog
Color: Fawn
Breed: Mastiff English
Gender: Female
Fixed: Not Applicable
Age: Senior
Emmy and her leash came up missing from our front yard at 6th and Aurora in Des Moines, IA. She is almost 13 years old and an English Mastiff.
Ankeny
Found: 7/27/2019
ID: 11992
Name: unknown
Type: Cat
Color: Gray with white
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Found at White Birch Condos, corner of Oralabor and 2nd Avenue, Ankeny.
Des Moines - North
Found: 7/26/2019
ID: 11975
Name:
Type: Cat
Color: Black/white Tuxedo
Breed: Tuxedo
Gender: Unknown
Fixed: Unknown
Age: Adult
It came back! Still don't know the sex. Will try to live trap it soon and take to the vet to have scanned. It comes early morning or evening.
Fort Dodge
Found: 7/26/2019
ID: 11970
Name: Indy
Type: Dog
Color: Brown and black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Adult
309 7th Ave South around 5:15 pm. Please help. She is very small and only 3 pounds. Reward for helping us find her. Her family is heartbroken. Please call Tony 515-351-1240 (any time of day). Thank you.
Urbandale
Found: 7/26/2019
ID: 11964
Name: Kinnick
Type: Dog
Color: Brindle-black and brown
Breed: Mastiff English
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on 65th st between Meredith and Aurora avenue in Urbandale. Probably with his brother Thor, a white Shepherd. He is very friendly and loving but will probably bark at you and his bark can be intimidating, but he is very kind!
Urbandale
Found: 7/26/2019
ID: 11963
Name: Thor
Type: Dog
Color: White
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
On 65th st in Urbandale, between Meredith and Aurora Avenue. With his brother Kinnick, a brindle mastiff. Thor is very kind and loving. Loves other dogs so might be trying to play with yours. Both dogs are lovers.
Truro
Found: 7/25/2019
ID: 11972
Name:
Type: Dog
Color:
Breed: English Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
In Truro, IA Northwest side of town. Call 515 681-2215
Norwalk
Found: 7/25/2019
ID: 11956
Name: Unknown
Type: Dog
Color: Liver and white
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Adult
Found 4 miles south of Norwalk. West side of Hwy 28. 1 mike north of PROLE.
Des Moines - East
Found: 7/23/2019
ID: 11946
Name: Oscar
Type: Cat
Color: Black with little white spot on chest has a kink in tail about a nuckle length and green eyes
Breed: Bombay
Gender: Male
Fixed: Not Neutered
Age: Baby
He was last seen at cash savers grocery store E 14th Euclid
Des Moines - South
Found: 7/22/2019
ID: 11942
Name:
Type: Cat
Color: Orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Orange tabby cat found near McKinley and South union in Des Moines. Looks to be about 6-8 months, un neutered friendly male cat.
Des Moines - Central
Found: 7/22/2019
ID: 11934
Name: Ravenclaw
Type: Cat
Color: Tiger/gray/white/back and orange
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Adult
We found Ravenclaw. I guess she’s just a naughty teenager needing her space Last seen near Terrace Hill/terrace Road.She may answer when called for as ‘kitty.’
Des Moines - Central
Found: 7/22/2019
ID: 11932
Name:
Type: Dog
Color:
Breed: Poodle
Gender: Male
Fixed: Unknown
Age: Senior
Waukee
Found: 7/21/2019
ID: 11918
Name:
Type: Dog
Color: White
Breed: Poodle
Gender: Male
Fixed: Unknown
Age: Young
Dogs have gone home.
Bondurant
Found: 7/20/2019
ID: 11924
Name:
Type: Cat
Color: Orange white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Found: 7/17/2019
ID: 11902
Name:
Type: Dog
Color: White & Tan
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Elkhart
Found: 7/17/2019
ID: 11901
Name:
Type: Dog
Color:
Breed: Rottweiler
Gender: Female
Fixed: Unknown
Age: Adult
Very sweet, well behaved girl.
Des Moines - South
Found: 7/17/2019
ID: 11893
Name: Unknown
Type: Dog
Color: Black/Brown
Breed: German Shepherd/Purebred
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Ankeny
Found: 7/15/2019
ID: 11886
Name: Mojo
Type: Dog
Color: Black
Breed: Pinscher
Gender: Male
Fixed: Not Neutered
Age: Senior
I found mojo !! He was stuck in the garage .
Des Moines - Central
Found: 7/13/2019
ID: 11864
Name: Edward
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
I found my son!!!
Des Moines - North
Found: 7/11/2019
ID: 11899
Name:
Type: Cat
Color: grey and white
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Showed up on our deck. We live in Saylorville Township. Is not afraid of people, very friendly.
Urbandale
Found: 7/11/2019
ID: 11854
Name: Batman
Type: Cat
Color: White & Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
FOUND HIM
West Des Moines
Found: 7/11/2019
ID: 11852
Name:
Type: Cat
Color: Grey and Brown Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Adult
400 block of 1st Street
Des Moines - Central
Found: 7/11/2019
ID: 11845
Name: Normin
Type: Cat
Color: Black and White
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult