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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Ankeny
Lost: 1/22/2017
ID: 4756
Name: Archer
Type: Cat
Color: black and caramel
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Norwalk
Lost: 1/21/2017
ID: 4752
Name: Mack
Type: Dog
Color: Briwn and white
Breed: Boston Terrier
Gender: Male
Fixed: Neutered
Age: Adult
West of Norwalk water tower about four miles. About 1 mile south of happy apple orchard.
Des Moines - East
Lost: 1/21/2017
ID: 4743
Name: Brutus
Type: Dog
Color: Brown
Breed: Bullmastiff
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen around 1:30am. He's very nice and he's probably pretty scared right now.
Des Moines - East
Lost: 1/20/2017
ID: 4782
Name: Raider
Type: Cat
Color: Black with a little white on his chest and belly
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
I last seen him playing in the back bay of our auto repair shop at 3214 E. 14th st. Des Moines. I'm missing him very badly and just want my raider baby back home.
Dubuque
Lost: 1/18/2017
ID: 4788
Name: Patrick
Type: Dog
Color: Jet black
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at guard shack in dub.ia.mother captured pic.on whispering hope rescue on same date.could be in sageville mud lake richardsville heritage trail area.loves to hunt rabbits and attention! Very friendly and beautiful.been looking about 100 miles on foot.lost other phone with his pics on it so no pics yet.please help we miss him dearly.hes the leader of the pets.thanks!
Des Moines - North
Lost: 1/13/2017
ID: 4706
Name: Toby
Type: Cat
Color: Gray and white
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Winterset
Lost: 1/12/2017
ID: 4757
Name: ?
Type: Cat
Color: Gray & white
Breed: Domestic Long Hair
Gender: Male
Fixed: Unknown
Age: Young
Chip not registered
Colo
Lost: 1/12/2017
ID: 4704
Name: Zoe
Type: Dog
Color: Tan and brown
Breed: Chiweenie
Gender: Female
Fixed: Unknown
Age: Young
Last seen in Colo by co-op
Des Moines - East
Lost: 1/11/2017
ID: 4715
Name: marley
Type: Cat
Color: smoke gray
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Young
very loveable cat all gray long hair lost over by fairgrounds north side of unviersity. he just turned 1 and is misssed by my son after having to but his dog down around christmas.
Des Moines - East
Lost: 1/11/2017
ID: 4700
Name: Molly
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Female
Fixed: Not Applicable
Age: Adult
She is very friendly and loves kids. She has a very weak stomach and can only eat certain food without getting sick!! Also she is spayed however that option not coming up on the fixed drop down
Worthington
Lost: 1/10/2017
ID: 4727
Name: Macy
Type: Dog
Color: white
Breed: Poodle Toy
Gender: Female
Fixed: Neutered
Age: Young
Ran from a farm in Worthington, IA. Last seen running west on X47. May be headed home to Cedar Rapids, IA. 5 pounds, 5 years old, spayed female. Hair is around 3-5 inches long. Docked tail. Brown eyes.
Kalona
Lost: 1/10/2017
ID: 4725
Name: Copper
Type: Dog
Color: Tan
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Redfield
Lost: 1/10/2017
ID: 4689
Name: Beans
Type: Cat
Color: Brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Senior
I posted one of these but I wasn't logged in a can't edit it sorry :( He was last seen inside, no one is sure if they let him out. He likes to hang around the Sewer Drains, and it rained the night before so we can't be sure what happened.
Redfield
Lost: 1/10/2017
ID:
Name: Beans
Type: Cat
Color: Brown
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Senior
Seen inside the house, unsure if someone let him out. He likes to sit in the sewer drain
Indianola
Lost: 1/9/2017
ID: 4695
Name: Brady
Type: Dog
Color: Mable
Breed: Collie Rough
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in his normal spot in front of our house in between Indianola and Carlisle, out by the Summerset Winery.
Ankeny
Lost: 1/9/2017
ID: 4685
Name: Abby
Type: Dog
Color: Black
Breed: Poodle
Gender: Female
Fixed: Unknown
Age: Adult
SE Deleware Ave
Ankeny
Lost: 1/6/2017
ID: 4671
Name: Max
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Adult
Around nw 70th place
Des Moines - North
Lost: 1/6/2017
ID: 4668
Name: Harley
Type: Dog
Color: Tan/white
Breed: Great Pyrenees
Gender: Unknown
Fixed: Neutered
Age: Young
Douglas and wright area. She jumped our fence. She doesn't like to be scruffed.
Des Moines - South
Lost: 1/6/2017
ID: 4667
Name: Daisy
Type: Dog
Color: Brown,white,black
Breed: Beagle
Gender: Unknown
Fixed: Unknown
Age: Baby
Lost near a school near SW14th and Geil.
Adel
Lost: 1/4/2017
ID: 4664
Name: PANCAKES
Type: Dog
Color: WHITE WITH LIVER SPOTS & TICKING
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at Doc's Hunt Club (Prospect Circle Adel, IA). He is a social dog, but slightly unsure of new situations but can be coaxed by using his name.
Panora
Lost: 1/4/2017
ID: 4662
Name: Hercules
Type: Dog
Color: Black white
Breed: German Shorthaired Pointer
Gender: Male
Fixed: Neutered
Age: Adult
10:30 pm he is very friendly and we miss him very much
Des Moines - North
Lost: 1/3/2017
ID: 4813
Name: Hercules
Type: Dog
Color: Black and white with a diamond shape on his back of his neck
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on forest ave on 4 street. He's can get scared with new people so he'll bark at you and if you come toward him might run. If you seen him text me if you seen him. Number is 515-444-6675
Des Moines - Central
Lost: 1/3/2017
ID: 4810
Name: Hercules
Type: Dog
Color: Black and white with Diamond shape on his back of his neck
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
If yiur not scared of pitbull then he'll bit a bit scared and start backing up but you are call me or text me where you lat seen him 515-444-6675
Des Moines - Central
Lost: 1/3/2017
ID: 4809
Name: Hercules
Type: Dog
Color: Black and white with a diamond shape on his back of his neck
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Don't be afraid to come up to him if you are he'll jump on you,he barks when he's scared
Des Moines - South
Lost: 1/3/2017
ID: 4669
Name: Baby
Type: Cat
Color: Grey and white
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
he has a tear on his right ear