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
Urbandale
Lost: 7/26/2017
ID: 6481
Name: Olive
Type: Cat
Color: Gray
Breed:
Gender: Female
Fixed: Neutered
Age: Adult
Olive is an indoor/outdoor cat, around 9-10 years old, weighs about 7 pounds, has all of her claws. She was wearing a pink collar and is microchipped. Very friendly but may be skiddish at first.
Des Moines - West
Lost: 7/26/2017
ID: 6312
Name: Vinny
Type: Cat
Color: Orange and white
Breed: Manx
Gender: Male
Fixed: Neutered
Age: Young
Last seen near douglas and lower beaver
Ames
Lost: 7/26/2017
ID: 6282
Name: Sugar
Type: Cat
Color: Buff and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 7/26/2017
ID: 6281
Name: Thea
Type: Cat
Color: grey tiger tabby
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Adult
last seen 1029 Johnson st. she does or should have a purple heart tag
Des Moines - South
Lost: 7/25/2017
ID: 6306
Name: Betsy
Type: Cat
Color: Dark Brown body light tan around neck long hair Siamese with blue eyes
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Adult
6901 SE 14th St Des Moines, Ia Cat will only come to her owner.
Des Moines - South
Lost: 7/25/2017
ID: 6301
Name: Betsy
Type: Cat
Color: Dark Brown body light tan around neck long hair Siamese with blue eyes
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Baby
6901 SE 14th Street.
St. Charles
Lost: 7/25/2017
ID: 6279
Name: Kobe
Type: Dog
Color: Black (some white on chest and paws)
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Lost black lab, 8 years old name is Kobe, roughly 80-90 pounds. Has black collar and blue collar on. He lives about 2 miles north of St. Charles off 10th Avenue. He could be somewhere between St. Charles and Bevington. Please Contact Ryan Katch at 515-528-6137 or Tyler Hellmann at 515-201-6164. Thanks for sharing and looking!
Des Moines - South
Lost: 7/25/2017
ID: 6274
Name:
Type: Dog
Color: Brown and white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Wondered into friends yard across from south union elementary.
Sioux City
Lost: 7/25/2017
ID: 6267
Name: Paisley
Type: Cat
Color: White/grey
Breed: Siamese
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Des Moines - South
Lost: 7/24/2017
ID: 6341
Name: Joan Jett
Type: Cat
Color: Striped
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 7/24/2017
ID: 6339
Name: Joan Jett
Type: Cat
Color: Striped
Breed: Tabby
Gender: Unknown
Fixed: Neutered
Age: Adult
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