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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Indianola
Lost: 7/20/2016
ID: 3520
Name: Hades
Type: Dog
Color: Tan
Breed: Cane Corso Mastiff
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around the dog park in Indianola
Indianola
Lost: 7/20/2016
ID: 3519
Name: Hades
Type: Dog
Color: Tan
Breed: Cane Corso Mastiff
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen by dog park in Indianola
Des Moines - North
Lost: 7/20/2016
ID: 3472
Name: Ash
Type: Dog
Color: Brown - spotted
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Unknown
Age: Adult
jumped my fence, which I had no idea he was capable of. 50th street block between Aurora and Meredith (Merle Hay area). He is an anxious and nervous dog, however he will not bite nor does he bark. I adopted him last October - he's about 4 years old. Super sweet and loving dog, and he's NEVER done anything like this before!
Johnston
Lost: 7/20/2016
ID: 3469
Name: Harley
Type: Cat
Color: Black with white on paws, chest and face
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Adult
Lost on NW 66th Place in Johnston. He is an indoor cat with all claws. Will probably be skittish.
Urbandale
Lost: 7/19/2016
ID: 3464
Name: Pretty
Type: Cat
Color: Multi Colored Orange Black Brown
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
Got Out of Patio Doors at Foxdale Condominiums on 104th & Sutton Drive/ Merideth Drive Area. She is Not an Outdoor Cat and Is Fully Declawed
Mitchellville
Lost: 7/17/2016
ID: 3496
Name: Cupid
Type: Dog
Color: White, tan undercoat
Breed: Great Pyrenees
Gender: Female
Fixed: Unknown
Age: Young
She is very friendly. She is a white pyrenese lab mix. She has her dew claws.
Des Moines - East
Lost: 7/17/2016
ID: 3450
Name: Perseus
Type: Dog
Color: White
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Baby
26th n lyon
Des Moines - Central
Lost: 7/16/2016
ID: 3452
Name: Chewy
Type: Dog
Color: black and brown
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
He got out of my yard. Hes not very active likes to be lazy. Hes is our family dog and he has a dog best friend who misses him dearly.
Winterset
Lost: 7/15/2016
ID: 3501
Name: RJ
Type: Dog
Color: Brown and white
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen running thru alley. RJ has been with me since he was 6 weeks old. He is now 4 years old. If anyone knows who has him, please return him to me. He is very friendly.
Onawa
Lost: 7/15/2016
ID: 3473
Name: Clare
Type: Dog
Color: Black
Breed: Pug
Gender: Female
Fixed: Unknown
Age: Young
Missing from Onawa, IA
Johnston
Lost: 7/14/2016
ID: 3445
Name: Sammie
Type: Cat
Color: Black/Orange/White
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
NW 95th Ct, Johnston
Des Moines - West
Lost: 7/13/2016
ID: 3515
Name: Hope
Type: Dog
Color: White
Breed: Boxer
Gender: Unknown
Fixed: Neutered
Age: Adult
She is very friendly and loves attention. She has a small scar on top of her head from when she was born.
Norwalk
Lost: 7/13/2016
ID: 3427
Name: Tinka
Type: Cat
Color: Brown
Breed: Maine Coon
Gender: Female
Fixed: Unknown
Age: Adult
PLEASE HELP!!!! Our amazing family member ran out the patio door tonight at about 6:15pm. Her name is Tinka, she is 20-25lbs and long haired. She is a Maine Coon and we love her dearly.
Des Moines - South
Lost: 7/13/2016
ID: 3421
Name: Besos
Type: Dog
Color: White
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
At water works park someone pick him up and those of on a bike
Des Moines - South
Lost: 7/13/2016
ID: 3420
Name: Besos
Type: Dog
Color: White
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
At water works park someone pick him up and those of on a bike
Des Moines - Central
Lost: 7/11/2016
ID: 3419
Name: face or bubba
Type: Dog
Color: white now brown red nose
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Baby
He was last seen outside in back yard if u have any treats near call him now ask for a high five if he give u a high five walks sideways with his butt to the left
Indianola
Lost: 7/11/2016
ID: 3413
Name: Suzie
Type: Dog
Color: Brownish
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Lost in indianola. Suzie is very shy
Indianola
Lost: 7/11/2016
ID: 3412
Name: Suzie
Type: Dog
Color: Brownish
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
Last seen in indianola. Suzie is very shy
Winterset
Lost: 7/10/2016
ID: 7439
Name: Blue
Type: Dog
Color: Blue Merle
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Was last seen South of Winterset Iowa
Woodburn
Lost: 7/10/2016
ID: 3407
Name: Zelda and Kiki
Type: Dog
Color: Brown/Red
Breed: GoldenDoodle
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at 8:30pm 7/9/16 Dogs kept outside in kennel in rural Woodburn IA Dogs appear to have been stolen. Zelda is about 45lbs and Kiki is about 25. Both girls are 1 year old. Both had collars with tags on them with my phone number 515-556-0291 Dogs were being kept at grandparents in Woodburn temporarily.
Des Moines - Central
Lost: 7/10/2016
ID: 3404
Name: popcorn
Type: Dog
Color: white
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Young
he's a little white fluffy dog. he is very friendly and love chew toys, if there any info please contact its also a therapy dog..
Underwood
Lost: 7/9/2016
ID: 3394
Name: Ginger
Type: Dog
Color: Red and white
Breed: Siberian Husky
Gender: Female
Fixed: Not Applicable
Age: Baby
Slipped her collar and escaped the fence. She likely ran towards the I-80 interstate in Underwood. She was traveling with her sister, a red husky named Rose.
Underwood
Lost: 7/9/2016
ID: 3393
Name: Rose
Type: Dog
Color: Red, white
Breed: Siberian Husky
Gender: Female
Fixed: Not Applicable
Age: Adult
Escaped the fence and possibly ran towards the I-80 interstate near Underwood, IA. She has one brown/blue eye and is with her sister, a red, long haired husky named Ginger.
Des Moines - North
Lost: 7/8/2016
ID: 3385
Name: Armani
Type: Dog
Color: Grey, Blonde, White
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Very small 3lb dog, only has half of his teeth, 9 years old, very friendly.
Des Moines - East
Lost: 7/8/2016
ID: 3382
Name: Chief
Type: Cat
Color: Black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around Copper Creek in Pleasant Hill/Des Moines area 50317