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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 6/8/2016
ID: 3104
Name: Callie
Type: Cat
Color: White,black&orange
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
Callie was last seen Sunday June 5th. It is unlike her to not be around home. We assume she is lost and can't find her way. shw is super sweet and very missed by her family. Please contact with any info 5152022672.
Ankeny
Lost: 6/8/2016
ID: 3103
Name: Callie
Type: Cat
Color: White,black&orange
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
Callie was last seen Sunday June 5th. It is unlike her to not be home...we assume she is lost and can't find her way. She is super sweet and very missed by her family. Any info would be appreciated.
Council Bluffs
Lost: 6/7/2016
ID: 3355
Name: jasmine
Type: Cat
Color: Bio color
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Adult
2o S 41st council Bluffs Iowa . THERE is a 500.00 reward
West Des Moines
Lost: 6/7/2016
ID: 3107
Name: Abbie
Type: Cat
Color: Grey Taby
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
Jumped out my bedroom window in the middle of the night
Council Bluffs
Lost: 6/6/2016
ID: 3354
Name: jasminene
Type: Cat
Color: SealBio color
Breed: Ragdoll
Gender: Female
Fixed: Neutered
Age: Adult
In the apt .thete is a 500.00 reward for her
Des Moines - Central
Lost: 6/5/2016
ID: 3081
Name: Freyja.
Type: Cat
Color: Black/white.
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Freya got out last night, and hasn't been seen since. She normally will stay in the yard, and has never been gone overnight. She is skitish, but very lovey.
Johnston
Lost: 6/5/2016
ID: 3079
Name: Sadie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in Johnston
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