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>='1600560000')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Des Moines - Central
Lost: 7/8/2016
ID: 3378
Name: Sugar
Type: Dog
Color: White
Breed: French Bulldog
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 7/7/2016
ID: 3387
Name: SUGAR
Type: Dog
Color: WHITE "FRENCH BULLDOG"
Breed: French Bulldog
Gender: Female
Fixed: Unknown
Age: Young
THIS IS MY NEIGHBORS DOG.. THERE IS A REWARD - THEIR NUMBER IS 515 201 2631 -LAST SEEN BEAVERDALE, 47TH OVID -- NOT SURE HOW TO GET PICTURES FROM OTHER DEVICE.. I HAVE PICS ON FB - HERE IS LINK https://www.facebook.com/photo.php?fbid=10206927663326164&set=pcb.10206927664526194&type=3&theater OR https://scontent-ord1-1.xx.fbcdn.net/v/t1.0-9/13620913_10206927663526169_6356807938913737823_n.jpg?oh=8e191710c443c167f37aa0cbf008e35b&oe=57F1C6BE
Pleasant Hill
Lost: 7/7/2016
ID: 3366
Name: Dusty
Type: Cat
Color: mixed grey and black medium haired
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
lost early morning today. in Pleasant Hill around the Greenwood Avenue area. he has all claws and is friendly however he is a house cat and never goes outside so this may have disoriented him and he is probably very scared. also call 344-1107. Please help find him. He has been a part of our family for 15 years. He is microchipped. got him at ARL in Des Moines, IA microchip number433B056F44
Ankeny
Lost: 7/7/2016
ID: 3365
Name:
Type: Dog
Color: Golden
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Senior
Des Moines - South
Lost: 7/6/2016
ID: 3361
Name: Denison “Deni”
Type: Dog
Color: black and white
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
He is a lovable one..my sons are devastated please contact us if seen
Ackworth
Lost: 7/5/2016
ID: 3425
Name: Little grey
Type: Cat
Color: Dark grey
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
He's an inside cat that snuck outdoors. He had an injury a few years and is afraid of wind. Very sweet guy, doesn't purr and has a very quiet meow.
Sigourney
Lost: 7/5/2016
ID: 3352
Name: Cooper
Type: Dog
Color: Sable & white
Breed: Shetland Sheepdog Sheltie
Gender: Male
Fixed: Neutered
Age: Adult
Southwest part of town 8am.
Dubuque
Lost: 7/5/2016
ID: 3351
Name:
Type: Dog
Color: blonde and trimmed. Maybe lighter. Dog is dirty.
Breed: Labradoodle
Gender: Male
Fixed: Neutered
Age: Adult
found around Elm and 28th street. Very friendly.
Pleasant Hill
Lost: 7/5/2016
ID: 3346
Name:
Type: Dog
Color:
Breed: Golden Retriever
Gender: Unknown
Fixed: Unknown
Age: Adult
Pleasant Hill police now have the dog.
Des Moines - North
Lost: 7/4/2016
ID: 3380
Name: Annabelle
Type: Dog
Color: Brindle
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in backyard 400 block E Sheridan Ave. Her pinky toenails are black the rest are white. She is very loved and missed, please help find her. She's afraid of fireworks and thunder storms. She is very spoiled, always inside, on furniture and sleeps in our bed.
Des Moines - North
Lost: 7/4/2016
ID: 3379
Name: Annabelle
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in backyard 400 block E Sheridan Ave. Her pinky toenails are black the rest are white. She is very loved and missed, please help find her. She's afraid of fireworks and thunder storms. She is very spoiled, always inside, on furniture and sleeps in our bed.
Des Moines - East
Lost: 7/4/2016
ID: 3377
Name:
Type: Dog
Color: Brow
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Baby
Grimes
Lost: 7/4/2016
ID: 3356
Name: Moo Moo
Type: Cat
Color: Black and White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at Cuttys camp ground in Grimes Iowa
Des Moines - West
Lost: 7/4/2016
ID: 3350
Name: Frogs
Type: Cat
Color: Black and gray
Breed: Tiger
Gender: Female
Fixed: Not Neutered
Age: Young
She has all claws. She was also born with a broken tail so there's a kink at the end!
Des Moines - East
Lost: 7/4/2016
ID: 3342
Name: Lemmy
Type: Dog
Color: Brown, Black, White
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
He was last seen behind my grandmother's fence but must have been extremely scared of the fireworks. He was around E. 13th and Hull ave. He has a blue and grey stripe shirt on that has a blue paw on the collar of his shirt. He's very scared, please bring him home.
Des Moines - East
Lost: 7/4/2016
ID: 3341
Name: Lemmy
Type: Dog
Color: Black, Brown, and White
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
He was last seen behind my grandmother's fence but must have been extremely scared of the fireworks. He was around E. 13th and Hull ave. He has a blue and grey stripe shirt on that has a blue paw on the collar of his shirt. He's very scared, please bring him home.
Des Moines - East
Lost: 7/4/2016
ID: 3340
Name: Duce
Type: Dog
Color: Black and white
Breed: English Setter
Gender: Male
Fixed: Neutered
Age: Adult
By 14th and euclid
Des Moines - South
Lost: 7/4/2016
ID: 3338
Name: Jax
Type: Dog
Color: White
Breed: English Setter
Gender: Male
Fixed: Unknown
Age: Young
He has brown spot on his belly. He is very friendly but shy towards strangers!