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>='1600560000')) ORDER BY pm1.meta_value DESC, post_date DESC
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.
Des Moines - East
Lost: 8/18/2020
ID: 14808
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: 14787
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 declawed. Kidney concerns and cataracts.
Colfax
Lost: 8/18/2020
ID: 14782
Name: Waylon
Type: Dog
Color: Brindle
Breed: Bulldog
Gender: Male
Fixed: Neutered
Age: Adult
Very friendly, our gate was accidentally left open and our dogs got loose. If anyone sees them or knows anything about there whereabouts please let me know. We are missing our boys so much!
Ames
Lost: 8/18/2020
ID: 14768
Name: Garfield
Type: Cat
Color: Orange
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Senior
Evening of August 18 by neighbor. He is friendly but not social. He is in bad health and needs his meds.
Des Moines - East
Lost: 8/18/2020
ID: 14763
Name: Neola
Type: Cat
Color: Dark back, white underbelly
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Senior
She's little (5-6pounds) and 18 years old but still spunky. Last saw at home on 8/18/20; assuming she went out the back door.
Urbandale
Lost: 8/18/2020
ID: 14755
Name: Marv
Type: Cat
Color: Dark gray
Breed: Sphynx (Hairless Cat)
Gender: Male
Fixed: Neutered
Age: Adult
4750 148th st Urbandale
Altoona
Lost: 8/18/2020
ID: 14752
Name: Tilly
Type: Cat
Color: Black , brown & white tabby cat
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Adult
Last night around 9:30 she got out an neighbor seen her run off with a neighborhood yellow tiger cat . She’s never got out an ran off before. She’s not people friendly . No front claws . Never been outside all night . She’s a house cat not an outdoor cat. Reward $100 still missing as of 8/22/20
Des Moines - South
Lost: 8/17/2020
ID: 14801
Name: Oz
Type: Dog
Color: White black patch on his eye
Breed: Pit Bull
Gender: Male
Fixed: Not Neutered
Age: Adult
He got out our gate around leach and Se 3rd street . Please bring him home he’s our family dog we have had him since he was a baby!
Cedar Falls
Lost: 8/17/2020
ID: 14760
Name: Jorge
Type: Dog
Color: Gray
Breed: Great Dane
Gender: Male
Fixed: Unknown
Age: Baby
Got loose from day care facility has no collar on
Des Moines - East
Lost: 8/17/2020
ID: 14751
Name: Meko
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Near E 29th & Madison Ave around 4:30 on 8/17