select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `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 and b.blocked=0 ) 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, 20
The space
Our three bedroom corner townhouse has a private first floor master furnished with a California King bed and office space. We are located a short walk to the famous Fairmont Orchid Hotel. The hotel's five restaurants can be used...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
This vacation rental is professionally managed by ResorticaHawaii
Fairways at Mauna Lani 206. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Mauna Lani Resort
Mauna Lani Fairways 1004 is a new-to-market two-story townhome in a prime location in the Mauna Lani Resort. This curated vacation home will delight guests with brand-new (2022) furnishings and decor in a tranquil coastal aesthetic, a large BBQ ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
This vacation rental is professionally managed by ResorticaHawaii
Fairways at Mauna Lani 906. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Mauna Lani Resort
Stay 7 nights with 1 night free! Ask me about Winter Specials and stay here a month! Relaxing views of North Golf Course at Fairways at Mauna Lani! You won't find a better appointed unit like this one. This beautifully maintained luxury 2 ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kamuela
Fairways at Mauna Lani 201. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Mauna Lani Beach Club Pass: Your stay ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Mauna Lani Resort
This vacation rental is professionally managed by ResorticaHawaii
Fairways at Mauna Lani 704. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea
This vacation rental is professionally managed by ResorticaHawaii
Fairways at Mauna Lani 2102. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Main Bedroom: King ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
Living the good life at Fairways 1703 with your own exclusive private beach!!
Welcome to your tropical paradise! As the owner of Fairways at Mauna Lani 1703, I wish to provide you with everything you need to enjoy your dream vacation here...
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Kamuela
This vacation rental is professionally managed by ResorticaHawaii
Fairways at Mauna Lani 1506. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Mauna Lani 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...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
This vacation rental is professionally managed by ResorticaHawaii
Fairways at Mauna Lani 606. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waimea
This vacation rental is professionally managed by ResorticaHawaii
Fairways at Mauna Lani 2001. Includes Mauna Lani Beach Club Pass
Steps away from the pool. Private end unit
Please scroll down for detailed ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Mauna Lani Resort
FAMILY FRIENDLY: Easy access from Lanai to the Fairways pool and fitness centers. Viking BBQ in downstairs Lanai. 4 small appliances and 7 major household appliances. Our townhouse villa has the warm feel of home, (the owners absolutely love the...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea