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>='1565827200')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 1/10/2018
ID: 7782
Name: Ziggy
Type: Dog
Color: Tan/White
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
He has a bowtie on. Last at home on SE SHARON DR in Ankeny IA
Lamoni
Lost: 1/9/2018
ID: 7789
Name: Maya
Type: Dog
Color: Brown and white
Breed: Saint Bernard
Gender: Female
Fixed: Not Neutered
Age: Young
She also responds to ‘Doof’.
Pleasantville
Lost: 1/9/2018
ID: 7778
Name: Jericho
Type: Dog
Color: Gray/white
Breed: Siberian Husky
Gender: Male
Fixed: Unknown
Age: Young
This is my nephew and niece’s boy...he took off with his sister yesterday, she returned home, he has not...they’ve been out searching for him..if you spot him or are taking care of him, please let us know. They’re very worried and missing him.
Hartford
Lost: 1/8/2018
ID: 7779
Name: Canopy
Type: Cat
Color: Orange tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
Canopy was last seen Monday at approx 5 pm. He got out as his family was leaving. He is a very sweet kitty. He was newly adopted and likely does not know his way back to his new home and is probably scared. If you find him he is chipped, his chip #is 98200041173667. If found please contact his owner Nick at 417-699-2721.
Dows
Lost: 1/6/2018
ID: 7790
Name: Diesel
Type: Dog
Color: Black & tan
Breed: Rottweiler
Gender: Male
Fixed: Not Neutered
Age: Young
By coop bins in Dows, his sister came back but not him
Des Moines - North
Lost: 1/6/2018
ID: 7759
Name: Brisoil
Type: Dog
Color: All white
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen Friday She is shy but very friendly
West Des Moines
Lost: 1/5/2018
ID: 7758
Name: Henry
Type: Cat
Color: White and orange on ears and tail
Breed: Turkish Van
Gender: Female
Fixed: Neutered
Age: Young
She is very shy and timid but if you crouch down and put your hand out she might come to you and smell you. Very small for a grown cat. Has orange markings on her ears, a spot in the back of her head, and has a striped tail.
Des Moines - South
Lost: 1/5/2018
ID: 7754
Name: Trapper
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Our dog Trapper got out of our fence today when he was let out to the bathroom. Please call if you find him! He is my sons dog and he will be crushed if we can't find his sleeping buddy :( Trapper is a very gentle dog that loves everyone so he will come if you call him.
Des Moines - East
Lost: 1/3/2018
ID: 7757
Name: Zeus
Type: Dog
Color: Ligth brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen between the Easton BLV and the 24th street.
Des Moines - East
Lost: 1/3/2018
ID: 7756
Name: Zeus
Type: Dog
Color: Ligth brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen between the Easton BLV ave and the 24th street.
Des Moines - East
Lost: 1/2/2018
ID: 7764
Name: Kimbo
Type: Dog
Color: Black with some gray around mouth
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
By 29th and East Euclid
Des Moines - Central
Lost: 1/2/2018
ID: 7762
Name: Luna
Type: Dog
Color: Red & white
Breed: English Bulldog
Gender: Female
Fixed: Unknown
Age: Baby
Des Moines - East
Lost: 1/2/2018
ID: 7748
Name: Bear
Type: Dog
Color: Black
Breed: English Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
E 36th st and Dubuque
Grimes
Lost: 1/1/2018
ID: 7830
Name: test
Type: Rabbit
Color: test
Breed: American
Gender: Male
Fixed: Unknown
Age: Baby
this is just a test.
Des Moines - Central
Lost: 12/31/2017
ID: 7745
Name: Epic
Type: Cat
Color: Medium gray
Breed: American Shorthair
Gender: Female
Fixed: Not Applicable
Age: Adult
5th ave and indianna
Des Moines - North
Lost: 12/30/2017
ID: 7948
Name: Zues
Type: Cat
Color: Tri colored
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Not declawed. Very very nice. He has a cricked back from an accident when he was younger. Hes my sons cat just want him home safe.
Adair
Lost: 12/29/2017
ID: 8648
Name: Hope
Type: Dog
Color: Red Lab
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Lost along I-80 East of Adair near the rest stop. Very personable well trained dog.
Des Moines - South
Lost: 12/29/2017
ID: 7740
Name: Batley
Type: Cat
Color: Black
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Rosemont place Apartments Southside des moines. About 4 months old.
Pleasantville
Lost: 12/29/2017
ID: 7723
Name: Dally
Type: Dog
Color: Brown black and white
Breed: Border Collie
Gender: Female
Fixed: Not Neutered
Age: Young
She was last spotted in a field by G40 and HWY 92 she is my sisters dog and we are very worried about her! Please please if anyone has any information contact my sister Kelsie at 515-729-2579
Urbana
Lost: 12/29/2017
ID: 7722
Name: Savage
Type: Dog
Color: black/white/tan
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Young
Our gate wasn't closed properly and they got out around 4:15pm. They are not outdoor dogs, so we are very worried. He originally went missing with his brother Max, but Max was found 01/05/2018, a week after they got loose. Max was found around 3138 56th Street Trail, Center Point, Iowa. This is a gravel road off the Urbana-Shellsburg black top that goes to Vinton. This is about 2 miles from our home. Savage may be sheltering himself in outbuildings around this area as well.
Pleasantville
Lost: 12/29/2017
ID: 7718
Name: Dally
Type: Dog
Color: Tri Color-Black,White, and Brown
Breed: Border Collie
Gender: Female
Fixed: Not Applicable
Age: Young
She was last seen running around G40 and Hwy 92 South of town in Pleasantville. She is very friendly but is timid of people she doesn’t know. Please contact Kelsie at 515-729-2579 if you see her or find her! We just want her home safe with us.
Winterset
Lost: 12/28/2017
ID: 7721
Name: Moose
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
2427 Carver Rd, Winterset, IA
Winterset
Lost: 12/28/2017
ID: 7720
Name: Moose
Type: Dog
Color: Golden
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
At our home 2427 Carver Rd, Winterset, IA.
Altoona
Lost: 12/28/2017
ID: 7716
Name: Wilhelm
Type: Cat
Color: Goldish orange
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Last seen outside on my driveway by neighbors. But not seen since
Des Moines - North
Lost: 12/27/2017
ID: 7711
Name: Zues
Type: Cat
Color: Brown calico
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
We live close to park fare mall. He very timid. Hes usually an outside cat, but brought him for the winter an he was let back out while i was at work.