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
Albia
Lost: 2/21/2018
ID: 8101
Name: Dozer
Type: Dog
Color: Red
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Baby
Dozer still hasn't returned home. We just want our best friend home. MISSING DOG: Dozer was last seen in Albia near by the fairgrounds. Went missing on February 21. If you have seen him or know any information please contact myself (641-799-8189) or my parents (641-777-6757). Please forward this message on to anyone in the Albia area.
Albia
Lost: 2/21/2018
ID: 8003
Name:
Type: Dog
Color: Red/Orange
Breed: Golden Retriever
Gender: Male
Fixed: Not Applicable
Age: Senior
Goes by dozer, doesn't have a collar, friendly dog.
Des Moines - South
Lost: 2/21/2018
ID: 7997
Name: Willow
Type: Cat
Color: Black/brown
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
Last seen on main level of our home. Front door found open from the wind (most likely) around 10:30 pm right after I got home
Des Moines - South
Lost: 2/20/2018
ID: 7991
Name: Wallie
Type: Dog
Color: Gray/black/brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Not Neutered
Age: Baby
He got out by weeks middle school in des moines on se 8th and hughes av if you have him please return him! Please call 5155373285.
Des Moines - South
Lost: 2/20/2018
ID: 7989
Name: Mika
Type: Dog
Color: Black and white
Breed: Alaskan Husky
Gender: Female
Fixed: Not Applicable
Age: Young
My baby girl Mika.... took off when my mom took her out. Couldn’t find her. She went down SE7th almost to my mckinley and went in a back yard that went down to the creeks behind the homes. She has 3 babies here at home, so if you see her please call or messGe one of us. She is micro-chipped and ARL has been notified
Pleasant Hill
Lost: 2/19/2018
ID: 7996
Name: Snickers
Type: Cat
Color: Gray and white
Breed: American Shorthair
Gender: Male
Fixed: Not Neutered
Age: Adult
5121 Magnolia dr pleasant hill Iowa
Des Moines - South
Lost: 2/17/2018
ID: 7984
Name: Simba
Type: Cat
Color: Orange white stripes
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
My cat got out yesterday afternoon off of park avenue and sw 2nd street very friendly he has a skin tag on his right ear please contact ASAP if you see him please!! 5157715903
Des Moines - Central
Lost: 2/17/2018
ID: 7980
Name: Cleo
Type: Dog
Color: White and brown
Breed: English Bulldog
Gender: Female
Fixed: Not Applicable
Age: Adult
2207 35th St. Des Moines, Is 50310
Des Moines - South
Lost: 2/17/2018
ID: 7979
Name: Spike
Type: Dog
Color: White,brown face, black/brown spot on his bottom
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Senior
On E Dunham Ave
Urbandale
Lost: 2/17/2018
ID: 7977
Name: Pickles
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in 4400 block of 67th St in Urbandale.
Des Moines - East
Lost: 2/16/2018
ID: 7973
Name: Bear
Type: Dog
Color: Orange/brown
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Young
Went missing from SE 7th and Maury, Downtown. Has orange coller and harness on, also has a tag shaped like a bone that says “Bear”
Des Moines - East
Lost: 2/16/2018
ID: 7970
Name:
Type: Dog
Color: Brown ... Gray
Breed: Chihuahua
Gender: Male
Fixed: Unknown
Age: Adult
There are 2 of them found together both boys very dirty and hungry
Des Moines - West
Lost: 2/16/2018
ID: 7969
Name: Unknown
Type: Dog
Color: Black
Breed: Chihuahua
Gender: Unknown
Fixed: Unknown
Age: Young
Found sweet thing in our back yard. 49th Street in Des Moines, south of Grand Avenue. No collar. Have alerted neighborhood via Nextdoor as well. He's enjoying some water and kennel time while we wait to hear from the owner.
Woodburn
Lost: 2/16/2018
ID: 7968
Name: Cracker
Type: Dog
Color: Golden yellow
Breed: Golden Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Was north of Woodburn, very friendly and loving
Cedar Rapids
Lost: 2/15/2018
ID: 7981
Name: Diseal
Type: Dog
Color: Liver and white
Breed: German Shepherd/Purebred
Gender: Male
Fixed: Neutered
Age: Young
Near Knapp road in Cedar Rapids
Des Moines - East
Lost: 2/15/2018
ID: 7975
Name: Snickers
Type: Cat
Color: calico
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Young
last seen by the fairgrounds when she got out. she has 4 white paws
Bondurant
Lost: 2/15/2018
ID: 7961
Name: Ollie
Type: Dog
Color: Brown, white
Breed: Beagle
Gender: Male
Fixed: Neutered
Age: Young
Was in backyard with orange/red shock collar
Des Moines - North
Lost: 2/15/2018
ID: 7960
Name: Ellie May
Type: Dog
Color: Black & Grey
Breed: Poodle
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on Beaver Avenue between Hickman Road and Beavercrest. Please return her. She has many food allergies.
Des Moines - Central
Lost: 2/14/2018
ID: 7994
Name: Collar number – 137305
Type: Dog
Color: tri color
Breed: Beagle
Gender: Male
Fixed: Unknown
Age: Adult
Found in Beaverdale Des Moines of 48th
Clive
Lost: 2/14/2018
ID: 7959
Name: Marvin
Type: Cat
Color: Gray with white boots and belly.
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Marvin in very smart and sweet. We are sure he thinks he is a dog. Often he will come if you call him by Marv or Marvcat.
St. Charles
Lost: 2/13/2018
ID: 7988
Name: Duke
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
Duke was last seen at our house on the St. Charles Highway. We haven't had any sightings of him since him taking off. He is very friendly and missed at home. He wasn't wearing his collar when he took off.
St. Charles
Lost: 2/13/2018
ID: 7987
Name: Duke
Type: Dog
Color: Chocolate
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen at our house on the St. Charles Highway. Haven't had any sightings of him since. He wasn't wearing his collar when he went missing.
Norwalk
Lost: 2/13/2018
ID: 7956
Name: Dove
Type: Dog
Color: White
Breed: American Eskimo Dog
Gender: Female
Fixed: Neutered
Age: Adult
Last seen on 45th Ave and Dakota outside of Norwalk, IA. She is shy but not a biter.
Ankeny
Lost: 2/13/2018
ID: 7953
Name: Schwartz
Type: Cat
Color: Black
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Have been on vacation since 1/26 and not sure when he got out. He responds to Kitty, raspy meow, very friendly, green eyes.
Des Moines - East
Lost: 2/12/2018
ID: 8006
Name: Toots
Type: Cat
Color: Gray an black striped
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
He was last seen on E41st he goes in an out we just moved an hes new to the area an im afraid he got lost out searching his surroundings! He never stays out more than 10-20 mins an is right back at the door wanting in.