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
Des Moines - South
Lost: 4/17/2018
ID: 8694
Name: Sweety
Type: Cat
Color: White and grey, bright green eyes
Breed:
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:
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.
Des Moines - East
Lost: 4/10/2018
ID: 8298
Name: Titan
Type: Cat
Color: Tabby
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Adult
He slipped out the house approximately around 12am. He hasn’t been seen since. We reside by the AE cows. He has all his claws and is not neautured. He is pretty large in size but normal in weight.
Blakesburg
Lost: 4/9/2018
ID: 8311
Name: Paisley
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Adult
Running around with neighbor dogs and our other dogs.