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>='1632009600')) ORDER BY pm1.meta_value DESC, post_date DESC
Blairstown
Lost: 8/17/2021
ID: 17523
Name: Roscoe
Type: Dog
Color: Brown and white
Breed: Mountain Cur
Gender: Male
Fixed: Not Neutered
Age: Adult
Last seen around hannen lake area.
Mason City
Lost: 8/17/2021
ID: 17503
Name: Skye walker
Type: Dog
Color: Tan
Breed: German Shepherd Dog
Gender: Unknown
Fixed: Neutered
Age: Senior
By 12 st ne and n ohio
Des Moines - North
Lost: 8/17/2021
ID: 17498
Name: Georgie
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Belle turner park north side. E 8th st. My house is next to park. Please help us get my son's kitten home she's super sweet and lovable. So much that her dog BFF is lost without her and her brother ninja is wondering everywhere meowing in search of her.
Des Moines - South
Lost: 8/17/2021
ID: 17497
Name: Harley
Type: Dog
Color: Brindle
Breed: American Bulldog
Gender: Unknown
Fixed: Not Applicable
Age: Young
South side of Des Moines on county line road by studebaker elementary school
Altoona
Lost: 8/17/2021
ID: 17492
Name: Duke
Type: Dog
Color: While with black spots
Breed: Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Baby
He is super friendly and sweet so we think someone maybe have brought him in. Please help us find him.
Bondurant
Lost: 8/16/2021
ID: 17545
Name: Tortoise
Type: Reptile
Color: Brownish
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Missing Tortoise! He is 3 years old. He is 13 lb 6 to 8 in tall and bigger around than a dinner plate. He is very friendly and loves to be pet. Someone found him and put him in the lake patoka area in Bondurant, IA last Monday. In the wild they travel 18 to 30 miles per day. He could be anywhere in Bondurant or further by now. I have put up flyers around the lake area and walked it many times. He cannot be outside below 45° I am really hoping to find him before it gets that cold out. Please check around your houses in your yards and fields. He is active in the mornings between 7:00 a.m. and noon and then again in the evenings when it starts to get cooler out usually after 6:00 p.m. this is when he has the best shot of being found walking around eating grass or walking along a sidewalk or roadway. He hides during the day when it's hot and he hides at night when he's sleeping his favorite place at home is behind the air conditioning unit. He also likes to hide in buckets that are big enough for him and he likes corners he feels safe there. There is a $200 reward for anyone that finds him alive! If found please do not pick him up from his shell only, this can seriously hurt them. Pick him up from underneath. Thank you again for all your help!
Bondurant
Lost: 8/16/2021
ID: 17530
Name: Tortel
Type: Reptile
Color: Dark and light brown
Breed: Turtle
Gender: Male
Fixed: Unknown
Age: Baby
Someone took him to lake Petoca. However they can travel 18 to 30 mi per day. He could be anywhere by now he could be in Bean fields cornfields people's backyards. He is active between 8:00 a.m. and noon. And active again from 6:00 p.m. to 8:00 p.m. he likes to hide during the day when it's hot and at night when he's sleeping. He likes to travel during the day he likes roadways sidewalks and fence lines. He cannot swim. Although he does like to soak in shallow water and drink. He hides in tall grass up against large rocks or other objects his favorite place at home is behind the air conditioning unit. He is very friendly and he loves to be pet. He is 3 years old. 13 lb. About as big as a dinner plate and 6 to 8 in tall. He is an African spurred sulcata tortoise he will live about 65 years and grow to be around 200 lb. He cannot be in temperatures below 45°. There is a $200 reward for anyone who finds him.
Waterloo
Lost: 8/16/2021
ID: 17507
Name: Dippy
Type: Cat
Color: Grey Tabby
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Adult
Dippy is a very vocal cat. May be skeptical to come to now people. She is chipped and spayed. Declawed on front paws only. Loves food so probably will come to anything.
Waterloo
Lost: 8/16/2021
ID: 17506
Name: Dippy
Type: Cat
Color: Grey Tabby
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Adult
Dippy is a very vocal cat. May be skeptical to come to new people. She is skinny. She is fixed. She is chipped. She LOVES food, including us "human" food. She's spoiled and probably would come to whatever food.
Urbandale
Lost: 8/16/2021
ID: 17494
Name: Stormy
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen out side her home near 70th and Holcomb. She is an outdoor cat.
Urbandale
Lost: 8/16/2021
ID: 17493
Name: Stormy
Type: Cat
Color: Black and white
Breed: Tuxedo
Gender: Unknown
Fixed: Neutered
Age: Adult
At home. We live on Holcomb Ave off of 70th in Urbandale
Webster City
Lost: 8/15/2021
ID: 17505
Name: MIA
Type: Dog
Color: liver & white
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Young
Last seen running in a cornfield by her home.
Des Moines - Central
Lost: 8/15/2021
ID: 17483
Name: Arthur
Type: Cat
Color: Black
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Young
Last seen early Sunday morning 8/15/21. Has a noticeable white scar/patch on the back of his neck. Very friendly but never gets outside.
Johnston
Lost: 8/15/2021
ID: 17480
Name: Zhubugou
Type: Dog
Color: Yellow
Breed: Shiba Inu
Gender: Male
Fixed: Neutered
Age: Adult
25lb shiba inu, last seen NW 54th ave and between NW 100th st and 86th street.
Des Moines - South
Lost: 8/14/2021
ID: 17482
Name: Newt
Type: Cat
Color: Grey black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Was stolen by someone in a red Chevrolet older 04-2011 malibu or impala. Couldnt see license plate. Was taken right from my driveway.
Waukee
Lost: 8/14/2021
ID: 17476
Name: Priscilla
Type: Cat
Color: Beige/brown
Breed: Himalayan
Gender: Female
Fixed: Neutered
Age: Young
Last seen at St. Boniface Church on Warrior Rd.
Waukee
Lost: 8/14/2021
ID: 17475
Name: Priscilla
Type: Cat
Color: Beige
Breed: Himalayan
Gender: Unknown
Fixed: Neutered
Age: Young
Seen at St. Boniface on Warrior. She is an indoor cat and has never been away from home.
West Des Moines
Lost: 8/14/2021
ID: 17474
Name: Lilly
Type: Cat
Color: Brownish tan tabby
Breed: Himalayan
Gender: Female
Fixed: Neutered
Age: Adult
At home in west des Moines. 1128 S Atticus Street
Ankeny
Lost: 8/13/2021
ID: 17470
Name: Lavana
Type: Cat
Color: White
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Baby
Bondurant
Lost: 8/13/2021
ID: 17468
Name: Ruby
Type: Dog
Color: Light brown and white
Breed: English Shepherd
Gender: Female
Fixed: Neutered
Age: Adult
2 miles north of Bondurant. She is a foster dog-friendly but skittish. She does not know the area at all. The contact info on her tag is not current-please call 515-442-6911 or 712-840-9067.
Des Moines - North
Lost: 8/12/2021
ID: 17465
Name: Elektra
Type: Cat
Color: Black and white. Tuxedo white paws
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
She’s a supper loving cat and comes to mama kitty or elektra kitty. She’s my husbands emotional support animal and we really need her back
Des Moines - South
Lost: 8/11/2021
ID: 17453
Name: Kain
Type: Dog
Color: Tan white
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
5:30 AM when I left my house.
Ankeny
Lost: 8/10/2021
ID: 17484
Name: Shadow
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Baby
Shy black cat, not used to being outdoors. Small tuff of white on her chest. Green eyes, Front declared, about 7 years old.
Des Moines - East
Lost: 8/10/2021
ID: 17457
Name: CESAR
Type: Dog
Color: Tan
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
Last seen, out of my house. East side by Dairy Queen by University Av. And 14th St.
Marion
Lost: 8/10/2021
ID: 17451
Name: Freddy
Type: Dog
Color: Red/White
Breed: Australian Shepherd
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in Neighborhood across from Echo hill at 8:17pm. He is hard of hearing and 14 years old. Please help!