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>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Hudson
Lost: 2/1/2021
ID: 15978
Name: Kitty
Type: Cat
Color: Multicolored
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Young
She’s never been outside before. She has all her claws.
Des Moines - East
Lost: 1/31/2021
ID: 16472
Name: Blue
Type: Dog
Color: Black and white
Breed: Alaskan Husky
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen in January ran over east by the fairgrounds
Boone
Lost: 1/31/2021
ID: 16173
Name: Peanut / Mr. Peanut
Type: Cat
Color: orange / tan with tiger stripes
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He got out around the Boone trailer park near the short stop and Toby Ks. He was scared because my mom was moving and he happened to get our right before we got the coldest temperatures, we’re hoping someone picked him up or let him inside.
Des Moines - East
Lost: 1/31/2021
ID: 16003
Name: Sassy
Type: Dog
Color: Black, brown, chest stomach white black spots
Breed: Beagle
Gender: Unknown
Fixed: Not Neutered
Age: Baby
In my back yard on her leash
Des Moines - East
Lost: 1/31/2021
ID: 15972
Name: Lily
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Lily is an indoor cat who has never gone outdoors before. She is 8 1/2 years old. She does not have her front claws. She was last seen at E 28th St just north of Easton Ave.
Des Moines - Central
Lost: 1/31/2021
ID: 15969
Name:
Type: Dog
Color:
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - South
Lost: 1/30/2021
ID: 15968
Name:
Type: Dog
Color: Brown
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 1/30/2021
ID: 15964
Name: Bella
Type: Dog
Color: Brindle
Breed: American Bulldog
Gender: Female
Fixed: Unknown
Age: Baby
Last seen timber lane. She got out thru a hole in the fence
Des Moines - South
Lost: 1/29/2021
ID: 16000
Name: Lou lou
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Last seen at 23rd and Park. She has one brown eye defect and one green. She is semi feral and very skittish.
Hudson
Lost: 1/29/2021
ID: 15991
Name: Rooster
Type: Dog
Color: Brown and White Speckled
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly and loves to go for rides.
Des Moines - North
Lost: 1/29/2021
ID: 15963
Name: Vikari
Type: Dog
Color: Black white
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Senior
1406 Clinton squeezed out door
Des Moines - West
Lost: 1/29/2021
ID: 15962
Name: Charlie
Type: Dog
Color: White
Breed: Poodle
Gender: Male
Fixed: Not Applicable
Age: Senior
Charlie is blind He was last seen in the area of 42nd in the beaverdale area
Des Moines - Central
Lost: 1/29/2021
ID: 15959
Name: CONWAY
Type: Cat
Color: solid grey
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Young
last seen at 3407 Grand Ave, Des Moines, IA 50312
Des Moines - Central
Lost: 1/29/2021
ID: 15958
Name: Conway
Type: Cat
Color: Grey
Breed: Russian Blue
Gender: Male
Fixed: Not Neutered
Age: Young
His collar has little fish on it
Waterloo
Lost: 1/28/2021
ID: 17410
Name: Rooster
Type: Dog
Color: White with brown spots and tics
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen outside of Eagle Center Iowa. He was out at his grandparents for the day running on the farm like he does everyday, and he never came back. He has never run away, and he knows his name and comes when called very well. He’s very friendly and we miss him so much.
Eldora
Lost: 1/28/2021
ID: 15954
Name: Dodge
Type: Dog
Color: Black/White
Breed: Coonhound
Gender: Male
Fixed: Unknown
Age: Adult
Southeast of Eldora, IA on our property in the country l
Eldora
Lost: 1/28/2021
ID: 15953
Name: Briggs
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen on our property Southeast of Eldora, IA
Des Moines - East
Lost: 1/28/2021
ID: 15950
Name:
Type: Rabbit
Color:
Breed: Great Dane
Gender: Unknown
Fixed: Unknown
Age: Adult
I found them in my garage. I'm going to put in my dog kennel inside over night.
Ankeny
Lost: 1/28/2021
ID: 15949
Name: Rory
Type: Dog
Color: Black and white
Breed: Schnauzer Miniature
Gender: Male
Fixed: Neutered
Age: Young
NW 8th street area in Ankeny
Des Moines - West
Lost: 1/27/2021
ID: 15946
Name: Oso
Type: Dog
Color: Brow and black
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Unknown
Age: Baby
Went to use restroom and never saw him again, lost around 59th St around Merl hay area
Clive
Lost: 1/26/2021
ID: 15945
Name: Barbeque
Type: Cat
Color: Black and Brown
Breed: Tiger
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in Clive Dec. 6th 2019.
Waterloo
Lost: 1/25/2021
ID: 15960
Name: Unknown
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Black cat found during the storm on Monday night on Knollview Dr. in Waterloo.
Berwick
Lost: 1/25/2021
ID: 15944
Name: Lucy
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Lucy was last seen running around with a black long hair stray male at the sunnybrook trailer park. Haven’t seen her since the snow storm. She is very friendly but is likely very scared and under a porch or in a shed as she’s never been outside before.
West Des Moines
Lost: 1/24/2021
ID: 15967
Name: Soka
Type: Cat
Color: Grey
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
West des Moines near from maple grove elementary school.
Altoona
Lost: 1/24/2021
ID: 15952
Name: Oliver
Type: Cat
Color: White with a grey tail and grey mark on his head
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Sunday, Jan. 24