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
College Springs
Lost: 10/25/2019
ID: 12691
Name: Jack
Type: Dog
Color: Roan
Breed: Brittany Spaniel
Gender: Male
Fixed: Neutered
Age: Young
Between College Springs and Blanchard
Urbandale
Lost: 10/25/2019
ID: 12682
Name: Tiger
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Valerius elementary neighborhood
Thompson
Lost: 10/24/2019
ID: 12698
Name: Nugget
Type: Cat
Color: Orange and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
He doesn't know the town of Thompson my friend is watching him for me because my new residence does not allow cats if you see him please call me anytime
Pleasant Hill
Lost: 10/24/2019
ID: 12688
Name: Sammie
Type: Dog
Color: Blondish
Breed: Shih Tzu
Gender: Female
Fixed: Not Neutered
Age: Adult
Copper creek neighborhood, Pleasant Hill
Johnston
Lost: 10/23/2019
ID: 12683
Name: Zoe
Type: Cat
Color: Brindel
Breed: Domestic Medium Hair
Gender: Female
Fixed: Unknown
Age: Baby
Nw93 and Longview crt Johnston ia
Des Moines - Central
Lost: 10/22/2019
ID: 12661
Name: Luna
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Not Neutered
Age: Young
Very cute small and shy she goes by Luna and boonsas she has green eyes
Story City
Lost: 10/21/2019
ID: 12734
Name: Mercy
Type: Dog
Color: black with brown legs
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Neutered
Age: Senior
Ran after a deer in timber by Skunk River Greenbelt on Pleasant Valley Drive. Could have gone to a truck stop nearby on I-35 CALL KURT @515-203-6411 REWARD for safe return.
Des Moines - South
Lost: 10/21/2019
ID: 12690
Name: Loca
Type: Cat
Color: Gray, white & tan Tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
Loca was missing for 2 years, got her back on Monday & she broke out the screen & disappeared again.
Des Moines - Central
Lost: 10/21/2019
ID: 12680
Name: Sassafrass
Type: Dog
Color: Bluetick and beagle
Breed: Bluetick Coonhound
Gender: Female
Fixed: Not Neutered
Age: Baby
Got loose or took over off of 2nd and Arlington or closer to Oakland and franklin. Very friendly she's my home wirld not even 4 months yet
Des Moines - South
Lost: 10/21/2019
ID: 12655
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: Male
Fixed: Not Neutered
Age: Young
Friendly and may be with our other dog Gracie
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