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>='1594252800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 7/9/2020
ID: 14460
Name: LUNA
Type: Cat
Color: Brown White Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Luna Is lost near E 38th St Des Moines
Des Moines - North
Lost: 7/9/2020
ID: 14458
Name: Slots
Type: Dog
Color: fawn with black face
Breed: Pug
Gender: Male
Fixed: Neutered
Age: Young
escaped from our back yard
West Des Moines
Lost: 7/8/2020
ID: 14492
Name: Neko
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Young
Huxley
Lost: 7/8/2020
ID: 14453
Name: Lexi
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Young
Picked up by two women in a white car by East 5th Street In Huxley Iowa off HWY 69. She recently gave birth and is still nursing.
Glenwood
Lost: 7/8/2020
ID: 14451
Name: Nallah
Type: Cat
Color: Gray, black, tan
Breed: Tabby
Gender: Female
Fixed: Not Applicable
Age: Young
Our home was broken into early this morning guns were taken. They left our basement door open on way out and Nallah got out. Shes an indoor cat so she's never been outside on her own. We just want her home. We miss her.
Des Moines - West
Lost: 7/8/2020
ID: 14448
Name:
Type: Dog
Color: Black, white, a bit buff
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Baby
He's a runner. We've only had him about a week. Bit the 1st day but not since. He's a rat terrier mixed with chihuahua. Has shots. His name is Panther and he likes to hid.
Urbandale
Lost: 7/8/2020
ID: 14447
Name:
Type: Cat
Color: black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Baby
Pleasant Hill
Lost: 7/7/2020
ID: 14441
Name: Sweetpee
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Adult
She has multiple toes on her front two paws she is long haired she is about 4 years old....plz help me bring my sweetpee home
Pleasant Hill
Lost: 7/7/2020
ID: 14439
Name: Sweetpee
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Female
Fixed: Unknown
Age: Baby
Last I seen my sweet girl was last night when she was laying down with me she is 4 years old she is a polydactyl wich is her has multiple toes on her front two paws she is my baby plz help her get home safe
Dubuque
Lost: 7/7/2020
ID: 14438
Name: Odie
Type: Dog
Color: Black and tan
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Escaped from home on Alpine near University. Wearing a red harness. Very sweet, responds to Odie. No microchip or tag on harness. He's a large German Shepherd with long black and brown hair and a white fluffy rump.
Urbandale
Lost: 7/7/2020
ID: 14437
Name: Mia
Type: Cat
Color:
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Young
In yard
Des Moines - North
Lost: 7/6/2020
ID: 14432
Name:
Type: Dog
Color: Cream
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Unknown
Age: Adult
Elkhart
Lost: 7/6/2020
ID: 14425
Name: Harlow
Type: Dog
Color: Reddish Gold
Breed: Nova Scotia Duck-Tolling Retriever
Gender: Female
Fixed: Not Neutered
Age: Baby
She was last seen in our yard the morning she disappeared. She is an extremely friendly dog that is spooked by loud noises.
Johnston
Lost: 7/5/2020
ID: 14454
Name: Butter
Type: Cat
Color: Grey
Breed: Nova Scotia Duck-Tolling Retriever
Gender: Female
Fixed: Neutered
Age: Young
Very friendly, located in north Johnston
Des Moines - North
Lost: 7/5/2020
ID: 14431
Name: Canela
Type: Dog
Color: Brown
Breed: Mastiff English
Gender: Unknown
Fixed: Unknown
Age: Baby
Des Moines - Central
Lost: 7/4/2020
ID: 14430
Name: Coco
Type: Dog
Color: white and tan
Breed: Chihuahua
Gender: Unknown
Fixed: Not Neutered
Age: Young
Des Moines - West
Lost: 7/4/2020
ID: 14424
Name: Topanga
Type: Cat
Color: White, gray, light brown
Breed: Siamese
Gender: Unknown
Fixed: Not Neutered
Age: Young
Our new kitty, Topanga, got spooked by the fireworks on the 4th of July and escaped. We are South of Grand back by the bike trails. She ran and was by the wooded area, and we are worried she may have wondered too far and got lost. Topanga is half Siamese, half tabby. Please contact us with any info or sightings. Cash reward if reunited!
Cascade
Lost: 7/4/2020
ID: 14420
Name: Duncan
Type: Dog
Color: White and tan
Breed: Cairn Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Duncan lives 1.5 miles east of Cascade on Garyowen Rd. Duncan is very friendly. He is a little deaf. His collar has his name and can act information.
Des Moines - West
Lost: 7/4/2020
ID: 14419
Name: Zellie (Zelda)
Type: Cat
Color: Brownish
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
SHE IS HOME NOW❤️ She is shy and probably won't come up to you. She is microchipped and has a grey Seresto flea collar on. Last seen around 56th Street and College Avenue in Des Moines Iowa
Des Moines - Central
Lost: 7/4/2020
ID: 14418
Name:
Type: Cat
Color: Brownish
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Senior
SHE IS HOME❤️Last seen around 56th Stret and College in Des Moines iowa
La Motte
Lost: 7/4/2020
ID: 14416
Name: Piper
Type: Dog
Color: Tan/White
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Doesn’t know the area at all
Norwalk
Lost: 7/4/2020
ID: 14413
Name: Stella
Type: Dog
Color: Brown Black White
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Sunset and Elm in Norwalk
Malcom
Lost: 7/4/2020
ID: 14412
Name: Bella
Type: Dog
Color: Brown/black
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Hwy 63 malcom iowa Scared of fireworks Skittish
Norwalk
Lost: 7/4/2020
ID: 14411
Name: Stella
Type: Dog
Color: Brown Black White
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Young
Sunset and Elm in Norwalk
Des Moines - North
Lost: 7/4/2020
ID: 14410
Name: Lady B
Type: Dog
Color: Blonde
Breed: Shar Pei
Gender: Unknown
Fixed: Neutered
Age: Adult
She got spooked from fireworks. She is very calm.