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 '%Mauna Lani Beach Club%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Kulalani 205. 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
- 3 bathroom
- Sleeps 6
HI> Waimea
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV.
NEW TO VACATION RENTAL! In the spirit of Aloha, we welcome you and hope you enjoy the Hawaiian vacation of your dreams while residing...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kamuela
Kulalani 2405. 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
- 3 bathroom
- Sleeps 6
HI> Kamuela
In light of the COVID-19 Crisis, LUVA Vacation Rentals has taken extra cleaning precautions to assure our arriving guests that they can vacation with confidence.
Find outdoor living at its finest at the 2-bedroom, 2.5-bath Kulalani 104 at Mauna...
- 2 bedroom
- 3 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
Mauna Lani Palm Villas F4. 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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Waimea
Golf Villas at Mauna Lani D3. 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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Waimea
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
Kulalani 2403. 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 4
HI> Waimea
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
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Serafina at the Residences of Laule'a at Mauna Lani, part of our Hawaiian Luxury Collection. Serafina has private pool and spa with stunning golf and Mauna Kea views....
- 4 bedroom
- 5 bathroom
- Sleeps 8
HI> Kamuela
Golf Villas at Mauna Lani O2. 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 4
HI> Waimea
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Mauna Lani Beach Retreat, part of our Hawaiian Luxury Collection. Mauna Lani Beach Retreat has private pool and spa with stunning golf, ocean and sunset views.
...
- 4 bedroom
- 5 bathroom
- Sleeps 10
HI> Kohala Coast
