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>='1523750400')) ORDER BY pm1.meta_value DESC, post_date DESC
Sidney
Lost: 4/20/2018
ID: 8343
Name: Sheila
Type: Dog
Color: Tri-color
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Neutered
Age: Adult
Last seen in Nebraska City corner of HWY 2 and ivy road. Sheila was picked up by a Black SUV or HUMV with a flag and or skull and crossbones logo on the side. There was luggage on top of their car, they are traveling and may be in central Iowa now. PLEASE let me know if you have any information!!!
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
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
Des Moines - East
Lost: 4/17/2018
ID: 8327
Name: Fiona
Type: Cat
Color: Gray
Breed: Persian
Gender: Female
Fixed: Not Applicable
Age: Young
kitten last seen on e 37th St between the corners of Sheridan and Easton Blvd. She is all gray with a small tan stripe through her fur, one tan paw and bright blue eyes. Very furry. She is my everything please alert asap if you see her
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