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
Des Moines - South
Lost: 10/24/2017
ID: 7209
Name: Smokey
Type: Dog
Color: White/grey
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Baby
In our fenced yard on se 19thst
Des Moines - Central
Lost: 10/23/2017
ID: 8019
Name: Louie
Type: Dog
Color: Black and white
Breed: Staffordshire Bull Terrier
Gender: Male
Fixed: Unknown
Age: Adult
Very will minded dog not sure where he could be someone said he was spotted,in orient not,much detail though :(
Altoona
Lost: 10/23/2017
ID: 7282
Name: Simba
Type: Cat
Color: Yellow tabby
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Adult
Indianola
Lost: 10/23/2017
ID: 7248
Name: Midnight
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 105 104 East Clinton Ave., Indianola, IA He is very shy, may not come to you.
Des Moines - East
Lost: 10/23/2017
ID: 7202
Name: Jennifer
Type: Dog
Color: Black and white
Breed: Fox Terrier
Gender: Female
Fixed: Neutered
Age: Senior
Last seen 2900 block of Easton Deaf and blind 5158678128
Des Moines - East
Lost: 10/23/2017
ID: 7199
Name: Jennicer
Type: Dog
Color: Black and white
Breed: Fox Terrier
Gender: Female
Fixed: Neutered
Age: Senior
Deaf, blind Last seen 2900 block of easton
Des Moines - South
Lost: 10/22/2017
ID: 7250
Name: SYLVEE
Type: Cat
Color: Black/white
Breed: Fox Terrier
Gender: Female
Fixed: Not Applicable
Age: Adult
Se 5th/Watrous
Des Moines - East
Lost: 10/22/2017
ID: 7240
Name: Prince
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
White on chest wanders to name eyes turn yellow when mad
Des Moines - East
Lost: 10/22/2017
ID: 7239
Name: Prince
Type: Cat
Color: Orange
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
White on chest wanders to name eyes turn yellow when mad
Ames
Lost: 10/22/2017
ID: 7190
Name: Sydney
Type: Dog
Color: Fawn
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Young
missing fawn boxer, Sidney. Llive west of Gilbert on X Ave. The tag on her collar says Josh Sills. She's been missing since this morning at 9am.
Huxley
Lost: 10/22/2017
ID: 7189
Name: Bruce
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Broke through the window screen this morning. Bruce is very energetic, curious, and friendly. He has a snaggletooth is a little smaller than other cats his age.
Des Moines - East
Lost: 10/21/2017
ID: 7194
Name: Borris
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
He ran off from our back door into some woods near the Lower Beaverdale area of Des Moines
Johnston
Lost: 10/21/2017
ID: 7174
Name: Char
Type: Dog
Color: White
Breed: West Highland White Terrier Westie
Gender: Female
Fixed: Neutered
Age: Senior
She is deaf and blind, all white with hair closely cut. One eye is removed and shut. Older dog, but our family treasure. We are devastated. She wondered out of our backyard in green meadows west in Johnston, iowa
Des Moines - East
Lost: 10/21/2017
ID: 7169
Name: Rizzo
Type: Dog
Color: Sable/White
Breed: Alaskan Malamute
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near E. 29th and E. Euclid Ave
Des Moines - East
Lost: 10/20/2017
ID: 7362
Name: Lil Bit
Type: Cat
Color: Black with white markings on belly
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 10/20/2017
ID: 7176
Name: Lil Bit
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Shellsburg
Lost: 10/20/2017
ID: 7162
Name: Molly
Type: Dog
Color: Black
Breed: Pomeranian
Gender: Female
Fixed: Neutered
Age: Young
She pulled the stake out of the ground that she was hooked up to. She now is pulling around her chain and stake. I'm afraid she might be caught up on something. We live in the country and have looked on our 8 acres and can't find her. We live outside Shellsburg on County Home road.
Polk City
Lost: 10/20/2017
ID: 7155
Name: Tucker
Type: Dog
Color: Black
Breed: Cockapoo
Gender: Male
Fixed: Neutered
Age: Baby
Lost by saylorville lake around 8 pm
Clarinda
Lost: 10/19/2017
ID: 7215
Name: Lola
Type: Dog
Color: Black
Breed: Pomeranian
Gender: Female
Fixed: Neutered
Age: Adult
She escaped from the yard around 930am. She’ll have longer hair than shown in the pic. Loves to chase squirrels and rabbits. GREATLY missed and needs to come home.
Des Moines - East
Lost: 10/19/2017
ID: 7161
Name: Lucky
Type: Cat
Color: Cream and Blue
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
NE 44th Drive
Ankeny
Lost: 10/18/2017
ID: 7350
Name: Mugsy
Type: Cat
Color: Tan/buff and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
It's been a few weeks, so he could have traveled quite a distance! But he was last seen in Ankeny by 8th and Lowell (which is off Delaware close to 1st St).
Des Moines - South
Lost: 10/18/2017
ID: 7309
Name: Mittens
Type: Cat
Color: Grey Tiger
Breed: Siberian
Gender: Male
Fixed: Neutered
Age: Young
Near Frazier avenue. Long hair coat.
Ankeny
Lost: 10/18/2017
ID: 7307
Name: Mugsy
Type: Cat
Color: Buff/tan and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Got out near 8th and Lowell/Michael (off Delaware by 1st). Sweet boy but a bit skittish. Would probably come if you called his name.
Ankeny
Lost: 10/18/2017
ID: 7213
Name: Mugsy
Type: Cat
Color: Buff/tan and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near 8th and Lowell (1st and Delaware area of Ankeny)
Ankeny
Lost: 10/18/2017
ID: 7177
Name: Mugsy
Type: Cat
Color: Buff/white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
5th and Michael in Ankeny (1st and Delaware area.