Add Search Details

SELECT h.* ,(case country when 'US' then country else countryname end ) country FROM hotels h , categorytoproperty c WHERE enabled_status=1 && status=1 and h.original_id = c.HotelID AND c.CategoryID=414 ORDER BY star_rating desc ,name asc LIMIT 0,5

Location Positioned on the grounds of a former sugar-plantation, Aston Waimea Plantation Cottages are located on the west shore of Kauai in Waimea, Hawaii. Lush tropical forests mingle with palm-speckled beaches of black, gold, white and even green sands on the Big Island. Kilauea Volcano is in a constant state of eruption, pouring molten lava down its massive slopes and into the ocean, ultimately forming more landmass. Recreational possibilities are endless, from water sports and volleyball to waterfall hikes and cliff diving.
Features. The resort features an outdoor pool flanked by a poolside bar, a jetted tub and a large sundeck with lounge chairs. The Waimea Brewing Company is located on site and offers microbrews and great food. The Hart-Felt Massage and Day Spa offers a hydrotherapy tub, warm-stone facials and massage in a variety of settings. Barbeque grills and picnic tables are located on the property. A video library and laundry facilities are available for guest use, and complimentary wireless Internet access is offered in the breezeway.

Guest Rooms The one-, two- and three-bedroom cottages outfitted with period furnishings and wood floors. Cooking facilities include refrigerators and ranges. Other standard amenities include cable television, in-room safes, CD players, VCRs and dial-up Internet access for a fee. Bathrooms feature deep-soaking tubs.

Expert Tip. Guests get a look at prehistoric Hawaii with a walk through the Waikoloa petroglyph fields. Cinder-rock paths mark the trail, which features historic petroglyphs of animals, humans, and ocean life. Complimentary guided tours are offered from the King's Shops at Waikoloa, a mile from the villas.

Family Plan: Kids Stay, Play, and Eat Free - 2010
Book a stay now - January 2, 2011 for travel January 3, 2010 - January 2, 2011 and receive the following:

Children ages 17 and younger stay at no charge (when occupying the same room as parents or guardians and using existing bedding)

Children ages 12 and younger receive complimentary activities, meals, and merchandise (details provided at check-in)

Restrictions may apply. May be combined with other promotions.

Aloha Deals Booklet - 2010
Book a stay now - January 2, 2011 for travel January 3, 2010 - January 2, 2011 and receive an Aloha Deals Booklet featuring hundreds of dollars in savings on dining, shopping, and golf.
One booklet per room, per stay. May be combined with other promotions. Restrictions may apply.

Honeymoon Special - 2010
Book a stay now - January 2, 2011 for travel January 3, 2010 - January 2, 2011 and receive spa amenities at check-in.
Restrictions may apply. May be combined with other promotions.

Senior Special (Ages 50 and Up) - 2010
Book a stay now - January 2, 2011 for travel January 3, 2010 - January 2, 2011 and receive a box of chocolates.
One box of chocolates per room, per stay. ID may be required. Other restrictions may apply. May be combined with other promotions.

Juicy Tidbits

National Geographic Traveler says..."A cluster of authentic plantation workers' cottages from a 1900s sugar mill set in a coconut grove and furnished with period pieces. Mango, banyan, and banana trees. Surfing, snorkeling, homestyle luaus. The plantation helps support affordable worker housing, a church, and a hospital."

Juicy Details Amenties 24 Hour Security Bath: Jacuzzi/Whirlpool in Bathroom Bath: Private Bathroom Bath: Soaking Tub Beach Beachfront Hotels Beachfront Pool Bedrooms: 1 Bedroom Bedrooms: 2 Bedrooms Bedrooms: 3 Bedrooms Bedrooms: 4 Bedrooms Bedrooms: 5 Bedrooms Beds: 2 Queen Beds Beds: Rooms with King Beds Beds: Rooms with Two Beds Ceiling Fan Charm up the Wazoo Dining Area in the Room Free Parking Gardens on the Property Hairdryer Hammocks to Hang Out On Internet: Available Internet: WiFi in Public Areas Kitchen: Coffee Maker Kitchen: Full Kitchen in the Unit Kitchen: Refrigerator Laundry Room Available Maid Service Microwave No TV in the Room Non-Smoking Room Pool Pool - Outdoor Privacy Private Deck/Patio/Terrace Private Garden with Room Restaurant On Property Room Type: Beachfront Rooms Room Type: Bungalows Room Type: Cottages Room Type: Good for 2 Couples Room Type: Good for 3 Couples Room Type: Ocean View Rooms Room Type: Stand Alone Single Unit Room Type: Waterfront Rooms Spa/Massage on Property Telephone in Room Tropical Vibe Voicemail Wheelchair Accessible Rooms   Hotel Types/Categories Benefits Local Community Best Affordable Romantic Hotels Best Budget Beach Resorts Best Family Reunion Resorts Cool Hotels to Work Remotely Flip Flop Island Resorts Hawaii National Geographic Traveler Stay List - US

Live the dream at Island Hideaway Spa Resort and Marina, set on the private, virgin island of Dhonakulhi, with at least 20 untouched dive sites close to the resort, a diving school, a spa and the first marina of its kind in the Maldives. Set amongst the lush greenery or on the dazzling beach, the villas here are extremely spacious and are set well apart to provide the ultimate in privacy. Celebrate on a grand scale at the stunning Hideaway Palace, which has five separate villas surrounded by infinity pools which create the sense of floating on water. Relax in the spa, a wonderful mix of pink slate, onyx, stone, silk fabrics and waterfall walls. Ask your butler to arrange a picnic trip to a nearby deserted island or an aerial photo flight on a private plane. Then dine, over the water, at Gaafushi restaurant. Island Hideaway Spa and Resort is a luxury resort hotel on Dhonakulhi Island and is a Small Luxury Hotels of the World property.

Juicy Details Amenties 24 Hour Front Desk Air Conditioned/Climate Control Babysitting or Child Care Balcony Bath: Jacuzzi/Whirlpool in Bathroom Bath: Outdoor Bath Tub (Private to the room) Bath: Outdoor Shower (Private for the Room) Bath: Tub with a View BBQ Area Beach Bar Beach Service Beach Toys Beachfront Hotels Beachfront Pool Beachfront Restaurant Bedding: Fine Linens Bedrooms: 2 Bedrooms Beds with Views Beds: Rooms with Two Beds Bikes to Use Boat to Hotel Business Center Butler Service Childrens Playground Concierge Services Cool Bath Tubs Desk Dining Area in the Room Dock Your Boat Extra Romantic Fitness Center Internet: Broadband Access in Guest Rooms Kid Friendly Kids Menu Kitchen: Coffee Maker Marina No TV in the Room Ocean View Dining Outdoor Dining Outdoor Massage Personal Concierge Available Pool - Extra Cool Kid Pool Pool - Outdoor Poolside Food & Drink Service Privacy Private BBQ Area Private Beach Dining Private Boat Available Private Deck/Patio/Terrace Private Garden with Room Private Pool (Private Pool with the Room) Restaurant On Property Romantic Bed Room Service (24 Hours) Room Service (Limited) Room Type: Beachfront Rooms Room Type: Bungalows Room Type: Family Rooms Room Type: Ocean View Rooms Room Type: Overwater Bungalows Room Type: Thatched Roof Cottages Room Type: Villa Safe Deposit Box Sauna on Property Seaplane to Hotel Spa/Massage on Property Stunning Settings Telephone in Room Tropical Vibe Uniformed Security on Site Waterfront Hotel Dining Windows: Windows Open in the Room   Activities Badminton Canoeing Cooking Classes Volleyball Walking Wildlife - Dolphins Windsurfing Lesson Wine Tasting & Activities   Hotel Types/Categories Cool Hotels to Work Remotely