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 '%Hualalai%') AND sleeps>=1 order by rating desc LIMIT 0, 50
On the Kona side, safe and away from the volcanic activity, the Cottage awaits you.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Kailua-Kona
Haliipua Villas are the newest generation of multi-family villas at Hualalai offering an array of designer finishes throughout the home. Special features include luxurious mahogany finishes, island-inspired ceiling treatments, enhanced ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua-Kona
This spacious 3 bedroom, 3.5 bath single-level villa is centrally located on the Resort’s popular Waiulu Street overlooking beautiful Punawai Pond, the 5th Hole of the Member’s Ke`olu Golf Course and the ocean beyond. With 2642 square feet ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua-Kona
One of the largest floor plans of any villa at Hualalai, this spacious and centrally located 3 bedroom, 3 bath villa is ideal for your Hawaii getaway. Extra bedding available with a "bonus" living room on the first level. The down-stairs suite ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Whale watch while listening to the breaking waves from the shoreline from the Primary bedroom's private lanai with unobstructed ocean views! This beautifully appointed three bedroom villa has over 2,500 square feet of living area. Each of the ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua Kona
The spacious floor plan includes a downstairs primary bedroom suite with king bed and luxury spa-like bath. Just off the master is a large living room with queen sized sofa pull out that opens to the downstairs lanai, leading to the lawn and ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Located in the Award Winning Resort Community of Hualalai Four Seasons.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Gorgeous, Contemporary, Newer Home Exemplifies Luxury and ease of Living in our Island Paradise. This 5-bedroom, 5 1/2 bath pod-style estate home is exceptionally appointed and designed to take full advantage of the temperate climate and island ...
5 bedroom
6 bathroom
Sleeps 10
Hawaii> Kailua-Kona
Ke Alaula Villa 217B at Hualalai Resort
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Located in the Award Winning Resort Community of Hualalai Four Seasons.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua-Kona
This beautiful and meticulously maintained home situated on the 9th hole of Hualalai's Jack Nicklaus golf course with Pacific Ocean views is available for private rentals. Perfectly located, the home is just a short walk or golf cart ride (two ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Magnificent Garden Level Villa located on the #18 hole of the Hualalai Jack Nicklaus Signature Course. Enjoy white water views and spectacular sunsets from this highly desirable location at Hualalai Resort. Listen to the ocean and whale watch ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Hillside 1102 is nestled near the shore in the exclusive 5 Star Four Seasons Hualalai Resort. From the lanai, listen to the rhythmic waves on the shore, just a short walk from the Villa. Fully receding pocket glass, screen and shutter doors ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua-Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua Kona
Welcome to Paradise! Enjoy Hawaii's Big Island from your private condo (with an ocean view)!
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa Village
One of only seven Hualalai Penthouse Villas. Upper-level Villa featuring single level interior with over 4,200 sq feet of living and lanai space. Hear the sounds of the Pacific Ocean while enjoying the beautiful close unobstructed ocean and ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua-Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua Kona
Welcome to the exquisite Waiulu Estate Villa at Four Seasons Hualalai Resort. This estate offers a private and serene setting with close wide-open ocean views. The estate has been recently updated with new contemporary décor by the renowned ...
5 bedroom
6 bathroom
Sleeps 10
Hawaii> Kailua-Kona
*Newly Remodeled*
4 bedroom
4 bathroom
Sleeps 8
Hawaii> Kailua Kona
This “Over-the-Top” estate is a resort within a resort! Guests often choose to Opt Out of paying the resort fees and enjoy this quiet retreat without the hustle and bustle of the resort activity. Beautiful infinity pool with sandy ...
5 bedroom
6 bathroom
Sleeps 10
Hawaii> Kailua-Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua Kona
Welcome to your tranquil oasis at the exclusive Lalani Lau'eki Estate at the Four Seasons Hualalai Resort. This private estate is nestled between exquisite and expansive ocean and Hualalai mountain views—perfect for beautiful Hawaiian ...
4 bedroom
5 bathroom
Sleeps 8
Hawaii> Kailua-Kona
Welcome to the exclusive Waiulu Tropical Sanctuary resting within the Hualalai Resort. Be one of the first to enjoy stunning contemporary interiors completed masterfully by the renowned Henderson Design Group. Every detail has been ...
4 bedroom
5 bathroom
Sleeps 8
Hawaii> Kailua-Kona
Experience luxury living at its finest at Fairways Villa 104A, a newly renovated 3-bedroom, 3.5-bathroom retreat in the prestigious Hualalai Resort on the Big Island of Hawaii. This stunning upper-level villa combines contemporary coastal ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Hualalai Hale is your personal resort home located in the exclusive Hualalai Resort, Hawaii on the Big Island. Offering four beautifully decorated bedroom suites, each with their own bath, this single-story, marbled and wood floor, grand ...
4 bedroom
5 bathroom
Sleeps 8
Hawaii> Kailua Kona
Beautifully maintained, this villa offers a welcomed amount of privacy from both the upper and lower levels without compromising stunning panoramic view of the ocean and the 4th fairway of the Jack Nicklaus signature Hualalai Golf Course. The ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Welcome to your very own paradise at Hualalai Four Seasons Resort! One of three unique residences in the prime Kauhale neighborhood with easy and quick access to the Four Seasons Resort amenities. This home is located at the end of Pakui Street ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua-Kona
This well appointed Palm Villa rental, at the Four Seasons Resort Hualalai, overlooks the 15th Fairway of the beautiful Jack Nicklaus Signature golf course. Sweeping ocean views beyond the golf course combined with the Villa's casual elegance ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Nestled on the slopes of Hualalai mountain on the Big Island of Hawai'i lies this gem of a property, boasting views of the Pacific Ocean from its expansive lanais that overlook a yard filled with a plethora of exotic fruits and flowers. Located ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua Kona
**Please note that the Chairman's Club Event takes place each year at Four Seasons Resort at Hualalai from approx December 2 - December 7th. . This event will result in limited access to resort amenities. Details at end of listing!. ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua Kona
This fabulous 3 bedroom, 2.5 bath luxury villa is a short distance to the Four Seasons Resort Hualalai - truly one of the worlds' great resorts. Enjoy the amazing ocean views from this ground floor Hillside Villa. Koa cabinets, travertine ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua Kona
Welcome to the Hali'ipua Villa! This two-story townhouse offers new, contemporary design and décor in calm neutral hues throughout. The panoramic ocean and Maui views are spectacular—including beautiful sunsets throughout the year. This ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua-Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
4 bedroom
5 bathroom
Sleeps 8
Hawaii> Kailua Kona
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua-Kona
This spacious 2 bedroom, 2 bath single-level villa is centrally located on the Resort’s popular Waiulu Street overlooking beautiful Punawai Pond, the 5th Hole of the Member’s Ke`olu Golf Course and the ocean beyond. With 1854 square feet of ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua-Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
4 bedroom
4 bathroom
Sleeps 8
Hawaii> Kailua Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua Kona
WHY IT'S SPECIAL
4 bedroom
6 bathroom
Sleeps 10
Hawaii> Kailua-Kona
Magnificent Garden Level Golf Villa 1101 enjoys golf course and water views from this highly desirable location at Hualalai Resort.
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Kailua Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Welcome to Ka'ulu Villa 133A — a luxurious 3 bedroom, 3 bathroom, 2-story villa in the extraordinary Hualalai Resort with gorgeous views of the Pacific Ocean, Haleakala volcano on Maui, and the stunning Jack Nicklaus designed golf course. ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua Kona
Escape to your own private paradise at this stunning newly renovated expansive 5 bedroom, 5 bathroom 6500 square foot ocean adjacent estate, a beautiful custom home on 3/4 of an acre, nestled within the exclusive Four Seasons Resort Hualalai. ...
5 bedroom
6 bathroom
Sleeps 14
Hawaii> Kailua-Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
4 bedroom
5 bathroom
Sleeps 8
Hawaii> Kailua Kona
Welcome to your ultimate vacation retreat at the Four Seasons Hualalai Resort! Step into luxury and relaxation with this brand-new, meticulously crafted 6,000 square foot, 6-bedroom home boasting the finest finishes and unparalleled comfort. ...
6 bedroom
9 bathroom
Sleeps 14
Hawaii> Kailua-Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua Kona
The Annual Chairman's Club Event at Hualalai Resort will take place from Monday December 01 through Saturday December 06, 2025. This event will result in modified access to select resort amenities.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua-Kona
Newly renovated villa from top to bottom. A 3 bedroom, 3.5 bath luxury villa conveniently located in the heart of Hualalai Resort overlooking the 15th hole of the Jack Nicklaus designed Hualalai Golf Course. Ground floor single level floor plan ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua Kona
This Hualalai Palm Villa is a spectacular three bedroom, three bath, two-story Hualalai villa on popular Waiulu Street at the world renowned Hualalai Resort. The Resort is home to the Four Seasons Hualalai, regarded by many as the #1 Resort in ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Kailua-Kona
Upper level 2-bedroom, 2-bath villa overlooking the 15th tee of the Hualalai Golf Course with stunning Mauna Kea, Island of Maui and horizon views of the ocean. Designed by Honolulu-based Architect Warren Sunnland, the Fairway Villas at ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Kailua-Kona
