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 (city = 'Waikoloa Village' OR postalCode = 'Waikoloa Village' OR region like '%|Waikoloa Village|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
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
Your Island Paradise Awaits You! Feel right at home in our spacious 1700 square foot, 3 bedroom, 2 1/2 bath Villa with an attached garage. This beautifully decorated Villa is just steps away from the resort style pool featuring a lava rock ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
OCEANFRONT VILLA Handicapped accessible No carpet
3 bedroom
2 bathroom
Sleeps 5
Hawaii> Waikoloa Village
Welcome back to the Aloha State.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waikoloa Village
Kolea 8C is a three bedroom, three and a half bath penthouse villa with an exquisite ocean and mountain view. It is perfectly situated overlooking the Kolea Beach Club, Anaeho’omalu Bay and Hualalai. The African Mahogany trimmed glass panels ...
3 bedroom
4 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Come enjoy the beauty of Hawaii in our perfectly located condo at Waikoloa Beach Villas. Just 20 minutes north of the Kona airport you will find yourself in paradise!
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa Village
Aloha and welcome to Leilani in the Beach Villas in the Waikoloa Beach Resort. A flawless vacations start at here, from it's lush palm-shaded grounds and lava rock swimming pools, to it's gourmet kitchen and private lanais scented by tropical ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
vrKCV - Hali'i Kai 10E, Professionally Managed by Kona Coast Vacations
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Hali'i Kai Ocean Front Resort is truly a gem on the sun-drenched Kohala Coast of the Big Island in the Waikoloa Beach Resort. The properties' grounds are well-kept, and the sunset views are AMAZING! Our unit, Hale Little Blue Whale (7F), is a ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waikoloa Village
Aloha and welcome to the idyllic gated community of Hali'i Kai! We're thrilled to introduce you to our exquisite, 180-degree oceanfront condo, where luxury meets affordability, and offers all the indulges, beauty, and relaxation that the Big ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Hali'i Kai is a gated community located in the Waikoloa Beach Resort area,
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa Village
Halii Kai 10H
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Our slice of Hawaiian Paradise! Traveller cancellation is your opportunity to secure dates in Feb and March 2025! We do not usually have dates available during this time!
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa Village
This beautifully decorated deluxe three bedroom condo is situated in the heart of Waikoloa Beach Resort. With no units above or below, the condo offers the most in privacy. It is newly professionally decorated in Ocean colors with granite and ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
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
You'll find all the comforts of home in this tropically furnished condo with scenic views of the mountains and golf course. Picture yourself relaxing in the reclining chair in the living room, where you can look out at the golf course or simply ...
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waikoloa Village
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
Hale 'O Malina is located in beautiful Waikoloa Village. The "Village" as it's affectionately referred to is located just up the road from world class golf courses, pristine beaches, stunning resorts, amazing restaurants and so much ...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waikoloa Village
Modern luxury right on the Waikoloa Village Golf Course! Ocean and sunset views from the lanai and almost every room!! Our Hawaiian home was completely renovated in 2017, with a brand new kitchen featuring custom maple cabinets, quartz ...
2 bedroom
3 bathroom
Sleeps 4
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waikoloa Village
A LUXURIOUS VIEW CONDO CLOSE THE THE BEACH AT VISTA WAIKOLOA - THE ENTIRE CONDO HAS BEEN COMPLETELY RENOVATED AND UP TO DATE!
2 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Ainamalu located at the entrance of the Waikoloa Beach Resort road. A 20 minute drive from the Ellison Onizuka Kona International Airport at Keahole. Our home is a 3 bedrooms 2 bath (model Kalani). There is a fabulous view of the Mauna Kea ...
4 bedroom
2 bathroom
Sleeps 8
Hawaii> Waikoloa Village
Elegantly furnished Condo with Ocean Views from every room located on the Waikoloa Beach Golf Course! Walk to Waikoloa Hilton (restaurants, shops), Island Gourmet Market (grocery store), or to 'A' Bay beach. Truly a paradise location! ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Looking for just the right place to enjoy your Big Island Hawaiian Holiday? Treat yourself to a fresh approach. Your own private 1 bedroom 1 bath cottage. Newly renovated, this delightful guest cottage is tucked away behind gates at the end ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waikoloa Village
Bright and sunny second floor 2 bedroom, 2 bath condo. Amazing lanai views overlooking the 14th tee of the Waikoloa Village golf course with partial ocean views. A short walk to a grocery store, restaurants, and shopping. The condo is less than ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Aloha! Welcome to Hali'i Kai, recently named #1 resort on the Big Island, which is located in Waikoloa on Kohala's Gold Coast, so named because our 350 annual days of sunshine is the most in Hawai'i. Hali'i Kai, is the only gated resort on the ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waikoloa Village
Beautiful 2 bedroom private villa with tranquil golf course views is the perfect place for a relaxing vacation! Due to covid-19, the property is disinfected and cleaned in preparation for every stay.
2 bedroom
3 bathroom
Sleeps 5
Hawaii> Waikoloa Village
The largest floor plan at Vista Waikoloa at 1428sf: This newly remodeled unit has an abundance of natural light and privacy curtains throughout.. I also provide nice breakfast items for your first morning. The fruit plate is to die for....
2 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Everything you need for a fun vacation. A lovely, impeccably cleaned, fully-equipped home with travertine flooring, fully-equipped kitchen with granite countertops, hickory cabinets, stainless appliances, breakfast bar, teak furniture, tropical...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa Village
Totally furnished and centrally located and less than 6 miles to several of the most beautiful beaches on the Big Island of Hawaii! It sits above the beautiful Kohala Coast. Just 9 Miles from Waimea where the famous Parker Ranch is located, ...
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Waikoloa Village
Welcome to our family’s piece of paradise. We’ve been travelling to Hawaii for twenty years, and our condo is the fulfillment of a dream to call the Big Island our second home. Our goal is to provide you with that same sense of ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa Village
Updated Upstairs condo swimming pool, hot tub, and work out room just a few steps away.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa village
Perfectly located in Waikoloa Beach Resort - Big Island! Close to all the best beaches on the Kohala Coast!
0 bedroom
1 bathroom
Sleeps 2
Hawaii> Waikoloa Village
2 bedroom
3 bathroom
Sleeps 6
Hawaii> Waikoloa Village
This pristine 3 bedroom, 3 bathroom home has 1,725 square feet in 2 stories with expansive outdoor spaces and backs up to Hole 3 of the prestigious Waikoloa Beach Resort Golf Course.
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Frolic with amazing sunny beach runs by day, and peaceful tropical tranquility by night with 2 private suites in our manicured gated community with full golf course views, partial ocean views and nightly sunsets from our villa. Enjoy the morning...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Waikoloa Village
Halli Kai is an upscale gated oceanfront property and the only Waikoloa Beach Resort with private restaurant and poolside bar. The Condo is centrally located in the complex and hosts unobstructed ocean and golf views from the living room, lanai,...
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Welcome to our slice of Hawaii paradise! This fully updated and remodeled unit offers a taste of luxury in every corner. From the tiled entrance, kitchen, and bathrooms to the hardwood floors that grace the remaining spaces, you'll find comfort ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Waikoloa Village
Kolea 14K Current Special Rate $550/nt+tax plus $100 Lava Lava Beach Card for a Limited Time!
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Our townhome features an open concept greatroom, fully-equipped gourmet kitchen with new amenities, 3 bedrooms (2 with kingsize beds). Great for families! Enjoy stunning ocean and mountain views while you relax in the most spacious floor plan at...
3 bedroom
3 bathroom
Sleeps 8
Hawaii> Waikoloa Village
Luxury Kolea Villa at Big Island Waikoloa Resort
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Please contact me for availability before booking. Some dates are still available even though they show on VRBO as taken and some dates might not be available as inventory is live. Also, pics are from Hilton Grand Vacations and not my personal...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Located in the acclaimed Kolea community, one of the most sought-after oceanfront developments on the island, Hale Mermaid penthouse is a spacious 2 bedroom, 2 bath luxury penthouse with partial views of Anaeho’omalu Bay. It is an 'end-unit' ...
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
Concierge Realty is proud to present luxury suites at Marriott's Waikoloa Ocean Club!
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Waikoloa Village
Kings' Land - 2 Bedroom Hilton HGVC
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Waikoloa Village
We first listed Villa One on VRBO May 1 2022. It had previously been an active and successful VRBO for over 6 years. We've had many happy guests, and many 5 star reviews. This exceptional and private condominium is the first ground floor ...
2 bedroom
3 bathroom
Sleeps 4
Hawaii> Waikoloa Village
