select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) as vw where 1 and round(price)>0 and bedrooms>=0 AND (city = 'Waikoloa Beach Resort' OR postalCode = 'Waikoloa Beach Resort' OR region like '%|Waikoloa Beach Resort|%') order by rating desc LIMIT 0, 15
Waikoloa Beach Villa is a relaxed haven for the entertainer and features three bedrooms, three full bathrooms, and accommodates up to eight ...
-
3
bedroom
-
3
bathroom
-
Sleeps 8
HI>
Waikoloa Beach Resort
E KOMO MAI – Welcome!
Make this beautiful townhouse your “home away from home” as you explore the rich diversity of the Big Island! ...
-
3
bedroom
-
3
bathroom
-
Sleeps 8
HI>
Waikoloa Beach Resort
Aloha! This stunning Waikoloa Beach Villa is surrounded by the sights, sounds and feel of the ocean, and features two bedrooms, two full ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Waikoloa Beach Resort
Enjoy expansive ocean and sunset views from this beautiful Hali’I Kai vacation condo with Waikoloa Gold Golf Membership Privileges for guest ...
-
2
bedroom
-
2
bathroom
-
Sleeps 5
HI>
Waikoloa Beach Resort
Aloha from 1102 Waikoloa Colony Villa! This tropical paradise 2-story condo is located on the 10th fairway of the picturesque Waikoloa Beach Golf...
-
3
bedroom
-
3
bathroom
-
Sleeps 8
HI>
Waikoloa Beach Resort
Waikoloa Fairway Villa K31 is a spectacular two bedroom, two bathroom penthouse with gorgeous sunset lake views. Close to the ocean in a perfect ...
-
2
bedroom
-
2
bathroom
-
Sleeps 4
HI>
Waikoloa Beach Resort
Our villa provides 2 Bedrooms and 2.5 Baths, totalling over 1400 square feet plus 2 Lanais.
It is perfect for families or couples vacationing ...
-
2
bedroom
-
3
bathroom
-
Sleeps 5
HI>
Waikoloa Village
Waikoloa Beach Villas I22.
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach ...
-
2
bedroom
-
2
bathroom
-
Sleeps 2
HI>
Waikoloa Beach Resort
Our condo is located in Waikoloa Beach Resort area not Waikoloa Village.
Our beautiful two-bedroom, two bath penthouse condominium is in a ...
-
2
bedroom
-
2
bathroom
-
Sleeps 5
HI>
Waikoloa Beach Resort
Welcome to Cooks Landing! A 3 bedroom 2 bath ground floor luxury villa (18H) in the prestigious Hali'i Kai gated condominium community of ...
-
3
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Waikoloa Beach
Villa One overlooking the Pacific Ocean, Palm Trees, and the fairways of the Beach Golf Course is a brand new, luxuriously furnished, decorator ...
-
2
bedroom
-
3
bathroom
-
Sleeps 4
HI>
Waikoloa Beach Resort
This large upscale 2BR/2BA villa is at Hali'i Kai, the only OCEANFRONT condo community within the famous Waikoloa Beach Resort. Besides a great ...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Waikoloa Beach Resort
Enjoy your stay at our home away from home at the Fairway Villas. With its truly Hawaiian plantation style architecture situated spectacularly on...
-
2
bedroom
-
2
bathroom
-
Sleeps 6
HI>
Waikoloa
Waikoloa Fairway Villa O4 is an exceptional getaway in the tropical paradise of Hawaii, with contemporary architecture and merged indoor/outdoor ...
-
3
bedroom
-
3
bathroom
-
Sleeps 8
HI>
Waikoloa Beach Resort
Location is everything on vacation, and Waikoloa Beach Colony Villas are conveniently located on Hawaii’s Kohala Coast with Big Island’s best...
-
2
bedroom
-
3
bathroom
-
Sleeps 6
HI>
Waikoloa Beach Resort
