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>='1571356800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 5/29/2017
ID: 5730
Name: Max
Type: Dog
Color: Brown
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on East 27th court at home
Des Moines - East
Lost: 5/29/2017
ID: 5712
Name: Bengi
Type: Dog
Color: Buff
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
Lost at E9th and Douglas headed toward E 8th Street
Des Moines - East
Lost: 5/29/2017
ID: 5711
Name: Bengi
Type: Dog
Color: Buff
Breed: Rat Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
Lost at E9th and Douglas headed toward E 8th Street
Des Moines - South
Lost: 5/28/2017
ID: 5925
Name: Odin
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 5/28/2017
ID: 5717
Name: kali
Type: Cat
Color: grey tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
7100 block of ne 14th st (south of ankeny)
Polk City
Lost: 5/28/2017
ID: 5706
Name: Blackie
Type: Dog
Color: White
Breed: Bichon Frise
Gender: Male
Fixed: Neutered
Age: Senior
15+ years old. Mostly deaf. Very bow legged.
Altoona
Lost: 5/28/2017
ID: 5704
Name: Max
Type: Dog
Color: Dark Brown with Black markings. He is a wirehair doxie mix, but has long legs, not short
Breed: Dachshund Standard
Gender: Male
Fixed: Neutered
Age: Adult
Max will come to you if you coax him. He is a lover not a fighter. Won't bite.
Des Moines - South
Lost: 5/27/2017
ID: 5860
Name: Odin
Type: Dog
Color: Black and white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Storm Lake
Lost: 5/25/2017
ID: 5746
Name: Mango
Type: Bird
Color: Yellow with neon green
Breed: Budgie/Budgerigar
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen in Lakeside on a tree. I am still looking for him and will not lose hope. If anyone has seen my budgie please contact me. :,(
Storm Lake
Lost: 5/25/2017
ID: 5745
Name: Mango
Type: Bird
Color: Yellow with a green/neon green.
Breed: Parakeet
Gender: Unknown
Fixed: Unknown
Age: Young
Last seen around lake side in Birch Street. Really heart broken and I'm still looking for it. Not losing hope. If someone has seen or know of this bird please contact me :(
Des Moines - East
Lost: 5/24/2017
ID: 5750
Name: Odie
Type: Cat
Color: tan/orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He was at my house, got out the front door.
Des Moines - East
Lost: 5/24/2017
ID: 5707
Name: Crow
Type: Cat
Color: Black
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on May 24, 2017 Small white spot on chest Also called "Kit Cat"
Des Moines - South
Lost: 5/24/2017
ID: 5682
Name: Pepper
Type: Dog
Color: White/Black/Brown
Breed: Rat Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Southwestern Hills neighborhood on SW 26th is where she escaped, last seen 5/26/17 at 6am near McKinley & Wakonda Pkwy
Pleasantville
Lost: 5/23/2017
ID: 5748
Name: Smalls
Type: Dog
Color: Wheaton
Breed: Irish Wolfhound
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 5/23/2017
ID: 5677
Name: Chico
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Senior
Lost around SE 14th and King
Fort Dodge
Lost: 5/23/2017
ID: 5663
Name: Charlotte
Type: Dog
Color: White and brown ears
Breed: Cockapoo
Gender: Female
Fixed: Not Neutered
Age: Baby
Last seen on south side. Doesn't have collar on
Des Moines - North
Lost: 5/22/2017
ID: 5655
Name: harley
Type: Dog
Color: white with tan spots
Breed: Shih Tzu
Gender: Female
Fixed: Not Neutered
Age: Adult
Possibly looking for my father who is deceased. Answers to Harley Warley woo. Very friendly
Des Moines - North
Lost: 5/22/2017
ID: 5654
Name: harley
Type: Dog
Color: white with few tan spots
Breed: Shih Tzu
Gender: Female
Fixed: Not Neutered
Age: Adult
minds well when told something . my son got him when his dad passed in jan. she has been lonesome for him and may have been looking for him.she also has cancer and was getting ready for surgery.Last seen around e. 14th and Guthrie 50316
What Cheer
Lost: 5/21/2017
ID: 5991
Name: Rosta
Type: Dog
Color: Dark Brindle and white on chest
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Young
Last seen west side of What Cheer at Skunk river bridge on Lacy rd
Des Moines - West
Lost: 5/21/2017
ID: 5649
Name: Kia
Type: Dog
Color: Tan
Breed: Husky
Gender: Female
Fixed: Neutered
Age: Senior
Des Moines - West
Lost: 5/21/2017
ID: 5645
Name: Sampson
Type: Dog
Color: Black and white
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Near Merle hay south neighborhood near glenwood cemetery
Des Moines - East
Lost: 5/20/2017
ID: 5650
Name: Company
Type: Dog
Color: White
Breed: Samoyed
Gender: Male
Fixed: Not Neutered
Age: Young
around Easton and Searle
Adel
Lost: 5/20/2017
ID: 5643
Name: Max
Type: Dog
Color: Brown/tan with black nose/ears
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - Central
Lost: 5/20/2017
ID: 5640
Name: Stellan
Type: Cat
Color: Grey tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
He goes outside regularly but doesn't usually stray far. Concerned he may be in someone's garage or trapped somewhere around Bowdoin Columbia Amherst area south of Euclid.
Des Moines - East
Lost: 5/20/2017
ID: 5634
Name: Stellan
Type: Cat
Color: Grey tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
He goes outside regularly but doesn't usually stray far, concerned he may be in someone's garage or trapped somewhere. He usually hangs around Bowdoin, Amherst, Columbia south of euclid