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>='1618272000')) ORDER BY pm1.meta_value DESC, post_date DESC
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
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.
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.
Cedar Rapids
Lost: 8/20/2020
ID: 14788
Name: Fearah
Type: Cat
Color: Gray and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Adult
Urbandale
Lost: 8/20/2020
ID: 14786
Name: Nemo
Type: Cat
Color: Blonde Orange
Breed: Tabby
Gender: Male
Fixed: Unknown
Age: Young
Karen Acres area
Urbandale
Lost: 8/20/2020
ID: 14785
Name: Nemo
Type: Cat
Color: Blonde Orange
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen Aug. 20 morning, i live in urbandale near iowa school of beauty
Des Moines - South
Lost: 8/20/2020
ID: 14774
Name: Weezy
Type: Dog
Color: Black/grey muzzle
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
He is very friendly towards people
Correctionville
Lost: 8/20/2020
ID: 14771
Name: Callie
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Adult
She was last seen inside our house but not knowing she got out she has never been outside before and she is in heat right now!
Des Moines - West
Lost: 8/19/2020
ID: 14826
Name: Linda
Type: Cat
Color: Grey
Breed: Unknown
Gender: Unknown
Fixed: Neutered
Age: Adult
Near valley junction area and Creston Ave. We just moved and she slipped out when workers were in the house.
Colfax
Lost: 8/19/2020
ID: 14780
Name: Ruger
Type: Dog
Color: Silver
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
Grimes
Lost: 8/19/2020
ID: 14770
Name:
Type: Dog
Color:
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Baby
1250 SE 11th Grimes,Ia 50111
Tama
Lost: 8/19/2020
ID: 14759
Name: Donny
Type: Cat
Color: Orange Tabby
Breed: American Shorthair
Gender: Male
Fixed: Neutered
Age: Young
He’s been missing since July 17th. A family member lost him and didn’t let us know. He was sent to a place where he wouldn’t adapt very well and he ran away. He is friendly and raised an indoor cat.
Des Moines - East
Lost: 8/18/2020
ID: 14991
Name:
Type: Cat
Color:
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
$100 reward if returned alive. Lost cat; last seen 8/18 South of Easton Blvd on E.40th CT in Des Moines. 18 years old, microchipped.
Des Moines - East
Lost: 8/18/2020
ID: 14893
Name:
Type: Cat
Color:
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
$100 reward if returned alive. Lost cat; last seen 8/18 South of Easton Blvd on E.40th CT in Des Moines. 18 years old, microchipped, spayed and front declawed. Kidney concerns and cataracts.
Des Moines - East
Lost: 8/18/2020
ID: 14867
Name: Neola
Type: Cat
Color:
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
Lost cat; last seen 8/18 South of Easton Blvd on E.40th CT in Des Moines. 18 years old, microchipped, spayed and front declawed. Kidney concerns and cataracts.
Des Moines - East
Lost: 8/18/2020
ID: 14832
Name: Neola
Type: Cat
Color:
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
Lost cat; last seen 8/18 South of Easton Blvd on E.40th CT in Des Moines. 18 years old, microchipped, spayed and front declawed. Kidney concerns and cataracts.
Des Moines - East
Lost: 8/18/2020
ID: 14819
Name: Neola
Type: Cat
Color:
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Senior
Lost cat; last seen 8/18 South of Easton Blvd on E.40th CT in Des Moines. 18 years old, microchipped, spayed and front declawed. Kidney concerns and cataracts.