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>='1575590400')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 9/15/2019
ID: 12961
Name: Frostie
Type: Cat
Color: Black and white tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen around 86th & Meredith in Urbandale. Escaped from the cat sitters. He is used to being outdoors and may have traveled from there. He may have integrated into a colony, he may be in someone’s home...but we miss him and just want our cat home!!!
Urbandale
Lost: 9/15/2019
ID: 12827
Name: Frostie
Type: Cat
Color: Black and white tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 86th & Meredith area in Urbandale. He escaped the cat sitters and is unfamiliar with the area. He is accustomed to the outdoors & has access to Greenspace that connects all over the western metro. He is an avid hunter and loves being outside. He could be in someone’s home by now. Reward!!
Urbandale
Lost: 9/15/2019
ID: 12578
Name: Frostie
Type: Cat
Color: Black & white tuxedo
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen 86th & Meredith area in Urbandale. He escaped the cat sitters and is unfamiliar with the area. He is accustomed to the outdoors & has access to Greenspace that connects all over the western metro. He is an avid hunter and loves being outside. He could be in someone’s home by now. Reward!!
Urbandale
Lost: 9/15/2019
ID: 12369
Name: Frostie
Type: Cat
Color: Black/white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
92nd & Tanglewood dr in Urbandale- he loves to be outside and hunt in the woods.
Des Moines - East
Lost: 9/15/2019
ID: 12354
Name: Daisy
Type: Dog
Color: Tri colored
Breed: Basset Hound
Gender: Unknown
Fixed: Neutered
Age: Senior
E14th and Vine
Des Moines - Central
Lost: 9/15/2019
ID: 12352
Name: Mocha
Type: Cat
Color: Gray and cream
Breed: Maine Coon
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - Central
Lost: 9/15/2019
ID: 12351
Name: Mocha
Type: Cat
Color: Multicolor calico
Breed: Calico
Gender: Male
Fixed: Unknown
Age: Baby
Last seen this morning in the hall way if our appartment a man let him out side because he didn't know the cat was ours and lived in this building
West Branch
Lost: 9/14/2019
ID: 12365
Name: Bay
Type: Cat
Color: Orange
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
West Branch
Lost: 9/14/2019
ID: 12364
Name: Bay
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - North
Lost: 9/14/2019
ID: 12359
Name: Marcy
Type: Cat
Color: Green Tabby
Breed: Tabby
Gender: Unknown
Fixed: Unknown
Age: Young
Ankeny
Lost: 9/14/2019
ID: 12348
Name: Sarsaparilla
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
North ankeny. Has black collar with a bell and possibly an ISU bandana
Des Moines - North
Lost: 9/14/2019
ID: 12347
Name: Murphy
Type: Dog
Color: Black with brown highlights
Breed: Beagle
Gender: Female
Fixed: Not Applicable
Age: Adult
800 Block of West Euclid
Des Moines - East
Lost: 9/14/2019
ID: 12345
Name: Capone
Type: Dog
Color: Fawn
Breed: Boston Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
E 24th and walnut area please bring him back fyi
Des Moines - West
Lost: 9/14/2019
ID: 12020
Name: Frazier
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at residence 7/31/19; Salisbury Oaks neighborhood. Frazier is well fed, and very mild mannered.
Jamaica
Lost: 9/13/2019
ID: 12421
Name:
Type: Cat
Color: White
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
Des Moines - East
Lost: 9/13/2019
ID: 12400
Name: Leo
Type: Cat
Color: Tricolor
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Leo loves to jump on your shoulders and lay on your back as u walk very loving he's my therapy cat i miss him dearly he needs to come back home to us
Bondurant
Lost: 9/13/2019
ID: 12360
Name: jasmine
Type: Cat
Color: calico. brown/gray, light brown on top of head
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
she is mainly indoor cat last seen going out my front door around 10:00 pm on 9/13/19. I live in a row of townhouses across from the Brick Street Market/Cafe. She always returns between 2/5 am in the morning. I haven't seen her since she walked out the front door.
Des Moines - East
Lost: 9/13/2019
ID: 12357
Name:
Type: Reptile
Color: Orange
Breed: Iguana
Gender: Male
Fixed: Unknown
Age: Adult
Disappeared at Sleepy Hollow Ren Faire
Des Moines - South
Lost: 9/13/2019
ID: 12340
Name: Dash
Type: Dog
Color: Tan
Breed: Mix
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in the back yard , on his neck he has a mark that makes him look like a cow kind of , and he is white on the bottom
Mount Pleasant
Lost: 9/12/2019
ID: 12499
Name: Zoey
Type: Dog
Color: Brown and black
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Young
Ankeny
Lost: 9/12/2019
ID: 12336
Name: Luna
Type: Cat
Color: Mix
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Young
She is very curious and likes to speak.
Des Moines - Central
Lost: 9/12/2019
ID: 12335
Name: Corky
Type: Dog
Color: Grey
Breed: Schnauzer
Gender: Male
Fixed: Unknown
Age: Baby
Last seen at home on 51st st (just east of Merle Hay) just south of Hickman, got out of the back yard. Very friendly, but does not like to be picked up.
Des Moines - East
Lost: 9/11/2019
ID: 12410
Name: Bella
Type: Dog
Color: Grey/white/and some brown & black
Breed: Shih Tzu
Gender: Female
Fixed: Unknown
Age: Adult
Last seen by the kum&go on university and 31st street. She didn’t have her collar on at the time she got lost but she is very missed pls help :(
Ankeny
Lost: 9/11/2019
ID: 12334
Name: Gideon
Type: Cat
Color: Dark gold/orange and black
Breed: Bengal
Gender: Male
Fixed: Neutered
Age: Senior
Lives in NW Ankeny off of Georgetown Blvd, was last seen at home before sneaking out. He has a very distinct meow.
Fonda
Lost: 9/11/2019
ID: 12330
Name: Carl
Type: Dog
Color: Red
Breed: Vizsla
Gender: Male
Fixed: Neutered
Age: Young
Running up d15 outside of Fonda. He's shy and does not always like men with hats on.