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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
West Des Moines
Lost: 1/26/2018
ID: 7870
Name: Unknown
Type: Cat
Color: White and gray
Breed: Domestic Long Hair
Gender: Unknown
Fixed: Unknown
Age: Young
Found in the area of 88th and Westown Parkway
Ankeny
Lost: 1/26/2018
ID: 7866
Name: Buddy
Type: Dog
Color: Brown black white mix
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Adult
NE Greenview Dr
Des Moines - South
Lost: 1/25/2018
ID: 7865
Name: Juniper
Type: Cat
Color: Calico
Breed: Beagle
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - West
Lost: 1/25/2018
ID: 7864
Name: Thorin
Type: Cat
Color: Brown, black, gold, white around face
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He has a cropped tail and went missing around 12pm. He is very sweet and loves ear rubs. He rarely goes outside so no collar, but he is very much loved and missed.
Center Point
Lost: 1/25/2018
ID: 7863
Name: Bentley and Paisley
Type: Dog
Color: White
Breed: GoldenDoodle
Gender: Male
Fixed: Not Neutered
Age: Young
Both Bentley and paisley are missing and were last seen in the yard at 7:15 this morning.
Des Moines - East
Lost: 1/24/2018
ID: 7917
Name: Thor
Type: Cat
Color: Grey and strips
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He is a lover, scared at first. Still has claws.
Brooklyn
Lost: 1/24/2018
ID: 7853
Name: Unknown
Type: Dog
Color:
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Found Pitbull possible mix. Found in brooklyn along interstate 80. No microchip. Vet is thinking possibly two years old.
Hawarden
Lost: 1/23/2018
ID: 7858
Name: Chance
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Unknown
Fixed: Unknown
Age: Senior
Lamoni
Lost: 1/23/2018
ID: 7846
Name: Ace
Type: Dog
Color: Red
Breed: Australian Cattle Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Broke through a window and ran away he is mixed with a lab so he is bigger than normal heeler.
Lamoni
Lost: 1/23/2018
ID: 7843
Name: Ace
Type: Dog
Color: Red/White
Breed: Cattle Dog
Gender: Male
Fixed: Not Neutered
Age: Young
Ankeny
Lost: 1/22/2018
ID: 7838
Name: Molly
Type: Dog
Color: Black and gray high lights
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Adult
Front yard of 209 NE 7th Street She is very sweet good to children and may be hurt on her tail that got shut in the door
Windsor Heights
Lost: 1/22/2018
ID: 7836
Name: Ringo
Type: Cat
Color: White and orange with spots on half of fave and an orange tale
Breed: American Shorthair
Gender: Male
Fixed: Unknown
Age: Young
Ringo will com to shaking cans of wet cat food! He may be scared due to just being in an apartment fire and this is how he became lost. He also answers to "blanc" loves stringy toys!
Norwalk
Lost: 1/21/2018
ID: 7877
Name: Jet
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly with all people and animals! Greying around the nose
Des Moines - Central
Lost: 1/21/2018
ID: 7839
Name: Boots
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Young
Our family cat ran outside on Sunday evening around 9pm, he is my daughters best friend and he has never been outside before and we are very worried. It’s so cold outside we just want him back!! We live right by Hoover high school on aurora ave. Please if you see him contact me.
Marion
Lost: 1/21/2018
ID: 7835
Name: Khali
Type: Dog
Color: Brown and white
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Young
Last seen at 27th Ave and Indian creek Marion ! Please if you know anything she is very missed !!
Des Moines - West
Lost: 1/20/2018
ID: 7869
Name: Chaplin
Type: Dog
Color: black and tan
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
Chaplin is approx: 58-64lbs. He is mostly black with tan legs, and on sides of his face. He has white running down his chest. Above each eye is a spot of tan. His legs are long and thin, he has rather floppy ears. He has two white toenails on one back foot. He is ill. He has a kidney disorder which he eats special food and medications. He also has an anxiety issue of which he takes medication. He shakes, whimpers,when he is scared. Although he is afraid of many things, he will never bite anyone and he has a overall friendly disposition. However he is not a fan of children because they scare him. I miss him so much and am afraid for him because he is sick. I pray and hope that someone finds him or sees him. Thank you.
Des Moines - West
Lost: 1/20/2018
ID: 7832
Name: Chaplin
Type: Dog
Color: black and tan - above each a tan spot
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
When we reliazed he was not in gated area then we had no idea. I will write that is a far stretch to think he would be far from home. And for whatever reason if he went farther then he most have gotten lost and could not find his way back home. He is friendly yet he can act apprehensive and he is afraid of other dogs.
Johnston
Lost: 1/20/2018
ID:
Name: Pedro or “Bubby”
Type: Cat
Color: Grey/White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Declawed in the front, no collar, long haired, friendly, chubby and very loved. Lost in the Beaver Creek Elementary area of Johnston.
Bondurant
Lost: 1/20/2018
ID: 7824
Name: Ashes
Type: Cat
Color:
Breed: Domestic Long Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 1/19/2018
ID: 7850
Name: Mittens
Type: Cat
Color: Black and white tuxedo
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
She is an indoor cat and slipped by us. She is not fond of strangers and i'm afraid if someone tries to pick her up other than myself she might claw and bite and in return someone would be mean to her, that is what i fear the most. I just want my little girl back home with me i have raised her since she was 5 wks old and she is now 10 yrs old.
Des Moines - North
Lost: 1/19/2018
ID: 7840
Name: Chaplin
Type: Dog
Color: black and tan tan spot above each eye
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the gated part of out patio. Someone had accidently left the gate open and he ran out. We thought for sure he would not be far from home which is the northwest part of Des Moines, however yet to be found. He is not well...kidney disease and eats special food for this. He also has a heart mummer. He has clinical anxiety and is afraid easy.
Des Moines - North
Lost: 1/19/2018
ID: 7833
Name: Chaplin
Type: Dog
Color: black and tan with a tan spot above each eye.
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
northwest Des Moines, Iowa
Des Moines - West
Lost: 1/18/2018
ID: 7851
Name: Tazz
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen on our porch at 3838 57th Street, Des Moines. He is very smart and friendly.
Des Moines - South
Lost: 1/18/2018
ID: 7696
Name: Gabriel
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Trusted the wrong people to watch my furbaby while I was away. He's very sweet loves to snuggle and is a mommas boy. I'm worried sick about him
Ottumwa
Lost: 1/17/2018
ID: 7845
Name: Buddy
Type: Dog
Color: chocolate lab brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Pioneer Ridge area south of Ottumwa Ia along Hiway 63 and 220th st. Will be with brown and white male lab mix "Speckles". Bothe are house pets owned by Curtis Thomas. Contact number/ vets office number on tags or call owner @ 641-208-2574.