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>='1599955200')) ORDER BY pm1.meta_value DESC, post_date DESC
Des Moines - North
Lost: 8/24/2020
ID: 14823
Name: Earl
Type: Cat
Color: Gray
Breed: Russian Blue
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at The 4801 North East 14th street Des Moines QT truck stop off I-80. He has cataract in left eye.
Des Moines - North
Lost: 8/24/2020
ID: 14816
Name: Kilo
Type: Dog
Color: white , red and brown
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Young
Last seen Euclid. By harding middle school
Oelwein
Lost: 8/23/2020
ID: 14982
Name: Ghost
Type: Cat
Color: Tiger Grey/White
Breed: Domestic Short Hair
Gender: Female
Fixed: Not Neutered
Age: Adult
She has a pink beaded collar, a white flea collar, dark yellow eyes, racoon like tail and spots on her belly.
Norwalk
Lost: 8/23/2020
ID: 14817
Name: Macho
Type: Cat
Color: White with black markings
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Last seen in new development eastern part of Norwalk.
Des Moines - Central
Lost: 8/23/2020
ID: 14815
Name: Rufus
Type: Dog
Color: Brown/ white
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
Pleasantville
Lost: 8/23/2020
ID: 14813
Name: Petey
Type: Dog
Color: Orange
Breed: Chihuahua
Gender: Male
Fixed: Not Neutered
Age: Young
Disappeared from our home yard , just off Hwy 5 I Swan/Pleasantville area.
Des Moines - East
Lost: 8/23/2020
ID: 14812
Name: Waya
Type: Dog
Color: Red and white
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Des Moines - East
Lost: 8/23/2020
ID: 14810
Name: Waya
Type: Dog
Color: Orange and white
Breed: Alaskan Husky
Gender: Male
Fixed: Not Neutered
Age: Young
Fiance let him out around midnight. Somehow he got out of the yard from our house near the fairgrounds.
West Des Moines
Lost: 8/23/2020
ID: 14809
Name: Brownie
Type: Dog
Color: Browni
Breed: Chiweenie
Gender: Male
Fixed: Unknown
Age: Baby
She probably got out through the garage
Des Moines - Central
Lost: 8/23/2020
ID: 14798
Name: Max
Type: Dog
Color: Brown
Breed: Mix
Gender: Male
Fixed: Unknown
Age: Senior
8/23/2020 ran out of apt at 4400 Park Avenue around 8:00am. Very friendly
Ankeny
Lost: 8/22/2020
ID: 14803
Name: Monte
Type: Cat
Color: Orange/Yellow
Breed: Extra-Toes Cat (Hemingway Polydactyl)
Gender: Male
Fixed: Unknown
Age: Senior
My cat, Monte, is a ‘reformed’ barn cat. He is an indoor/outdoor cat that likes to roam, but usually stays on our street & is back within an hour or two. He is loved, & I’m very worried as I haven’t seen him since yesterday morning. He is a very large cat, with 6 toes on each paw, & is wearing a blue collar. We are located on the SE side of Ankeny, just off of Magazine Rd. Please reach out with any information, thank you.
Ankeny
Lost: 8/22/2020
ID: 14793
Name: Zeus
Type: Dog
Color: Black and White
Breed: Border Collie
Gender: Male
Fixed: Neutered
Age: Adult
Hes terrified of people he doesn't know. He'll mostly bark and try and run from you. He likes anything that squeaks. Last seen near delaware, at the prairie glen town homes
Dubuque
Lost: 8/21/2020
ID: 14848
Name: Fluff
Type: Cat
Color: White & Black
Breed: Border Collie
Gender: Female
Fixed: Unknown
Age: Adult
front declawed and spayed, very scared of everything
Des Moines - East
Lost: 8/21/2020
ID: 14776
Name: Tracker
Type: Dog
Color: White and Brown
Breed: Jack Russell Terrier
Gender: Male
Fixed: Neutered
Age: Adult
Near the state fairgrounds on east side of Des Moines off university ave.
Des Moines - East
Lost: 8/21/2020
ID: 14775
Name: Groot
Type: Dog
Color: Red
Breed: Shiba Inu
Gender: Male
Fixed: Not Neutered
Age: Young
By the cooper creek golf course he will run if chased he’s fast
Altoona
Lost: 8/21/2020
ID: 5902
Name: Ginger
Type: Cat
Color: White with black & orange spots
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Please bring her home 360 9th St NW
Altoona
Lost: 8/21/2020
ID: 5901
Name: Ginger
Type: Cat
Color: White with black & orange spots
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
Ginger is a small, friendly cat. We miss her bunches! Please bring her home 360 9th St NW
Avoca
Lost: 8/20/2020
ID: 14856
Name: Nemo
Type: Cat
Color: Orange/ white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Avoca
Lost: 8/20/2020
ID: 14855
Name: Nemo
Type: Cat
Color: Orange/ white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
At the flying j truck stop. Very friendly and affectionate
Avoca
Lost: 8/20/2020
ID: 14854
Name: Nemo
Type: Cat
Color: Orange/ white
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
At the flying j truck stop. Very friendly and affectionate
Dubuque
Lost: 8/20/2020
ID: 14846
Name: Lucy
Type: Cat
Color: Gray & White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Front declawed and spayed
Spirit Lake
Lost: 8/20/2020
ID: 14804
Name: Doug
Type: Dog
Color: Reddish Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Doug was hit by a car outside of our home in Spirit Lake, IA. He is a yellow lab with reddish mix. He is a wonderful dog. Medium sized.
Urbandale
Lost: 8/20/2020
ID: 14800
Name: Nemo
Type: Cat
Color: Blonde Orange
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Urbandale area near iowa school of beauty
Des Moines - Central
Lost: 8/20/2020
ID: 14790
Name: Daisy
Type: Cat
Color: Gray Tiger stripe and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home. Just moved so everything is new. Indoor cat with no claws. Friendly but may be different outside.
Des Moines - Central
Lost: 8/20/2020
ID: 14789
Name: Daisy
Type: Cat
Color: Gray tiger stripe and white
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Last seen at home. Indoor cat with no claws. We just moved so everything is new. Friendly in home but may be different outside.