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>='1618444800')) ORDER BY pm1.meta_value DESC, post_date DESC
Urbandale
Lost: 5/19/2020
ID: 14035
Name: Rugby
Type: Dog
Color: golden
Breed: GoldenDoodle
Gender: Male
Fixed: Neutered
Age: Young
Carlisle
Lost: 5/19/2020
ID: 14034
Name: Jack
Type: Dog
Color: Tan and black
Breed: Yorkshire Terrier Yorkie
Gender: Male
Fixed: Unknown
Age: Young
Jack slipped out the door when getting ready for bed tonight. He is 4.5lbs, 1.5yrs old and very friendly. He is wearing a collar but no tags.
Des Moines - South
Lost: 5/19/2020
ID: 14031
Name: Garfunkel
Type: Cat
Color: Black
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Tuesday morning around 9. I also call her Garf or Garfie. She is scared of strangers, but she is so important to me, please keep an eye out for her.
Ankeny
Lost: 5/18/2020
ID: 14118
Name: Duke
Type: Cat
Color: Black with a couple white spots
Breed: Bombay
Gender: Male
Fixed: Neutered
Age: Adult
Duke turned 10 years old on May 29th
Ankeny
Lost: 5/18/2020
ID: 14063
Name: Duke
Type: Cat
Color: Black with white on the chest and paws.
Breed: Bombay
Gender: Male
Fixed: Neutered
Age: Adult
Last seen at 11:30 PM of Sunday Night. Tended to be more paranoid of people he doesn't know so may just run. Very good at climbing trees and enjoyed doing it. May be treed somewhere.
Des Moines - South
Lost: 5/18/2020
ID: 14029
Name: Bella
Type: Dog
Color: White black and gray
Breed: Siberian Husky
Gender: Unknown
Fixed: Not Neutered
Age: Young
Her collar came undone , she went running around carman estate apartments the new complex on porter Ave 50320
Des Moines - South
Lost: 5/17/2020
ID: 14070
Name: Tac
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near Union and Kenyon in the wooded area along the creek.
Des Moines - South
Lost: 5/17/2020
ID: 14069
Name: Tac
Type: Cat
Color: Black
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near Union and Kenyon in the wooded area along the creek.
Iowa City
Lost: 5/17/2020
ID: 14032
Name: Lilac
Type: Cat
Color: Cream, lilac / grey - blue eyes
Breed: Siamese
Gender: Unknown
Fixed: Neutered
Age: Senior
Slipped out the door - is an indoor cat. Microchip may have our old address from Dyersville as we may have forgotten to update it
Altoona
Lost: 5/17/2020
ID: 14022
Name: Lyla
Type: Cat
Color: Dark brown
Breed: Norwegian Forest Cat
Gender: Female
Fixed: Neutered
Age: Young
Sunday morning
Ankeny
Lost: 5/17/2020
ID: 14021
Name: Koa
Type: Dog
Color: White and cream with black and grey
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Young
Our dog Koa is a husky shepherd pit bull mix. We adopted him 1 month ago and he’s about 6 months old. He’s very very skittish of people and may be hard to approach. He is not a biter! He’s not neutered yet and he’s been vaccinated. His collar is a custom beaded collar made out of leather and his name KOA is imprinted on it. We lost him 3001SE Convenience Blvd, Ankeny, IA 50021. He has been spotted near the Ankeny Airport and near the Iowa State Fairgrounds.
Ankeny
Lost: 5/17/2020
ID: 14020
Name: Koa
Type: Dog
Color: White and cream with black and grey
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Young
Our dog Koa is a husky shepherd pit bull mix. We adopted him 1 month ago and he’s about 6 months old. He’s very very skittish of humans and may be hard to approach. He’s not neutered yet and he’s been vaccinated. His collar is a custom beaded collar made out of leather and his name KOA is imprinted on it. We lost him 3001SE Convenience Blvd, Ankeny, IA 50021.888
Des Moines - North
Lost: 5/17/2020
ID: 14018
Name: Ginger
Type: Cat
Color: Calico
Breed: Calico
Gender: Female
Fixed: Unknown
Age: Baby
In our new home. She was really scared.
Boone
Lost: 5/17/2020
ID: 14016
Name: Nina
Type: Cat
Color: Orange
Breed: American Shorthair
Gender: Female
Fixed: Neutered
Age: Adult
Orange tabby. Claws on all 4 paws. Does not like strangers, may or may not respond to treats.
Indianola
Lost: 5/16/2020
ID: 14068
Name: Leo
Type: Cat
Color: Gray with white patch on chest
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Went missing from Indianola area - R63 and 103rd Ave.
Anamosa
Lost: 5/16/2020
ID: 14015
Name: Keke
Type: Dog
Color: Black/brown/tan
Breed: German Shepherd/Purebred
Gender: Female
Fixed: Not Applicable
Age: Young
Last seen around Cass township in Iowa. She is very friendly & energetic. She is approachable & will not attack.
Urbandale
Lost: 5/16/2020
ID: 14012
Name: Miley
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Female
Fixed: Neutered
Age: Adult
Lost from my yard in Urbandale by the trail. 95 and Meredith..
Eagle Grove
Lost: 5/16/2020
ID: 14008
Name: Tinkerbelle
Type: Dog
Color: Brown
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Not Applicable
Age: Baby
230 had new tshirt on just took a bath
Polk City
Lost: 5/16/2020
ID: 14006
Name: Goose “Lucy”
Type: Cat
Color: White with grey markings on face and body
Breed: Unknown
Gender: Female
Fixed: Unknown
Age: Adult
In a car accident with owner in a silver Hyundai Sonata that drove into an embankment near intersection of 35-80. Owner is in the hospital desperately searching for lost cat
Des Moines - South
Lost: 5/15/2020
ID: 14096
Name: Pearl
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen near Watrous Ave and 5th St. She is nice and kind of shy.
Des Moines - South
Lost: 5/15/2020
ID: 14095
Name: Pearl
Type: Cat
Color: Black and White
Breed: Domestic Medium Hair
Gender: Unknown
Fixed: Neutered
Age: Young
Last seen near Watrous Ave and 5th St. She is nice and kind of shy.
Spencer
Lost: 5/15/2020
ID: 14074
Name: Xavier
Type: Dog
Color: Brown/red & white
Breed: Siberian Husky
Gender: Male
Fixed: Not Applicable
Age: Adult
He was last seen at our home by Jefferson on east 9th him and our other dog were in the kennel.
Norwalk
Lost: 5/15/2020
ID: 14026
Name: Milo
Type: Cat
Color: Tiger
Breed: Siberian Husky
Gender: Male
Fixed: Neutered
Age: Adult
Very sweet, hesitant to come to strangers
Des Moines - Central
Lost: 5/15/2020
ID: 14013
Name: Winnie
Type: Dog
Color: Black with brown
Breed: Chihuahua
Gender: Female
Fixed: Not Neutered
Age: Young
Last seen 6th and ovid
Urbandale
Lost: 5/15/2020
ID: 14011
Name: Rizzo
Type: Cat
Color: Grey
Breed: Chihuahua
Gender: Female
Fixed: Neutered
Age: Young
Friday morning. She is very sweet. Loves everyone.