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>='1555632000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 7/24/2017
ID: 6265
Name: Pepe
Type: Dog
Color: Brown
Breed: Pomeranian
Gender: Male
Fixed: Neutered
Age: Adult
10:30 lally st
Ankeny
Lost: 7/23/2017
ID: 6308
Name: Tiny
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Tiny is black kitten approximately 5-6 months last seen outside residence near Saylorville Lake at 35th or Hwy 415 and 80th Lane, Ankeny catching bugs.
Ankeny
Lost: 7/23/2017
ID: 6307
Name: Tiny
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
Tiny is black kitten approximately 5-6 months last seen outside residence near Saylorville Lake at 35th or Hwy 415 and 80th Lane , Ankeny catching bugs.
Grinnell
Lost: 7/23/2017
ID: 6270
Name: Willow
Type: Cat
Color: White with peach colored nose and ears
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Sweet, but shy when approached. Approx. one year old.
West Des Moines
Lost: 7/23/2017
ID: 6260
Name: Oxford
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Around the area of Woodland and 50th street. Across from Crossroads Elementary. He is an inside cat, very timid and fast. We miss him!!
Des Moines - South
Lost: 7/23/2017
ID: 6256
Name: Skip
Type: Dog
Color: Black and white
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Our Boston Terrier ran off from our SW side home early this afternoon. Our mobile is 515-867-668. Thank you.
Johnston
Lost: 7/22/2017
ID: 6296
Name: Autumn
Type: Cat
Color: Orange
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Outdoor cat, haven't seen her in awhile, can be friendly but can also not be friendly, growls when upset, fast
Johnston
Lost: 7/22/2017
ID: 6295
Name: Autumn
Type: Cat
Color: Orange
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Baby
Travels far distances, fast, growls sometimes if not happy, sometimes can be friendly
Johnston
Lost: 7/22/2017
ID: 6294
Name: Autumn
Type: Cat
Color: Orange
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Baby
Travels far distances, fast, growls sometimes if not happy, sometimes can be friendly
Johnston
Lost: 7/22/2017
ID: 6293
Name: Autumn
Type: Cat
Color: Orange
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Baby
Travels far distances, fast, growls sometimes if not happy, sometimes can be friendly
Mount Pleasant
Lost: 7/21/2017
ID: 6320
Name: Mack
Type: Dog
Color: White with a gray bergandy
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Adult
Please help me find him!
Des Moines - North
Lost: 7/21/2017
ID: 6266
Name: Callie
Type: Cat
Color: Blonde/multi
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Adult
Someone was house sitting and when we came back she was missing. She's friendly and we want her back. Hoover high school area was where she was last seen
Des Moines - South
Lost: 7/21/2017
ID: 6263
Name: Turd Ferguson
Type: Cat
Color: Gray
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen near SE 4th CT and Park Ave
Mingo
Lost: 7/21/2017
ID: 6247
Name: Bubba
Type: Cat
Color: Seal point mix
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Baby
210 Davenport St Mingo
Cedar Rapids
Lost: 7/20/2017
ID: 6239
Name: Olivia
Type: Cat
Color: Gray
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Adult
We last saw her in that house around 4:30pm-5:00pm
Stuart
Lost: 7/19/2017
ID: 6250
Name: Joe
Type: Cat
Color: Gray
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 7/19/2017
ID: 6236
Name: Totsie
Type: Cat
Color: Brown , black, gray
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
We live in apartments, probably ran out because screen is broken on patio door and I was on the patio sweeping
Woodbine
Lost: 7/17/2017
ID: 6280
Name: Kota
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Very nice
Des Moines - East
Lost: 7/17/2017
ID: 6238
Name: Marly
Type: Dog
Color: Black/white/grey mix
Breed: Pomeranian
Gender: Female
Fixed: Not Neutered
Age: Adult
I live at 21st and Capitol in East Des Moines. I was leaving my home and didn't realized she was behind me, she took off out the door after a rabbit.
Cedar Rapids
Lost: 7/16/2017
ID: 6258
Name: Bella
Type: Cat
Color: Multi color long hair
Breed: Norwegian Forest Cat
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen on 31st street near bever park SE side of cedar rapids. She is very friendly and loves to be held. Answers to the name Bella or Isabella. She may not have a collar on.
Ankeny
Lost: 7/16/2017
ID: 6219
Name:
Type: Dog
Color: White
Breed: Boxer
Gender: Female
Fixed: Unknown
Age: Young
She is super hot and with no where cool to keep her we are taking her to ARL MAIN @2:30pm
Adel
Lost: 7/15/2017
ID: 6237
Name: Jordy
Type: Dog
Color: Gold/yellow
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - West
Lost: 7/14/2017
ID: 6226
Name: Steve
Type: Cat
Color: Tan and Brown Siamese
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Steve was last seen on 7/14 at 9 pm. The tip of one of his ears is missing. We live one block east of Beaver Ave and 1 1/2 block North of Hickman Ave so right in the heart of Beaverdale. He loves us his family completely, but he is wary of strangers. He will warm up to you. He loves canned cat food and usually comes running when we snap the can open. If you see him please feel free to call my cell phone: 515-490-5717. He befriended us as a stray 8 years ago and he has never stopped saying thank you to us. Best cat I have ever owned. Thank you to everyone who looks.
Des Moines - North
Lost: 7/14/2017
ID: 6223
Name: Steve
Type: Cat
Color: Siamese: tan/brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Steve is a Siamese with the tip of one ear missing. He was last seen at 9 pm on 7/14. I live in the Beaverdale area of Des Moines.
Des Moines - South
Lost: 7/14/2017
ID: 6215
Name: Wade
Type: Dog
Color: Brown with black stripe on back
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Young
By evergreen apartments