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>='1618444800')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 2/4/2021
ID: 16016
Name: Fat cat
Type: Cat
Color: sandy colored
Breed:
Gender: Unknown
Fixed: Unknown
Age: Adult
Came to us as a stray 3 yrs ago. Most likely abused early on in life as cat is very timid and nervous around people/noise. Finally warmed up to us last 6 months.
Waterloo
Lost: 2/4/2021
ID: 16004
Name: Angel
Type: Cat
Color: Black and Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
He got out right when the blizzard started. He answers to Angel and Nunu. His left ear is clipped
Des Moines - North
Lost: 2/4/2021
ID: 15993
Name: Lola
Type: Dog
Color: Cream
Breed: GoldenDoodle
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at the intersection of NE 66th Ave and 2nd Ave in Des Moines. Just north of Smokey D's
Des Moines - South
Lost: 2/3/2021
ID: 15977
Name: No idea
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
HOME SAFE
Waterloo
Lost: 2/3/2021
ID: 15994
Name: Bowser
Type: Cat
Color: Brown Tiger
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Ran off over by Cedar Bend Humane Society on Airline Highway
Oelwein
Lost: 2/3/2021
ID: 15990
Name: Unknown
Type: Dog
Color: Black/White
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Young
Oelwein
Lost: 2/3/2021
ID: 15988
Name: Unknown
Type: Dog
Color: Black/White
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Young
Des Moines - East
Lost: 2/3/2021
ID: 15982
Name: Charlie
Type: Dog
Color: Redish orange
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around William's and timber lane
Des Moines - South
Lost: 2/2/2021
ID: 16017
Name: Addie
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
We live around Army Post and Indinanola Ave. She's friendly but probably wont come at first. Doesn't get along well with other pets so keep her isolated if need be.
Lamont
Lost: 2/2/2021
ID: 16006
Name: Remi
Type: Dog
Color: Fawn and white
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
NE of Lamont..this dog is thin and escaped from a home in Lamont..he is not my dog by I am concerned about him ..
Indianola
Lost: 2/1/2021
ID: 15998
Name:
Type: Cat
Color:
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Adult
Orange colored male cat. Very large. Last seen at 130th Ave. And Polk Street.
Pleasant Hill
Lost: 2/1/2021
ID: 15995
Name: Jack
Type: Dog
Color: Sable
Breed: Shetland Sheepdog Sheltie
Gender: Male
Fixed: Neutered
Age: Young
Seen at 720s.e.55 st. 8 months old. Recently neutered. Can still see Incision site. Right leg small spot where it has been shaved.
Pella
Lost: 2/1/2021
ID: 15989
Name: Kobe
Type: Dog
Color: Black
Breed: Pomeranian
Gender: Male
Fixed: Not Neutered
Age: Young
At 173 Highway T14
Des Moines - Central
Lost: 2/1/2021
ID: 15985
Name: Chispa & mogi
Type: Dog
Color: All brown and a black with brown and white
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
At my house they went poddy and never came back in. I lost both our puppies and hope they are still together.
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