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>='1560384000')) ORDER BY pm1.meta_value DESC, post_date DESC
Truro
Lost: 7/4/2018
ID: 9084
Name: Katie
Type: Dog
Color: Black
Breed: Basset Hound
Gender: Unknown
Fixed: Neutered
Age: Adult
She has a chip but for Tampa Florida area. She now lives in Truro, ia
Des Moines - South
Lost: 7/4/2018
ID: 9070
Name: Myla
Type: Dog
Color: Black & Brown
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Applicable
Age: Young
Myla was last seen south of Des Moines around 50320 area. Visiting family around Easter lake- Avon Cemetary area. We think she was frightened by fireworks and ran off. She is not familiar with that area.
Pleasant Hill
Lost: 7/4/2018
ID: 9067
Name: Ollie
Type: Cat
Color: brown and gray striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
St. Marys
Lost: 7/4/2018
ID: 9062
Name: Ruby
Type: Dog
Color: Reddish/golden
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Young
Last seen east of St.Marys, got scared by the fireworks and took off running west towards St.Marys.
Ankeny
Lost: 7/4/2018
ID: 9060
Name:
Type: Cat
Color: Black, white patch
Breed: Golden Retriever
Gender: Male
Fixed: Unknown
Age: Young
2 black cats
Cambridge
Lost: 7/4/2018
ID: 9040
Name:
Type: Cat
Color: Dark brown withe a mix of tan
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Baby
Last seen in the White Oak Neighborhood
Des Moines - North
Lost: 7/4/2018
ID: 9038
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
“LOST “ dog . Part German Sheperd that answers to the name of CHIEF. He busy through a window because of all the fireworks and is bleeding . Lost in the 1600 block of Hull. He is a friendly dog. If found, please message me ASAP! Thank you 515 669 7100
Des Moines - North
Lost: 7/4/2018
ID: 9037
Name: Cheif
Type: Dog
Color: Brown
Breed: German Shepherd Dog
Gender: Male
Fixed: Neutered
Age: Adult
1600 block hull ave. “LOST “ dog . Part German Sheperd that answers to the name of CHIEF. He busy through a window because of all the fireworks and is bleeding . Lost in the 1600 block of Hull. He is a friendly dog.
Des Moines - North
Lost: 7/4/2018
ID: 9035
Name: Ms Beasley
Type: Cat
Color: Grey, brown, tan
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
We saw her last evening but we had company come over and she usually hides but we have looked all over and have not found her. We think she may have snuck outside when they were going in and out.
Granger
Lost: 7/4/2018
ID: 9031
Name: Baby
Type: Dog
Color: White with brown spots
Breed: Terrier
Gender: Unknown
Fixed: Neutered
Age: Adult
She was spooked by fireworks and was headed towards Jester park
Ames
Lost: 7/4/2018
ID: 9027
Name: Spanky
Type: Dog
Color: White/brown spots
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
West Ames by Mortensen St.
Keokuk
Lost: 7/3/2018
ID: 9483
Name: Lucy
Type: Cat
Color: gray with tiger stripes
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Last seen in Carbide Lane area of Keokuk. She was wearing a purple flea collar. Mostly shy & timid
Cumming
Lost: 7/3/2018
ID: 9056
Name: Whiskers
Type: Cat
Color: Black and brown tabby with white feet
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Baby
We adopted whiskers and his bonded buddy cheeta at the ARL Des Moines in July 2015 He is micro chipped Very very friendly kitty. Very affectionate and Loving He enjoys going outside with cheetah Please call with any info. We are missing whisker so much Thank you
West Des Moines
Lost: 7/3/2018
ID: 9052
Name: Polly
Type: Dog
Color: Balck and White
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Baby
West Des Moines
Lost: 7/3/2018
ID: 9051
Name: Woody
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Baby
West Des Moines
Lost: 7/3/2018
ID: 9050
Name: Sally
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Baby
Mid afternoon, Border Collie pup 12 weeks old.
Bondurant
Lost: 7/3/2018
ID: 9045
Name: Laka
Type: Dog
Color: Brown-white, blue eyes
Breed: Alaskan Husky
Gender: Female
Fixed: Unknown
Age: Young
Last seen running into corn field between Bondurant and Mitchelville near I-80.
Des Moines - South
Lost: 7/3/2018
ID: 9034
Name: Maddy
Type: Cat
Color: Mackrel Tabby, Brown & Black tiger stripe
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
This is Maddy she was heading to the vet on 7/3/18 south side Des Moines (SW 3rd between Watrous & Rose)when the kennel broke open & she got loose. In a panic she ran into the trees/bushes behind the neighbors between SW 2nd off of Watrous and is now missing. Long hair, hates loud noises, scared, very timid and shy, hates to be picked up by people. She will hunker down and not move even if you are standing right next to her. She won't make a sound, but will growl or hiss if you try to pick her up or just run. No collar on & does not have a chip. She does have all of her claws. She is spayed & her belly hangs down alot. Please don't chase her, she will come to me if she can she me. Very skinny, weighs about 7 lbs she is 6 years old.
Bondurant
Lost: 7/3/2018
ID: 9029
Name: Olliver
Type: Dog
Color: Brown black white
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Senior
Dug out from underneath fence between 830-1030 pm.
Bondurant
Lost: 7/3/2018
ID: 9028
Name: Sully
Type: Dog
Color: Golden
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Young
Last seen running from 2nd st (Cemetry rd) through corn field toward high school.
Van Horne
Lost: 7/2/2018
ID: 9075
Name:
Type: Cat
Color: Red Point Siamese
Breed: Siamese
Gender: Male
Fixed: Not Neutered
Age: Young
He never leaves home and is terribly missed. Please call with any information.
Des Moines - East
Lost: 7/2/2018
ID: 9059
Name: Charlie
Type: Cat
Color: White/black&grey stripes
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 7/2/2018
ID: 9025
Name: Rosco
Type: Dog
Color: Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Young
Dog missing last seen at 35st and Clark St His name is Rosco /Chihuahua mix.please if somebody found him please call me at 515 525 2116...or msm..or text 9172845336. Ps my child is missing him so much.. Se extravio mi perro su nombre es Rosco /Chihuahua Mix /.thank you Re
Des Moines - East
Lost: 7/2/2018
ID: 9024
Name: Rosco
Type: Dog
Color: Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Young
Dog missing last seen at 35st and Clark St His name is Rosco /Chihuahua mix.please if somebody found him please call me at 515 525 2116...or msm..or text 9172845336. Ps my child is missing him so much.. Se extravio mi perro su nombre es Rosco /Chihuahua Mix /.thank you Re
Des Moines - East
Lost: 7/2/2018
ID: 9023
Name: Rosco
Type: Dog
Color: Brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Unknown
Age: Young
Dog missing last seen at 35st and Clark St His name is Rosco /Chihuahua mix.please if somebody found him please call me at 515 525 2116...or msm..or text 9172845336. Ps my child is missing him so much.. Se extravio mi perro su nombre es Rosco /Chihuahua Mix /.thank you Re