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
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
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.