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 '%Fairways at Mauna Lani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This newly renovated 2-bedroom condo at the Mauna Lani Resort is now available for your next vacation. This condominium/townhome is bright and airy and spans two floors with large windows to allow in the natural light. This popular floor plan ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kamuela
Paradise awaits you in Mauna Lani Resort aka Mountain reaching Heaven. NEW vacation townhome rental - 2 bedroom + 2 newly renovated bathroom end unit in the Fairways at Mauna Lani right on the golf course! Cares melt away as you enjoy sun and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kamuela
Fairways at Mauna Lani 704. 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...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Waimea
Aloha and welcome to the Fairways, a private gated community located in the prestigous Mauna Lani Resort. This resort area has miles of secluded shoreline, access to the private beach club, pool, golf, tennis complex and fitness center.
Our ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kamuela
Fairways at Mauna Lani 606. 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...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Waimea
Fairways at Mauna Lani 1506. 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Mauna Lani Beach Resort
ALOHA! Come discover for yourself the magic of Hawaii. This Beautiful Villa is conveniently located in the prestigious Mauna Lani Resort at the Fairways at Mauna Lani and right next to the 5 star Fairmount Orchid Resort.
Mauna Lani Resort sits ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kamuela
