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
Des Moines - East
Lost: 11/17/2016
ID: 4384
Name: Willow
Type: Dog
Color: tan
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
Was in car accident on Williams and east university and she took off north down Williams
Des Moines - East
Lost: 11/17/2016
ID: 4366
Name: Willow
Type: Dog
Color: tan
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
Was in car accident on Williams and east university and she took off north down Williams
Des Moines - South
Lost: 11/17/2016
ID: 4359
Name: Punkin
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
We believe he ran out when the neighborhood kids were playing and in/out of the house last night. He is very lovey, but scared around many people. He is orange with a black collar that is worn out and has a bell on it. My son was heart broken when he couldn't find him this morning.
West Des Moines
Lost: 11/17/2016
ID: 4357
Name: Tillie
Type: Dog
Color: White and Gray
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Senior
Last seen 11-17 in the evening. Tillie is a small older dog she will be 15 next month. She can't hear every well and hard of seeing. She is scared easily.
Des Moines - South
Lost: 11/15/2016
ID: 4370
Name: Mr. Tippycat aka Tippy or Mr. Tippy depending on his mood
Type: Cat
Color: black, white patch on his chest and the tip of his tail is white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
last seen running out the front door of my house, didn't come back that night like he usually does. he likes to go out and wander around / hunt for small critters.
Boone
Lost: 11/15/2016
ID: 4349
Name: Daisy
Type: Dog
Color: Yellow
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Baby
Daisy was last seen on near the Lost Lake Trailhead at Ledges State Park in Boone. After hiking we came accross people on the trail with another dog and something scared her so she slipped from her collar and ran. She is timid and shy but so sweet, Shes only a baby at 6 months. She was fixed about 3 weeks ago and her surgery scar is still visible. Her family and brother miss her. Please help!
Winterset
Lost: 11/14/2016
ID: 4391
Name: Dodge
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Posting for a friend. Dodge was last seen at his home north of winterset on Highway 169. He's wearing a red color. He's very missed by his family.
Des Moines - West
Lost: 11/14/2016
ID: 3522
Name: Kitty
Type: Cat
Color: Gray/Silver
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Young
2901 Rutland Ave DM, Very friendly, but shy at first. Never been an outside cat. 1 year old. He has a white patch on his stomach
Woodburn
Lost: 11/13/2016
ID: 4508
Name: Teacup
Type: Cat
Color: Russian Blue
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
I let him out at 4 pm on Nov. 13th and he never returned. He has never done that before. Never been out all night. I have searched everywhere for him. He is very sweet and I love him so much and miss him terribly. I have a REWARD out for him. He is declawed in the front.
Des Moines - South
Lost: 11/13/2016
ID: 4339
Name: Oliver / Ollie
Type: Cat
Color: Oarnge/White
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen 11/13/16 afternoon, southside des moines by QT on SE 14th, white front and face and paws
West Des Moines
Lost: 11/13/2016
ID: 4333
Name: Domino
Type: Dog
Color: White
Breed: Collie
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at Wellington Apartment Homes. Has 1 blue eye, 1 brown eye.
Des Moines - South
Lost: 11/12/2016
ID: 4515
Name: Clairabelle
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Senior
Clarabelle was last seen in our back yard at 4419 SE 6th St Des Moines Iowa. She had gotten out of our back yard. She crawled through the fence and lost her collar and tags in doing so. She is a full blooded yellow lab. About 108lbs. She is great with kids even young ones and other animals. She doesn't really bark at all. She's really lovable. She was last seen around the SE. 6th, SE 7th and SE 5th area. If anyone has any information please contact me at 641-203-0169. My children really miss her.
Creston
Lost: 11/12/2016
ID: 4457
Name: Kit (Fatty)
Type: Cat
Color: White with unique black markings
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Senior
REWARD! for his safe return!! Cash - REWARD !!!! STILL MISSING Please HELP! Very special and deeply missed...!! LOST on Saturday11/12/2016 Last seen: Saturday early afternoon November 12th, 2016 on West Fremont street in Creston (Next to: Creston Medicap Pharmacy ). Description: Large build- medium length hair-Mostly White with Black unique markings- sweet personality but will more likely be scared. “Indoor cat only” He is a large male adult (Senior) neutered 12 year old cat. Front paws declawed Please share to help find this special cat. If anyone has taken him in for shelter – NO questions asked – just want him returned home safely. If you have seen him or have him: PLEASE call ASAP Denise @ 641-202-0902. Thank you,
Grimes
Lost: 11/12/2016
ID: 4405
Name: Max
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly cat.
Grimes
Lost: 11/12/2016
ID: 4355
Name: Max
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Green collar with rhinestones and bells. Very friendly. He has 4 BBs in chest area from neighbor shooting him previously.
Cedar Rapids
Lost: 11/11/2016
ID: 4324
Name: Comrade
Type: Cat
Color: Blue Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
314 66th Ave SW Cedar Rapids, IA REWARD IF FOUND Very friendly. Has collar with a tag, but the tag has the wrong phone number. Please call 319-213-8634 if he is found.
Tiffin
Lost: 11/11/2016
ID: 4323
Name: DeVinci
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Cat was lost in Tiffin, got spooked while on a blue leash. He is friendly and up to date on all shots. He also has a dysfunctional tail and you can feel an indent towards the end of his tail. He is microchipped, but registered to the Iowa City animal shelter. I do not have a great picture, but he looks like every other black cat! :)
Des Moines - West
Lost: 11/11/2016
ID: 4317
Name: Silo
Type: Dog
Color: Tan
Breed: Rat Terrier
Gender: Unknown
Fixed: Unknown
Age: Baby
Please help find Silo!! We need her back. Silo got away this afternoon, we are not from around here. She has a loving family with 3 kids who are distraught. Look above for more info. Call 612 387 8602 pleas
Urbandale
Lost: 11/10/2016
ID: 4345
Name: Beans
Type: Bird
Color: Green
Breed: Conure
Gender: Unknown
Fixed: Unknown
Age: Baby
Beans was last seen on 100th st around 8:15pm. He is a green cheek and his wings are clipped.
New Virginia
Lost: 11/10/2016
ID: 4328
Name: Annie Oakley
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Not Neutered
Age: Young
Walking on highway 69 North to Indianola with a woman thin young woman with long brown hair, most likely to be a drifter. She did not have Annie on a leash when they were last saw which is extremely irresponsible!
Des Moines - Central
Lost: 11/10/2016
ID: 4299
Name: Rose
Type: Dog
Color: Brindle /white
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
Rose went missing near woodland cemetery. Very friendly did not have her tags on she got out of house Please call 5154415168 or 702-292-8786 Please help bring my baby home .
Des Moines - Central
Lost: 11/10/2016
ID: 4298
Name: Rose
Type: Dog
Color: Brindle /white
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
Rose went missing near woodland cemetery. Very friendly did not have her tags on she got out of house Please call 5154415168 or 702-292-8786 Please help bring my baby home .
Windsor Heights
Lost: 11/10/2016
ID: 4291
Name: Chubs
Type: Dog
Color: White with brown and black markings
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Adult
Slipped out of his collar so he has no tags...Windsor heights area...very friendly and loves food
Des Moines - West
Lost: 11/9/2016
ID: 4276
Name: Momo
Type: Dog
Color: Black/white
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
West Des Moines area around knolls park. He like kids so probably found at the park.
West Des Moines
Lost: 11/9/2016
ID: 4387
Name: Bugs
Type: Cat
Color: Solid black 3/4 white hairs on his chest
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
Neighbors in bldg 9 (regency woods apartment) seen him on 19th He's skittish of people