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>='1575504000')) ORDER BY pm1.meta_value DESC, post_date DESC
Altoona
Lost: 11/23/2016
ID: 4414
Name: Phoenix (Cass)
Type: Dog
Color: Brindle black/brown
Breed: Pit Bull Terrier
Gender: Female
Fixed: Neutered
Age: Young
She's very friendly, loves kids. Somehow managed to open the door and get out
Des Moines - East
Lost: 11/22/2016
ID: 4408
Name: Ziggi
Type: Dog
Color: Black and brown with white paws and brown eyebrows
Breed: Australian Shepherd
Gender: Male
Fixed: Unknown
Age: Young
At the caseys on e 14th and Euclid
Runnells
Lost: 11/21/2016
ID: 4410
Name: Molly
Type: Dog
Color: Blonde
Breed: Cairn Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
459 se garrett dr
Altoona
Lost: 11/19/2016
ID: 4416
Name: Fat Fat
Type: Cat
Color: Tigger
Breed: Cairn Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
6930 NE 56th st Altoona he has a cricked tell at the end his 2 back feet have white very loving
Urbandale
Lost: 11/18/2016
ID: 4732
Name: Charlie
Type: Cat
Color: Black, Brown, Grey
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Very sweet, has all of his claws, please help bring him home, my kids are devastated.
Durango
Lost: 11/18/2016
ID: 4450
Name: Lovey
Type: Dog
Color: Red/Black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Neutered
Age: Senior
Last seen Friday, Nov. 18 @ 9 pm when she went out potty. She is deaf, low vision, has only a few teeth. At that time her hair was longer than photo. She had a healing sore on her left upper leg. She is friendly and would go to anyone. Reward.
Fort Dodge
Lost: 11/18/2016
ID: 4404
Name: Chloe
Type: Cat
Color: Light brown with darker brown, Black and Tan stripes
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
Last seen in Fort Dodge on 9th avenue south between 14th and 15th street near Butler school and a few blocks from Olsen Park. Her family misses her so much. Please help me bring her home!!!!
Fort Dodge
Lost: 11/18/2016
ID: 4393
Name: Chloe
Type: Cat
Color: Light brown with darker brown and black stripes
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
Last seen the morning of novemeber 18, 2016. In Fort Dosge Iowa on 9th avenue south between 14th and 15th steeet(near the Butler school area and a few blocks from Olsen Park. She has all of her claws.
Altoona
Lost: 11/18/2016
ID: 4388
Name: Murphy
Type: Cat
Color: Gray and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He has a white stomach with a gray stripe that looks like a belt.
Des Moines - West
Lost: 11/18/2016
ID: 4386
Name: Pj popcorn
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Nw 51st st by merle hay and Meredith
Monroe
Lost: 11/18/2016
ID: 4383
Name: Sunny
Type: Cat
Color: Yellow with Orange Stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen Friday night at 11 pm. He has stripes on his legs and spots on his back and belly. He is really shy with strangers and is afraid of being outside. He loves tuna.
Des Moines - East
Lost: 11/18/2016
ID: 4378
Name: Mia
Type: Dog
Color: Gold
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Young
On E 9th st Des Moines, Is 50316 by The Nursing Home .. please if anybody's Sees Her please let Me Know ASAP My Mia Is My Life
Des Moines - East
Lost: 11/18/2016
ID: 4377
Name: Mia
Type: Dog
Color: Gold
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Young
On E 9th st Des Moines, Is 50316 by The Nursing Home .. please if anybody's Sees Her please let Me Know ASAP My Mia Is My Life
Des Moines - East
Lost: 11/18/2016
ID: 4373
Name: Myah
Type: Dog
Color: White and reddish brown
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
Let her out about 9:45pm, didn't realize the front gate was open, she was gone when I went to let her in at 9:55pm.
Des Moines - South
Lost: 11/17/2016
ID: 4488
Name: Cali
Type: Cat
Color: black/brown/orange/grey
Breed: Tortoiseshell
Gender: Female
Fixed: Not Neutered
Age: Young
last seen in the neighborhood south of armypost rd and west of sw 9th. her name is Cali she is about a lil over a year old she is not fixed and she still has all her claws (front and back)
Des Moines - North
Lost: 11/17/2016
ID: 4396
Name: Bobo
Type: Cat
Color: White and brown
Breed: Tortoiseshell
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the Norwoodville area
Des Moines - East
Lost: 11/17/2016
ID: 4384
Name: Willow
Type: Dog
Color: tan
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
Was in car accident on Williams and east university and she took off north down Williams
Des Moines - East
Lost: 11/17/2016
ID: 4366
Name: Willow
Type: Dog
Color: tan
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Young
Was in car accident on Williams and east university and she took off north down Williams
Des Moines - South
Lost: 11/17/2016
ID: 4359
Name: Punkin
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
We believe he ran out when the neighborhood kids were playing and in/out of the house last night. He is very lovey, but scared around many people. He is orange with a black collar that is worn out and has a bell on it. My son was heart broken when he couldn't find him this morning.
West Des Moines
Lost: 11/17/2016
ID: 4357
Name: Tillie
Type: Dog
Color: White and Gray
Breed: Shih Tzu
Gender: Female
Fixed: Neutered
Age: Senior
Last seen 11-17 in the evening. Tillie is a small older dog she will be 15 next month. She can't hear every well and hard of seeing. She is scared easily.
Des Moines - South
Lost: 11/15/2016
ID: 4370
Name: Mr. Tippycat aka Tippy or Mr. Tippy depending on his mood
Type: Cat
Color: black, white patch on his chest and the tip of his tail is white
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
last seen running out the front door of my house, didn't come back that night like he usually does. he likes to go out and wander around / hunt for small critters.
Boone
Lost: 11/15/2016
ID: 4349
Name: Daisy
Type: Dog
Color: Yellow
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Baby
Daisy was last seen on near the Lost Lake Trailhead at Ledges State Park in Boone. After hiking we came accross people on the trail with another dog and something scared her so she slipped from her collar and ran. She is timid and shy but so sweet, Shes only a baby at 6 months. She was fixed about 3 weeks ago and her surgery scar is still visible. Her family and brother miss her. Please help!
Winterset
Lost: 11/14/2016
ID: 4391
Name: Dodge
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Adult
Posting for a friend. Dodge was last seen at his home north of winterset on Highway 169. He's wearing a red color. He's very missed by his family.
Des Moines - West
Lost: 11/14/2016
ID: 3522
Name: Kitty
Type: Cat
Color: Gray/Silver
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Young
2901 Rutland Ave DM, Very friendly, but shy at first. Never been an outside cat. 1 year old. He has a white patch on his stomach
Woodburn
Lost: 11/13/2016
ID: 4508
Name: Teacup
Type: Cat
Color: Russian Blue
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
I let him out at 4 pm on Nov. 13th and he never returned. He has never done that before. Never been out all night. I have searched everywhere for him. He is very sweet and I love him so much and miss him terribly. I have a REWARD out for him. He is declawed in the front.