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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 1/17/2016
ID: 2221
Name:
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Young
Very friendly! Lost in north Ankeny late afternoon/early evening.
Des Moines - Central
Lost: 1/16/2016
ID: 2249
Name: Logan
Type: Dog
Color: White
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
E. 38th and Easton
Decorah
Lost: 1/16/2016
ID: 2239
Name: Rosabelle
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Young
At our home near burr oak iowa. Very friendly dog and answers to rosabelle.
Lorimor
Lost: 1/16/2016
ID: 2224
Name: Max
Type: Dog
Color: brown, tan and whit
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in Lorimor Iowa
Runnells
Lost: 1/12/2016
ID: 2217
Name: Cy
Type: Dog
Color: yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen in the Runnells/Pleasant Hill area. East of Yellow Banks Park 2 miles. Has blue collar and possibly red harness.
Waterloo
Lost: 1/10/2016
ID: 2525
Name: Odin
Type: Dog
Color: White and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
I found him
Creston
Lost: 1/10/2016
ID: 2182
Name: Cinderella
Type: Dog
Color: Black
Breed: Shar Pei
Gender: Female
Fixed: Unknown
Age: Adult
Cinder was last seen around the Campground area at the City Park. She is small, around 30 pounds. She is known as a mini in her breed. She is shy and may not come up to people. She may run if approached. Please do not chase her. A little coaxing with food may be helpful. Stauffer's Animal Crackers will Win her over. Shake the bag and you may get her to come to you. Because of no sightings in Crestion after 4:30 pm, she may have headed out into the Open fields. May have found shelter in an open barn or shed.
Clarinda
Lost: 1/8/2016
ID: 2229
Name:
Type: Cat
Color: white and black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
that he is shy and we miss him
Des Moines - East
Lost: 1/5/2016
ID: 2167
Name: Fabi
Type: Dog
Color: tan and white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
English bulldog beagle mix. docked tail. if seen please call or text 515-443-9448
Des Moines - East
Lost: 1/5/2016
ID: 2162
Name: Fabbi
Type: Dog
Color: Tan with white chest
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
She is very skitches and most likely run from new people. Very sweet and don't bark. She has a bobbed tail. Please call 515-443-9448 if you see her or have found her thank you.
Des Moines - East
Lost: 1/5/2016
ID: 2161
Name: Fabi
Type: Dog
Color: tan and white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
Fabi is skittish and nervous around New people. She's a 3 year old beagal English bulldog mix.
Des Moines - East
Lost: 1/5/2016
ID: 2160
Name: Fabi
Type: Dog
Color: Tan and white
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Baby
Fabi is skittish and gets nervous around New people. She has a short tail.She's about 3 years old, she's a beagal English bulldog mix.
Winterset
Lost: 1/3/2016
ID: 2149
Name: peewee
Type: Cat
Color: gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Was seen september 9th in winterset.
Ames
Lost: 1/1/2016
ID: 2284
Name: Ashby (or goes by Kat)
Type: Cat
Color: Black & brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on North Russell (right off of Lincoln way)
West Des Moines
Lost: 1/1/2016
ID: 2152
Name: Mackinnon
Type: Cat
Color: light grey with black tiger stripes; ginger bengal-like tummy, pale grey eyes
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Valley Ridge Place next to field on Grand Avenue and across from Chou's Gym. First time outside. Does have all claws. He IS chipped !!! $100 CASH REWARD for safe return.
Grimes
Lost: 1/1/2016
ID: 2136
Name: snickers
Type: Dog
Color: Grey brown white fluffy snazzier cut
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Baby
Dollar General in Grimes running behind owner. He has a pink coat and tags with his name and a chip in his shoulder
Des Moines - East
Lost: 1/1/2016
ID: 2132
Name:
Type: Dog
Color: Rust
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Young
At Easton Blvd & E. 41st Ct.
Pleasant Hill
Lost: 12/27/2015
ID: 2146
Name: Blackie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Lab/Shepherd mix looks more like a lab. Friendly.
Winterset
Lost: 12/27/2015
ID: 2127
Name: Britt
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Last seen by home north of Winterset with our other lab. Other lab is chocolate female and younger with blue collar
Winterset
Lost: 12/27/2015
ID: 2126
Name: Char
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
She was last seen near her home North of Winterset with our other dog which is missing as well. They usually stick together. Other dog is black lab older female.
Churdan
Lost: 12/26/2015
ID: 2181
Name: Deidre
Type: Dog
Color: Tri-Color Black White Brown
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Senior
When let out to potty at farmhome 8 miles W. of Churdan. Has cateracts both eyes. 95 lbs. Mostly black, no tail, lots of white around neck & chest. Hair is grown out on paws, long nails.
Victor
Lost: 12/26/2015
ID: 2120
Name: Cheerio
Type: Dog
Color: White
Breed: Maltese
Gender: Female
Fixed: Neutered
Age: Adult
Cheerio was last seen on the outskirts of Victor, but she could be anywhere in the area! Her family lives in Ankeny so she is unfamiliar with the area except for visiting. She comes to her name and treats. Very sweet dog.
Des Moines - North
Lost: 12/26/2015
ID: 2110
Name: Mya
Type: Dog
Color: Black and white
Breed: Alaskan Malamute
Gender: Female
Fixed: Neutered
Age: Young
House dog but was on chain outside at 1426 9th Street in Des Moines. Came back and the chain was now clipped to the waterbowl. Suspect theft or "rescue". Please watch for someone trying to sell her or possibly being used as a bait dog?
Des Moines - South
Lost: 12/26/2015
ID: 2103
Name: annabell
Type: Dog
Color: redish brown
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Adult
Trailer parks by earl may next to highway 69
Des Moines - East
Lost: 12/25/2015
ID: 2108
Name: Nessa
Type: Dog
Color: Gray and little white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Baby
Court Ave and Astor ave