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 '%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! We are members of the Mauna Lani Resort Golf Courses and have ...
- 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
https://travel.hawaii.gov/#/
What sets 16B apart from the rest? Location, amenities and service. I live on Island and can assist with any issues or questions. Halii Kai Unit 16B is right across from the clubhouse. Enjoy the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa
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
Perfect location for vacationers. The condo is located on the first row of condos right on the 10th hole of the Blue Golf Course, next door to the Club House and the new Wailea Village Shopping Center. It's in the heart of the resort community...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
*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
Kaanapali Royal N-202 - Pride of ownership is readily apparent in this spacious 2-bedroom / 2-bath air-conditioned unit. With over 1,500 sf of living space, all on one level, the condominium underwent a full kitchen remodel plus new carpeting ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaanapali
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
Summary:
Aloha and welcome to our beautiful brand new 2-story, 3 bedroom 2 1/2 bath, air conditioned condo located on the 9th hole of Kiahuna Golf Course in Poipu. With ocean, golf course, mountain views. It sits a half mile walk from the ...
- 4 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
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 9
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
vrKCV - Mauna Lani Fairways 903, Professionally Managed by Kona Coast Vacations
Living Aloha at Mauna Lani Fairways 903 — Prime Location, Superb Views and Beach Club Access.
Relax, unwind, and enjoy all the amenities that this ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waimea
Aloha and welcome to Kapalua located on the West side of Island of Maui. Our 1 bedroom 2 bath villa has been renovated with only top-of-the-line materials and furnishings. Full-size kitchen features granite counters and stainless-steel ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
Ke Alaula Villa 217B is located in the Award Winning Resort Community of Hualalai Four Seasons.
3 Bedrooms / 3 Baths
Living Area: 2,657 sqft and 940 sqft of Lanai
Ocean,Golf Course and Mountain Views
Spilt Level Townhouse
2 ~...
- 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
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
IDEAL FOR ... Corporate & Long Stays ! Centrally Located -
CLOSE TO ... Golf & Disney !
Our home is located in an exclusive Quiet Private area of Kapolei, Honolulu County, Hawaii, away from the hustle and bustle of town and yet close ...
- 5 bedroom
- 4 bathroom
- Sleeps 11
Hawaii> Kapolei
Welcome to a world where moments transcend into timeless memories—a place we lovingly call “Luxury In Paradise”. Whether you’re celebrating a birthday, anniversary, a new job, retirement, or simply celebrating the sunshine, our home and ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach
This 2,500 sq. ft. luxury home is at the end of a cul-de-sac in the amazing Ka Milo development of Mauna Lani. It features 4 bedrooms and 3 and 1/2 baths, sleeping up to 10.
Bedroom descriptions: The owner's suite on the bottom floor has...
- 4 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Waimea
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
Welcome to Olu’olu (meaning a “happy" home, in Hawaiian), which it will always be! Enjoy beautiful Wailea, in South Maui at our home!
Olu’olu is remodeled, beautiful and relaxing. Your first view from the living room lanai, across ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea, Maui
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.
We have recently remodeled our bedrooms including the loft with new furniture, new flooring and flat screen TVs. It is a ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
ENJOY MAUI'S ocean sunsets every night from your own patio after sun drenched days at world famous Kaanapali Beach. Situated right on the lush green fairways of Royal Kaanapali's North Course, this beautiful suite has TWO spacious bedrooms ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
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
