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>='1571184000')) ORDER BY pm1.meta_value DESC, post_date DESC
Clive
Lost: 7/29/2017
ID: 6357
Name: Leo
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He must've snuck out when we came in the door. He is front declawed and we are very worried. Our whole family LOVES Leo and he isn't used to roaming free outside.
Clive
Lost: 7/29/2017
ID: 6345
Name: Leo
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is declawed on the front and isn't used to exploring.:(
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.