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 (`headline` like '%Villages at Mauna Lani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Our Villages at Mauna Lani, private one-level Hawaiian Kahili home is filled with everything you need for a Hawaiian vacation including your own pool and spa! Located in an intimate gated community in the heart of Mauna Lani Resort on the Kohala...
- 3 bedroom
- 4 bathroom
- Sleeps 8
HI> Kamuela
Starting Aug. 1, 2020 travelers who test negative for coronavirus 72 hours before arriving in Hawaii will be able to avoid the state's mandatory, 14-day quarantine.
Spacious and beautifully appointed, Villa Hui offers a fabulous location at the...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Kamuela
The discriminate traveler will enjoy luxury resort living in our town home at the Villages at Mauna Lani. Our home which accommodates 6 people consists of 2,785 split-level living space including 2 master suites and another large bedroom with ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Kamuela
AMAZING PROPERTY!! VERY PRIVATE & VERY SPACIOUS HOME, INCLUDES VIP PASS TO PRIVATE BEACH CLUB.
We invite you to escape to our beautiful Hawaiian hide-away. The luxurious deluxe townhome is located in a private gated community within the lush ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Kamuela
Villages at Mauna Lani 622. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ Areas...
- 3 bedroom
- 4 bathroom
- Sleeps 8
HI> Kamuela
Enjoy a wonderful luxury, tropical villa that sleeps 6 for less than a night at The Fairmont Orchid, Mauna Lani Bay or Four Seasons at Hualalai Hotels. This Lehua Villa is located within The Villages at Mauna Lani. Access card is provided to ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Kamuela
AMAZING PROPERTY!! VERY PRIVATE & VERY SPACIOUS HOME, INCLUDES VIP PASS TO PRIVATE BEACH CLUB.
We invite you to escape to our beautiful Hawaiian hide-away. The luxurious deluxe townhome is located in a private gated community within the lush ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Kamuela