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>='1581984000')) ORDER BY pm1.meta_value DESC, post_date DESC
Johnston
Lost: 8/31/2019
ID: 12269
Name: Archie
Type: Cat
Color:
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
Last seen sliding out the front door. Archie is extremely shy and any aggression will send him running. Additionally very strong.
Johnston
Lost: 8/31/2019
ID: 12268
Name: Archie
Type: Cat
Color: Gray
Breed: Unknown
Gender: Male
Fixed: Neutered
Age: Senior
Last see at front door. He slide out while I tried to keep another one I side. Archie is shy. Aggression will send him running. He's surprisingly strong
Des Moines - Central
Lost: 8/31/2019
ID: 12247
Name: Panch
Type: Dog
Color: Grey and light brown
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Young
He is very friendly
Ankeny
Lost: 8/30/2019
ID: 12246
Name: Mouse
Type: Cat
Color: Grey and white
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
We last saw her inside our house. She does not have front claws but she has her back claws. She is very friendly. This is her first time being outside.
Des Moines - Central
Lost: 8/30/2019
ID: 12241
Name: nala
Type: Dog
Color: Black and brown
Breed: Yorkshire Terrier Yorkie
Gender: Unknown
Fixed: Neutered
Age: Adult
Last seen around 8:00pm - went missing after hearing fireworks go off.
Des Moines - North
Lost: 8/30/2019
ID: 12240
Name: Harley
Type: Dog
Color: Tan/white/black
Breed: Boxer
Gender: Female
Fixed: Neutered
Age: Adult
In my backyard
Des Moines - East
Lost: 8/30/2019
ID: 12237
Name: Mac
Type: Dog
Color: Brindle
Breed: Boxer
Gender: Male
Fixed: Neutered
Age: Young
Mac ran off from Des Moines St & 21st! He is a big baby won't bite or bark. If he is seen please call or text 515-441-1325 Thank you
Manchester
Lost: 8/29/2019
ID: 13080
Name: Quinn
Type: Cat
Color:
Breed: Siamese
Gender: Female
Fixed: Not Neutered
Age: Adult
Des Moines - Central
Lost: 8/29/2019
ID: 12282
Name:
Type: Dog
Color:
Breed: Dalmatian
Gender: Male
Fixed: Not Neutered
Age: Baby
Missing from my front yard near Pennsylvania Ave. By state capitol/East Village. $$$Cash Reward$$$
Des Moines - Central
Lost: 8/29/2019
ID: 12235
Name:
Type: Dog
Color:
Breed: Dalmatian
Gender: Male
Fixed: Not Neutered
Age: Baby
Near state capitol neighborhood, Cash Reward!
Ankeny
Lost: 8/29/2019
ID: 12233
Name: Lele
Type: Cat
Color:
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Got lost at the Woodland apartment complex around 7:00am on 29th. The tip of her tail is broken. Green/yellow eyes.
Manchester
Lost: 8/27/2019
ID: 13286
Name: Quinn
Type: Cat
Color:
Breed: Siamese
Gender: Unknown
Fixed: Not Neutered
Age: Baby
Last seen by Central Park in Manchester Iowa. She has blue eyes during the day and darker eyes at night. My phone number is (563) 608-0805
Altoona
Lost: 8/27/2019
ID: 12272
Name: Autumn
Type: Cat
Color: Black, orange, and brown
Breed: Calico
Gender: Female
Fixed: Not Neutered
Age: Adult
She is pregnant, her name is autumn.
Iowa City
Lost: 8/27/2019
ID: 12270
Name: Finn
Type: Cat
Color: White and grey/brown
Breed: Domestic Short Hair
Gender: Male
Fixed: Not Neutered
Age: Baby
Last seen on corner of Muscatine ave and Scott blv
Des Moines - West
Lost: 8/27/2019
ID: 12218
Name: Nikki
Type: Dog
Color: black
Breed: Poodle
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - Central
Lost: 8/27/2019
ID: 12213
Name: Jojo And Louis
Type: Dog
Color: Brown and white/ black and white
Breed: American Bulldog
Gender: Male
Fixed: Not Neutered
Age: Adult
38th and Franklin. Both are friendly. Big but friendly
Des Moines - South
Lost: 8/27/2019
ID: 12210
Name:
Type: Dog
Color: Black
Breed: Husky
Gender: Unknown
Fixed: Unknown
Age: Adult
Not the best pictures but these dogs are out wondering the streets. They were seen at sw16th and Burnham in des Moines around 7p on 8/26 and then i spotted them on sw 14th and hackley ave going south at 1215am on 8/27. one is a husky and the other is a black what looks like to me some sort of herding dog with no tail or a short tail.
Des Moines - South
Lost: 8/26/2019
ID: 13361
Name: Rigatoni
Type: Cat
Color: Grey and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Des Moines - Central
Lost: 8/26/2019
ID: 12225
Name: Chloe
Type: Cat
Color: Grey Torti
Breed: Tortoiseshell
Gender: Unknown
Fixed: Neutered
Age: Adult
Front leg is bent funny so she walks with a limp.
Des Moines - North
Lost: 8/25/2019
ID: 12227
Name: Neko (nay-koh)
Type: Cat
Color: Beige
Breed: Siamese
Gender: Female
Fixed: Neutered
Age: Senior
Missing several days "Bobbed" tail Has all claws, skittish
Des Moines - East
Lost: 8/25/2019
ID: 12203
Name: Carlos
Type: Cat
Color: Orange
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
E 16th and Grand ave.
Palo
Lost: 8/25/2019
ID: 12200
Name: Bella
Type: Cat
Color: Grey, White & Black
Breed: Tabby
Gender: Female
Fixed: Neutered
Age: Young
Bella is an indoor cat (The one on the right) and we think she may have gotten outside somehow and maybe became spooked and ran off..She always stays near her mom, whom we have in our home as well and have not seen her since August 24th 2019. We live in Palo. Please call Bekah & Brian at 615-504-3923 if found. REWARD.
Swisher
Lost: 8/24/2019
ID: 12204
Name: no collar, on Kitten
Type: Cat
Color: dark gray tiger strip
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Young
Extremely friendly, young cat maybe a kitten 6+ months old
Des Moines - South
Lost: 8/24/2019
ID: 12199
Name: Bella
Type: Cat
Color: Black (Primary) White (Secondary
Breed: Tabby
Gender: Female
Fixed: Unknown
Age: Baby
Bella was sitting on the windowsill looking out the window screen. She saw a bird and went after it. The screen did not hold her and broke. She got spooked and ran. When she was at the Des Moines South Shelter she was named Crystal.
Des Moines - East
Lost: 8/23/2019
ID: 12190
Name: Zeke
Type: Dog
Color: Light brown pink nose
Breed: Labrador Retriever
Gender: Male
Fixed: Unknown
Age: Baby
On east 13 st Desmoines iowa