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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 4/5/2018
ID: 8254
Name: Kitty
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
5th and grand west des moines
Jewell Junction
Lost: 4/4/2018
ID: 8310
Name: John Wayne
Type: Cat
Color: Orange tabby
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Adult
Corner of Blaine and Edwards Street Jewell Ia. May respond to his name. Friendly and playfull. Yellow/gold eyes. Declawed on front paws.
Des Moines - North
Lost: 4/3/2018
ID: 8308
Name: Lynx
Type: Cat
Color: Buff/cream
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen near 4th and Aurora in north Des Moines. He is average size, he may have a small scar on his left eyelid. He could easily be mistaken for an orange tabby, but he is not orange and he has darker tan stripes. He is very affectionate and loves snuggling.
Jewell Junction
Lost: 4/2/2018
ID: 8309
Name: Nib
Type: Cat
Color: Black with very few white hairs on chest
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Senior
Corner of Blaine and Edwards Street in Jewell ia. Declawed all 4 paws. Friendly but shy. Greenish eyes.
Des Moines - North
Lost: 4/2/2018
ID: 8244
Name: Buster
Type: Dog
Color: Brown
Breed: Australian Cattle Dog
Gender: Male
Fixed: Neutered
Age: Young
This morning. He is super friendly and will jump up for kisses. Please call me at 515-991-9018.
Ankeny
Lost: 4/1/2018
ID: 8250
Name: Earl
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He has no front claws. Very sweet.
Waukee
Lost: 4/1/2018
ID: 8245
Name: Teddy
Type: Dog
Color: Off white
Breed: Poodle
Gender: Male
Fixed: Not Neutered
Age: Adult
Very friendly 20 lbs approx. Fuzzy white messy hair schnauzer mix Very loved needs to get home
Sioux Center
Lost: 4/1/2018
ID: 8241
Name: Coqueta
Type: Dog
Color: White with brown spots
Breed: Cockapoo
Gender: Unknown
Fixed: Neutered
Age: Senior
Last seen backyard of our house.
Ankeny
Lost: 4/1/2018
ID: 8239
Name: Quinn
Type: Cat
Color: Calico
Breed: Cockapoo
Gender: Female
Fixed: Neutered
Age: Young
Micro chipped! Very sweet and cuddly female. All claws intact, indoor only kitty. Very worried, slipped out in the foot traffic with family easter. Likely slipped out through deck door not being shut fully.
Ankeny
Lost: 4/1/2018
ID: 8238
Name: Quinn
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen in morning, calico female indoor kitty only. She does have all claws, spayed. Very sweet but likely terrified and shy.
Ames
Lost: 4/1/2018
ID: 8236
Name: Company
Type: Dog
Color: White
Breed: Samoyed
Gender: Male
Fixed: Neutered
Age: Young
Near University Housing in Ames
Ankeny
Lost: 3/31/2018
ID: 8232
Name: Buck
Type: Cat
Color: Brown and whitee
Breed: Ragdoll
Gender: Male
Fixed: Neutered
Age: Young
He is a small cat and usually responds to buck man or buck. He is thin and has a brown and white fur. His eyes are blue.
Altoona
Lost: 3/31/2018
ID: 8229
Name: Chloe
Type: Dog
Color: Fawn
Breed: Pug
Gender: Unknown
Fixed: Neutered
Age: Adult
Lost in Altoona area.
Woodburn
Lost: 3/30/2018
ID: 8234
Name: Pearl
Type: Dog
Color: White With Reddish Tan Accents
Breed: Great Pyrenees
Gender: Female
Fixed: Neutered
Age: Young
Her tummy is shaved from a recent surgery.
Ames
Lost: 3/29/2018
ID: 8218
Name:
Type: Dog
Color: Brown / black
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Tripp Street Ames
Des Moines - East
Lost: 3/29/2018
ID: 8217
Name: Rocky
Type: Dog
Color: Golden Brown
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Young
Before I went to the hospital at 11am. He is very kind and a very good listener. He has beautiful golden brown eyes. Long ears and he is mixed with dashund.
Guernsey
Lost: 3/29/2018
ID: 8216
Name: BOOTS
Type: Cat
Color: Brown tiger with white front toes & white back feet, white patches on chest & tummy
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
We're still missing our big tiger boy! Boots is a large, handsome, friendly cat with a funny high voice, not your average “meow.” He's around five years old and has been neutered & vaccinated since we adopted him 2+ years ago. He's a "farm smart" indoor/outdoor cat and gets along well with other kitties and our dog. He was last seen Sunday, March 18th near B Ave./V-38 & 270th St. south of I-80 Victor exit 205 (western Iowa County). We're heartbroken and want him home safe! There's a chance he went "visiting" so could have been transported out of our area if someone picked him up & took him to a shelter or new home. Thank you very much for your help, please call or text ASAP if you've seen or heard anything about our Boots!
Des Moines - North
Lost: 3/28/2018
ID: 8213
Name: Dakota
Type: Dog
Color: Black and Silver
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen evening of March 28th in the vicinity of 50th and Aurora in Des Moines, by Merle Hay Mall. Please contact me asap 5152900596 He has been found! Thank you!
Dubuque
Lost: 3/27/2018
ID: 8210
Name: Tommy
Type: Cat
Color: brown/black/grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
Our 7 month old kitten, Tommy, got loose last night around 11:30pm around Windsor Ave. We are so upset and scared and just want our little baby Tommy back home. He has recently had surgery to remove a tumor on the left side of his lip. Because of this he has a bit of an "Elvis snarl", as his vet likes to say, and there is a patch of fur missing in that area of his face and his nostrils are a little smushed to the right because of his surgery. He managed to get his collar off when we were trying to catch him, but it slipped of his head. Despite this, he still has his grey flea collar on.
Ankeny
Lost: 3/27/2018
ID: 8209
Name: Norman
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Has a distinctive broken fang and bright white collar. He’s friendly and loves attention. Please bring our beloved furry friend home!
West Des Moines
Lost: 3/27/2018
ID: 8203
Name: Tucker
Type: Dog
Color:
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Young
Approx. 12:30 pm
Ankeny
Lost: 3/26/2018
ID: 6472
Name: Jewel
Type: Cat
Color: Black and tan
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Senior
Jewel is very shy but never aggressive. She has a tan diamond between her shoulder blades.
Cedar Rapids
Lost: 3/25/2018
ID: 8247
Name: Fred
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Fruitland Blvd SW
Cedar Rapids
Lost: 3/25/2018
ID: 8246
Name: Fred
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on SW side of cedar rapids but we have reason to believe he may have been taken by neighbors a dropped off on a farm anywhere.
Ionia
Lost: 3/25/2018
ID: 8227
Name: Jade
Type: Dog
Color: Black and white
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Last seen with her companion Kenzi, Jade is shy around strangers, she has a white muzzle, chest, white markings on her back paws and front left paw, a small white patch between her shoulder blades, left ear stands up, right ear flops over. Missed very much.