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>='1614297600')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 10/9/2022
ID: 15170
Name: Charlie
Type: Cat
Color: White with black spots/tail
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
At home address. Comes to “Ki Ki”. Friendly
Des Moines - South
Lost: 3/3/2021
ID: 16118
Name: Osiris Mau
Type: Cat
Color: White & Orange
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at Elmcrest Apartments late in the night. 433 E. Philip St.
Des Moines - Central
Lost: 3/2/2021
ID: 16116
Name: S’mores
Type: Cat
Color:
Breed: American Shorthair
Gender: Unknown
Fixed: Unknown
Age: Adult
Des Moines - South
Lost: 3/2/2021
ID: 16115
Name: Cota
Type: Dog
Color: Black & White
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen by MCDONALD'S on SW 9th St.
Des Moines - South
Lost: 3/2/2021
ID: 16114
Name: Cota
Type: Dog
Color: Black & White
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Baby
Cota was last seen by MCDonalfs on SW 9th st.
Ankeny
Lost: 3/2/2021
ID: 16113
Name: Orion
Type: Cat
Color: Orange Stripe
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
Got out around 11 p.m. on March 2. The apartment is very close to I-35. There is a fence between the apartment complex and the interstate. Any leads would be appreciated. Thank you. Call or text 515-864-9121.
Des Moines - East
Lost: 3/2/2021
ID: 16111
Name: Goliath
Type: Cat
Color: Grey
Breed: British Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 3/2/2021
ID: 16110
Name: Goliath
Type: Cat
Color: Grey
Breed: British Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Des Moines - South
Lost: 3/2/2021
ID: 16107
Name: Sativa
Type: Dog
Color: Black gray and brown
Breed: Hound
Gender: Male
Fixed: Not Neutered
Age: Adult
The evening 8215 Plaza Lane Des Moines Iowa the lady said she brought her to the ARL cuz we saw a post where somebody had found her you could call me at 515-443-2599
Ankeny
Lost: 3/2/2021
ID: 16103
Name: Snoop
Type: Dog
Color: Black and rust
Breed: Doberman Pinscher
Gender: Male
Fixed: Neutered
Age: Adult
Northwest elementary school Ankeny
Des Moines - West
Lost: 3/1/2021
ID: 16117
Name: Timmy
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
His collar has his name and phone number embroidered in it
Searsboro
Lost: 3/1/2021
ID: 16109
Name: Diesel
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Ankeny
Lost: 3/1/2021
ID: 16106
Name: Gunner
Type: Dog
Color: Gray
Breed: Schnoodle
Gender: Male
Fixed: Neutered
Age: Senior
Wearing a neon green fleece jacket. He is 16yrs old, hard of hearing, has difficulty seeing, and weighs around 20 pounds.
Indianola
Lost: 3/1/2021
ID: 16105
Name: Milo & Max
Type: Dog
Color: Liver & White. Carmel & White
Breed: Cocker Spaniel
Gender: Male
Fixed: Neutered
Age: Adult
At home. Before 8 AM. Milo is wearing his shock collar, Max is just wearing his collar with tags. Milo is an amputee, he is missing a hind leg.
Des Moines - East
Lost: 3/1/2021
ID: 16102
Name:
Type: Cat
Color: Orange
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, has a collar with chip and rabies information.
Mitchellville
Lost: 3/1/2021
ID: 16101
Name: Bel
Type: Dog
Color: Black
Breed: Border Collie
Gender: Unknown
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 3/1/2021
ID: 16099
Name: Oso
Type: Dog
Color: Black & fluffy, brown eyebrows, brown snout, brown paws, white underbelly
Breed: Border Collie
Gender: Male
Fixed: Unknown
Age: Senior
Des Moines - South
Lost: 3/1/2021
ID: 16098
Name: Oso
Type: Dog
Color: Black & fluffy, brown eyebrows, brown snout, brown paws, white underbelly
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Senior
Last seen around SE 14th and Army Post
Osceola
Lost: 2/28/2021
ID: 16100
Name: Stella
Type: Dog
Color: light brown and cream
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Young
Osceola, Ia on Truro Pavement towards the interstate by State troopers station.
Dubuque
Lost: 2/28/2021
ID: 16089
Name: Sophie
Type: Cat
Color: Calico
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Adult
Auburn st/Algona
Urbandale
Lost: 2/28/2021
ID: 16088
Name: Thumper
Type: Cat
Color: Gray Tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on Greenbelt Dr. in Urbandale. He is a gray tabby cat with a white chest and white paws. He is declawed on all 4 paws. He is not wearing his collar, but he is microchipped. He is okay to approach and really loves treats. If seen or found, please call Alex at (515) 537-0093 or Jake at (515) 554-6769.
Hartford
Lost: 2/28/2021
ID: 16085
Name: Sophie/sophia
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
At storage units in hartford iowa. Got out at 2 am tbis morning.
Des Moines - East
Lost: 2/27/2021
ID: 16092
Name: Romeo
Type: Cat
Color: Half white half brown/black tabby
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He’s a big cuddle bear and loves people he’s a little chunky and always come home to eat but hasn’t been seen in a few days, it’s not like him ,he will let anyone near him but he’s a mamas boy and I’m definitely lost myself without him he is 2 years old this month
Bondurant
Lost: 2/27/2021
ID: 16087
Name: Binky
Type: Dog
Color: Black and Tan
Breed: Manchester Terrier
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on NE 74th Ct, 5 miles north of Bondurant. Just east of NE 72nd. She is chipped to Jodi Alsin, but that phone number is mo longer in service. Please contact 515-633-7380
Bondurant
Lost: 2/27/2021
ID: 16084
Name: Binky
Type: Dog
Color: Black and Tan
Breed: Manchester Terrier
Gender: Unknown
Fixed: Neutered
Age: Adult
NE 74th Ave Tea cup Min Pin Sweet,