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>='1596240000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Des Moines - West
Lost: 9/11/2019
ID: 12324
Name: Chunk
Type: Cat
Color: Black
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Senior
Chunk was last seen Wednesday morning in her home. She is a talkative 10 yr old short hair 11 pound lean black cat. No collar. No markings. She is friendly but doesn't like to be held. Please call if you see her.
Elkhart
Lost: 9/10/2019
ID: 12383
Name: Scrappy
Type: Dog
Color: Brian brendal and white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 9/10/2019
ID: 12323
Name: Rusty
Type: Dog
Color: Red Merle
Breed: Australian Shepherd
Gender: Male
Fixed: Not Neutered
Age: Young
He somehow escaped out of our backyard sometime after 5:00 pm on 9/10/2019.
Des Moines - East
Lost: 9/9/2019
ID: 12366
Name: River
Type: Cat
Color: Grey and White
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen right next to the Grandview college soccer field. Recently started bolting outside with the dogs. Didn’t realize he was outside and he followed us on our walk a block and a way from home before I noticed. Then the soccer players ran by and he ran to hide before I could get him.
Des Moines - Central
Lost: 9/8/2019
ID: 12325
Name: Sabbath
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Senior
Sabbath comes and goes as he pleases but has never wondered away for so long before. I’m afraid something has happened to him. He’s very friendly and comes when you call his name.
Des Moines - Central
Lost: 9/8/2019
ID: 12316
Name: Boo Boo Lucy
Type: Dog
Color: Tan
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Neutered
Age: Adult
Headed East on Guthrie Avenue. Could be in surrounding neighborhoods or made it to industrial area and train tracks
Des Moines - South
Lost: 9/8/2019
ID: 12314
Name: Lola
Type: Cat
Color: Gray
Breed: Chihuahua Short Haired
Gender: Female
Fixed: Unknown
Age: Adult
last seen Sunday evening at 6151 SE 5th St. Very friendly
Eddyville
Lost: 9/8/2019
ID: 12310
Name:
Type: Dog
Color: Tan
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Unknown
Age: Adult
On north 4th st in eddyville. 5:37 pm. Is being watched so not ran over by a car but the people are actively trying to find his owner. He has a collar but no tags
Waukee
Lost: 9/8/2019
ID: 12309
Name: Buddy
Type: Dog
Color: Black and white
Breed: Chihuahua Short Haired
Gender: Male
Fixed: Neutered
Age: Adult
Waukee , SE carefree Lane. 95 pounds. Loves people scared or other dogs.
Waukee
Lost: 9/8/2019
ID: 12308
Name: Buddy
Type: Dog
Color: Black and white
Breed: English Pointer
Gender: Male
Fixed: Neutered
Age: Adult
Waukee , SE carefree Lane. 95 pounds. Loves people scared or other dogs.
Des Moines - North
Lost: 9/7/2019
ID: 12321
Name: GrayC
Type: Cat
Color: Gray
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Does not have a tail
Des Moines - East
Lost: 9/7/2019
ID: 12299
Name: Rose
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Unknown
Fixed: Neutered
Age: Baby
On E 22ct near Dairy Zone. She isn't collared currently bc she doesn't wear a collar inside. She has a distinctive limp from trauma as a puppy.
Altoona
Lost: 9/6/2019
ID: 12339
Name: Takao
Type: Cat
Color: Tan with white stripes
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
West Des Moines
Lost: 9/6/2019
ID: 12303
Name: Bella
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
09/06/19
Waukee
Lost: 9/6/2019
ID: 12302
Name: Cleo
Type: Cat
Color: Black white brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
She was walking around 156th and Meredith.