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 Kea Resort%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Rates vary based on time of year. Rates begin at $399. per night, plus taxes and fees. Please contact owner for details, by clicking on Send email to owner.
This luxurious 3 Bedroom 3 full Bath residence with high-end finishes and gorgeous ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Waimea
Aloha and welcome to our home, villa #311. Our villa offers concierge service to all of our guests. We have ocean views, a private pool with spa, and gourmet kitchen with professional grade appliances. The villa is bright, airy and spacious with...
- 3 bedroom
- 4 bathroom
- Sleeps 8
HI> Kamuela
**Effective January 1, 2022 the state of Hawaii has added a 3% county tax. The new tax rate is 17.962%** This goes into effect for guests arriving after the new year for both hotel and rental guests.
MEMBER OF THE CLUB - This allows you to ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Kamuela
Wai'ula'ula 411 is one of the few and exclusive Estate Homes in the Wai'ula'ula community. This single-family resort home just completed construction at the end of 2015 and boasts spectacular ocean, golf course and sunset views. This 3 bedroom, ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Kamuela
**Effective January 1, 2022 the state of Hawaii has added a 3% county tax. The new tax rate is 17.962%** This goes into effect for guests arriving after the new year for both hotel and rental guests.
Aloha, and welcome to paradise! This ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
HI> Kohala Coast
Covid-19 cancellations due to government restrictions or positive test of one of the travelers receive a full refund of funds paid.
Aloha, picture yourself in paradise! Less than 30 minutes from the Kona airport, this beautiful three bedroom ...
- 3 bedroom
- 4 bathroom
- Sleeps 10
HI> Waimea
**Effective January 1, 2022 the state of Hawaii has added a 3% county tax. The new tax rate is 17.962%** This goes into effect for guests arriving after the new year for both hotel and rental guests.
This home is the place for you and your ...
- 3 bedroom
- 4 bathroom
- Sleeps 7
HI> Kohala Coast
This cozy Mauna Kea Resort vacation home offers 3 bedroom and 3 bathrooms, comprised over 2,400 square feet overlooking the Hapuna golf course. The kitchen and bathrooms have all been recently renovated (2017) with modern European fixtures, ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Kamuela
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes.
Welcome to Majestic Ocean Villa, a part of our Hawaiian Luxury Collection. Majestic Ocean Villa at the Mauna Kea Resort Kumulani complex has majestic views of golf, mountains ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Waimea
Located at the exclusive Mauna Kea Resort, Kumulani A2 is a 2 bedroom, 2 bathroom ground-floor condo with beautiful ocean views. Located in the Uplands, A2 is a perfect choice for visitors who want to be close to the best beaches and hotels on ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kamuela
❤️PiH❤️ brought to you by Paradise in Hawaii Luxury Homes
Welcome to Ocean Palms Villa, part of our Hawaiian Luxury Collection. Ocean Palms Villa at the Mauna Kea Resort Wai'ula'ula complex has majestic views of mountains and ocean. You...
- 3 bedroom
- 3 bathroom
- Sleeps 7
HI> Kamuela
Beautiful private duplex on the golf course in the world famous Mauna Kea resort. Includes access to the Mauna Kea and Westin Hapuna resorts. The perfect white sand of Mauna Kea is one of the best beaches in the world....
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Waimea
A slice of paradise awaits you and your family. This upscale vacation home is the perfect place to relax and unwind while you experience the beauty and adventures that Hawaii has to offer. This condominium is a second story, 3 bedroom, 3 bath ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kamuela