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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Johnston
Lost: 1/1/2021
ID: 15795
Name: Charlie
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
He barks at strangers but is a very sweet baby.
Des Moines - East
Lost: 12/31/2020
ID: 15847
Name: Kittie
Type: Cat
Color: White
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Young
Na
Bondurant
Lost: 12/31/2020
ID: 15845
Name: Kittie
Type: Cat
Color: White
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Na
Bondurant
Lost: 12/31/2020
ID: 15844
Name: Kittie
Type: Cat
Color: White
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Bondurant
Lost: 12/31/2020
ID: 15843
Name: Kittie
Type: Cat
Color: White
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Young
Iowa City
Lost: 12/31/2020
ID: 15798
Name: Scout
Type: Dog
Color: Black
Breed: Labradoodle
Gender: Male
Fixed: Neutered
Age: Adult
Scout got loose around the SE side of Iowa City. He’s friendly, but probably scared. Please keep an eye open for him. We do not know what direction he might be heading. The family misses him dearly.
Moravia
Lost: 12/30/2020
ID: 15799
Name: Rip
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Male
Fixed: Not Neutered
Age: Young
Rip is very friendly. His collar has our phone number on it. He is also with our other dog, Rocky. A small beagle terrier mix. Both are missing.
Pleasant Hill
Lost: 12/30/2020
ID: 15786
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Lilly was removed from my car at the Pleasant Hill Post Office She is now 14 weeks old
Ankeny
Lost: 12/30/2020
ID: 15784
Name: Bear
Type: Dog
Color: Blonde
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on Ne 5th St and Wanda in Ankeny IA. around 7pm. He is very friendly and loves people. He got off his collar so his name tag is missing. He answers to bear/snug/bear bear and loves treats. He is a Pomeranian Shih Tzu mix. We are very sad and concerned. Please help bring my baby back home!
Marshalltown
Lost: 12/29/2020
ID: 15792
Name: Kat
Type: Dog
Color: Black and Grey
Breed: Blue Heeler
Gender: Female
Fixed: Neutered
Age: Young
Riverside cemetery and waterworks area
Orange City
Lost: 12/29/2020
ID: 15779
Name: Mochi
Type: Dog
Color: white
Breed: Poodle Miniature
Gender: Male
Fixed: Neutered
Age: Adult
last seen on 5th St. NW in Orange City, IA
St. Charles
Lost: 12/28/2020
ID: 15817
Name: Archer
Type: Dog
Color: Brown and black/gray
Breed: Airedale Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - West
Lost: 12/27/2020
ID: 15805
Name: Foxy
Type: Cat
Color: Black, tan, mostly white
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Left home near NW 50th Des Moines. Usually returns home if she gets out. If seen please call 469-825-1167.
Des Moines - South
Lost: 12/26/2020
ID: 15765
Name: Button
Type: Dog
Color: Black
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
Se 14th and mckinley
Bedford
Lost: 12/25/2020
ID: 15846
Name: Ethel
Type: Dog
Color: Black, tan, white
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Young
She disappeared from my grandpas house on highway 2 east of Bedford between 1 and 4 pm. We think someone picked her up. Please return her.
West Des Moines
Lost: 12/25/2020
ID: 15758
Name: Cora
Type: Dog
Color: Orange
Breed: Shar Pei
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around 8302 Westown Pkwy
Ankeny
Lost: 12/25/2020
ID: 15757
Name: Luna
Type: Cat
Color: Black & White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
In our house
Des Moines - West
Lost: 12/24/2020
ID: 15925
Name: PopaaKing
Type: Dog
Color: White and Brown
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Young
Last seen on Des Moines west side around good park area with small female bull dog
Carroll
Lost: 12/24/2020
ID: 15900
Name: GiGi
Type: Dog
Color: Grey and White
Breed: Pit Bull Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
12/24/20 last seen and she is very friendly and spoiled. She runs away from aggression
Pleasant Hill
Lost: 12/24/2020
ID: 15886
Name: Lilly
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Unknown
Fixed: Unknown
Age: Young
Pleasant Hill Post Office employee parking lot on Dec 10 in the morning.
Clive
Lost: 12/24/2020
ID: 15754
Name: Yoshi
Type: Bird
Color: Grey, yellow, white, orange
Breed: Cockatiel
Gender: Male
Fixed: Unknown
Age: Adult
NW 78th st in Clive, IA near the park. If captured, please call 515-988-6151
Ottumwa
Lost: 12/23/2020
ID: 15764
Name: Tank
Type: Dog
Color: White & Tan
Breed: Jack Russell Terrier
Gender: Male
Fixed: Unknown
Age: Senior
West Des Moines
Lost: 12/23/2020
ID: 15762
Name: Magnum
Type: Cat
Color: Gray/black tiger stripes. White face with spots
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on 34th Pl Friendly, has claws, like to “play” bite.
Sully
Lost: 12/22/2020
ID: 15777
Name: Ranger
Type: Dog
Color: Red merel
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Sully
Lost: 12/22/2020
ID: 15776
Name: Ranger
Type: Dog
Color: Red merel
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
Lost in the country west of Sully