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>='1560384000')) ORDER BY pm1.meta_value DESC, post_date DESC
Knoxville
Lost: 4/19/2018
ID: 8336
Name: Coconut
Type: Cat
Color: White with black and tan spots
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last seen on Woodland/Stone Drive in Knoxville, IA. Not an outdoor cat usually so might be skittish. I love her more than anything else in the world!
Des Moines - South
Lost: 4/18/2018
ID: 8331
Name: Lady
Type: Dog
Color:
Breed: Alaskan Husky
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 4/17/2018
ID: 8694
Name: Sweety
Type: Cat
Color: White and grey, bright green eyes
Breed: Alaskan Husky
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 4/17/2018
ID: 8693
Name: Sweety
Type: Cat
Color: Grey and white with green eyes
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Young
Cedar Rapids
Lost: 4/17/2018
ID: 8329
Name: Diseal
Type: Dog
Color: Brown
Breed: Pug
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on 18th st SE. Very friendly dog
Victor
Lost: 4/16/2018
ID: 8323
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 kitty 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... ? Please, please help us get our kitty back, call or text (319) 530-6052 if you've seen or heard anything about Boots! THANK YOU SO MUCH!!!
Des Moines - South
Lost: 4/15/2018
ID: 8322
Name: Eddy
Type: Cat
Color: White and gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 4/15/2018
ID: 8318
Name: Izzy
Type: Dog
Color: Brown lab
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
Last seen on wakonda parkway near fluer. Likely traveling with a black lab. Names are champ and izzy.
Des Moines - South
Lost: 4/15/2018
ID: 8317
Name: Champ
Type: Dog
Color: Black lab
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Baby
Last seen on wakonda parkway near fluer. Likely traveling with a brown lab. Names are champ and izzy.
Des Moines - Central
Lost: 4/15/2018
ID: 8314
Name: Zeus
Type: Dog
Color: Brindle
Breed: Mastiff
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - Central
Lost: 4/15/2018
ID: 8313
Name: Mali
Type: Dog
Color: Apricot
Breed: Mastiff English
Gender: Female
Fixed: Not Neutered
Age: Young
Adel
Lost: 4/14/2018
ID: 8307
Name: Lucy
Type: Dog
Color: Golden
Breed: Chihuahua Long Haired
Gender: Female
Fixed: Neutered
Age: Adult
In our yard on Pleasant St. in Adel
Ankeny
Lost: 4/13/2018
ID: 8312
Name: Gigi
Type: Cat
Color: Cream and Brown
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
Gigi is a beautiful Himalayan Siamese mix cat. We are located off SE Delaware near E1st St in Ankeny. She responds to Gigi, and is a very timid but loving 3 year old cat. She is an indoor cat, and very likely will be looking for shelter in someone's garage or under someone's deck while it's storming and snowing. She has a purple collar with a black tag with phone number listed. Please contact 515-554-0124 if she is found or spotted. Thank you.
Des Moines - North
Lost: 4/13/2018
ID: 8304
Name: Lola
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Young
Snuck out of our house in the morning around 8:00 right by hubbell elementary school
Des Moines - South
Lost: 4/13/2018
ID: 8295
Name: Gus
Type: Dog
Color: Black/brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
South Des Moines by Easter Lake.
Ankeny
Lost: 4/12/2018
ID: 8335
Name: Luna
Type: Cat
Color: White/grey
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Senior
Ankeny
Lost: 4/12/2018
ID: 8334
Name: Luna
Type: Cat
Color: White/gray
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Senior
Ankeny
Lost: 4/12/2018
ID: 8333
Name: Luna
Type: Cat
Color: White/gray
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Senior
Estherville
Lost: 4/12/2018
ID: 8299
Name: Spot
Type: Dog
Color: Brindle
Breed: Welsh Corgi Cardigan
Gender: Male
Fixed: Unknown
Age: Young
4 miles south of Estherville near Hwy. 4
Indianola
Lost: 4/12/2018
ID: 8296
Name: Scout/Jade
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Adult
Scout- 11 y/o male, Jade- 3 y/o female. Both friendly, though Jade can be timid.
Des Moines - West
Lost: 4/12/2018
ID: 8289
Name:
Type: Dog
Color: Black and Tan
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Senior
With me
Mason City
Lost: 4/11/2018
ID: 8297
Name: Koko
Type: Dog
Color: Black and white
Breed: Poodle
Gender: Female
Fixed: Neutered
Age: Young
She is very energetic and likes to bark.
Des Moines - East
Lost: 4/11/2018
ID: 8288
Name: Pepperd
Type: Cat
Color: brown tiger stripped with black down his back & tail
Breed: Poodle
Gender: Male
Fixed: Neutered
Age: Adult
brown tabby with a lot of black, has a nick in one ear, very friendly, his name is Peppers
Des Moines - South
Lost: 4/11/2018
ID: 8285
Name: Brooklyn
Type: Dog
Color: Black
Breed: Maltese
Gender: Unknown
Fixed: Unknown
Age: Adult
Lost on southeast side of Des Moines by SE 27th and Pine. She has a white spot on her left front paw and gray whiskers around her face.
Marshalltown
Lost: 4/10/2018
ID: 8300
Name: Trouble, Formerly Akira
Type: Dog
Color: White and Black
Breed: Alaskan Husky
Gender: Female
Fixed: Neutered
Age: Adult
Lost around the fairgrounds. Had been recently added to our family from the ARL. They said she was found as a stray originally.