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>='1558051200')) ORDER BY pm1.meta_value DESC, post_date DESC
Fort Dodge
Lost: 4/1/2015
ID: 991
Name:
Type: Dog
Color: brown
Breed: Basset Hound
Gender: Male
Fixed: Unknown
Age: Baby
Northeast iowa
Fort Dodge
Lost: 4/1/2015
ID: 990
Name:
Type: Dog
Color: black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Northeast iowa
Des Moines - East
Lost: 4/1/2015
ID: 266
Name: Chey
Type: Dog
Color: White with Brown mask
Breed: American Bulldog
Gender: Female
Fixed: Not Neutered
Age: Young
She ran down stewart. Usually running in kings park by haitt middle school
De Soto
Lost: 4/1/2015
ID: 231
Name: miya
Type: Dog
Color: fawn n white
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
Very friendly loves every one her family is going crazy
Des Moines - West
Lost: 4/1/2015
ID: 229
Name: PANTHER AKA BABY PANTH
Type: Cat
Color: WHITE WITH SOME BLACK MARKINGS, BLUE EYES
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
ACCIDENTALLY LEFT DOOR OPEN, SEEN LAST AT 700 BLOCK OF 39TH STREET DES MOINES IOWA; TIMID PROBABLY WILL NOT COME TO YOU, HAD NEVER BEEN OUTSIDE PRIOR TO APRIL 1, 2015. I AM SURE HE IS FRIGHTENED. CALL ANY TIME DAY OR NIGHT. 515-279-7183 ASK FOR KOLLEEN
Des Moines - East
Lost: 4/1/2015
ID: 219
Name: Sassy
Type: Cat
Color: Calico
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Senior
Not very approachable. She has a bit of an attitude as her name would imply.
West Des Moines
Lost: 4/1/2015
ID: 214
Name: Tito
Type: Cat
Color: Brown with black spots
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Young
Jordan creek pkw and pommel place
Corning
Lost: 3/30/2015
ID: 299
Name: Bryn
Type: Dog
Color: Fawn brindle
Breed: Mix
Gender: Female
Fixed: Not Applicable
Age: Adult
Des Moines - South
Lost: 3/30/2015
ID: 233
Name: Patches
Type: Cat
Color: White with black markings, black tail green eyes
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
She was a feral cat that had kittens under our shed. We adopted her and the 3 kittens. They are indoor only cats.
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