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>='1544227200')) ORDER BY pm1.meta_value DESC, post_date DESC
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
Urbandale
Lost: 3/16/2015
ID: 3118
Name: Gypsy
Type: Dog
Color: Tan/Black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Adult
She got out in Urbandale around 100th st and Douglas Ave. She is teacup size. About 4 lbs. Last seen wearing a pink polka dot diaper. She has a missing tooth and she is 8 years old.
Urbandale
Lost: 3/16/2015
ID: 563
Name: Gypsy
Type: Dog
Color: Bown/tan
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Adult
She got out of the screen door of Parkway Apartments off of Douglas Ave in Urbandale. She had on a pink polka dot diaper when she got out. Her hair was not groomed like in the picture but a few inches longer. She has missing teeth from getting them pulled and really bad breath. She looks like a puppy but she's actually 6 years old and full grown
Urbandale
Lost: 3/16/2015
ID: 107
Name: Gypsy
Type: Dog
Color: Brown/black/grey
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Adult
She got out of the screen door sometime between noon and 9:30 I got home from work and there was a hole in the screen. She had on a pink diaper.
Des Moines - North
Lost: 3/16/2015
ID: 97
Name: Maui
Type: Dog
Color: yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
our yellow lab jumped the fence around noon. she usually doesn't go far but we cant find her!! we live on 4th in highland park!! very worried!! thank you
Story City
Lost: 3/14/2015
ID: 46
Name: Nelson
Type: Dog
Color: White with black spots
Breed: Dalmatian
Gender: Male
Fixed: Not Neutered
Age: Adult
He is very special to us and hope we can find him! Offering REWARD for any information to help us find him!! 515-291-6140!
Story City
Lost: 3/14/2015
ID: 45
Name: Taz
Type: Dog
Color: Black spots and white
Breed: Dalmatian
Gender: Male
Fixed: Neutered
Age: Young
We are offering REWARD for any information as to where he is located! 515-291-6140
West Des Moines
Lost: 3/13/2015
ID: 109
Name: Basil
Type: Cat
Color: Off White and grey striped
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Lost around Walnut Street which is east of Valley West Drive and North of EP True. Basil has her claws and beautiful blue eyes.
Des Moines - South
Lost: 3/13/2015
ID: 104
Name: Raven (poop cat)
Type: Cat
Color: Black and White
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Small head, larger behind, skittish, last seen on the south side a block north from smittys on army post.
Davenport
Lost: 3/13/2015
ID: 86
Name: bree
Type: Dog
Color: brown/white
Breed: Pit Bull
Gender: Female
Fixed: Not Applicable
Age: Adult
She is not allowed outside by herself and she was in the house and my 5yr old went outside and left the door open and she found a way out of our privacy fence.
Des Moines - South
Lost: 3/13/2015
ID: 81
Name:
Type: Dog
Color: tan
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Adult
Se 6th and Edison by the fire station and b&b super market
Des Moines - Central
Lost: 3/13/2015
ID: 79
Name: Daisy
Type: Dog
Color: black with high white paws
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Baby
She was running from west to east on lyon st by the capitol.
Chatsworth
Lost: 3/12/2015
ID: 129
Name: Blacky an Lilly
Type: Dog
Color: Black both of them
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
2 blk labs. One female an one male.. Lost in Chatsworth iowa
Des Moines - East
Lost: 3/11/2015
ID: 491
Name: bubba
Type: Dog
Color: tan white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Unknown
Age: Baby
Near tasty Tacos on east 29th & Euclid he's really friendly please return him call 515/473/2196
La Porte City
Lost: 3/11/2015
ID: 179
Name: Oreo
Type: Cat
Color: White gray tan
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
Waukee
Lost: 3/11/2015
ID: 73
Name: Gucci
Type: Cat
Color: Brown/grey with a white stomach
Breed: Calico
Gender: Male
Fixed: Neutered
Age: Young
Gucci went outside 3/11/15 at night and never came home in the morning. He is an extremely lovable sometimes skittish cat. He is very much loved and a part of our family
Ankeny
Lost: 3/11/2015
ID: 62
Name: Amaya
Type: Dog
Color: black
Breed: Cockapoo
Gender: Female
Fixed: Neutered
Age: Adult
In Ankeny, Iowa...my mom was taking my son to daycare. My son was fussing in the backseat and she pulled over and my dog jumped out of the car. She was on 36th street near the Otter Creek area.
Perry
Lost: 3/9/2015
ID: 930
Name: Champ
Type: Dog
Color: White
Breed: White German Shepherd
Gender: Male
Fixed: Neutered
Age: Adult
Limping on front right paw in our driveway. He was most likely picked up and someone thought he had been dumped. He was dirty this day fron digging up a foxhole and limping from his venture. We live just outside of Perry on P58.
Perry
Lost: 3/9/2015
ID: 339
Name: Champ
Type: Dog
Color: white
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by boat ramp at my house on p58 in Perry Iowakin
Afton
Lost: 3/8/2015
ID: 178
Name: Ella
Type: Dog
Color: Black, with white on chest and front feet,
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Unknown
Age: Young
last seen 5 miles south of Afton
Perry
Lost: 3/8/2015
ID: 100
Name: Champ
Type: Dog
Color: white
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Adult
On p58 near Perry,Ia He's very friendly also has a hurt front paw and has a limp has chip we just want him home reward if found there is a 200.00 award if hes found plz help us find him he missed so much and he is very loved
Afton
Lost: 3/8/2015
ID: 84
Name: Ella
Type: Dog
Color: Black with white and grey on chest
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Young
Last seen about 5 miles south of Afton!!! Please help find this puppy her family is devastated!!!