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>='1594080000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 6/27/2020
ID: 14352
Name: Suzu
Type: Dog
Color: White
Breed: Whippet
Gender: Unknown
Fixed: Not Neutered
Age: Senior
Last seen at York st. and Ovid
Des Moines - East
Lost: 6/27/2020
ID: 14349
Name:
Type: Dog
Color: Brown/White
Breed: Whippet
Gender: Male
Fixed: Unknown
Age: Young
Brook Landing Dr Des Moines, Is 50317
Des Moines - East
Lost: 6/27/2020
ID: 14348
Name:
Type: Dog
Color: Brown/white
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Young
Brook Landing Dr Des Moines Is 50317
Des Moines - Central
Lost: 6/26/2020
ID: 14371
Name: Darkiplier
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
We let him outside and he hasn't been back since. He normally stays around the house, but he's not in the cul-de-sac anywhere.
Des Moines - South
Lost: 6/26/2020
ID: 14366
Name: Buddy
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
White toes on back paws
Des Moines - Central
Lost: 6/26/2020
ID: 14362
Name: Blue
Type: Cat
Color: Gray and white
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
Lost kitten last seen des.moines and known of was Friday night surrounded area of Washington and franklin ave his name is blue if you have any information or have been seen please inbox me please and thank you god bless
Des Moines - Central
Lost: 6/26/2020
ID: 14355
Name: Dobby
Type: Dog
Color: Tri Color - Spotted
Breed: Chiweenie
Gender: Male
Fixed: Not Neutered
Age: Young
VERY SCARED OF FIREWORKS. Shy and cautious, barks a lot, super sweet boy. Responds to Dobbo and Dobby kind as well as Dobby.
Johnston
Lost: 6/26/2020
ID: 14344
Name:
Type: Dog
Color: Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Senior
Very friendly - missing between 8:30 and 11:30 p.m. Reward offered
Weldon
Lost: 6/26/2020
ID: 14342
Name: Roxie
Type: Dog
Color: black white
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Adult
clarke decatur st weldon iowa 50264
Weldon
Lost: 6/26/2020
ID: 14341
Name: roxie
Type: Dog
Color: black white
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Adult
clarke decatur street weldon iowa
Johnston
Lost: 6/26/2020
ID: 14340
Name: Abby
Type: Dog
Color: Red-blonde
Breed: Golden Retriever
Gender: Female
Fixed: Neutered
Age: Young
At home. 5612 Kensington Circle, Johnston, Ia
Fort Dodge
Lost: 6/25/2020
ID: 14405
Name: Tank
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
$250.00 reward. Claimed sighting by little damn in fort dodge being loaded into a red truck.
Altoona
Lost: 6/25/2020
ID: 14393
Name: Stitch
Type: Cat
Color: Gray/white
Breed: Domestic Medium Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Dubuque
Lost: 6/25/2020
ID: 14338
Name: Marie
Type: Cat
Color: grey
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Unknown
Age: Adult
last seen at 2445 Simpson st she is very friendly no collar
Des Moines - East
Lost: 6/25/2020
ID: 14332
Name: Casper
Type: Dog
Color: cream
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Not Neutered
Age: Young
Arthur Ave. Chihuahua Maltese mix. Please call or text
Des Moines - North
Lost: 6/24/2020
ID: 14358
Name: Kali
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Kali was last seen in my apartment off 6th and hickman. She is not very friendly but she is harmless. I miss her very much, and am struggling as she is my emotional support animal. If she is returned I have a reward.
Des Moines - North
Lost: 6/24/2020
ID: 14320
Name: Norman
Type: Cat
Color: brown tabby with white chest and feet, distinctive tail is very bushy
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in backyard on E 8th street by Belle Turner Park
St. Charles
Lost: 6/24/2020
ID: 14318
Name: Mylo
Type: Dog
Color: Gray, white, tan
Breed: Shih Tzu
Gender: Male
Fixed: Neutered
Age: Young
ran south of our home on Woodland Avenue Saint Charles, IA he is a rescue and very skiddish and anxious
Clive
Lost: 6/24/2020
ID: 14313
Name: Rockey
Type: Cat
Color: Black with brown undertones and white spots
Breed: Norwegian Forest Cat
Gender: Male
Fixed: Neutered
Age: Adult
He is sick and needs medication.
Des Moines - North
Lost: 6/23/2020
ID: 14367
Name: Greyson
Type: Cat
Color: Grey and white
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Young
He is very friendly and has gotten lost by Merle Hay. He is bonded with our dog.
Waukee
Lost: 6/23/2020
ID: 14327
Name: Teddy
Type: Dog
Color: Brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Senior
Teddy has a mass on his right hind leg. His tongue hangs out on the right side of his mouth. My little guy is deaf. He can feel vibrations, but can’t hear. Missing near Alice Road in Waukee in the Redwoods Apt.
Des Moines - West
Lost: 6/23/2020
ID: 14326
Name: Leona “Leo”
Type: Cat
Color: Spotted tabby
Breed: American Shorthair
Gender: Female
Fixed: Not Applicable
Age: Adult
Leo snuck out of our Beaverdale home the evening of June 23rd and did not return within a few hours like she normally would. She has food allergies and can only have grain free food or will break out in horrible skin sores. She is greatly missed. Please help us find her.
Des Moines - North
Lost: 6/23/2020
ID: 14319
Name: Porter
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
We were catching fireflies and we think he slipped out the door! Not declawed but very friendly.
Des Moines - East
Lost: 6/23/2020
ID: 14315
Name: Buddy
Type: Cat
Color: Grey, dark brown, cream
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
He loves treats. We shake the bag to get him to come.
Des Moines - South
Lost: 6/23/2020
ID: 14309
Name: Zuri
Type: Dog
Color: White with tan spots
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
She was stolen from my friend’s backyard, wearing white and blue leash. Super friendly. Friend lives 5 minutes away from Grandview College in Des Moines.