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
Pleasant Hill
Lost: 7/29/2017
ID: 6330
Name: Layah
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen in copper creek
Carlisle
Lost: 7/28/2017
ID: 6439
Name: Phoenix
Type: Cat
Color: Black/Gray tabby with white patches
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Corner of Elm and 1st St in Carlisle
Perry
Lost: 7/27/2017
ID: 6645
Name: Navy
Type: Dog
Color: Brindle
Breed: Pit Bull Terrier
Gender: Male
Fixed: Neutered
Age: Young
Park street and houston avenue west of Perry at my house. Very gentle loving dog, a little shy at first, but love people.
Milo
Lost: 7/27/2017
ID: 6333
Name: Warrant
Type: Dog
Color: Brindle
Breed: Greyhound
Gender: Male
Fixed: Neutered
Age: Adult
Last seen heading west in Milo past the school.
Perry
Lost: 7/27/2017
ID: 6321
Name: Lucy
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
Female cat named Lucy , about 2 years old . She wasn't wearing a collar when she went missing, she went missing Yesterday night Thursday July 27 . She's friendly but can be scared of strangers. Call or text anytime if seen or know where she can be . We miss her so much!!!!! 515-726-0747
Indianola
Lost: 7/27/2017
ID: 6315
Name: oscar
Type: Dog
Color: red and white
Breed: Basenji
Gender: Male
Fixed: Neutered
Age: Senior
He is blind and needed immediate medical attention for diabetic.
Des Moines - South
Lost: 7/27/2017
ID: 6303
Name:
Type: Dog
Color: Brown, tan spots
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen
Des Moines - Central
Lost: 7/27/2017
ID: 6302
Name: Max
Type: Dog
Color: Brown and black
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
Got off his harness after bath. Heart shape on face of lighter color then the rest of body and a floppy ear when upright.
Urbandale
Lost: 7/26/2017
ID: 6481
Name: Olive
Type: Cat
Color: Gray
Breed: Mix
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.