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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 2/2/2018
ID: 7904
Name: Viserys
Type: Cat
Color: Black and Grey
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
156th and Meredith
Des Moines - East
Lost: 2/1/2018
ID: 7901
Name: Romeo
Type: Cat
Color: Black long hair
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
By Grandview ave. And e.9th he doesn't meow
Adel
Lost: 2/1/2018
ID: 7899
Name: Addy
Type: Dog
Color: Gray mix of tan and white
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
S. 16 street in Adel (515) 229-1729
Adel
Lost: 2/1/2018
ID: 7898
Name: Addy
Type: Dog
Color: Gray with mix of tan and white
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Young
She was frightened by the wind and somehow got out of our gated yard.
Grinnell
Lost: 1/31/2018
ID: 7900
Name: Luna
Type: Cat
Color: Tortoise shell
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
Very talkative, knows her name, very loving, please bring her home
Ankeny
Lost: 1/31/2018
ID: 7896
Name: Penny
Type: Dog
Color: Black with white front
Breed: Cocker Spaniel
Gender: Male
Fixed: Neutered
Age: Adult
Son took her out to go bathroom but never came back. 605 NE 70th Ankeny
Monroe
Lost: 1/31/2018
ID: 7891
Name: MARIO
Type: Dog
Color: RED
Breed: Cocker Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
MISSING SINCE 12/19. LAST SPOTTED NEAR MONROE SOFTBALL FIELD. HE IS SKITTISH AND MAY NOT COME IF CALLED. PLEASE HELP BRING HIM HOME. HE IS A RED MIN PIN WITH SOME DARK ON HIM. SMALL PATCH WHITE HAIR ON NECK. THANKS. HE IS THE ONE ON THE FAR RIGHT.
Pella
Lost: 1/29/2018
ID: 7888
Name: Oakley
Type: Dog
Color: Liver
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
Young male liver and white English Springer Spaniel. Last seen 5 miles north of Pella near Hwy T14. Shy and skittish, may not approach a stranger. Not chipped. Call if seen or take to Tri County Vet Clinic. 641-780-4963.
Urbandale
Lost: 1/29/2018
ID: 7886
Name: Casper
Type: Cat
Color: Orange and white
Breed: Manx
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 1/28/2018
ID: 7882
Name: Kitty Morales
Type: Cat
Color: Grey and black with white on paws and face
Breed: Manx
Gender: Male
Fixed: Unknown
Age: Young
Over the weekend she somehow got out of the house. She got out of my house at 1707 E Walnut St Des Moines, IA 50316.
Des Moines - South
Lost: 1/28/2018
ID: 7881
Name: Tony
Type: Dog
Color: Black and white tan face markings
Breed: Manx
Gender: Male
Fixed: Not Neutered
Age: Adult
LOST him on se 14th and watrous. His name is Tony. He has no collar on him he got out the fence. Boston terrier x daschund 25lbs very very fast and strong for his size. Very friendly will come to you if you can get his attention. He's black white with tan face markings
West Des Moines
Lost: 1/28/2018
ID: 7878
Name:
Type: Dog
Color: White
Breed: Alaskan Husky
Gender: Male
Fixed: Unknown
Age: Young
Found near Dowling High School.
Des Moines - South
Lost: 1/27/2018
ID: 7945
Name: JUNIPER
Type: Cat
Color: Calico tabby short hair
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Young
2825 S.E. 14 TH & Glenwood s.s. Des Moines. We feel she was taken because she always comes home. Has a loud meow. Red collar with bell on it. We miss you Just.
Des Moines - East
Lost: 1/27/2018
ID: 7872
Name: Daisy
Type: Dog
Color: Black, white, gray
Breed: Terrier
Gender: Female
Fixed: Unknown
Age: Young
Area of E. 46th and Hubbell Avenue by Delaware Elementary. Please text/call and I can come pick her up. Thank you!
West Des Moines
Lost: 1/26/2018
ID: 7870
Name: Unknown
Type: Cat
Color: White and gray
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Found in the area of 88th and Westown Parkway
Ankeny
Lost: 1/26/2018
ID: 7866
Name: Buddy
Type: Dog
Color: Brown black white mix
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
NE Greenview Dr
Des Moines - South
Lost: 1/25/2018
ID: 7865
Name: Juniper
Type: Cat
Color: Calico
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - West
Lost: 1/25/2018
ID: 7864
Name: Thorin
Type: Cat
Color: Brown, black, gold, white around face
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He has a cropped tail and went missing around 12pm. He is very sweet and loves ear rubs. He rarely goes outside so no collar, but he is very much loved and missed.
Center Point
Lost: 1/25/2018
ID: 7863
Name: Bentley and Paisley
Type: Dog
Color: White
Breed: GoldenDoodle
Gender: Male
Fixed: Not Neutered
Age: Young
Both Bentley and paisley are missing and were last seen in the yard at 7:15 this morning.
Des Moines - East
Lost: 1/24/2018
ID: 7917
Name: Thor
Type: Cat
Color: Grey and strips
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He is a lover, scared at first. Still has claws.
Brooklyn
Lost: 1/24/2018
ID: 7853
Name: Unknown
Type: Dog
Color:
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Found Pitbull possible mix. Found in brooklyn along interstate 80. No microchip. Vet is thinking possibly two years old.
Des Moines - South
Lost: 1/24/2018
ID: 7852
Name: Gnarly (NarNar)
Type: Dog
Color: White and black
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
Riverwoods neighborhood
Hawarden
Lost: 1/23/2018
ID: 7858
Name: Chance
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Senior
Lamoni
Lost: 1/23/2018
ID: 7846
Name: Ace
Type: Dog
Color: Red
Breed: Australian Cattle Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Broke through a window and ran away he is mixed with a lab so he is bigger than normal heeler.
Lamoni
Lost: 1/23/2018
ID: 7843
Name: Ace
Type: Dog
Color: Red/White
Breed: Cattle Dog
Gender: Male
Fixed: Not Neutered
Age: Young