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>='1632096000')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - South
Lost: 10/21/2019
ID: 12654
Name: Gracie and Lucifer
Type: Dog
Color: All black with white patch on chest and white tipped toes, Lucifer has a white streak on face
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
Friendly may be with our other dog Lucifer both black and very friendly Lucifer has a dopey look very distinctive in the face
Des Moines - North
Lost: 10/20/2019
ID: 12672
Name: Oliver
Type: Cat
Color: Black with a white belly
Breed: American Staffordshire Terrier
Gender: Male
Fixed: Neutered
Age: Young
Last seen near lower beaver
Des Moines - North
Lost: 10/20/2019
ID: 12671
Name: Oliver
Type: Cat
Color: Black with white belly
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Young
Last seen at house near lower beaver
Urbandale
Lost: 10/20/2019
ID: 12664
Name: Moxie
Type: Cat
Color: White tummy, grey, calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
near 147 th and 158th str north of Meredith drive. young kitten.
Story City
Lost: 10/20/2019
ID: 12649
Name: Mercy
Type: Dog
Color: black with brown legs
Breed: German Shepherd Dog
Gender: Female
Fixed: Neutered
Age: Senior
Mercy is friendly to people but can be dog aggressive. She was last seen chasing a deer near Pleasant Valley Drive,Story City area
Winterset
Lost: 10/20/2019
ID: 12648
Name: Mischa Ann
Type: Dog
Color: Black and Tan
Breed: German Shepherd Dog
Gender: Female
Fixed: Unknown
Age: Young
Last seen north of winterset off the cumming hiway and 185th st. We are desperate to have her home, her brother came home without her.
Grimes
Lost: 10/19/2019
ID: 12646
Name: Kiki
Type: Cat
Color: Grey and white
Breed: American Shorthair
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen at our house. She was let out at a birthday party by accident. Declawed front. Very friendly.
Johnston
Lost: 10/19/2019
ID: 12643
Name: Morty
Type: Cat
Color: Tannish orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
6460 Merle Hay Rd.
Des Moines - South
Lost: 10/18/2019
ID: 12681
Name: Zack
Type: Dog
Color: Black and brown
Breed: Yorkie Poo
Gender: Male
Fixed: Neutered
Age: Senior
Zack is friendly and loves people. At this point I think somebody is giving him shelter. If you see a dog that resembles Zack, please comment. Zack is missed greatly by his family and best dog friend. Zack may have been seen the morning of October 24th on SE 36th and Hart. He was also possible seen that same day, in the evening, on Indianola and Evergreen. Possible reward for information leading to Zack's return home.
Afton
Lost: 10/18/2019
ID: 12673
Name: Hunnydew
Type: Dog
Color: Golden brown
Breed: Pinscher-Miniature
Gender: Female
Fixed: Neutered
Age: Senior
Last seen in the fence of 902 s. Scott st afton iowa 50830 She has no teeth, is very friendly may be scared she is scared of loud noises. Has a large scar on her stomach from hysterectomy/hernia surgery she also doesnt have a docked tail
Sumner
Lost: 10/18/2019
ID: 12650
Name:
Type: Dog
Color: Black & White
Breed: Siberian Husky
Gender: Female
Fixed: Not Neutered
Age: Adult
Disappeared off our farm outside Sumner IA without a trace. Suspicioned stolen!
Des Moines - North
Lost: 10/18/2019
ID: 12645
Name: Millie
Type: Cat
Color: Grey stripes
Breed: Tabby
Gender: Female
Fixed: Not Neutered
Age: Adult
We just moved and she hasn’t been outside since. She is very timid.
Des Moines - South
Lost: 10/18/2019
ID: 12638
Name: Molly
Type: Cat
Color: White grey black
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Greys lake apartment
Des Moines - South
Lost: 10/18/2019
ID: 12637
Name: Molly
Type: Cat
Color: White black grey
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Greys lake apartment
Des Moines - South
Lost: 10/18/2019
ID: 12636
Name: Molly
Type: Cat
Color: White grey black
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at greys lake apartments
Des Moines - South
Lost: 10/18/2019
ID: 12630
Name: Zack
Type: Dog
Color: Black and brown
Breed: Yorkie Poo
Gender: Male
Fixed: Neutered
Age: Senior
Last seen running after a car. He is very friendly and won't bite. Please help us find him! He is the one in pink...
Des Moines - East
Lost: 10/18/2019
ID: 12629
Name: Chief
Type: Dog
Color: Brown and black
Breed: German Shepherd Dog
Gender: Male
Fixed: Not Neutered
Age: Baby
Out in the backyard with max a yellow mixed lab
Des Moines - East
Lost: 10/18/2019
ID: 12628
Name: Max
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Was out in the back with my roommates dog Chief who is a German Shepard
Swisher
Lost: 10/17/2019
ID: 12657
Name: Louis
Type: Cat
Color: grey and white with stripes
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
last seen between 140th st NE and James Ave. in Swisher IA
Tama
Lost: 10/16/2019
ID: 13378
Name: echo
Type: Cat
Color: orange and white
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
he has a white chin and long fluffy tail
Des Moines - West
Lost: 10/16/2019
ID: 12626
Name: Simba
Type: Cat
Color: orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
shy
Des Moines - West
Lost: 10/16/2019
ID: 12625
Name: Simba
Type: Cat
Color: orange tabby
Breed: Domestic Short Hair
Gender: Male
Fixed: Unknown
Age: Young
shy
Grand Junction
Lost: 10/16/2019
ID: 12616
Name: Isabel (Izzy)
Type: Dog
Color: Augoti or Brownish with a white tipped tail
Breed: Siberian Husky
Gender: Female
Fixed: Neutered
Age: Adult
At the corner of 14th and Hager St. E. She does not bite but she is shy.
Des Moines - Central
Lost: 10/15/2019
ID: 12607
Name: Mac
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
26th and School Street. Mac is blind. He has no eyes, so he cannot find his way home. Snuck out while we were letting the dogs out. He is an indoor cat.
Hampton
Lost: 10/14/2019
ID: 12656
Name: Chester
Type: Cat
Color: Mostly Orange with white paws
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen last Monday early in the morning around the Coonley apartments. He's mostly Orange with darker Orange Tiger strips, with white paws. He's a médium haired cat with kind of a puffier tail if that makes any sense lol.. I really need to find him..