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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - West
Lost: 6/20/2018
ID: 8888
Name: Patty
Type: Dog
Color: Fawn/ brown w black mussle
Breed: Bull Terrier
Gender: Unknown
Fixed: Neutered
Age: Senior
She will be with a black dog she's friendly.
Des Moines - West
Lost: 6/20/2018
ID: 8887
Name: Chase
Type: Dog
Color: Black
Breed: Bull Terrier
Gender: Male
Fixed: Neutered
Age: Senior
He's blind in one eye and shoukd be with our other dog a brown n black nosed terrier
Des Moines - West
Lost: 6/20/2018
ID: 8886
Name: Chase
Type: Dog
Color: Black
Breed: Chesapeake Bay Retriever
Gender: Male
Fixed: Neutered
Age: Senior
He's blind in one eye and shoukd be with our other dog a brown n black nosed terrier
Des Moines - South
Lost: 6/20/2018
ID: 8885
Name: Chipper
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Last seen 05/25/2018 Posting a picture of what he looks like when he is sick and stops eating.. he slipped out of his collar and got out. He does look like a stray so I’m unsure if someone took him in to care from him. I’ve had him for 12 years and would really love to have him home. He has a cataract or discoloration in one eye and freckles on his nose and mouth. Please help. He is dearly missed and needs to see his vet for his thyroid problem.
Johnston
Lost: 6/19/2018
ID: 8949
Name: Mrs Norris
Type: Cat
Color: Black, gray and brown tabby
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
We just moved to Iowa from California. She’s very shy but friendly. Last seen around Enfield Dr and 93rd in Johnston
Des Moines - North
Lost: 6/19/2018
ID: 8947
Name: drifter
Type: Dog
Color: brown suger in color and white on his chest he is neuterd
Breed: Mountain Dog
Gender: Male
Fixed: Neutered
Age: Adult
his name is drifter he is from the mountains i live in woodland park colorado my brother took his girlfrind back to ther and he said drifter jumped out of truck looked for days he said and alo flyers he jumped out at 2nd av and the quick trip im comin for him if i got no respones in next day so please give him back i will find him i will not stop i will give the finder person much money drifter im comin for ya here i come flat landerz please call me 24hr please thanke youjim
Urbandale
Lost: 6/19/2018
ID: 8942
Name: Garfield
Type: Cat
Color: Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen by lake View pond at the corner of Aurora 79th st.
Leland
Lost: 6/19/2018
ID: 8891
Name: Bailey jean
Type: Dog
Color: white black
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
last seen in Leland,ia she is a epilepsy service dog, friendly but shy. please help
Des Moines - East
Lost: 6/19/2018
ID: 8881
Name: Nightmare
Type: Cat
Color: Black
Breed: German Shorthaired Pointer
Gender: Female
Fixed: Neutered
Age: Young
Last seen on 25th and Grandview Ave in East DSM.
West Des Moines
Lost: 6/18/2018
ID: 8897
Name: Phantom
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
He is sensitive to light and has never attempted to leave before.
Bondurant
Lost: 6/18/2018
ID: 8879
Name: Odie
Type: Dog
Color: Blonde
Breed: Labradoodle
Gender: Male
Fixed: Neutered
Age: Senior
Last seen north of our house at 10am. Has never wondered before and is a very friendly dog. Loves people and other animals.
Des Moines - South
Lost: 6/18/2018
ID: 8868
Name:
Type: Dog
Color: White
Breed: American Staffordshire Terrier
Gender: Female
Fixed: Not Neutered
Age: Young
Missing June 9 2018 south of county line road heading towards des Moines
Clive
Lost: 6/17/2018
ID: 9182
Name: Cosmo
Type: Bird
Color: yellow, gray, white, orange cheeks
Breed: Cockatiel
Gender: Male
Fixed: Not Applicable
Age: Young
Last seen on 78th street in Clive, IA His band number is A-0375.He has a red band. Please contact me if you find him. 515-988-6151 REWARD OF $200 WILL BE GIVEN.
Ames
Lost: 6/17/2018
ID: 8870
Name: Wolfie
Type: Dog
Color: Gray
Breed: Siberian Husky
Gender: Male
Fixed: Not Neutered
Age: Baby
Last spotted on hunziker drive in north ames, between fellows elementary, bethesda church, and grand.
Des Moines - North
Lost: 6/17/2018
ID: 8857
Name:
Type: Cat
Color: gray and white
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
Saturday 6.16.18 late afternoon
Des Moines - Central
Lost: 6/16/2018
ID: 8953
Name: Sox
Type: Cat
Color: Black n white areas
Breed: Tuxedo
Gender: Male
Fixed: Not Neutered
Age: Young
Very friendly maybe hurt on leg needs vet. He has white dot on nose. Last seen on lower beaver he is not a stray he has a home. Please help worried sick!
Swan
Lost: 6/16/2018
ID: 8927
Name: Pax
Type: Dog
Color: yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Adult
Lost dog--ran away/was taken from yard in rural Swan near the intersection of Hwy 5 and Hwy 316. Male yellow lab with blocky face; responds to Pax. Was wearing blue collar but no tags/chip. Missing since Saturday, 6/16. Reward. Please help bring my mom's dog home safely!
Des Moines - Central
Lost: 6/16/2018
ID: 8869
Name: Willa
Type: Cat
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Last seen in the Sherman Hill Neighborhood. Willa is an indoor/outdoor cat and VERY friendly.
Des Moines - South
Lost: 6/16/2018
ID: 8867
Name: Sylvester
Type: Cat
Color: Black and white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen Saturday evening. He is an outdoor cat 98% of the time, but has never missed his morning meal and usually hangs out close to the house. He has 2 strips of hair on his lower back filling in after going a little bald due to hormonal issues. He has a black dot on his nose and black patch of hair under his chin.
Des Moines - Central
Lost: 6/16/2018
ID: 8856
Name: Coco
Type: Dog
Color: Light brown, white chest
Breed: Pit Bull
Gender: Female
Fixed: Unknown
Age: Young
Slipped collar at our house new York Ave and Merle Hay near first assembly of God church
Des Moines - North
Lost: 6/16/2018
ID: 7259
Name: Boots
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Moving his w A Y down lower beaver. Very sweet young though I think lost his way.
Des Moines - East
Lost: 6/15/2018
ID: 8890
Name: Little Devil
Type: Cat
Color: Tort
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
N.E. Des Moines - Highland Park area. We didn't have him very long. She got outside overnight and we think it was because she was scared.
Cedar Falls
Lost: 6/15/2018
ID: 8873
Name: Cheezit
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
I did not lose him in iowa i lost him in nebraska on interstate 80 at the sidney eastbound rest stop about 70 miles into the state. please 200$ reward if found
Des Moines - West
Lost: 6/14/2018
ID: 8852
Name: Maddie
Type: Cat
Color: Tortoise shell
Breed: Unknown
Gender: Female
Fixed: Neutered
Age: Young
Very friendly , wearing collar with tags and bells.
Des Moines - South
Lost: 6/14/2018
ID: 8849
Name: Rowan
Type: Cat
Color: Brown and white nose
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Young