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 (`headline` like '%Waikoloa Beach Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Waikoloa Beach Villas E4
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach Villas will be undergoing renovations beginning June 30, 2021. Guests will have access to a swimming ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Waikoloa Village
Aloha! Welcome to Hale Lobo, located in the Waikoloa Beach Villas community.
Check out our vitual tour:
https://my.matterport.com/show/?m=3hUEL6qoVgp
Waikoloa Beach Villas is a private gated 20-acre community approximately 21-minutes north ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Waikoloa
Waikoloa Beach Villas C23
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach Villas will be undergoing renovations beginning June 30, 2021. Guests will have access to a swimming ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Waikoloa Beach Resort
Waikoloa Beach Villas E23
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach Villas will be undergoing renovations beginning June 30, 2021. Guests will have access to a swimming ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Waikoloa Village
Waikoloa Beach Villas I33
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach Villas will be undergoing renovations beginning June 30, 2021. Guests will have access to a swimming ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 Villas will be undergoing renovations beginning June 30, 2021. Guests will have access to a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Waikoloa Beach Resort
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!
Our property is perfect for 2 couples or a family of four. Decorated to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> 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!
Our property is perfect for 2 couples or a family of four. Decorated to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Waikoloa
Waikoloa Beach Villas G22
Please scroll down for detailed information
***PLEASE NOTE: Due to current Coronavirus Restrictions we cannot currently guarantee the availability of Beach Villa Pool Services, Fitness Rooms or Community/BBQ Areas ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Waikoloa Village
Waikoloa Beach Villas! There is no better location in Waikoloa Resorts than the Beach Villas. Peaceful, quiet with very low density units. Enjoy the wide open spaces, tropical landscapes and quiet serene beauty perfectly located within ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Waikoloa Village
Waikoloa Beach Villas M33
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach Villas will be undergoing renovations beginning June 30, 2021. Guests will have access to a swimming ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Waikoloa Village
Waikoloa Beach Villas L22
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach Villas will be undergoing renovations beginning June 30, 2021. Guests will have access to a swimming ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Waikoloa Village
Waikoloa Beach Villas A1-Includes Waikoloa Gold Golf Membership
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach Villas will be undergoing renovations beginning June 30, 2021. ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Waikoloa Village
Waikoloa Beach Villas A2
Please scroll down for detailed information
PLEASE NOTE: The swimming pools and pool areas at the Waikoloa Beach Villas will be undergoing renovations beginning June 30, 2021. Guests will have access to a swimming ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Waikoloa Village
This Villa is in an excellent location right at one of the two lava rock pools that Waikoloa Beach Villas has to offer. The property is located on the ground floor which comes with many benefits. No stairs to climb, which makes bringing ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Waikoloa
