DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 96' at line 10 Travel Information and Hotel Reservations
Hanalei, United States The ultimate romantic Hawaiian vacation experience! Absolutely nothing like it on Kauai. If you're looking for an alternative to resort lodging this is it! Our strong repeat customer base says it all! Once you visit River Estate you never want to leave! Features include... Air Conditioning Ultra Private Accommodations Spectacular Botanical Gardens Serenity and Comfortable Surroundings Pristine Natural Setting Spiritually Healing Environment Exceptional North Kauai Location Nationally Known Property Walk to general store Paddle to Beach and back easily Hardwood floors throughout You know what they say...Location, Location, Location. In fact it's uniqueness is so special that River Estate was included in the February 2006 issue of National Geographic Magazine's as it's recommendation for where to stay on Kauai on it's map of the Hawaiian islands in which it described specific places and activities for travelers on each island as well as being listed in Fodor's Guide, Lonely Planet Guide and the Los Angeles Times Travel Online Deals and recommendations section. We're very proud of that. This Kauai vacation rental property was featured in National Geographic Adventure Magazine in Feb. 2006 and the L.A. Times Online Travel Magazine as well as Fodor's and Lonely Planet's Kauai travel guides.
