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 - North
Lost: 7/4/2016
ID: 3326
Name: Annabelle
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen in back yard. Neighbor said he seen run to the East of 400 block East Sheridan Ave about 9:30-9:45 this morning
Des Moines - South
Lost: 7/3/2016
ID: 3996
Name: Alize
Type: Dog
Color: Brown and white
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
If anyone sees her she is not with her correct owner these sick people even stole her dog food to feed her I've looked everywhere :/
Des Moines - East
Lost: 7/3/2016
ID: 3786
Name: Milla
Type: Dog
Color: Brown with white on breast and front paws
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 7/3/2016
ID: 3651
Name: Sheebah
Type: Dog
Color: Black and white
Breed: Husky
Gender: Female
Fixed: Not Applicable
Age: Young
She's beautiful unique 1 of a kind... We miss our family!
Ames
Lost: 7/3/2016
ID: 3467
Name: Otis
Type: Dog
Color: Silver-gray
Breed: Weimaraner
Gender: Male
Fixed: Neutered
Age: Adult
Otis got out of yard and was last seen at 13th St & Northwestern in Ames Sunday 7/3/16 before Ames Fireworks. Very friendly, had a blue collar & tag. 8 yr old family pet, silver gray color with white spot on chest.
Des Moines - East
Lost: 7/3/2016
ID: 3408
Name: sheebah
Type: Dog
Color: black and white
Breed: Weimaraner
Gender: Female
Fixed: Not Applicable
Age: Young
please if any1 has seen her or have any information we miss our family very much.
Des Moines - East
Lost: 7/3/2016
ID: 3343
Name: Milla
Type: Dog
Color: Light brown
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Young
East Hubbell. Very friendly and excitable.
Des Moines - South
Lost: 7/3/2016
ID: 3319
Name: Buster
Type: Dog
Color: White and Brown
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the Easter Lake area. You can also call Gaylene at 515-480-2936 Update: He was spotted by a neighbor on the corner of SW 9th and Leach on 07/03
West Des Moines
Lost: 7/3/2016
ID:
Name: Lulu
Type: Dog
Color: Brown, white, tan
Breed: Brittany Spaniel
Gender: Unknown
Fixed: Not Applicable
Age: Adult
Last seen in our backyard which backs to the woods behind Ponderosa Dr and S Prairie View.
Council Bluffs
Lost: 7/2/2016
ID: 3532
Name: Izzie
Type: Dog
Color: Blue Merle (grey and white)
Breed: Australian Shepherd
Gender: Female
Fixed: Neutered
Age: Senior
Microchip information is out of date, it has my maiden name Hansel and the phone number is likely wrong. Izzie has blue eyes and appears to be wearing eye makeup with her coloring.
Boone
Lost: 7/2/2016
ID: 3360
Name: Hercules
Type: Dog
Color: brown brindle
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
By energy star. Very friendly
Winterset
Lost: 7/2/2016
ID: 3315
Name: Remington
Type: Dog
Color: White with black and brown spots
Breed: Beagle
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen July 2nd,2016. He will answer to the name of Remington.He disappear from 53 Grade street,Winterset,Ia.
Clive
Lost: 7/2/2016
ID: 3312
Name:
Type: Cat
Color:
Breed: Bengal
Gender: Male
Fixed: Unknown
Age: Adult
Bengal cat killed and was moved the median between 80th and 82nd and Hickman in Clive.
Clive
Lost: 7/2/2016
ID: 3310
Name:
Type: Cat
Color:
Breed: Bengal
Gender: Male
Fixed: Unknown
Age: Adult
Sorry post should unknown sex. Bengal was hit and killed is in the grass median between 80th and 82nd on Hickman.
Dubuque
Lost: 7/2/2016
ID: 3297
Name: Carter
Type: Dog
Color: Tan and Silver
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
Last seen near Jaeger Dr and Brian St in Dubuque.
West Des Moines
Lost: 7/2/2016
ID: 3295
Name: Bobby
Type: Dog
Color: White and Black spots
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
Shy dog will got to you if you offer him food good dog potty trained
Des Moines - East
Lost: 7/2/2016
ID: 3294
Name: Lefty
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen in our backyard, e 27th and elm
Des Moines - East
Lost: 7/2/2016
ID: 3293
Name: Lefty
Type: Dog
Color: Black and white
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Adult
Seen last by Titan tire
Des Moines - East
Lost: 7/1/2016
ID: 3339
Name: Fajita
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen over by East 29th and Easton
Des Moines - East
Lost: 7/1/2016
ID: 3336
Name: Bella
Type: Cat
Color: Brown and black multiple
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Some how she got out. And I'm worried sick she never been outside. She is friendly and probably scared my poor cat!!; (
Davenport
Lost: 7/1/2016
ID: 3323
Name: Random (see description for nicknames)—Microchip is German
Type: Cat
Color: European Short Hair---White on her belly and legs, and black and brown on her back and head. Right rear leg has a small dark patch near her heel.
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
LOST AT ABOUT 7:48am on 2 JULY 2016 AT THE I-80 WEST REST STOP ADJACENT TO THE HIDDEN HILLS GOLF COURSE AND DEVILS HILL ROAD. SHE RAN OFF AFTER GETTING LOOSE FROM HER HARNESS. (SHE WAS FERAL IN GERMANY BEFORE WE ADOPTED HER.) FEMALE EUROPEAN SHORT HAIR CAT, KIND OF SMALL, WITH WHITE ON HER BELLY AND BROWN AND BLACK MARKINGS ON HER HEAD AND BACK. SHE ALSO HAS A SMALL BROWN/BLACK MARK ON HER RIGHT REAR HEEL. SHE HAS A PINK COLLAR (FRAYED FROM SCRATCHING) WITH A RED TAG WITH “TASSO” ON IT (WWW.TASSO.NET), WHICH IS A GERMAN LOST-AND-FOUND REGISTRATION SYSTEM (INFORMATION IS OUR OLD GERMAN INFORMATION). HER CHIP # IS: 977-200008204518 (LEFT NECK AREA). HER CHIP IS REGISTERED IN GERMANY (WE JUST MADE A MILITARY MOVE FROM GERMANY TO DES MOINES, IA), AND HER NAME IS “RANDOM.” SHE RESPONDS BETTER TO “Mäuschen” (PRONOUNCED “Mois-shen”) or “Mausi” (pronounced “Mow-se”). HER CHIP NUMBER IS 977-200008204518, AND THE INFORMATION IS STILL OUR GERMANY INFORMATION (PHONE NUMBERS 0160-326-4314 AND 06561-948-2699; ADDRESS AUF QUART 36; 54634 BITBURG). $100 REWARD FOR HER RETURN TO US (WE WILL COME GET HER) PLEASE CALL RICK AT 815-382-6345, or 847-244-3885
Des Moines - South
Lost: 7/1/2016
ID: 3064
Name: Mortimer
Type: Cat
Color: gray striped
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He's very, very friendly. In fact, we think it may be possible another family might have taken him in because last time he came home, he was wearing an unfamiliar collar. If someone does have him, we beg you to please return him, he has a family already and is very missed and loved.
Des Moines - Central
Lost: 6/30/2016
ID: 3448
Name: Nikko
Type: Dog
Color: Brown tan and white
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Adult
Please let me know if you have him. He's my baby.. He's half chihuahua half terroir. Thank you
Dubuque
Lost: 6/30/2016
ID: 3357
Name: smokey
Type: Cat
Color: grey and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
last seen on Winne ct has claws white tummy and grey on back
Johnston
Lost: 6/30/2016
ID: 3320
Name: George
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Baby
He's 9 years old. Declawed. Not an outside cat. He will come when you call his name. Missing from Enclave Dev.