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
St. Charles
Lost: 10/9/2020
ID: 15178
Name: KC
Type: Cat
Color: Black & White
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on Main Street in St. Charles. Friendly but scared of fast movements and loud noises. Has a limp when he walks.
Sumner
Lost: 10/9/2020
ID: 15177
Name: Olive
Type: Dog
Color: Gray
Breed: Great Dane
Gender: Female
Fixed: Neutered
Age: Young
Dog parents went away for the weekend and were being looked after by family. Ran away at 5:45. Scared pup only a year old See photo for more info
Sumner
Lost: 10/9/2020
ID: 15176
Name: Olive
Type: Dog
Color: Gray
Breed: Great Dane
Gender: Female
Fixed: Neutered
Age: Young
See photo for info on dog. Posting for family.
Des Moines - North
Lost: 10/9/2020
ID: 15175
Name: Charlie
Type: Dog
Color: Black
Breed: Great Dane
Gender: Male
Fixed: Unknown
Age: Young
E Sheridan ave last seen by neighbor someone picked him up.
Des Moines - North
Lost: 10/8/2020
ID: 15385
Name: Kashmir
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He goes missing for weeks at a time. When he returns home he is well-fed and healthy. I think someone may be feeding him and keeping him as their pet. I appreciate that he is cared for, but would like him to be returned as his brothers and the kids miss him terribly!
Dubuque
Lost: 10/8/2020
ID: 15219
Name: Delilah
Type: Cat
Color: Black and white
Breed: Maine Coon
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen on 16th and white street.
Des Moines - South
Lost: 10/8/2020
ID: 15173
Name: Bella
Type: Cat
Color: White/black/pink
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Hudson
Lost: 10/8/2020
ID: 15165
Name: Petey
Type: Dog
Color: Brown Brindle Greying Muzzle
Breed: Pit Bull
Gender: Male
Fixed: Neutered
Age: Senior
South of Hudson IA Country - think he jumped out of yard chasing something - very old but friendly - is mostly Deaf - normally has trouble walking.
Des Moines - East
Lost: 10/8/2020
ID: 15163
Name:
Type: Dog
Color: Tri color
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Baby
Des Moines - North
Lost: 10/8/2020
ID: 14588
Name: Kashmir
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Very sweet and friendly but gets scared easily.
Waterloo
Lost: 10/7/2020
ID: 15174
Name: Autumn
Type: Cat
Color: Black and White
Breed: Tuxedo
Gender: Female
Fixed: Neutered
Age: Young
Corner of Locust and Mullan.
Des Moines - South
Lost: 10/7/2020
ID: 15160
Name: Cocoa
Type: Dog
Color: Brownish
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - West
Lost: 10/7/2020
ID: 15153
Name: Rupert
Type: Cat
Color: White
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
West Des Moines
Lost: 10/6/2020
ID: 15148
Name: Luka
Type: Cat
Color: Gray
Breed: Nebelung
Gender: Male
Fixed: Unknown
Age: Baby
He has blue nail caps so he won’t be able to scratch! Last seen around 92nd street west Des Moines! Please call 857-800-2928 thank you!
Norwalk
Lost: 10/5/2020
ID: 15156
Name: Oreo
Type: Cat
Color: White & Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
She is an inside cat who likes to go outside and chase things but has never been gone this long. She is very friendly. She is mostly white with black spots and a black tail with a white spot on the end of her tail.
Des Moines - South
Lost: 10/5/2020
ID: 15138
Name: Varg
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen by B&B Market on southside
West Des Moines
Lost: 10/4/2020
ID: 15159
Name: Jasper
Type: Cat
Color: Black and white "tuxedo"
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Lost in the vicinity of White Oaks Townhomes in the 2200 block of Grand Ave. WDM. Very friendly, sweet and lovey. Has a small white spot on his nose.
Urbandale
Lost: 10/4/2020
ID: 15144
Name: Stitch
Type: Cat
Color: Gray
Breed: Persian
Gender: Male
Fixed: Neutered
Age: Adult
6100 block of Oakwood Urbandale
Des Moines - East
Lost: 10/4/2020
ID: 15132
Name: Luna
Type: Dog
Color: Multi
Breed: Persian
Gender: Female
Fixed: Unknown
Age: Adult
We were leaving for the day and thought she was inside, when we came back she was gone
Waterloo
Lost: 10/3/2020
ID: 15143
Name: Pixie
Type: Cat
Color:
Breed: Persian
Gender: Female
Fixed: Unknown
Age: Senior
Very large longhair. 12 years old so needs special care. She is a new family member and may be trying to make her way to her former owner so her location could be a wider range
Des Moines - Central
Lost: 10/3/2020
ID: 15126
Name: Mickey
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Mickey escaped and was last seen by Hoover high school. Hes a very big dog but friendly. He has a white tummy and paws and answers to Mickey and Mick Mick. If found please call Amber or Caroline at 515-867-1374.
Early
Lost: 10/3/2020
ID: 15121
Name: George
Type: Dog
Color: Merle - Grayish brown with black spots
Breed: Great Dane
Gender: Male
Fixed: Neutered
Age: Adult
Slipped leash at Caseys general store hwy 71 and 6th street in Early, IA. Last seen at 6pm near United Methodist Church. Shy and skittish, Please call with location if seen but do not chase- 501-388-5431
Johnston
Lost: 10/3/2020
ID: 15119
Name: Clyde
Type: Dog
Color: Brindle
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen by Johnston public library. He’s skittish but friendly.
Des Moines - Central
Lost: 10/3/2020
ID: 15112
Name: Pepper
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Pepper escaped around 2:00 AM on 10/3/2020. She stayed around the back door until 7:00 AM. That was the last time she was seen (on camera). She was a stray before rescued.
Altoona
Lost: 10/2/2020
ID: 15310
Name: grey
Type: Cat
Color: grey
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
never came home that night. she is missing the tip of her tail.