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>='1549756800')) ORDER BY pm1.meta_value DESC, post_date DESC
Redfield
Lost: 3/31/2016
ID: 2609
Name: JJ
Type: Dog
Color: Brown, Black, White
Breed: Poodle Miniature
Gender: Male
Fixed: Not Neutered
Age: Baby
Has a shaved face and the rest of his hair is long.
Redfield
Lost: 3/31/2016
ID: 2608
Name: Chevy
Type: Dog
Color: White
Breed: Husky
Gender: Female
Fixed: Not Neutered
Age: Young
Chevy has blue eyes. Had on a case international collar when she ran away.
Des Moines - South
Lost: 3/31/2016
ID: 2579
Name:
Type: Dog
Color: Black
Breed: Husky
Gender: Male
Fixed: Unknown
Age: Adult
Last seen on the Johnson street block near the blank park zoo
Des Moines - East
Lost: 3/30/2016
ID: 2581
Name: luka
Type: Cat
Color: black and white tuxedo
Breed: Husky
Gender: Male
Fixed: Not Neutered
Age: Young
He was last seen outside my house hes very nice and loving
Ankeny
Lost: 3/30/2016
ID: 2578
Name: Tawnie
Type: Dog
Color: White with apricot spots
Breed: Mix
Gender: Female
Fixed: Neutered
Age: Senior
She is a Cavachon. She has one ear that is shorter than the other.
Adair
Lost: 3/30/2016
ID: 2566
Name: Lilly
Type: Dog
Color: white with light tan on face.
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Neutered
Age: Baby
On Iowa I80 At rest area A2 in Adair. Lilly was traveling to Colorado with her Dad Alan Craig in an R.V. from Vermont. He stopped at the rest area for some sleep and took his other dog out at 12:30 am and thinks Lilly slipped out. He did not realize she was missing right away.
Adair
Lost: 3/30/2016
ID: 2565
Name: Lilly
Type: Dog
Color: white with light tan on face.
Breed: Chihuahua Short Haired
Gender: Unknown
Fixed: Neutered
Age: Baby
On Iowa I80 At rest area A2 in Adair. Lilly was traveling to Colorado with her Dad Alan Craig in an R.V. from Vermont. He stopped at the rest area for some sleep and took his other dog out at 12:30 am and thinks Lilly slipped out. He did not realize she was missing right away.
Cedar Falls
Lost: 3/29/2016
ID: 2574
Name: Cali
Type: Cat
Color: White/Gray
Breed: American Shorthair
Gender: Female
Fixed: Unknown
Age: Young
Left eye tends to water and build up. Small, real friendly cat
Greenfield
Lost: 3/28/2016
ID: 2570
Name: Nashville
Type: Dog
Color: Brown black
Breed: Coonhound
Gender: Male
Fixed: Not Neutered
Age: Baby
He is An amazing puppy he got out the door the 28 and we have t been able to find him he has always been an inside dog since we have had him and I don't think he can survive out side very long
Prairie City
Lost: 3/26/2016
ID: 2548
Name: Sadie
Type: Pig
Color: Black with white stripe
Breed: Unknown
Gender: Female
Fixed: Not Neutered
Age: Adult
This pig is very tame. She usually comes right to me when called for. She likes her ears scratched and will roll on her tummy. She is a little intimidating, as probably weighs about 400 lbs.
Urbandale
Lost: 3/26/2016
ID: 2545
Name: Miss Kitty
Type: Cat
Color: Grey
Breed: Domestic Short Hair
Gender: Female
Fixed: Neutered
Age: Young
Last seen Saturday night in Lockner Drive area of Urbandale.
Bagley
Lost: 3/25/2016
ID: 2683
Name: Bella Fi Fi
Type: Dog
Color: tan and black
Breed: Beagle
Gender: Female
Fixed: Not Neutered
Age: Adult
Des Moines - Central
Lost: 3/25/2016
ID: 2547
Name: Rory
Type: Dog
Color: Tan with black on his back.
Breed: Norwegian Elkhound
Gender: Male
Fixed: Neutered
Age: Senior
Last seen in front yard during day. He is very friendly and will not bite anyone if they come close, has intimidating bark but really 100% not a biting dog. Has arthritis so I kinda waddles.
Des Moines - West
Lost: 3/23/2016
ID: 2569
Name: Henry
Type: Cat
Color: Black/white
Breed: Tuxedo
Gender: Male
Fixed: Unknown
Age: Adult
Indoor/outdoor cat. Last seen going outside for his morning walk.
Des Moines - West
Lost: 3/23/2016
ID: 2568
Name: Henry
Type: Cat
Color: Tuxedo
Breed: Tuxedo
Gender: Male
Fixed: Neutered
Age: Adult
Waukee
Lost: 3/23/2016
ID: 2533
Name: Bear
Type: Dog
Color: Brown & Black
Breed: German Shepherd Dog
Gender: Male
Fixed: Unknown
Age: Baby
German Shepard puppy last seen in Waukee. Bear was taken from backyard on Wednesday the 23rd. Reward offered, contact 515-554-1317.
Pleasant Hill
Lost: 3/22/2016
ID: 2546
Name: Cheeto
Type: Cat
Color: orange
Breed: Domestic Medium Hair
Gender: Male
Fixed: Neutered
Age: Adult
last seen at home in south east Pleasant Hill friendly and has his claws
Altoona
Lost: 3/21/2016
ID: 2515
Name: Lu
Type: Cat
Color: brown/black
Breed: Siamese
Gender: Male
Fixed: Neutered
Age: Adult
hes apart of the family & we miss him bunches! we're moving soon, out of altoona.
Des Moines - Central
Lost: 3/20/2016
ID: 2504
Name: Dutchess
Type: Dog
Color: Fawn
Breed: Siamese
Gender: Female
Fixed: Not Neutered
Age: Baby
She snuck out the screen door in drake neighborhood near kingman
West Des Moines
Lost: 3/19/2016
ID: 2561
Name: ACE
Type: Cat
Color: Black and white
Breed: Domestic Long Hair
Gender: Male
Fixed: Neutered
Age: Adult
He was lost in area of 49th Street in West Des Moines. He has a black do on his face that looks like he is smoking a cigar. He shy of people.
Des Moines - Central
Lost: 3/19/2016
ID: 2497
Name: Mara
Type: Dog
Color: Black with white patch on chest
Breed: Mix
Gender: Female
Fixed: Unknown
Age: Adult
Last seen around noon, Friday march 19th. Responds to mara, loves to be pet and scratched. Please call 515-664-9918 if you see or find her
Spirit Lake
Lost: 3/18/2016
ID: 2649
Name: Bo
Type: Dog
Color: Yellow
Breed: Labrador Retriever
Gender: Male
Fixed: Not Neutered
Age: Young
He has no dew claws. Please if anyone has seen him or taken him, we really need him back. He has been a wonderful addition to our family and means a lot to us! Anyone with any information is asked to contact Dawn at 507-841-1295 or Perry at 507-360-9485. Thanks Note from Denise: He is very important to the entire family. I gave him to Dawn at the toughest point in her cancer battle. She had been in the hospital for 17 days with a bowel obstruction and throwing up everyday until the 18th of June when she endured a 4 1/2 hour surgery to repair the obstruction and more signs of cancer were found. It was by far her most difficult recovery. She came home about 2 weeks after the surgery on a Saturday evening. And awoke on Sunday morning to learn that Jan Bakalyers sweet daughter Shelly had died from her battle with colon cancer. Dawn became very depressed and cried all the time. I was racking my brain trying to think of something that would help lift her spirits and bring her out of it. Then one day I happen to see yellow labs for sale on Facebook. The seller just happened to be a nurse that I knew from Hartley. I debated briefly...but not long because it just so happened Colton wanted a yellow lab. I was also desperate to find something to help my sister.....I had tried all the other tricks up my sleeve. I walked in to the house that Saturday and Dawn was on the phone with a friend. She hung up the phone and just started crying. I had my grandson Caleb standing outside with the puppy so I went to the door and said Caleb....you can come in!!!! Dawns heart melted on sight!!!! And yes, she turned a corner that day!!!! She's not over her battle with cancer but she's stronger than ever. Her oncologist has told us more than once that if you have ovarian cancer and you develop a bowel obstruction your gone in 60 days. That bowel obstruction was in June of 2014. The battle continues and Bo's gentle presence has brought great joy and comfort to Dawn and the entire family. I will not give up the hunt for Bo....he is indeed a "therapeutic" dog. Please call or return him if you know where he is. His presence is greatly missed.
Des Moines - South
Lost: 3/18/2016
ID: 2490
Name: Grace
Type: Dog
Color: White with brown spot
Breed: American Bulldog
Gender: Female
Fixed: Neutered
Age: Senior
She broke her rope around 6 pm she is old and needs to be home
Rome
Lost: 3/17/2016
ID: 2509
Name: Cricket
Type: Dog
Color: black with white belly
Breed: Shiba Inu
Gender: Male
Fixed: Not Neutered
Age: Baby
he went into the woods near the skunk river
Rome
Lost: 3/17/2016
ID: 2508
Name: Cricket
Type: Dog
Color: black with white underbelly and paws
Breed: Shiba Inu
Gender: Male
Fixed: Not Neutered
Age: Baby
He got off his chain and ran into the woods, cant find him since. Hasnt had shots, hes almost sixth months and a very smart dog