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
Polk City
Lost: 3/22/2018
ID: 8196
Name: Zac
Type: Cat
Color: Orange/White
Breed:
Gender: Male
Fixed: Neutered
Age: Adult
Shenandoah
Lost: 3/22/2018
ID: 8179
Name: Gregory
Type: Cat
Color: Orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
Ankeny
Lost: 3/22/2018
ID: 8178
Name: Django
Type: Dog
Color: Black Grey and White
Breed: Alaskan Husky
Gender: Male
Fixed: Neutered
Age: Young
West Des Moines
Lost: 3/22/2018
ID: 8172
Name: Frank
Type: Dog
Color: Black, white
Breed: Chihuahua
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in our backyard but went under the fence.
Des Moines - South
Lost: 3/21/2018
ID: 8222
Name: Church
Type: Cat
Color: Grey
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
Around the e Emma ave between se 3rd st and south union on the Southside of des moines. Please if any one has seen him. We are having to move and would really like to have him back before we do move. We will still be in des moines. Church is my youngest son's first pet and he is really upset about him being missing.
Clive
Lost: 3/21/2018
ID: 8199
Name: Freyia
Type: Cat
Color: Orange tabby
Breed: Tabby
Gender: Unknown
Fixed: Not Neutered
Age: Young
She is very small and about 1 years old. Her name is Freyia but doesn’t answer to her name because she’s a cat. She is very loved and missed. She’s is about 3 lbs. no collar.
Des Moines - West
Lost: 3/21/2018
ID: 8175
Name: Michelle
Type: Cat
Color: Gray Tabby
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
She cannot meow so might seem like she’s hissing. Very sweet cat! Has a bell on her collar.
Des Moines - North
Lost: 3/21/2018
ID: 8174
Name: oscar
Type: Dog
Color: white, grey, black
Breed: Alaskan Malamute
Gender: Male
Fixed: Not Neutered
Age: Adult
last seen around 46th st by meredith st.
Urbandale
Lost: 3/21/2018
ID: 8173
Name: ROWAN
Type: Cat
Color: Orange Tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
He is a foster kitty for Panora P.E.T.S. and escaped from his foster home. He has a very husky build and his right ear is ear notched. He will be very scared and will not liked to be picked up. Lost around the Urbandale High School area (76th & Winston).
Des Moines - Central
Lost: 3/21/2018
ID: 8170
Name: Gerald
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
He usually gets to go out and returns within a few hours. Very nice cat that does not usally bite or scratch but is kinda shy. Hes been gone for 7+hours which is unusual. He loves attention and treats.
Des Moines - South
Lost: 3/21/2018
ID: 8169
Name: Ranger
Type: Dog
Color: Black
Breed: Pit Bull
Gender: Male
Fixed: Unknown
Age: Young
Last seen around 5:00pm on Wednesday 3/21/18 on the South side, corner of Leach and SW 9th. We also call him Ranger Danger.
Des Moines - Central
Lost: 3/19/2018
ID: 8198
Name: Diesel
Type: Dog
Color: Brindel
Breed: American Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Some mean lady had my baby, if u have him please we are begging for our family back
Des Moines - East
Lost: 3/19/2018
ID: 8166
Name: Spitfire
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 3/19/2018
ID: 8160
Name: Paco
Type: Dog
Color: White and black
Breed: Terrier
Gender: Male
Fixed: Neutered
Age: Senior
Urbandale
Lost: 3/19/2018
ID: 8158
Name: Benny
Type: Cat
Color: Brown/black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Found!!!
Victor
Lost: 3/18/2018
ID: 8204
Name: Boots
Type: Cat
Color: Brown tiger with white front toes & white back feet, white patches on chest & tummy
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
We're missing our big tiger boy! Boots is a large, handsome, smart, friendly cat with a funny high voice, not your average "meow". He's around 5 years old & has been neutered and vaccinated since we adopted him 2+ years ago. He's a "farm smart" indoor/outdoor cat, very friendly. He gets along well with other kitties & our dog. He was last seen near B Ave./V-38 south of the I-80 Victor exit at 270th St. We're heartbroken and really want him home & safe. There's a chance he went "visiting" & since he's very friendly, he could have been transported out of our area if somebody picked him up and took him to a new home. Thank you very much for your help, please get in touch ASAP if you've seen or heard anything about our Boots!
Defiance
Lost: 3/18/2018
ID: 8159
Name: Baby girl
Type: Cat
Color: Black and white
Breed: Unknown
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen in side think she slipped out when my.husband let the dog out
Des Moines - East
Lost: 3/18/2018
ID: 8157
Name: Pickles Henry
Type: Cat
Color: Brown black stripes white paws
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in our yard 3/18 evening
Stuart
Lost: 3/17/2018
ID: 8171
Name:
Type: Dog
Color: Black and white
Breed: Border Collie
Gender: Unknown
Fixed: Unknown
Age: Adult
Cedar Rapids
Lost: 3/17/2018
ID: 8165
Name: VJ
Type: Dog
Color: Black
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Young
Lost in wal-mart parking lot. Black with white belly
Urbandale
Lost: 3/17/2018
ID: 8154
Name: Cisco
Type: Cat
Color:
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Young
Last seen around Madison Avenue and Patricia drive. He’s friendly, fully clawed but they are trimmed.
Sutherland
Lost: 3/16/2018
ID: 8163
Name: Bridger
Type: Dog
Color: Black w/ some caramel and a touch of white
Breed: Bluetick Coonhound
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen Friday, March 16th close to our home. We live Northeast of Sutherland. He has been gone for a few days so we are sure he is scared to death by now! However, he is a total sweetheart and has never had a mean bone in his body around people so if you see him don't be afraid to try to help him and get a hold of us right away! Call 515-408-7085 or 712-346-7757..thank you!
Melcher-Dallas
Lost: 3/16/2018
ID: 8156
Name: Diesel
Type: Dog
Color: White
Breed: Great Pyrenees
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen on Perry Dr. between Melcher and Pleasantville. He broke his chain so most likely he is dragging it. He’s friendly but most likely scared.
Grimes
Lost: 3/16/2018
ID: 8145
Name: Molly
Type: Cat
Color: White & Tabby
Breed: Great Pyrenees
Gender: Female
Fixed: Not Neutered
Age: Young
Molly has a funky face and 6 toes on each paw. Our door blew open overnight & a few of our pets got out. Molly is the only one who hasn’t returned. Please help us find our baby! Last seen in our home in Grimes.
Ankeny
Lost: 3/15/2018
ID: 8149
Name: Capree Dawn
Type: Cat
Color: Buff (orange)
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Young
Capree escaped outside when leaving out the door. We just moved to the area a couple months ago.