select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `address`,round(price) as price,minimum_nights, `rating`, `review_count`,`latitude`, `longitude`,case when propertyName='' then trim(address) else CONCAT(CONCAT(propertyName,'(',trim(address)),'',')') end as addre,propertyName,
(6371 *
acos(
cos( radians( 21.2759167 ) ) *
cos( radians( `latitude` ) ) *
cos(
radians( `longitude` ) - radians( -157.8233677 )
) +
sin(radians(21.2759167)) *
sin(radians(`latitude`))
)
) as distance from `vacationrentalindex` a inner join vacationrentalindexfeed b on a.uniturl=b.unitUrl and a.headline!='' and a.thumbnailUrl!='' and b.enabled=1) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`uniturl` like '%9a470b39-1a46-4b40-9e0f-f57fddfcd6dd%' ) AND sleeps>=1 order by rating desc LIMIT 0, 15
Kipuka Lani offers a fresh approach to luxury resort living. The modern tropical design seamlessly links interior and exterior spaces in the lush Mauna Lani landscape. Embracing the spirit of Malama Aina - respect for the land, this luxury retreat makes abundant use of natural materials, natural light and natural ventilation. Walls of the central Great Room slide away to allow uninterrupted activity, breeze and a sweeping view of the adjacent golf course and ocean. Outside the private Entrance Garden, there is ready access to the neighboring Beach Club and a private beach.
Relaxed living is assured at Kipuka Lani amid contemporary furnishings, a fully equipped gourmet kitchen, and a Sonos digital music system. For quieter times, a separate Media Room invites relaxation with books, games or movies. On a cool evening, guests may enjoy star gazing from the hot tub or gathering around a fire table on the lanai's sectional sofas. Four spacious air-conditioned bedroom suites each include a king-sized bed, a luxurious bathroom and a private lanai. Bedrooms are all provided with flat screen TVs and are tastefully appointed with hotel & custom bedding. For those with young children, there are provisions at Kipuka Lani to facilitate care and safety. The heated pool is equipped with an easy-to-operate pool cover. Bedrooms can be interconnected for ease of supervision.
**Guests of Kipuka Lani will receive exclusive membership benefits to the Auberge ...
- 4 bedroom
- 5 bathroom
- Sleeps 8
HI> Kamuela
