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, rewritten_description,
(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 '%golf%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Our Honu Villa in the Villages at Mauna Lani is a private one-level Hawaiian Kahili home filled with everything you need for a Hawaiian vacation including your own pool and spa, and nearby beach! We are members of the Mauna Lani Resort Golf
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kamuela
This is a an amazing 1 bedroom 1 Bath ground floor unit with plenty of space.It has been fully renovated with beautiful furnishings inside and out. It has lots of windows that lead out to a spacious patio. It has central air if the cool Hawaiian
- 1 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> waikoloa village
Peaceful...Serene...Relaxing...
HIGHLIGHTS:
• Over 3100 square feet of space
• Quiet residential neighborhood on the Makai Golf Course at Princeville
• Beach and snorkel gear
• Close to grocery
- 4 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Princeville
VILLA'S ON THE PRINCE at Princeville in Hanalei Kauai 96722 sleeps six .
LUXURIOUS WELL, APPOINTED VILLA. Welcome to Kauai's upscale gated community ~ Villas On The Prince. Located just past the main water fountain at the entrance to
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> PRINCEVILLE, KAUAI
Call for our Introductory Special Pricing!
New! Luxury 2BR, 2 BA ground floor villa with sophisticated tropical décor and direct beach access!
Kolea, located just 30 minutes north of Kona-Kailua at Waikoloa Beach Resort between
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Waikoloa
Located on the beautiful Waikoloa Beach Course, 1st fairway and green with the Petroglyph Trail and Mauna Kea as the backdrop, the second floor unit has two bedrooms with king size beds and options for separate twin beds, an open lanai and
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa
STVR-19-358846 - Relax and pamper yourself in luxury in this well-appointed condo. On the golf course with Spectacular Ocean views. This is NOT your average condo rental! This condo has had an extensive high-end renovation and interior
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
*SPECIAL - 2 Free Rounds of Golf at the King Kamehameha Golf Club, Maui's Premiere Private Club. On Stays of 5 nights or more.
Looking for a great Honeymoon, Anniversary or Vacation of a Lifetime. Our 1 bedroom condo is just the right
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaanapali
Situated on the beautiful Kohala Coast in the heart of the luxurious, world renown Mauna Lani Resort, we welcome you to the Golf Villas at Mauna Lani, a collection of exquisite town homes.
Poised alongside the 9th Tee, this Balinese
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
FREE daily activities included with your stay value up to $570! Complimentary admission, every day of your stay*: Whale Watch (seasonal), Dinner Sunset Sail, Snorkel Sail, Alpaca Farm Tour, Pineapple Farm Tour, and All Day Electric Bike Rental.
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
E Komo Mai “welcome” to Maui Eldorado A210, with ocean and Kaanapali golf course views at unit A210!!
Enjoy a fresh and modern stay with a newly remodeled kitchen, bathroom, flooring and furniture. Located in the heart of Kaanapali.
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kaanapali
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
vrKCV - Country Club Villas 315, Professionally Managed by Kona Coast Vacations
*CONSTRUCTION NOTICE - Complex began stair railing steel painting project for the month of August, 2024. This consists of sanding away old paint, which can be
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Spectacular Sweeping Views from this Four Bedroom Luxury Home with Separate Guest House is Paradise Perfected. Located on the #16 Fairway of the Hualalai Golf Course, this luxury home is recently redecorated by Willman Interiors, and boasts
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Kailua-Kona
Located in the Award Winning Resort Community of Hualalai Four Seasons.
Enjoy the sounds of the ocean serenade, the magic of sunsets, and whale watching during the winter months, from this recently updated garden level Hillside Villa.
- 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
vrKCV - Hali'i Kai 10E, Professionally Managed by Kona Coast Vacations
Welcome to Villa 10E – Ocean, Golf & Sunset Views at Hali'i Kai
Step into the luxury and tranquility of Villa 10E, a recently remodeled ground-floor unit at
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Enjoy our 2 bedroom, 2 bath villa for you and your family quietly tucked away along the Big Island's sunny Kohala Coast, Fairway Villas Waikoloa offers the crisp style, gracious elegance, and modern sophistication. Villa has FREE WIFI and
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa,
Turn the corner, and head straight to paradise. This welcoming 2 Bedroom / 2.5 Bath airy and bright condo is yours to enjoy with your family and friends. On a quiet side of the active stay-and-play Waikoloa Resort area, Waikoloa Colony Villas
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waikoloa
Ke Alaula Villa 217B at Hualalai Resort
Experience unparalleled luxury and tranquility at Ke Alaula Villa 217B, located within the prestigious Hualalai Resort. This exceptional property is situated within one of Hawaii’s most renowned
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Located in the Award Winning Resort Community of Hualalai Four Seasons.
Beautiful ocean views from this delightful two bedroom Garden Level Villa. Spacious Lanai with lounge seating extends seamlessly to a large lawn area. Enjoy the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Kings Club Gold Membership Exclusively for guests of 16G included! Big Savings! This membership gives overnight guests of the unit (16G) access to golf at Hawai`i’s premier 27-hole golf experience is comprised of three nine-hole loops, Beach
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
Beautifully situated above the Pacific Ocean and Mauna Kea and Hapuna Prince Resorts, at the base of the Kohala Mountains is the setting for your dream vacation on the Big Island of Hawaii. This new 3-bedroom, 3.25-bathroom Villa at the
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kamuela
Come enjoy our spacious 1 bedroom, 2 bathroom condo in one of the most beautiful spots in all of Maui. Located directly on the 4th fairway of the Kapalua Bay Course can be both entertaining and comical as you watch the golfers pass by. A
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Halii Kai 10H
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
With unique ocean and golf course views, this three-bedroom, two-bath condo at
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
We are located in the gated complex of Vista Waikoloa on the fourth green of the Waikoloa beach golf course. The course is a twenty seven hole layout, kings nine, lakes nine and beach nine. One of the advantages of renting this unit is the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa
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
Enjoy Our Comfortable Tropical Condo For Your Island Get Away. We Are Directly Across From One Of Two Pools And BBQ Areas And Right On The 8th Fairway Of The Waikoloa Beach Golf Course. In The Living Room, We Have A 55" Samsung QLED 4K Smart TV
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
*Hilton Waikoloa Pool Pass for stays in 2025! J4 Waikoloa Beach Villas
We extend our Gold Golf Membership benefits at Waikoloa Golf to guest renting our villa.
Please scroll down for detailed information
Aloha! Welcome to Luxury
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach
STVR-19-357988
https://tours.spaces.808.com/1759448
Luxury living can be found at this spectacular 4 bedroom, 4.5 bath, resort home. Located within the Four Seasons Resort Hualalai on the Big Island of Hawaii.
The
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kailua-Kona
If you are not familiar with the Ko Olina Resort, please Google 'Ko Olina', there are just too many fun things to do, too many beautiful places to see, too many great restaurants and shops to do them justice in this little ad.
This condo
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapolei
We invite you to relax and enjoy our luxurious Golf Villa which is perfect for two persons who desire a highly upgraded place to stay in Maui. Our spacious Villa has Sweeping Ocean Views from the Island of Lanai to the Island of Molokai.
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Lahaina
Hale Honoiki is a classic Hawaiian Style getaway with a second story lanai that extends around the entire house. Here you will enjoy views of the magnificent ocean, lush mountains and abundant waterfalls. The large sliding glass doors in each
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Princeville
Welcome to our Beautiful Waikoloa Beach Condo-Penthouse with Discounted Gold Golf Membership & Fabulous Sunsets.
This beautiful rental is a peaceful & quiet condominium (overlooking the 5th hole on the Beach Course, rated 18th nationally)
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach
Hawaii GE & TA Tax ID # G/T 006-824-3456-01 Taxes on total amount is 17.42%. Not included in the vrbo quote.
Required is a signed rental agreement between guest and owner.
This rental agreement is in addition to the deposit. After you
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Your own private tropical pool and jacuzzi! Hale Ohana is open concept home with an expansive living room, dining room, and kitchen with breakfast bar that are to be enjoyed. Ceiling fans and Hawaiian louvered windows in every room allow you to
- 4 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Princeville
Aloha and welcome to our home on the Big Island of Hawaii!
The island style Fairway Villas in the Waikoloa Beach Resort is the perfect location from which to explore the breathtaking Big Island. Situated just 15 minutes north of the Kona
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
ALOHA!
E Komo mai. nou ka hale! Welcome to our home!
Kulalani is a beautifully landscaped, private, gated community within the Mauna Lani Resort.
Our brand new luxury golf villa boasts spectacular views of Mauna Kea and the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
Enjoy spectacular panoramic ocean views from this beautiful condo in a truly private setting! This is one of the best located units in the complex providing unobstructed ocean views from the living area, dining area, kitchen, master bedroom and
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Wailea
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
Imagine your well-deserved vacation at a gorgeous three bedroom, two and a half bath townhouse at the Waikoloa Colony Villas - a luxury, gated community located in the prestigious Waikoloa Beach Resort. The townhome is the former model built in
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa
vrKCV - Hali'i Kai 12F, Professionally Managed by Kona Coast Vacations
Spectacular Ocean Views and Exclusive Golf Privileges
Welcome to Hali'i Kai 12F, where breathtaking views and luxurious amenities come together to create the
- 4 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
Our villa provides 2 Bedrooms and 2.5 Baths, totaling over 1400 square feet plus 2 Lanais.
It is perfect for families or couples vacationing together. The well-appointed kitchen has beautiful maple cabinetry and granite countertops.
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Waikoloa
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
Enjoy all the best that the Big Island has to offer!! Our beautifully Hawaiian furnished home at the Waikoloa Beach Villas - a luxury gated community at the Waikoloa Beach Resort - is conveniently located across the street from the King's Shops
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa
Please be aware we only rent to a maximum of two guests at a time.
The Mauna Kea Beach Resort has remodeled the main tower and the golf course. Phase 2 is the fitness center/spa/hotel wing on the grass through early third quarter 2025,
- 2 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kamuela
Ground Unit #9B Oceanview condo in Halii Kai, famed newer development near Waikoloa Hilton and Mauna Lani beach homes. Halii Kai has an incredible salt water pool, spa covered workout room, poolside restaurant/bar right on ocean front. The
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
SPRING SPECIAL!
Kapalua Golf Villa 24T8 – Ocean View Elegance at Its Finest
Indulge in the tranquil beauty of Maui at Kapalua Golf Villa 24T8, a beautifully appointed 1-bedroom, 2-bathroom villa that perfectly blends luxury, comfort,
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Luxurious ground floor "no stair steps" villa with private lanai, large lawn area and wide open views of the golf course. Granite slab counters in the large, well-equipped kitchen. Living and dining areas have hardwood floors. Kitchen, entry
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Village
This luxurious and completely remodeled unit offers GOLFERS STAYING IN THIS UNIT GREAT DISCOUNTS FOR GOLFING with our Gold Membership @ WAIKOLOA BEACH AND KINGS COURSES. ALMOST ½ OFF!!
Our complex has a large HEATED, SALINE outdoor
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
