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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Avoca
Lost: 3/30/2015
ID: 213
Name: Dexter
Type: Dog
Color: Chocolate and tan
Breed: Pinscher-Miniature
Gender: Male
Fixed: Not Neutered
Age: Young
SHARE!!! PLEASE HELP!!!!!! My dad lost his dog! LOST DOG - CHOCOLATE MINIATURE PINSCHER (MALE) - PLEASE SHARE!!!! DEXTER was in the Truck with Bill Kishbaugh in Avoca Iowa yesterday and jumped out of the truck and ran....He was at the Pilot Truck Stop off of I-80, Exit 40-phone # 712-343-4007. The police in that area have been notified and the following Vet Clinics: Avoca Vet Clinic- phone # 712-307-6565, Shelby Vet Clinic-712-544-2521 and Pottawattamie County Animal Control-phone # 712-328-4656 or 712-366-1143. IF FOUND, PLEASE CONTACT: Bill Kishbaugh at 570-751-8001 or Joan Browna at 570-599-5731.....REWARD OFFERED!!!!
Des Moines - West
Lost: 3/30/2015
ID: 211
Name: Bear
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
8pm seen on merle hay road.
Des Moines - Central
Lost: 3/29/2015
ID: 205
Name: Bella
Type: Dog
Color: Gold
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
On oak park av with a smaller goldish while lab German Shepard mix. Love a lot please help
Des Moines - Central
Lost: 3/29/2015
ID: 198
Name: Cheif
Type: Dog
Color: white with brown tail
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a very friendly dog looks kind of mean but he's really not. He has little black dots on his ears. Bad thing about him is he will jump in anyone's car. If you do find him please text or call I got him as a gift from my deceased grandfather and he is the last thing I got. He means a lot to my family. My number is 515-745-4093
Des Moines - Central
Lost: 3/29/2015
ID: 197
Name: Cheif
Type: Dog
Color: white with brown tail
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a very friendly dog looks kind of mean but he's really not. He has little black dots on his ears. Bad thing about him is he will jump in anyone's car. If you do find him please text or call I got him as a gift from my deceased grandfather and he is the last thing I got. He means a lot to my family. My number is 515-745-4093
Des Moines - Central
Lost: 3/29/2015
ID: 196
Name: Cheif
Type: Dog
Color: white with brown tail
Breed: Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
He is a very friendly dog looks kind of mean but he's really not. He has little black dots on his ears. Bad thing about him is he will jump in anyone's car. If you do find him please text or call I got him as a gift from my deceased grandfather and he is the last thing I got. He means a lot to my family. My number is 515-745-4093
Des Moines - Central
Lost: 3/28/2015
ID: 204
Name: Punzle
Type: Dog
Color: Gold and white
Breed: Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
With a gold lab named bella last seen on oak park av. We love and miss them please help Shepard and lab
Des Moines - Central
Lost: 3/28/2015
ID: 203
Name: Punzle
Type: Dog
Color: Goldish white
Breed: Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
By a park with a slightly larger gold lab named bella. We love them so much please help she's lab and German Shepard
Des Moines - Central
Lost: 3/28/2015
ID: 202
Name: Bella
Type: Dog
Color: Gold
Breed: Labrador Retriever
Gender: Female
Fixed: Unknown
Age: Adult
Running past a park with another slightly smaller goldish white female dog
Ankeny
Lost: 3/27/2015
ID: 188
Name: rafeeky
Type: Cat
Color: long haired black cat
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Senior
Johnston
Lost: 3/25/2015
ID: 175
Name: Cat
Type: Cat
Color: Grey
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
This morning when I fed her, I think she slipped out when a friend and I left around 10.
Des Moines - East
Lost: 3/23/2015
ID: 181
Name: RUKKUS
Type: Cat
Color: SOLID GREY
Breed: Russian Blue
Gender: Male
Fixed: Not Neutered
Age: Adult
LAST SEEN IN THE AREA OF 40TH AND MAHASKA AVE. NO COLLAR. HE IS FRIENDLY AND RESERVED. MOTIVATED BY FOOD WHICH COULD OF GOTTEN HIM INTO TROUBLE PERHAPS TRAPPED. HAS UNUSUAL CHARACTERISTIC WITH HIS LEFT EYE. LIGHT GREEN EYES AND SMALL DAINTY PAWS VERY SOFT GREY FUR A STRONG PURR & SOFT MEOW.
Des Moines - North
Lost: 3/23/2015
ID: 158
Name: Charlotte
Type: Dog
Color: Brindle/brown
Breed: Mountain Cur
Gender: Female
Fixed: Neutered
Age: Young
Last seen playing in our backyard with our big white German Shepard/Huskie mix. the shepard/huskie was tied up and now both escaped. they tend to escape together. She should be with the big white dog. Both are very nice and friendly. She is so sweet and gets scared easily.
Des Moines - North
Lost: 3/23/2015
ID: 157
Name: Bella
Type: Dog
Color: White
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Adult
Tied up to our backyard tree. She is a furry white German Shepard/Huskie mix. Very very nice. Loves to run. She will be with a medium size dog (Brindle/hound)
Craig
Lost: 3/20/2015
ID: 463
Name: Otto
Type: Dog
Color: brown black white
Breed: Shar Pei
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen near Craig Iowa escaped from yard very sweet boy. Aussie Sharpei mix.
Ankeny
Lost: 3/20/2015
ID: 141
Name: ranga
Type: Cat
Color: orange has white stripes and a white circle on each side of its body
Breed: Shar Pei
Gender: Male
Fixed: Neutered
Age: Baby
got out 12am . answers when i call. cant find in neighborhood
Ankeny
Lost: 3/20/2015
ID: 139
Name:
Type: Cat
Color:
Breed: Domestic Medium Hair
Gender: Male
Fixed: Unknown
Age: Baby
orange with circle on each side
Rural Polk County
Lost: 3/19/2015
ID: 131
Name: Lola
Type: Dog
Color: Black with brown legs
Breed: Airedale Terrier
Gender: Female
Fixed: Not Applicable
Age: Senior
Nw 6th dr and nw66th saylorville She has one ear that sticks up and one that stays down. If you feel her tail you can feel bone sticking out of skin that is covered up by her tail hair. Has a finicky stomach and can not eat most treats or foods or it will make her sick.
Sigourney
Lost: 3/18/2015
ID: 187
Name: bear
Type: Dog
Color: white
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen east of sigourney headed towards what cheer
Sigourney
Lost: 3/18/2015
ID: 186
Name: cheyanne
Type: Dog
Color: white
Breed: Great Pyrenees
Gender: Female
Fixed: Not Neutered
Age: Adult
last seen headed east of sigourney towards what cheer
Sigourney
Lost: 3/18/2015
ID: 185
Name: cheyanne
Type: Dog
Color: white
Breed: Great Pyrenees
Gender: Female
Fixed: Not Neutered
Age: Adult
last seen headed east of sigourney towards what cheer
Sigourney
Lost: 3/18/2015
ID: 184
Name: bear
Type: Dog
Color: white
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen heading east
Sigourney
Lost: 3/18/2015
ID: 183
Name: cheyanne
Type: Dog
Color: white
Breed: Great Pyrenees
Gender: Female
Fixed: Not Neutered
Age: Adult
last seen heading east..
West Des Moines
Lost: 3/18/2015
ID: 122
Name: Ty
Type: Cat
Color: Gray
Breed: Munchkin
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen in our backyard around 3pm off 50th Street in West Des Moines, IA
Des Moines - North
Lost: 3/17/2015
ID: 111
Name: Max
Type: Dog
Color: tri colored. white eith brown n black spots
Breed: Rat Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Got out from our home sometime after 4pm. Oakpark neighborhood