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>='1543881600')) ORDER BY pm1.meta_value DESC, post_date DESC
Sioux City
Lost: 10/19/2016
ID: 4403
Name: Garfield
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Sioux City
Lost: 10/19/2016
ID: 4398
Name: Garfield
Type: Cat
Color: Orange and white
Breed: Tabby
Gender: Male
Fixed: Neutered
Age: Young
Pleasant Hill
Lost: 10/19/2016
ID: 4176
Name: Roscoe
Type: Dog
Color: Brown has stripes looks likes a pit mix with husky slim tall ears big paws
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Young
Call 515-779-9875 or 515-357-2092
Des Moines - East
Lost: 10/19/2016
ID: 4134
Name: Pete
Type: Cat
Color: Black/white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Norwoodville. Pete has 1/2 a black mustache
Des Moines - East
Lost: 10/19/2016
ID: 4133
Name: Pete
Type: Cat
Color: Black/white
Breed: Pit Bull Terrier
Gender: Female
Fixed: Unknown
Age: Adult
Norwoodville. Pete has 1/2 a black mustache
Des Moines - East
Lost: 10/19/2016
ID: 4132
Name: Pete
Type: Cat
Color: Black/white
Breed: Tuxedo
Gender: Female
Fixed: Unknown
Age: Young
She has 1/2 a black mustache
Des Moines - South
Lost: 10/19/2016
ID: 4116
Name: Ruthie
Type: Dog
Color: tan
Breed: Pug
Gender: Female
Fixed: Neutered
Age: Young
Ruthie was last seen in the Riverwoods Development on the South Side of Des Moines. She is about 15 lbs.
Clive
Lost: 10/19/2016
ID: 4114
Name: Beckham
Type: Dog
Color: black/grey spots
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
8:45 pm
Des Moines - East
Lost: 10/18/2016
ID: 4103
Name: Kamila
Type: Dog
Color: Tan
Breed: Pomeranian
Gender: Female
Fixed: Not Neutered
Age: Adult
Last seen on the east side of des moines around E 9th and fremont. She is very friendly and will come when called by her name
Bloomfield
Lost: 10/17/2016
ID: 4110
Name: Leia
Type: Dog
Color: Tri - Colored
Breed: Shetland Sheepdog Sheltie
Gender: Female
Fixed: Not Neutered
Age: Young
She is shy and will not come to you willing.
Des Moines - South
Lost: 10/17/2016
ID: 4102
Name: Jinx
Type: Cat
Color: grey/white/brown
Breed: Domestic Medium Hair
Gender: Female
Fixed: Neutered
Age: Adult
Des Moines - South
Lost: 10/17/2016
ID: 4097
Name: Clyde
Type: Dog
Color: Trip colored Brown, tan, white
Breed: Pit Bull Terrier
Gender: Male
Fixed: Not Neutered
Age: Adult
Looks mean, very friendly!!
Wapello
Lost: 10/16/2016
ID: 4140
Name: Tess
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Female
Fixed: Not Neutered
Age: Adult
Ran away from home east of Wapello. Very sweet dog. She has had puppies less than a year ago. She loves to play fetch and will try to "hide" behind anything when playing.
Waukee
Lost: 10/15/2016
ID: 4236
Name: Bridget
Type: Cat
Color: Mostly Dark grey, orange accents
Breed: Domestic Medium Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Outdoor/indoor cat well known to the neighborhood in old Waukee. Stopped coming home Saturday Oct 15.has bright yellow eyes and stripped legs. Please share- I think someone took her in, and isn't looking for an owner.
Waukee
Lost: 10/15/2016
ID: 4135
Name: Bridget
Type: Cat
Color: Grey
Breed: Domestic Medium Hair
Gender: Female
Fixed: Not Neutered
Age: Young
Bridget is an outdoor/indoor cat we've had for about 8 months. She roams old waukee a lot. She stopped coming home a week ago today. We miss her! Please let us know if you've spotted her. A couple neighbors have said they've seen her, so she is sticking close to home.
Des Moines - South
Lost: 10/15/2016
ID: 4126
Name: Kitty
Type: Cat
Color: Tortoiseshell
Breed: Tortoiseshell
Gender: Female
Fixed: Unknown
Age: Adult
Ankeny
Lost: 10/13/2016
ID: 4078
Name: Miss Mine
Type: Cat
Color: Tabby
Breed: Maine Coon
Gender: Female
Fixed: Neutered
Age: Adult
I miss her so much :(
Des Moines - Central
Lost: 10/12/2016
ID: 4657
Name: Sparky
Type: Cat
Color: Multi
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on kingman by the drake area wearing a pink collar with microchip info
Des Moines - North
Lost: 10/12/2016
ID: 4656
Name: Sparky
Type: Cat
Color: Multi
Breed: Maine Coon
Gender: Male
Fixed: Neutered
Age: Adult
Last seen on kingman around the drake area very sweet with a big busy tale he was wearing a pink collar with rinestones with his microchip information on his collar
Johnston
Lost: 10/12/2016
ID: 4077
Name: April
Type: Cat
Color: Black
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Adult
last seen inside house Wednesday evening, ran outside when door was opened. She is black with white markings on chest. Green Collar with Home Again chip #, rabies tag & Id tag with her name April & phone number to call Josh at 515/480-6801.
Davenport
Lost: 10/12/2016
ID: 4068
Name: Unknown
Type: Cat
Color: Tan, Brown, and black
Breed: Calico
Gender: Unknown
Fixed: Unknown
Age: Young
This cat looks like a calico and acts like it to. She is super cuddly. We found her on Kirkwood Ave last night around 10:00. We will keep her at our house for a couple days and then figure out what to do with her. We only took her in because she didn't seem to want much to do with the outside and didn't regard cars as a threat. Most outside cats don't just run up to you and snuggle let alone let you pick them up and follow you. Contact me if you know this animal.
Des Moines - East
Lost: 10/11/2016
ID: 4056
Name: Savannah
Type: Bird
Color: Blue
Breed: Quaker Parakeet
Gender: Male
Fixed: Not Applicable
Age: Baby
Blue Quaker parrot flew out the door 5:30 AM on east side of Des Moines, Iowa.
Conrad
Lost: 10/10/2016
ID: 4081
Name: Murphy
Type: Dog
Color: Black
Breed: Labrador Retriever
Gender: Male
Fixed: Neutered
Age: Young
Redfield
Lost: 10/9/2016
ID: 4075
Name: Grace
Type: Dog
Color: Brown / White
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Not Neutered
Age: Adult
South of Redfield on Delta Cir (rural); went missing with our other german wirehair (separate post)
Redfield
Lost: 10/9/2016
ID: 4074
Name: Jane
Type: Dog
Color: Brown
Breed: German Wirehaired Pointer
Gender: Female
Fixed: Not Neutered
Age: Adult
South of Redfield on Delta Circle (rural)