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 = 'lost' AND pm2.meta_value = 'Active' AND (pm3.meta_value IS NULL or (pm3.meta_value IS NOT NULL AND pm1.meta_value>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 8/12/2017
ID: 6480
Name: Sophie
Type: Dog
Color: White
Breed: Maltese
Gender: Female
Fixed: Neutered
Age: Adult
Very friendly, didn't have her tag on! Please contact Briar at 515.657.1798
Madrid
Lost: 8/12/2017
ID: 6464
Name: Tucker
Type: Dog
Color: Golden/tan
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Very sweet boy. Will come when you call
Des Moines - East
Lost: 8/11/2017
ID: 6449
Name:
Type: Dog
Color: Blond and Black
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Adult
Found on Hickman across from Broadlawns Hospital
Des Moines - South
Lost: 8/10/2017
ID: 6582
Name: Smokey
Type: Cat
Color: Grey
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
He has an enlarged thumb on his front feet. Declared in the front too
Waukee
Lost: 8/10/2017
ID: 6541
Name: Squarsh
Type: Cat
Color:
Breed: Himalayan
Gender: Female
Fixed: Neutered
Age: Adult
Near Waukee triangle
Hartford
Lost: 8/9/2017
ID: 6536
Name: mcgee
Type: Cat
Color: black and tan
Breed: Burmese
Gender: Male
Fixed: Neutered
Age: Adult
Was spotted at Monalu's in Hartford Iowa the Friday after he was missing
Urbandale
Lost: 8/9/2017
ID: 6445
Name: Cole
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
He is a very social cat and very friendly. All black. He went outside overnight and hasn't come home.
West Des Moines
Lost: 8/8/2017
ID: 6515
Name: Arwen
Type: Cat
Color: Orange black white
Breed: Birman
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Arwen got out of the house last Tuesday. She is an indoor cat and has not been declawed.
Des Moines - South
Lost: 8/8/2017
ID: 6442
Name: Kitty
Type: Cat
Color: Grey Tortie
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Lost: 8/8/2017
ID: 6434
Name: Calli
Type: Cat
Color: Tri colored
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Senior
60th and EP true Has medical issues
Norwalk
Lost: 8/8/2017
ID: 6420
Name:
Type: Dog
Color: Brown and white
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Adult
Found on Clarke Rd
Ankeny
Lost: 8/7/2017
ID: 9810
Name: Penny
Type: Dog
Color: Mahogany
Breed: Irish Setter
Gender: Female
Fixed: Neutered
Age: Adult
Last Seen: 2501 NW Pleasant St Ankeny IA 50023-9069 Microchip# 4C18387768
Des Moines - East
Lost: 8/7/2017
ID: 6640
Name: Millie
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Pomeroy
Lost: 8/7/2017
ID: 6545
Name: Maximus
Type: Cat
Color: brown/gray &white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He's got a white spot on his back
West Des Moines
Lost: 8/7/2017
ID: 6461
Name: Pumba
Type: Cat
Color: Orange and White
Breed: Abyssinian
Gender: Male
Fixed: Neutered
Age: Adult
He got out of my apartment at Chapel Ridge West.
Des Moines - South
Lost: 8/7/2017
ID: 6426
Name: Ollie
Type: Cat
Color: Tabby and white
Breed: Abyssinian
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Aug,7,2017 . Ollie has a red collar , white prints and a tiny bell.
Des Moines - South
Lost: 8/7/2017
ID: 6424
Name: Ollie
Type: Cat
Color: Tabby and white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Aug,7,2017 . Ollie has a red collar , white prints and a tiny bell.
Urbandale
Lost: 8/6/2017
ID: 6459
Name: Bandit
Type: Cat
Color: Bandit
Breed: Snowshoe
Gender: Male
Fixed: Neutered
Age: Adult
By Kmart on Hickman
Ames
Lost: 8/6/2017
ID: 6437
Name: Kelso
Type: Cat
Color: Black/White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Parking lot at Hampton Inn & Suites on SE 16th St in Ames, IA. Kelso is spooked easily, and if spotted, it is best to speak softly and move slowly. He is very receptive to having his name called and using kitty noises is also helpful. He loves catnip and wet kitty food, and may even come out of hiding when in the presence of a hairbrush, as he is absolutely obsessed with having his fur brushed, (especially around his ears and chin).
Spragueville
Lost: 8/6/2017
ID: 6407
Name: Petey
Type: Dog
Color: White and brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen running into wood behind our house. He is microchipped.
Des Moines - South
Lost: 8/6/2017
ID: 6403
Name: Molly
Type: Dog
Color: Wheat
Breed: Wheaten Terrier
Gender: Unknown
Fixed: Neutered
Age: Young
Sutures in abdomen from recent surgery
Ames
Lost: 8/5/2017
ID: 6455
Name: Winston
Type: Cat
Color: Black
Breed: Wheaten Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Recently moved from Clark & 20th area.
Grinnell
Lost: 8/4/2017
ID: 6520
Name: Happy
Type: Dog
Color: Black with white tux
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
Was adopted to a couple in grinell without my permission by a friend who was taking temporary custody. I adopted him on 11 24 2016 from dsm arl Hes chipped and licensed in my name I know hes in grinell and that's all
Waterloo
Lost: 8/4/2017
ID: 6382
Name: Pablo
Type: Dog
Color: White
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in my front yard! He just got a hair cut so he looks like a chihuahua he is also mixed with poodle he has a little hair on his tail still!
Grinnell
Lost: 8/3/2017
ID: 6519
Name: Happy
Type: Dog
Color: Black
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
Adopted without my permission to a family in grinell Hes chipped thru dsm arl . He was rescued there by me on nov 24 2016