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>='1573257600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 6/4/2016
ID: 3138
Name: Gary
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Has a white flea collar.
Des Moines - Central
Lost: 6/4/2016
ID: 3077
Name: Mya
Type: Dog
Color: Snow dog colored
Breed: Alaskan Malamute
Gender: Female
Fixed: Neutered
Age: Young
9th and Forest in Des Moines.
Des Moines - South
Lost: 6/4/2016
ID: 3071
Name: rella
Type: Dog
Color: brindle
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
She is always thirsty
Ankeny
Lost: 6/3/2016
ID: 4016
Name: Snooki
Type: Cat
Color: Brown/white/black stripes
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Snooki is a longhair tabby (I think) cat. Outdoor/indoor mix. One day she never returned. She has a combination of white/tan/brown/black hair. Kind of like a striped pattern. White belly, has a black "M" shape above her eyes. Loves people, super friendly and loving. She has problems with her eyes. Being gone for so many months she hasn't had her medicine so her eyes could be very cloudy. It's been about 4-5 months. I'm hoping someone has her. Please contact me if you have any information. 515-419-2534
Des Moines - East
Lost: 6/3/2016
ID: 3307
Name: Tuffy
Type: Dog
Color: Yellow
Breed: Cocker Spaniel
Gender: Male
Fixed: Not Neutered
Age: Senior
Last seen in our backyard at 1840 capitol ave
Pleasant Hill
Lost: 6/3/2016
ID: 3070
Name: Herky
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen1030am at our residence in pleasant hill. We left for a few hours and when we came home, he was gone.
Des Moines - East
Lost: 6/1/2016
ID: 3444
Name: Zeus
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Lost from se creston ave off e 14th. Has a loving family with kids that miss him!
Des Moines - East
Lost: 6/1/2016
ID: 3359
Name:
Type: Dog
Color: black and white
Breed: Husky
Gender: Female
Fixed: Unknown
Age: Baby
Johnston
Lost: 6/1/2016
ID: 3124
Name: Sunny
Type: Cat
Color: Orange
Breed: Husky
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 6/1/2016
ID: 3063
Name: Cotton
Type: Cat
Color: White with gray and brown markings. Black stripped tail
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at home on the corner of 41st and Forest Ave. Cotton has bright blue eyes. He is very friendly and very vocal. He also has a nasal congestive issue which causes him to sneeze frequently.
Stanhope
Lost: 6/1/2016
ID: 3055
Name: Twinkie
Type: Cat
Color: White/orange/brown
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Should answer to Twinkie or Twinkerbell or twinker stinker Inside cat just recently started going outside
Des Moines - East
Lost: 6/1/2016
ID: 3053
Name: Mia
Type: Dog
Color: Black with brown markings. Minpin-chihuahua mix
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Last seen university & 37th street in des Moines east side
Pleasant Hill
Lost: 5/30/2016
ID: 3048
Name: Milo
Type: Cat
Color: Multi dark brown light brown black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Milo is greatly missed he was just rescued from the arl about two months ago my niece is devastated any help would be greatly appreciated
Colfax
Lost: 5/30/2016
ID: 3037
Name: Diesel
Type: Dog
Color: Silver
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Near Valeria, Iowa
Des Moines - South
Lost: 5/30/2016
ID: 3034
Name: Sherman
Type: Dog
Color: Salt and pepper
Breed: Schnauzer Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
Sherman slipped his collar and wanted to check out the neighborhood. He is due for his summer cut and looks much more shaggy than in the pic. He is very friendly and loves to play with everyone.
West Liberty
Lost: 5/29/2016
ID: 3058
Name: Cowgirl
Type: Dog
Color: merle
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Baby
very friendly puppy, very socialized, will get in your vehicle if door was open. A Reward will be offered for her return, no questions asked. she is very missed by her family. she is also being shown in 4-h dog obedience by my 9 year old son.
West Liberty
Lost: 5/29/2016
ID: 3057
Name: cowgirl
Type: Dog
Color: merle
Breed: Australian Shepherd
Gender: Female
Fixed: Unknown
Age: Young
very friendly puppy, will get in your vehicle if door was open. was in 4-h obedience classes with my 9 year old son. has been VERY socialized. a reward will be offered for her return, no questions asked. very missed by my family
Des Moines - South
Lost: 5/29/2016
ID: 3033
Name:
Type: Dog
Color:
Breed: Australian Shepherd
Gender: Female
Fixed: Not Neutered
Age: Adult
has dog licence tag on collar
Des Moines - South
Lost: 5/29/2016
ID: 3032
Name: kissy
Type: Dog
Color: black &white
Breed: Siberian Husky
Gender:
Fixed: Not Neutered
Age: Adult
has dog licence tag on collar
Des Moines - South
Lost: 5/29/2016
ID: 3031
Name: kissy
Type: Dog
Color: black &white
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
has dog licence tag on collar
Polk City
Lost: 5/29/2016
ID: 3030
Name: Diesel
Type: Dog
Color: Black with white stripe on chest
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 5/29/2016
ID: 3024
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
Wandering in South Des Moines, German Shepherd and Border Collier mix dogs. Wasn't able to get close. Border Collier has tags.
Ankeny
Lost: 5/29/2016
ID: 3023
Name: Megan
Type: Dog
Color: Black and white
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Neutered
Age: Senior
2003 SE Clover Ridge Dr, Ankeny. Her home.
Ankeny
Lost: 5/28/2016
ID: 3016
Name: Princess
Type: Cat
Color: Mostly white with grey
Breed: Persian
Gender: Unknown
Fixed: Not Neutered
Age: Young
713 sw Springfield dr Ankeny Iowa 50023
Des Moines - South
Lost: 5/27/2016
ID: 3051
Name: Gizzie
Type: Dog
Color: Brown and tan
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Adult
5