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>='1555113600')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 6/19/2018
ID: 8881
Name: Nightmare
Type: Cat
Color: Black
Breed:
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
Des Moines - South
Lost: 6/14/2018
ID: 8848
Name: Rowan
Type: Cat
Color: Brown and white nose
Breed: Tabby
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - South
Lost: 6/14/2018
ID: 8836
Name: Taz
Type: Dog
Color: Brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen around 4 a.m. Around Southridge Mall (near SE14th & County Line Rd)
Des Moines - Central
Lost: 6/14/2018
ID: 8830
Name: Stella
Type: Dog
Color: White and liver
Breed: Brittany Spaniel
Gender: Male
Fixed: Not Neutered
Age: Young
Friendly last seen at 61st and holcombe
Russell
Lost: 6/13/2018
ID: 8858
Name: Remy Jo
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Applicable
Age: Young
In Russell Iowa on West Ames st
Altoona
Lost: 6/13/2018
ID: 8847
Name: Missy Mae
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Female
Fixed: Neutered
Age: Adult
8068 NE 38th Ave Altoona.
Des Moines - East
Lost: 6/13/2018
ID: 8827
Name: Annie
Type: Dog
Color: Tan, White, Black
Breed: Beagle
Gender: Female
Fixed: Neutered
Age: Senior
Last seen at her home located on East 38th and Tiffin Avenue on the Northeast side of Des Moines.
Waukee
Lost: 6/13/2018
ID: 8825
Name: Billy
Type: Cat
Color: Black with white stomach (Tuxedo) and white toes, extra toes on feet.
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Young
Last seen on heading east on Melrose Dr, between Winfield and Linden in Waukee
West Des Moines
Lost: 6/13/2018
ID: 8823
Name: Ace
Type: Dog
Color: Red
Breed: Pomeranian Toy
Gender: Male
Fixed: Unknown
Age: Adult