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=245 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

Rockhouse hotels is a member of Design Hotels TM. Including villas comprised of several air conditioned, thatch roofed, octagonal cottages of timber and stone including private sun bathing decks. Built along either the waters edge for privacy or hidden in a jungle of exotic gardens. Lazy ceiling fans and large four-poster beds with mosquito netting reflect the laid back atmosphere. The cliffside freshwater pool was carved from solid rock, as were the ladders and stairs that lead down into Pristine Cove for swimming and snorkeling. The wood-hewn terraced restaurant and bar offers some of the best food in Negril, a new Jamaican cuisine featuring the flavorful spice of curries and the sweetness of tropical fruits. The restaurant is suspended directly over the water making it one of the best places to watch the sun go down.

Juicy Tidbits
Travel + Leisure says..."This ultrahip hangout takes its name from its cluster of thatched-roof bungalows built atop rock cliffs that jut just above an aquamarine cove. Most of the 34 so-called rock houses are outfitted with private patios or sundecks; a few have private ladders leading right down into the sea. With four-poster beds made of local timber and covered in the softest linens, soaring ceilings, and giant windows facing the sea or gardens, the rooms encourage ordering breakfast in bed before venturing out for snorkeling in the sheltered waters of the reef or an “On the Rocksa massage in the new open-air, cliff-top spa.Tip: The hotel funds The Rockhouse Foundation, which provides resources and facilities to Jamaican children; ask the front desk to help arrange a trip to a local school, where guests can donate supplies like notebooks and pens.Room to Book: An oversize Premium Villa for the killer sunsets every night.Why It's a Bargain: Your dollars do double duty; your vacation helps build and repair local schools and expand libraries. Since 2004, the Rockhouse Foundation has donated over $500,000 to its community."-From www.travelandleisure.com

Juicy Details Amenties 24 Hour Front Desk 24 Hour Security Air Conditioned/Climate Control Balcony Bath: Outdoor Shower (Private for the Room) Business Center Concierge Services Fitness Center Green Hotel Internet: Available Internet: WiFi in Public Areas Laundry Room Available Maid Service News Stand Outdoor Massage Pool Private Deck/Patio/Terrace Restaurant On Property Romantic Bed Room Service (Limited) Room Type: Ocean View Rooms Room Type: Swim Up Rooms Room Type: Thatched Roof Cottages Room Type: Villa Safe Deposit Box Stunning Settings Telephone in Room View: Rooms with Ocean View View: Rooms wtih Water Views Wake-up Service   Activities Snorkeling Yoga   Hotel Types/Categories Bang for the Buck Hotels Benefits Local Community Best Affordable Caribbean Best Affordable Romantic Hotels Best Budget Beach Resorts Best Honeymoon Resorts Best Romantic Hotels Best Spa Hotels Boutique Hotels Caribbean Eco Friendly Green Hotels Hip Hotels Travel and Leisure Best Affordable Caribbean Travel and Leisure Top Affordable Beach Resorts

Oceanfront on the best stretch of world-famous Kaanapali Beach. The 430-room low-rise Kaanapali Beach Hotel is recognized as the Most Hawaiian Hotel in the State. Guest Rooms overlook tropical gardens to the beach and feature Hawaiian quilts-tropical furnishings-and conveniences including coffee and tea service-hairdryer-iron and ironing board-mini fridge-cable TV-and in room internet access. Complimentary welcome breakfast-childrens program-nightly hula show-Hawaii regional cuisine-and an extensive offering of ocean sports and cultural activities make each day a fun-filled value packed Hawaiian experience. Package reservations require full prepayment of package rate and tax to confirm. DOWNTOWN IS APPROX 4. 0MI / 4. 8KM.

Juicy Tidbits
National Geographic Traveler says...
"Four buildings with roomy rooms (400+ square feet [37+ square meters] apiece) outfitted with loads of comforts (including complimentary Kona coffee, the local brew). Strong on Hawaiian culture: Learn how to play the ukulele; leaf-printing; lei-making. Take a self-guided walk or a swim in the whale-shaped pool. Extensive community and preservation involvement. 432 rooms

Juicy Details Amenties 24 Hour Front Desk Babysitting or Child Care Balcony Barber/Hair Stylist Beachfront Hotels Bedrooms: 1 Bedroom Beds with Views Beds: Rooms with King Beds Beds: Rooms with Two Beds Business Center Cable/Satellite TV Complimentary Breakfast Concierge Services Connecting Rooms Cool Pool Views Golf Course on Property Internet: Available Internet: High Speed Outlet in Room Kid Friendly Kids Menu Kitchen: Coffee Maker Kitchen: Refrigerator Live Music on Property Meeting Facilities Outdoor Dining Pool Restaurant On Property Room Type: Beachfront Rooms Room Type: Family Rooms Room Type: Ocean View Rooms Safe Deposit Box Safe: In-Room Safe Telephone in Room View: Rooms with Ocean View View: Rooms wtih Water Views   Activities Boogie Boarding Golf Guided Nature Walk Helicopter Excursion Hiking Jetboating Kayaking Kids Activites/Club Ping Pong Putting Green Stargazing Surfing Surfing Lessons Volleyball Walking Wildlife - Birds Wildlife - Dolphins Wildlife - Turtles Wildlife - Whales Zip Line   Hotel Types/Categories Benefits Local Community National Geographic Traveler Stay List - US