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
Ankeny
Lost: 9/29/2017
ID: 7043
Name: Whiskey
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
All black with white patch on his lower belly. Almost in the shape of a heart. Afraid of most people. Lost around Ankeny high school.
Clarion
Lost: 9/29/2017
ID: 6959
Name: BUSTER
Type: Dog
Color: Red
Breed: Dachshund
Gender: Male
Fixed: Not Neutered
Age: Adult
By hospital, in Clarion Iowa
Des Moines - North
Lost: 9/29/2017
ID: 6957
Name: Casper
Type: Cat
Color: White
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
38th and Adams. Very shy and may not let anybody get her.
West Des Moines
Lost: 9/29/2017
ID: 6941
Name: Kitty
Type: Cat
Color: Dark Grey Tabby
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at Cambridge Courts Apartments. Pink collar says ‘little trooper’ Has a clipped ear. 2 years old
Ottumwa
Lost: 9/29/2017
ID: 6934
Name: BANDIT
Type: Dog
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
5pm milner stteet
Ottumwa
Lost: 9/29/2017
ID: 6933
Name: BANDIT
Type: Dog
Color: Black and white
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Adult
5pm milner stteet
Des Moines - North
Lost: 9/29/2017
ID: 6932
Name: Lily
Type: Dog
Color: Reverse brindle/white
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 9/29/2017
ID: 6931
Name: Lily
Type: Dog
Color: Reverse brindle/white
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Adult
Near Madison Elementary School
Des Moines - North
Lost: 9/29/2017
ID: 6926
Name: Rajah
Type: Dog
Color: Brindle
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Young
Escaped from my backyard. Highland Park Area
Des Moines - North
Lost: 9/29/2017
ID: 6923
Name: Barkley
Type: Dog
Color: White
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Senior
8th and Franklin
Des Moines - West
Lost: 9/28/2017
ID: 7114
Name: Willow
Type: Dog
Color: Brown
Breed: Pug
Gender: Female
Fixed: Not Neutered
Age: Baby
She was last seen on the 27 of sept 27 but went missing on the 28 of sept she is brown and black
Dubuque
Lost: 9/28/2017
ID: 6961
Name: Casper
Type: Dog
Color: White
Breed: Maltese
Gender: Male
Fixed: Neutered
Age: Senior
He is a 17 year old 6lb maltese named Casper. He ran off Thursday morning from my parents house in Massey, just south of Dubuque. He is mostly blind, mostly deaf, is arthritic and does not have many teeth. I have also contacted his vet, Key West Animal Hospital, The Dubuque Humane Society, Whispurring Hope Animal Rescue and this has been posted to the Dubuque Garage Sales Facebook page and the Dubuque Pets Facebook page.
Cedar Falls
Lost: 9/28/2017
ID: 6946
Name: Daisy
Type: Cat
Color: Black and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
My toddler was playing escape artist on Thursday and managed to let Daisy out in the process. If you know anything about Daisy she DOES NOT like the wild outdoors so I didn't think to check for her when he escaped and we didn't notice her missing immediately. I will be putting up fliers and going door to door looking for her as soon as I can but until then please share this notice about her in hopes that we can find her.
Des Moines - South
Lost: 9/28/2017
ID: 6928
Name: Zoey
Type: Cat
Color: Grey and cream/orange
Breed: Tortoiseshell
Gender: Female
Fixed: Not Neutered
Age: Young
She slipped out the front door, hasn't come back, usually does.
Waukee
Lost: 9/28/2017
ID: 6916
Name: Tootsie
Type: Cat
Color: Black and brown
Breed: Tortoiseshell
Gender: Male
Fixed: Neutered
Age: Adult
Most likely would be hiding out in a garage, under a porch or on pateo furniture.
North Liberty
Lost: 9/27/2017
ID: 6942
Name: Kia
Type: Cat
Color: Brown with black stripe. White chest and feet
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Last seen at 8 am on Wednesday September 27th on Watercress Road in North Liberty Ia. He has a tummy pouch that hangs low. Head looks a little small for his body. He is heavy. He is usually scared of new things. He goes by Kia and Kiki Hims.
Indianola
Lost: 9/27/2017
ID: 6915
Name: Atilla
Type: Cat
Color: White with black markings
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Adult
He got out through a ripped screen in the screen door of our new house (which we weren't aware of) on Wednesday 9/27 between 6:00 and 8:00pm. We live near the Simpson football field. He's very, very friendly and quite talkative but he's never been outside before so he might be pretty scared.
Ankeny
Lost: 9/27/2017
ID: 6911
Name: Reggie
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen by the townhomes on the north side of town. He is very friendly and loves people. Answers to Reg or Reggie.
Des Moines - North
Lost: 9/27/2017
ID: 6907
Name: Rocky – Min Pinscher
Type: Dog
Color: Black/Brown
Breed: Pinscher-Miniature
Gender: Male
Fixed: Neutered
Age: Adult
He got out of the front door in Highland Park/Oak Park Area. Please call 515-991-2927 if you have seen him.
Des Moines - Central
Lost: 9/27/2017
ID: 6899
Name: jasmine
Type: Dog
Color: white
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Neutered
Age: Young
highland park area
Johnston
Lost: 9/27/2017
ID: 6897
Name: Bo
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Houses behind Beaver Creek Elementary
Urbandale
Lost: 9/26/2017
ID: 6914
Name: Crucio
Type: Reptile
Color: Green/Grey
Breed: Iguana
Gender: Female
Fixed: Neutered
Age: Adult
We were on vacation and our pet sitters accidentally left her latch open. She left during the downpour. Do not attempt to capture alone. Please contact us and keep an eye on her. She likes high places, trees, roofs, etc. We will come get her. She is really fast and can whip her tail and attempt to bite. She is an herbivore (plant eater). 515-635-5897 Tricia or Travis
Des Moines - Central
Lost: 9/26/2017
ID: 6905
Name: Mama
Type: Cat
Color: White and black
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
She ran out the door while we were moving. She is very shy but she does meow when she hears her name.
Des Moines - East
Lost: 9/26/2017
ID: 6896
Name: Jade
Type: Dog
Color: Blue gray
Breed: Pit Bull
Gender: Female
Fixed: Not Neutered
Age: Young
I lost my pit around 16th and Des Moines St her name is Jade she is 14 weeks I will pay 500$ to get her back please any info call 2296984
Nevada
Lost: 9/26/2017
ID: 6895
Name: Zena
Type: Dog
Color: Black and brown
Breed: German Shepherd Dog
Gender: Female
Fixed: Not Applicable
Age: Adult
Last seen at the Intersection of 3rd st. and E Avenue in Nevada she was in the parking lot of the church. She has been staying around the area where last seen and been seen three times on Westwood St. which is on the west of 3rd St. Is friendlier to Women, can be scared of men she doesn’t know. Offering a reward for safe return