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>='1565654400')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - East
Lost: 6/15/2018
ID: 8890
Name: Little Devil
Type: Cat
Color: Tort
Breed:
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
Indianola
Lost: 6/10/2018
ID: 8955
Name: Eli
Type: Dog
Color: Blue and White
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
Eli was last seen 5 miles south of Indianola by Lake Aquahbi, at his house. He is a big dog and can look intimidating, but very friendly with people and kids. He has taken to running off in the last two months, (will be neutered when he comes back home). He has some health issues and was on medication when he ran off, he might look or act sick but is not mean. He has a white chest and his feet are white with blue spots. His family loves him very much, please post if you spot or find him! Thank you
Des Moines - North
Lost: 6/10/2018
ID: 8875
Name: Boots
Type: Cat
Color: All Black long haired with some white and white paws
Breed: Domestic Long Hair
Gender: Male
Fixed: Not Neutered
Age: Adult
Our cat boots was last seen in our home on aurora ave, right across the street from Hoover high school. He got out out of the window screen. He has never been outside so we are worried about him dearly, he has white paws and green eyes. His neck area is white and also on chin area.
West Des Moines
Lost: 6/10/2018
ID: 8828
Name: Arya
Type: Cat
Color: Grey/Brown
Breed: Tiger
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at Wellington Apartments on 50th and EP True
Des Moines - Central
Lost: 6/10/2018
ID: 8805
Name: Rapunzel
Type: Cat
Color: Tan
Breed: Siamese
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen at 8 am. Maintenance left door open and she got out. She’s VERY sweet but shy.
Des Moines - East
Lost: 6/10/2018
ID: 8803
Name: Swisher
Type: Dog
Color: Tan and brown
Breed: Chihuahua Long Haired
Gender: Male
Fixed: Not Neutered
Age: Adult
In east end on 29th st