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>='1560384000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Urbandale
Lost: 1/17/2018
ID: 7815
Name: Sheldon
Type: Cat
Color: Grey
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
last seen in my home in Urbandale. Located near Meredith and 142nd street
Norwalk
Lost: 1/17/2018
ID: 7812
Name:
Type: Cat
Color: Yellow/Gold
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Adult
We have noticed this cat hanging around East 17th st area in Norwalk, The cat is very friendly but was starving. Please contact me if you lost this cat or are interested in giving it a good home. It is NOT a feral cat. I have a feeling someone dumped this poor cat during this harsh weather. Call 981-4906
Des Moines - East
Lost: 1/17/2018
ID: 7807
Name: Thor
Type: Dog
Color: Black
Breed: Rottweiler
Gender: Male
Fixed: Unknown
Age: Young
E 26th Street Des Moines Iowa
Ottumwa
Lost: 1/16/2018
ID: 7844
Name: Speckles
Type: Dog
Color: white and brown
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
Broke chain while tied out to potty. House pet. Last seen at Pioneer Ridge south of Ottumwa 20 th st. He may bark but will lick you and loves being petted. May still be dragging part of chain. He is intact male brown and white Lab mix He is most likely with Chocolate lab "Buddy". neutered male. Also barks but loves treats and friendly. Both owned by Curtis Thomas please call 641-208-2574 with any information leading to safe return of Speckles and Buddy
Waukon
Lost: 1/16/2018
ID: 7811
Name: Daisy
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Female
Fixed: Neutered
Age: Adult
She is a black and white collie who is not very good about coming to her name. She was only wearing a flea collar when she was last seen near Dorchester, Iowa. If found, please call home phone at 563-497-3456 or cell at 507-450-0338. Thanks!
Des Moines - South
Lost: 1/15/2018
ID: 7818
Name: King
Type: Cat
Color: Black and Grey
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Young
Sunday Night before bed thinking he got out in morning
Ogden
Lost: 1/14/2018
ID: 7937
Name: FLATHEAD
Type: Dog
Color:
Breed: Tiger
Gender: Male
Fixed: Not Neutered
Age: Adult
847 170th st Ogden IA
Des Moines - East
Lost: 1/14/2018
ID: 7804
Name: Bro
Type: Cat
Color: Black
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
E. Madison Ave and Lay
Des Moines - South
Lost: 1/14/2018
ID: 7800
Name: Louie & Saint
Type: Dog
Color: Louie is white & brown, Saint is white
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Young
They were last seen in the Fleur hyvee parking lot area
Des Moines - East
Lost: 1/14/2018
ID: 7799
Name: Spots Johnson
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen across from sleepy hollow