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 Kea%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Aloha nui Loa! Minutes from Mauna Kea and Hapuna beaches, the Red 'Ohana 2 bedroom is located in Waimea is a quaint town with breezes and milder temperatures that provide an idyllic Hawaiian environment.
The ultimate in comfort and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kamuela
Aloha! The Red 'Ohana 3 bedroom is located on the beautifully scenic Kohala Mountain Ranch Road on the 'sunny side' of Waimea/Kamuela, above Mauna Kea and Hapuna Beach. Waimea is a quaint town with breezes and milder temperatures that provide an...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kamuela
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
Hawaii> Kamuela
Aloha & Welcome to this slice slice of paradise at Wai'ula'ula, nestled within the prestigious Mauna Kea Resort. This rare 4-bedroom private home offers sweeping ocean views, a private infinity pool, and a separate Ohana cottage with it's own ...
- 4 bedroom
- 5 bathroom
- Sleeps 9
Hawaii> Kamuela
Aloha, picture yourself in paradise! Less than 30 minutes from the Kona airport, this beautiful three bedroom Villa provides the perfect location to enjoy all that the Big Island has to offer. Located in prestigious Wai'ula'ula, just minutes ...
- 3 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Waimea
Welcome to Wai‘ula‘ula at Mauna Kea---a private, gated community on the Hapuna Golf Course.
Relax in our 3-bedroom, 3-bathroom, 2,100 sqft. condominium and enjoy the many upgrades we’ve added to our home, including hardwood ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
This stunning home offers the best of both worlds: the comfort of a spacious, private home and access to all of the facilities of the Mauna Kea and Hapuna resorts. All four bedrooms have en-suite bathrooms.
We have not furnished and ...
- 4 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Kamuela
Aloha! Welcome to the ʻOhana Hale, your Puako retreat with stunning forest and unobstructed view of majestic Mauna Kea from the lanai, living room and dining area. This quiet and tranquil location is literally 100 steps away from the beach. ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kamuela
This vacation rental is professionally managed by ResorticaHawaii
Mauna Kea High Bluffs #9. Stunning Private Home with swimming pool and ocean views. Mauna Kea Resort Amenity Program add on option
Please scroll down for detailed ...
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Mauna Kea Beach Resort
Rates vary based on time of year. Rates begin at $550. 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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea
The Hawaiian word for family is ohana and we affectionately call our home, O2 or Ohana 2, as it is our family vacation home and we would love to share it with the you!
Marvel at the shimmering Pacific Ocean and tropical Kohala Coast ...
- 4 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Waimea
Alohale | Aloha (Hello) + Hale (Home). Kulalani is a special place you will want to return to again and again. This artistically presented home offers true serenity and privacy with world class services and amenities all around.
3 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
Aloha! Welcome to Hapuna Beach Villa, our home overlooking the Hapuna Golf Course in the beautiful Waiulaula development with panoramic 180 degree views of the ocean and Kohala mountains. We also have partial views of the 14th green.
Our...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Waimea
This 7,768 square foot home was designed by Hawaiian architect Thomas Bingham (a protege of Frank Lloyd Wright) for indoor/outdoor living and entertainment. It has 5 bedrooms, each with a private bath, the master suite enjoying complete privacy ...
- 5 bedroom
- 6 bathroom
- Sleeps 10
Hawaii> Kamuela
Enjoy two of the world's finest resorts, the Mauna Kea and the Hapuna Prince, at this 2 bedroom 2 bath luxury 2nd floor condo at the "Kumulani at the Uplands" of the Mauna Kea resort on the Big Island of Hawaii. This peaceful gated community is ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
Villas at Mauna Kea #37 FREE resort access to both the Mauna Kea Beach Hotel and The Westin Hapuna Beach Resort For many years, the Mauna Kea Resort has served the world's most sophisticated travelers. It has been their special place to visit, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
This luxury two-story townhome features four bedrooms (including two primary suites) and 4.5 baths, with its own private pool and spa, in an exclusive gated community. Only about 500 yards from two exceptional resorts and two of the most ...
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Kamuela
This newly renovated four bedroom luxury property, walking distance to the Mauna Kea Beach Hotel, offers the ideal oasis for relaxing and luxuriating in paradise. Unwind on the generous private pool deck and covered lanai and revel in fabulous ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kamuela
This destination home is in the seat of horse country in the beautiful town of Kamuela/Waimea. This A-frame challet home has spectacular views of Mauna Kea and the verdant green, rolling hills of paniolo (hawaiian cowboy) country. Cozy up to ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
Villas at Mauna Kea #22 This single-level, sophisticated, oceanfront estate offers a sunken living room with sliding glass pocket doors for indoor/outdoor island living, a chef’s kitchen with Wolf and Sub-Zero appliances, a dining area with an...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
Situated within the Mauna Kea Resort, this home is close to two championship golf courses: the newly renovated Mauna Kea Golf Course and Hapuna Golf Course. Furnished in a natural tropical motif with high beam ceilings and lots of windows, this ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea
Welcome to Wai'ula'ula' at the Mauna Kea Resort!
Professionally decorated former model home with mahogany trim and stone upgrades, and now current newer updates and furnishings, offers breathtaking ocean, Maui, and Kohala Mountains ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Waimea
vrKCV - Golf Villas at Mauna Lani A2, Professionally Managed by Kona Coast Vacations
Welcome to Your Tranquil Golf Retreat on the Big Island
Nestled within the exclusive Golf Villas at Mauna Lani Resort, this stunning ground-floor ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
New to VRBO! This three bedroom home sleeps six to eight with modern amenities, a gourmet kitchen, large open floor plan, pool and spa. Located on the resort side and ocean side of the highway in one of the original Mauna Kea developments - ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
This extraordinary, oceanfront, newly-constructed, third level masterpiece offers floor-to-ceiling sliding window walls that create indoor/outdoor living space, a magnificent chef’s kitchen outfitted with professional-grade Wolf, Sub-Zero and ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> KAMUELA
Relax in the luxurious comfort and privacy of this oceanfront, deluxe studio penthouse, just steps from the white sands of world famous Hapuna Beach. Enjoy spectacular sunset ocean views from the unique, four floor-to-ceiling radius glass ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KAMUELA
This smart and chic, oceanfront, newly-constructed, second level island masterpiece offers floor-to-ceiling sliding window walls that create indoor/outdoor living space, a chef’s kitchen outfitted with professional-grade Wolf, Sub-Zero and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KAMUELA
This beguiling, oceanfront, newly-constructed, ground level masterpiece offers floor-to-ceiling sliding window walls that create indoor/outdoor living space, an exquisite chef’s kitchen outfitted with professional-grade Wolf, Sub-Zero and ...
- 3 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Kamuela
This divine, oceanfront, newly-constructed, fourth level studio offers floor-to-ceiling sliding window walls that create indoor/outdoor living space, a professional-grade chef’s kitchen outfitted with Wolf, Sub-Zero and Miele appliances, and ...
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> KAMUELA
This incomparable, oceanfront, newly-constructed, ground level penthouse offers floor-to-ceiling sliding window walls that create indoor/outdoor living space, a superb chef’s kitchen outfitted with professional-grade Wolf, Sub-Zero and Miele ...
- 4 bedroom
- 4 bathroom
- Sleeps 9
Hawaii> KAMUELA
This stylish, oceanfront, newly-constructed, third level island masterpiece offers floor-to-ceiling sliding window walls that create indoor/outdoor living space, a chef’s kitchen outfitted with professional-grade Wolf, Sub-Zero and Miele ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> KAMUELA
This marvelous, oceanfront, newly-constructed, second level studio offers floor-to-ceiling sliding window walls that create indoor/outdoor living space, a luxe chef’s kitchen outfitted with professional-grade Wolf, Sub-Zero and Miele ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> KAMUELA
This immaculate, oceanfront, newly-constructed, island masterpiece offers floor-to-ceiling sliding window walls that create indoor/outdoor living space, a sleek, epicurean kitchen with Wolf and Sub-Zero appliances, wine storage and hand-crafted ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> KAMUELA
This magnificent, oceanfront, newlyconstructed, island masterpiece offers floortoceiling window walls that create indooroutdoor living space, a sleek, gourmet kitchen with Wolf and SubZero appliances, double ovens, a cappuccino machine, wine ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> KAMUELA
Brought to you by Paradise in Hawaii Luxury Homes.
Welcome to Mauna Kea Sunsets, a part of our Hawaiian Luxury Collection. Mauna Kea Sunsets at the Mauna Kea Resort Kumulani complex has stunning views of golf, ocean and mountains. This ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
This sophisticated, oceanfront, island masterpiece offers floortoceiling sliding window walls that create indooroutdoor living space, a splendid kitchen with Wolf and SubZero appliances, wine storage and handcrafted cabinetry, plus a dining ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
Presenting this exciting opportunity to vacation in a private estate in the Mauna Kea Resort's exclusive Fairways South community. Fairways South 31 has completed extensive renovations and offers guests expansive living spaces, fresh interiors, ...
- 4 bedroom
- 6 bathroom
- Sleeps 13
Hawaii> Kamuela
This superb, oceanfront, newlyconstructed, island masterpiece showcases floortoceiling sliding window walls that create indooroutdoor living space, a magnificent chefs kitchen outfitted with professionalgrade Wolf, SubZero and Miele appliances, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
Enjoy unobstructed beachfront views in this modern, luxurious two-bedroom unit decorated with Restoration Hardware furniture throughout. Overlooking the white sandy beach, the living and master bedrooms feature floor-to-ceiling sliding glass ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
Stylish, island-modern residence housed within the renowned Mauna Kea Resort area overlooking the beautiful Hapuna Beach. Just steps to the ocean as well as amenities to allow for easy access to play, dine, unwind, and connect. Available access ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waimea
Escape to paradise at Hapuna Beach Residences Unit C34, a luxurious 2-bedroom, 2-bathroom oceanfront condo at Hapuna Beach Resort on Hawaii's Big Island. This high-end, premium beachfront vacation rental features stunning ocean views, designer ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waimea
Brought to you by Paradise in Hawaii Luxury Homes.
Welcome to Sun Ray Retreat, a part of our Hawaiian Luxury Collection. Sun Ray Retreat at the Mauna Kea Resort Kumulani complex has stunning views of golf, ocean and sunsets. This three ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
Brought to you by Paradise in Hawaii Luxury Homes
Welcome to Mauna Kea Beach Escape, a brand new exquisite 4 bedroom, 4 1/2 bath home located in Hapuna Estates within the Mauna Kea Resort. Prepare to embark on a truly remarkable escape ...
- 5 bedroom
- 5 bathroom
- Sleeps 11
Hawaii> Kamuela
Elevate your Hawaiian island getaway at Hapuna Beach Paradise™, a luxurious beachfront retreat on the Kohala Coast.
This penthouse residence will mesmerize you by its stunning, unobstructed views of Hapuna Beach, the best white sand ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Hawaii County
Brought to you by Paradise in Hawaii Luxury Homes.
Welcome to Mauna Kea Palms, a part of our Hawaiian Luxury Collection. Mauna Kea Palms at the Mauna Kea Resort Kumulani complex has majestic views of golf, mountains and sea. You will be ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
Kumulani G2 is a 2 bedroom, 2 bathroom ground floor condo with beautiful ocean views. The spacious living room has glass sliders that open to a large lanai with a BBQ that overlooks the Mauna Kea Resort golf course and Pacific Ocean. The condo ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
Welcome to Kumulani at Mauna Kea where the beauty of the Big Island's golden Kohala Coast awaits you. Our spacious condominium is ideal for families and couples, and it offers gorgeous ocean and sunset views. We have recently redecorated and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
Hawaiian Charm Mauna Kea Fairways South 14 - Incredible Ocean Views.
This comfortable Mauna Kea home offers vast indoor/outdoor space and is the perfect home for your next Hawaiian vacation. The ample lanai overlooks gorgeous ocean ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Waimea
We are implementing the highest level of sanitization for the villa with our housekeeping and use of E-Mist between guests. E-Mist's patented electrostatic disinfectant application systems deliver safer surfaces, and can kill up to 99.999 ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
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 and sea. You...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
