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>='1544054400')) ORDER BY pm1.meta_value DESC, post_date DESC
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)
Des Moines - South
Lost: 10/9/2016
ID: 4045
Name: Denali
Type: Dog
Color: White and grey
Breed: Shih Tzu
Gender: Male
Fixed: Not Neutered
Age: Young
Last seen at the Meadows apartment complex near the South ridge Mall.
Des Moines - East
Lost: 10/8/2016
ID: 4047
Name: Sophie
Type: Bird
Color: white
Breed: Chicken
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - Central
Lost: 10/6/2016
ID: 4295
Name: Odie
Type: Dog
Color: Brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - Central
Lost: 10/6/2016
ID: 4294
Name: Odie
Type: Dog
Color: Brown
Breed: Mix
Gender: Male
Fixed: Not Neutered
Age: Baby
Des Moines - South
Lost: 10/6/2016
ID: 4027
Name: KIKI
Type: Cat
Color: Multi
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
Near 421 east marion
Ankeny
Lost: 10/6/2016
ID: 4026
Name: Brady
Type: Cat
Color: White with gray spots
Breed: Domestic Short Hair
Gender: Male
Fixed: Neutered
Age: Adult
Please if anyone knows any info if you have seen him at someone else's house contact us. My daughter and I are missing Brady so much! If you have him please do the right thing and return him to us. He had a blue collar on with phone number on it. $$$REWARD$$$ 515-669-9229 or 515-313-8834
Des Moines - North
Lost: 10/5/2016
ID: 4048
Name: Gidget
Type: Cat
Color: Black and White
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Adult
Last seen in her yard in Northeast Des Moines. She's shy, has a colored speck in her left eye. Belly is completely white, head black with white stripe down nose.
Des Moines - Central
Lost: 10/5/2016
ID: 4011
Name:
Type: Dog
Color: Black brown
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
Des Moines - North
Lost: 10/4/2016
ID: 4000
Name: Grayse
Type: Cat
Color: Grey calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Last seen Early Tues morning around 57th and Urbandale. Special needs requires meds, friendly, NO tail, has claws
Des Moines - North
Lost: 10/4/2016
ID: 3999
Name: Grayse
Type: Cat
Color: Grey calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Last seen Early Tues morning around 57th and Urbandale. Special needs requires meds, friendly, NO tail, has claws
Des Moines - North
Lost: 10/4/2016
ID: 3998
Name:
Type: Cat
Color: Grey calico
Breed: Calico
Gender: Female
Fixed: Neutered
Age: Adult
Special needs, meds required, no tail, friendly, with claws, name is Grayse. Reward
Des Moines - North
Lost: 10/3/2016
ID: 4028
Name: Tessa
Type: Cat
Color: White and grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Unknown
Age: Young
She's very small, and is a little scared of people she doesn't know. She has some orange on her front paws. She had a grey collar with a bell, but she might have taken it off because she usually does that.
Des Moines - East
Lost: 10/3/2016
ID: 4019
Name: Bruce
Type: Cat
Color: Gray but belly and feet white
Breed: Unknown
Gender: Male
Fixed: Not Neutered
Age: Baby
27th and Indianapolis Ave
Cedar Rapids
Lost: 10/3/2016
ID: 4010
Name: Shennobi
Type: Bird
Color:
Breed: Quaker Parakeet
Gender: Male
Fixed: Unknown
Age: Young
10/03/2016. Green colored with white chest and a little blue in feathers bird