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>='1454716800')) ORDER BY pm1.meta_value DESC, post_date DESC
Knoxville
Lost: 2/11/2016
ID: 2330
Name: Jager
Type: Dog
Color: Brindle and white
Breed: English Bulldog
Gender: Male
Fixed: Unknown
Age: Young
Traveling with a black lab named Robbie who is also missing
Hiawatha
Lost: 2/10/2016
ID: 2328
Name: Tig
Type: Dog
Color: White
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Baby
White boxer w/ blue eyes. Microchipped, came loose from his color. Will answer to Tig or Tiggy. Lost near Cedar Run Boarding in Hiawatha at 6:30 pm
Des Moines - East
Lost: 2/10/2016
ID:
Name: Fluffy
Type: Dog
Color: White /apricot
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Senior
Fluffy was last seen around 1030/1100 am on Brook Run Drive on the east side.He was wearing a teashirt that had studs on it that said bling ,bling.He is a senior dog.Very sweet and likes to cuddle.He is an inside dog and not use to the cold.Please if you see him please give me a call.Hes my running buddy.Thanks!
Des Moines - East
Lost: 2/10/2016
ID: 2327
Name: Fluffy
Type: Dog
Color: White /apricot
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Senior
Fluffy was last seen around 1030/1100 am on Brook Run Drive on the east side.He was wearing a teashirt that had studs on it that said bling ,bling.He is a senior dog.Very sweet and likes to cuddle.He is an inside dog and not use to the cold.Please if you see him please give me a call.Hes my running buddy.Thanks!
Des Moines - East
Lost: 2/10/2016
ID: 2324
Name: Fluffy
Type: Dog
Color: White and some apricot
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Baby
He was wearing a black teashirtthat said bling,bling.He is a little skittish ,but a very friendly dog.He was lost on the east side Village Run area.
West Des Moines
Lost: 2/10/2016
ID: 2321
Name: Archie
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Cherrywood Dr and 50th Street area of west des moines.
Des Moines - Central
Lost: 2/9/2016
ID: 2317
Name: Jack
Type: Dog
Color: Mostly white with brown spots
Breed: Italian Greyhound
Gender: Male
Fixed: Unknown
Age: Young
Last seen near Plymouth Place senior housing just off 42nd and Ingersoll. Running east. He's usually on a leash so, may run into traffic!
Des Moines - Central
Lost: 2/9/2016
ID: 2316
Name: Jack
Type: Dog
Color: Mostly white with brown spots
Breed: Italian Greyhound
Gender: Male
Fixed: Unknown
Age: Baby
Last seen running east just off of 42nd & Ingersoll. Always on a leash so, not used to being free and may run into traffic.
Martensdale
Lost: 2/8/2016
ID: 2320
Name: Anakin
Type: Dog
Color: black and tan
Breed: Italian Greyhound
Gender: Male
Fixed: Not Neutered
Age: Adult
White spot on his chest, ears aren't docked, arthritis in his leg, still has his duclaws, and he belongs to my brother whom is half blind
Des Moines - North
Lost: 2/7/2016
ID: 2322
Name: Finn
Type: Cat
Color: orange tabby
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Sunday afternoon at home in Beaverdale/Drake neighborhood.