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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
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
West Des Moines
Lost: 6/13/2018
ID: 8822
Name: Ace
Type: Dog
Color: Tan
Breed: Pomeranian Toy
Gender: Male
Fixed: Neutered
Age: Young
Been gone for 3 hours
West Des Moines
Lost: 6/13/2018
ID: 8821
Name: Ace
Type: Dog
Color:
Breed: Poodle Toy
Gender: Male
Fixed: Unknown
Age: Adult
Des Moines - North
Lost: 6/12/2018
ID: 8843
Name: Drake
Type: Cat
Color: Grey/Black stripe
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Young
Front declawed. Very, very missed!
Bevington
Lost: 6/12/2018
ID: 8818
Name: Nellie
Type: Dog
Color: White
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
last seen our Lab at home has never left area, live off of Warren Ave and 178th Ct 2 miles North of Hwy 92 in Bevington. Very friendly and loves kids
Des Moines - East
Lost: 6/12/2018
ID: 8816
Name: Ravin
Type: Dog
Color: Blue
Breed: Pit Bull
Gender: Unknown
Fixed: Not Neutered
Age: Adult
She ran out back door jumped fence
Des Moines - South
Lost: 6/12/2018
ID: 8813
Name: Benny
Type: Dog
Color: Brown, Black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Neutered
Age: Adult
We just got him so he is in an unfamiliar area.
Des Moines - North
Lost: 6/11/2018
ID: 8815
Name: Duke
Type: Dog
Color: Brown
Breed: Boxer
Gender: Male
Fixed: Not Neutered
Age: Young
@ 809 need Broadway Ave between need 14th and 2nd Ave he's has one brown eye and a white eye please call 515-380-6572 or 515-865-8995
Wilton
Lost: 6/11/2018
ID: 8812
Name: SKYLAR
Type: Dog
Color: White
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
In backyard pretty sure she was stolen