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>='1555545600')) ORDER BY pm1.meta_value DESC, post_date DESC
Johnston
Lost: 12/3/2015
ID: 2088
Name: Rusty
Type: Dog
Color: Brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Lost in Johnston behind sonic and bandit burrito he's all brown he has a white spot on his chest brown eyes and he has one white nail and the rest are black he's a very loving dog not aggressive at all and he also loves to sit on somebody's lap lol but I will give a revard to the person that found or has my dog my family misses him very much and it's been very hard without him so please contact me if you have any information reward will be given to the person thanks
Des Moines - North
Lost: 12/3/2015
ID: 2018
Name: tom tom
Type: Cat
Color: cream
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Adult
Ne 43rd ave and unique meow
Des Moines - North
Lost: 12/3/2015
ID: 2017
Name: tom tom
Type: Cat
Color: cream
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Adult
Unique mow
Waterloo
Lost: 12/1/2015
ID: 2241
Name: Jack
Type: Dog
Color: gray
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Adult
last seen on Ridgeway Ave across from the planet fitness mall
Walnut
Lost: 12/1/2015
ID: 2105
Name: Unknown
Type: Cat
Color: Black with white legs
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Baby
My house. Helping him find his owners.
West Des Moines
Lost: 11/27/2015
ID: 1981
Name: Oliver (Ollie)
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Adult
6pm Friday night 11/27. Will come if you call him. Friendly but doesnt like to be grabbed by his collar. Will jump into you car or sit to put on a lead
Des Moines - East
Lost: 11/26/2015
ID: 1986
Name: zoey
Type: Dog
Color: brown and tan
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Young
She has one blue eye and one brown eye.
Des Moines - South
Lost: 11/26/2015
ID: 1980
Name: Gidget
Type: Dog
Color: Black with a white chest.
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
It has been over a year since our little Gidget escaped out of our back yard off of SW 30th street. We miss her greatly as does her playmate Tank, which was raised with her. She is a Pekingese/Shih Tzu mix and very friendly.
Des Moines - East
Lost: 11/26/2015
ID: 1977
Name: TAZ
Type: Dog
Color: White
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Last seen around 8:30 pm around East 28th and Dean.
Des Moines - Central
Lost: 11/25/2015
ID: 1975
Name: Baby bear
Type: Dog
Color: Brown n black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
Was at my home
Waukee
Lost: 11/24/2015
ID: 1985
Name: Mae
Type: Cat
Color: Gray and white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Waukee
Lost: 11/24/2015
ID: 1979
Name: Mae
Type: Cat
Color: Gray with white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
She has her claws but friendly. She does not like her belly rubbed. Likes to cuddle
Ogden
Lost: 11/23/2015
ID: 2000
Name: Bella
Type: Dog
Color: White
Breed: Shiba Inu
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 11/23/2015
ID: 1968
Name:
Type: Dog
Color: blond
Breed: Shiba Inu
Gender: Female
Fixed: Unknown
Age: Young
Johnston
Lost: 11/23/2015
ID: 1963
Name: Maci
Type: Dog
Color: White with brown patches
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
Last seen around Dewey park
Seymour
Lost: 11/22/2015
ID: 2006
Name: Kiki
Type: Cat
Color: Gray and black
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Adult
She ran away while being watched on a farm in Seymour. She is friendly. Her fur patters are generally symmetrical on right and left side. Has all of her claws.
Des Moines - West
Lost: 11/21/2015
ID: 1950
Name: Piper
Type: Dog
Color: White
Breed: Jack Russell Terrier (Parson Russell Terrier)
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Wearing a collar with a heart. Please call 763 381 2751.
Ankeny
Lost: 11/20/2015
ID: 1959
Name: zelda
Type: Cat
Color: gray/black striped
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
south side of ankeny near carney.
Des Moines - Central
Lost: 11/20/2015
ID: 1944
Name: Charlie
Type: Dog
Color:
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Adult
He was let out to pee and he ran after a rabbit. He may still be in the 31st Street/Ingersoll area. He answers well to his name and kissy noises. If he sees you, he'll jump up on you in excitement.
West Des Moines
Lost: 11/20/2015
ID: 1940
Name: Houston
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Lost on Monday evening
Des Moines - South
Lost: 11/19/2015
ID: 2059
Name: BB
Type: Cat
Color: Grey, White, yellow.
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
BB is a indoor outdoor cat, she comes and goes through our doggy door. It has been 4 weeks since we've seen her. With any information please call or text 515-988-2727.
Des Moines - South
Lost: 11/19/2015
ID: 2058
Name: BB
Type: Cat
Color: Grey, White, Yellow.
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She is a indoor out door cat. She comes and goes through our doggy door. It has been 4 weeks since she has returned home. We live around Lincoln and any information would be greatly appreciated.
Winterset
Lost: 11/19/2015
ID: 1966
Name: Marshall
Type: Cat
Color: Dark gray tabby
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 11/19/2015
ID: 1942
Name: Rosa
Type: Dog
Color: White
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen by 13th street and Ascension street. Rosa is deaf and she is also dog aggressive. She is great with people.
Bevington
Lost: 11/18/2015
ID:
Name: bruno
Type: Dog
Color: brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Baby
missing fur under neck and under belly due to scratching from severe allergies