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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 2/6/2018
ID: 7926
Name: Ford
Type: Dog
Color: red
Breed:
Gender: Male
Fixed: Neutered
Age: Adult
He is a redbone coonhound with floppy ears. All red with white chest. Lost on E. 8th and Hull area in Des Moines. Loud barker.
Des Moines - East
Lost: 2/6/2018
ID: 7925
Name: Ford
Type: Dog
Color: red
Breed: Coonhound
Gender: Male
Fixed: Neutered
Age: Adult
He is a redbone coonhound with floppy ears. All red with white chest. Lost on E. 8th and Hull area in Des Moines. Loud barker.
West Des Moines
Lost: 2/6/2018
ID: 7919
Name: Diesel
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
63rd and railroad
Carlisle
Lost: 2/6/2018
ID: 7918
Name: Ruby and Trapper
Type: Dog
Color: Black and white
Breed: Mix
Gender: Unknown
Fixed: Unknown
Age: Baby
Our 2 dogs got out today and are exploring apparently! We just moved to Carlisle/Avon area about 2 weeks ago. Ruby's (the white spotted one) tags came off yesterday but she is wearing a pink collar. Trapper (black male) has on a green collar, he has tags and is microchipped. Both are VERY friendly! Please call or email if you find them. We are worried about them in this cold :(
Winfield
Lost: 2/5/2018
ID: 7941
Name: Lexi
Type: Dog
Color: Black with brown markings
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Neutered
Age: Young
Very tame loving pup
Des Moines - East
Lost: 2/4/2018
ID: 7924
Name: Queen
Type: Dog
Color: White, black, brown spots
Breed: Jack Russell Terrier
Gender: Unknown
Fixed: Unknown
Age: Young
She was on a yellow cable rope. Had not eaten yet.
Des Moines - North
Lost: 2/3/2018
ID: 8009
Name: Bella
Type: Dog
Color: Tan with black
Breed: Mix
Gender: Unknown
Fixed: Neutered
Age: Young
Ran away from home. We live on 7th street in North Des Moines.
Grinnell
Lost: 2/3/2018
ID: 7916
Name: Luna
Type: Cat
Color: Black and White
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Luna was last seen on the SE side of Grinnell. He is an indoor cat, declawed and scared. We love or baby and just want him home.
Grinnell
Lost: 2/3/2018
ID: 7915
Name: Luna
Type: Cat
Color: Black and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on SE side of Grinnell. Long haired, declawed house cat. We love him so much and just want our baby home. He replies to Luna, but is very timid to strangers.
Boone
Lost: 2/3/2018
ID: 7909
Name: Perry
Type: Cat
Color: Grey and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Perry got out of the house this morning. We have looked for him and are very worried. He needs his medication. If you see Perry, please call me.
Boone
Lost: 2/3/2018
ID: 7908
Name: Perry
Type: Cat
Color: Grey
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
Perry is a grey Siamese mix cat, with white paws and blue eyes. He bolted out of the door when my friend was moving out. If you see him, please call me first.
Des Moines - South
Lost: 2/3/2018
ID: 7907
Name: Romeo
Type: Dog
Color: Brown and black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Young
SE Des Moines
Urbandale
Lost: 2/2/2018
ID: 7934
Name: Viserys
Type: Cat
Color: Black and grey with hints of brown
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Urbandale
Lost: 2/2/2018
ID: 7904
Name: Viserys
Type: Cat
Color: Black and Grey
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
156th and Meredith
Des Moines - East
Lost: 2/1/2018
ID: 7901
Name: Romeo
Type: Cat
Color: Black long hair
Breed: Unknown
Gender: Male
Fixed: Unknown
Age: Baby
By Grandview ave. And e.9th he doesn't meow
Adel
Lost: 2/1/2018
ID: 7899
Name: Addy
Type: Dog
Color: Gray mix of tan and white
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Young
S. 16 street in Adel (515) 229-1729
Adel
Lost: 2/1/2018
ID: 7898
Name: Addy
Type: Dog
Color: Gray with mix of tan and white
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Young
She was frightened by the wind and somehow got out of our gated yard.
Grinnell
Lost: 1/31/2018
ID: 7900
Name: Luna
Type: Cat
Color: Tortoise shell
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
Very talkative, knows her name, very loving, please bring her home
Ankeny
Lost: 1/31/2018
ID: 7896
Name: Penny
Type: Dog
Color: Black with white front
Breed: Cocker Spaniel
Gender: Male
Fixed: Neutered
Age: Adult
Son took her out to go bathroom but never came back. 605 NE 70th Ankeny
Monroe
Lost: 1/31/2018
ID: 7891
Name: MARIO
Type: Dog
Color: RED
Breed: Cocker Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
MISSING SINCE 12/19. LAST SPOTTED NEAR MONROE SOFTBALL FIELD. HE IS SKITTISH AND MAY NOT COME IF CALLED. PLEASE HELP BRING HIM HOME. HE IS A RED MIN PIN WITH SOME DARK ON HIM. SMALL PATCH WHITE HAIR ON NECK. THANKS. HE IS THE ONE ON THE FAR RIGHT.
Ankeny
Lost: 1/30/2018
ID: 7885
Name: Dexter
Type: Dog
Color: brown
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Adult
carney.south ankeny
Pella
Lost: 1/29/2018
ID: 7888
Name: Oakley
Type: Dog
Color: Liver
Breed: English Springer Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
Young male liver and white English Springer Spaniel. Last seen 5 miles north of Pella near Hwy T14. Shy and skittish, may not approach a stranger. Not chipped. Call if seen or take to Tri County Vet Clinic. 641-780-4963.
Urbandale
Lost: 1/29/2018
ID: 7886
Name: Casper
Type: Cat
Color: Orange and white
Breed: Manx
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - East
Lost: 1/28/2018
ID: 7882
Name: Kitty Morales
Type: Cat
Color: Grey and black with white on paws and face
Breed: Manx
Gender: Male
Fixed: Unknown
Age: Young
Over the weekend she somehow got out of the house. She got out of my house at 1707 E Walnut St Des Moines, IA 50316.
Des Moines - South
Lost: 1/28/2018
ID: 7881
Name: Tony
Type: Dog
Color: Black and white tan face markings
Breed: Manx
Gender: Male
Fixed: Not Neutered
Age: Adult
LOST him on se 14th and watrous. His name is Tony. He has no collar on him he got out the fence. Boston terrier x daschund 25lbs very very fast and strong for his size. Very friendly will come to you if you can get his attention. He's black white with tan face markings