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 '%Mauna Lani Beach Club%') AND sleeps>=1 order by rating desc LIMIT 0, 50
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
AMAZING PROPERTY!! VERY PRIVATE & VERY SPACIOUS HOME, INCLUDES VIP PASS TO PRIVATE BEACH CLUB.
This Phase One Maile plan with its direct west facing view and end of cul-de-sac location is a gem. Immaculately maintained with many developer...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Waimea
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
Kulalani 1702. Includes Mauna Lani Beach Club Pass
This vacation rental is professionally managed by ResorticaHawaii
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Mauna Lani Resort
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
Kulalani 705
Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom (downstairs): King Bed
Guest Bedroom: Two Twin Beds
Guest Bedroom: One Queen ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
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
Aloha and Welcome to Kulalani in Mauna Lani Resort, your home-away from home on the Big Island of Hawaii. Kulalani shares a two-acre world class amenity center with the neighboring KaMilo complex that offers a large lagoon pool, a lap pool, two ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
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
This vacation rental is professionally managed by ResorticaHawaii
Villages at Mauna Lani 622. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kamuela
This vacation rental is professionally managed by ResorticaHawaii
Golf Villas at Mauna Lani D3. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
Breathe in that fresh ocean air during a relaxing stay at this vacation rental. With 3 bedrooms, 2 bathrooms, a private lanai, and access to pool, tennis courts, yoga classes, and more, this Mauna Lani condo promises a worry-free retreat. Stroll...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
vrKCV - Kulalani at Mauna Lani 2301, Professionally Managed by Kona Coast Vacations
In the spirit of Aloha, we welcome you and hope you enjoy the Hawaiian vacation of your dreams while residing as our guests at Kulalani at Mauna Lani ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
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
This vacation rental is professionally managed by ResorticaHawaii
Mauna Lani Terrace L102. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
PLEASE NOTE: There are stairs to that lead down to the...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Mauna Lani Resort
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
Mauna Lani Palm Villas B4. Includes Mauna Lani Beach Club Pass. Please scroll down for detailed information
This vacation rental is professionally managed by ResorticaHawaii
Bedding Configuration:
Master Bedroom: King ...
- 5 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
Aloha and E Komo Mai "Welcome"
The perfect island vacation experience awaits you at Kulalani at Mauna Lani, located on Hawai`i Island’s Kohala Coast in the beautiful Mauna Lani Resort.
Our Kulalani luxury vacation villa is ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waimea
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 and sunset views.
Located in the ...
- 4 bedroom
- 5 bathroom
- Sleeps 10
Hawaii> Kohala Coast
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 ...
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Kamuela
Fairways at Mauna Lani 701. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Living Room: Sleeper Sofa
Mauna Lani ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Mauna Lani Resort
