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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
Winterset
Lost: 8/30/2015
ID: 1362
Name: Luna
Type: Cat
Color: Gray, black, white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
S 8th Ave and Summit in Winterset
Winterset
Lost: 8/30/2015
ID: 1348
Name: Luna
Type: Cat
Color: Tabby/ White
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
corner of S 8th Ave and summit in Winterset Iowa
Clive
Lost: 8/30/2015
ID: 1300
Name: Charlie
Type: Cat
Color: Black & white
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
5 pm Saturday, declawed front and back, glaucoma in right eye,grumpy deminor, beloved pet
West Des Moines
Lost: 8/28/2015
ID: 1311
Name: Rowdy
Type: Dog
Color: White with black and brown spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Jumped out of car in the Valley Junction area and ran into the woods. He is very friendly and will go to anyone. He is missed very much.
West Des Moines
Lost: 8/28/2015
ID: 1310
Name: Rowdy
Type: Dog
Color: White with black and brown spots
Breed: Jack Russell Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Jumped out of car in the Valley Junction area and ran off into the woods. He is very friendly and will go to anyone. He needs to be found as he is very much missed.
Des Moines - East
Lost: 8/26/2015
ID: 1573
Name: kebe
Type: Dog
Color: brown and black
Breed: Yorkshire Terrier Yorkie
Gender: Female
Fixed: Unknown
Age: Adult
In back yard
Clarence
Lost: 8/25/2015
ID: 1307
Name: Timin
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
No tags but has phone number in permanent marker on his collar.
Des Moines - East
Lost: 8/25/2015
ID: 1282
Name: Stevie
Type: Cat
Color: White/Grey w/tiger stripes
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around 5pm on Aug 25th. Very nice, but shy and probably wont let anyone approach. Used to be a fairly regular outdoor cat until his owner passed away. Last seen on East 29th street, at the intersection of E29th and Shawnee (Norwoodville area)
Des Moines - East
Lost: 8/24/2015
ID: 1365
Name: Reggie
Type: Cat
Color: Strawberry blonde
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Pleasant Hill
Lost: 8/24/2015
ID: 1297
Name: Loki, Persephone, Thor
Type: Cat
Color: Black, calico, gray and black tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen, dropped off by my boyfriends sisters and mother........ They took them to a little gathering of homes in pleasenthill hill just up the street from E. Oakwood Dr. I think it's NE 64th or 67th. But its also by rising sun Dr. As well. One is female. The brothers are boys. They are my babies and I miss them so much. I need them back!
Pleasant Hill
Lost: 8/24/2015
ID: 1277
Name: Loki, Persephone, Thor
Type: Cat
Color: Black, calico, gray and black tiger
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Boyfriends sisters and momvstole and dropped my three kittens on the side of the road of 6th St. In pleasenthill. If you know where E. Oakwood Dr. is follow it itllvturn into rising sun dr. And ypoull see Ne 5th and then E 65th st. Theyre around there and its a short very curvy road that they dropped them off by suposedly. Its by up and coming housing and there is one all black, one calico, and one gray and black tiger. None are over six months old and none have ever been outside to hunt on their own or even been left alone before. These kittens are my fur babies and I am desperate to find them. Please please please feel free to call my mom's # 515 418 2802 her name is Catherine. Thank you!
Earlham
Lost: 8/23/2015
ID: 1386
Name: gracie and jr
Type: Dog
Color: black male and blue tri female
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Adult
they both are missing from earlham iowa they have neen gone about 3 weeks now black and white male jr he is not fixed and blue tri female who is fixed both very friendly and loving ..our family is crushed that they havent turned up please if youve seen them contact 5152183363
Earlham
Lost: 8/23/2015
ID: 1295
Name: jr
Type: Dog
Color: black wih white on chest
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
jr and my female gracie have been missing together since sunday night are family is worried sick please if you have any information please contact us thank you..both dogs are very friendly gracie that is also missing is a blue tri female that is fixed im unsure if shes microchiped because she was older when we got her
Earlham
Lost: 8/23/2015
ID: 1294
Name: gracie
Type: Dog
Color: blue tri
Breed: Pit Bull
Gender: Female
Fixed: Neutered
Age: Adult
last seen at are farm in earlham she is missing with my male dog named jr theres a post for him aswell both very friendly and very much missed please help them home
Adel
Lost: 8/23/2015
ID: 1257
Name: Luna
Type: Dog
Color: Black/Brown
Breed: Mix
Gender: Female
Fixed: Not Neutered
Age: Adult
Adel, IA Husky & Rottweiler Mix. Very Friendly. Has one blue eye
Adel
Lost: 8/23/2015
ID: 1256
Name: zeus
Type: Dog
Color: White/Beige
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Adel, IA Malamute & Great Pyrenees mix. Very Friendly.
Des Moines - South
Lost: 8/21/2015
ID: 1261
Name: Khloe
Type: Dog
Color: Grey/Brown
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
Last time seen on the south side of des Moines by se 14th and Hartford 50315. Please call 515-943-4906 if you have any information.
Des Moines - Central
Lost: 8/21/2015
ID: 1242
Name:
Type: Dog
Color:
Breed: Boston Terrier
Gender: Unknown
Fixed: Unknown
Age: Baby
Near garden nightclub
Des Moines - Central
Lost: 8/21/2015
ID: 1241
Name:
Type: Dog
Color:
Breed: Boston Terrier
Gender: Unknown
Fixed: Unknown
Age: Adult
Garden night club 9:15
Pleasant Hill
Lost: 8/19/2015
ID: 1260
Name: Sassy
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen near Copper Creek golf course. Sassy's family misses her!!! She has a white "drool" marking coming out of her bottom jaw. All four of her paws are white. She does have a chip.
Winterset
Lost: 8/18/2015
ID: 1224
Name:
Type: Dog
Color: Brown and Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
My husband found this adorable girl about an hour outside of Des Moines in Madison County. She was found on the side of a gravel road near one of his wind sites. This baby was wet and cold. He went to the nearest home to see if it belonged to the family and was told she had been running around that area for the last 3 days. My husband then called the police in Madison County who told him they don't have a shelter and no local vets will take found animals. They suggested he take her back to where he found her and hope for the best. This was uncalled for therefore my husband asked a co-worker to keep her until we can find her family or a new loving home. She is great with kids and other animals.
Ames
Lost: 8/17/2015
ID: 1231
Name: CJ
Type: Cat
Color: Gray
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen in Squaw Valley neighborhood in NW Ames. Declawed front paws. Has a slight bend at the end of his tail where it once was broken. CJ is an avid hunter and loves being outdoors, but he never fails to come for some food or treats! He's a very friendly and social cat.
Des Moines - East
Lost: 8/17/2015
ID: 1219
Name: Peanut
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
He has a crooked tail-z like. Was neutered last week. Has had rabies shot. Last seen at 3618 E 8th. He has peanut butter colored eyes. Comes when called. May have crawled in the car frame and fell out between Des Moines and Jordan Creek.
Ankeny
Lost: 8/16/2015
ID: 1243
Name:
Type: Cat
Color: Grey
Breed: Unknown
Gender: Unknown
Fixed: Unknown
Age: Adult
She? Has been in the neighborhood of nw 3rd st and college by Faith Baptist Bible College about a week. She? Is super sweet, friendly and clean to be a stray.
Ankeny
Lost: 8/16/2015
ID: 1217
Name: Coach
Type: Dog
Color:
Breed: Collie Rough
Gender: Male
Fixed: Neutered
Age: Adult
Got phone call seen him in this area at 08~17~2015 around 7to 8pm. contact 5157781736