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 '%Waikoloa Beach Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 30
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 3. Decorated to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas C23
Please scroll down for detailed information:
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Loft ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas G1
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom Upstairs: One Queen ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
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!
Our property is perfect for 2 couples or a family of 3. Decorated ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa,
This fabulous stylish place to stay is perfect for family or group trips. Enjoy a lap of luxury staying at Hale Lobo | Waikoloa Beach Villas L-4. Bespoke aloha 3/3 townhouse style end-unit in paradise. Hale Lobo is centrally located and is ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas N1. Please scroll down for detailed information
Hilton Pool Pass: Valid for stays in 2024. Maximum 6 persons per pass (children under the age ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas G22
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: One Queen Bed
Beach ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas I2.
Please scroll down for detailed information:
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Two Twin ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas A1-Includes Waikoloa Gold Golf Membership
Please scroll down for detailed information
Waikoloa Beach Resort Gold Membership Golf benefits ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas I33
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: King Bed
Additional ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Welcome to Waikoloa Beach Villas K22! This charming 2 bedroom 2 bathroom condo with lanai and BBQ will make you never want to leave The Gold Coast! The Waikoloa Beach Villas is a gated community within walking distance of the Queen's and King's ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas L2
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: One Queen Bed
Living ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
Stunning end-unit townhouse in tropical Hawaii. Come relax and unwind in Paradise. This spacious 3 bedroom, 3 bathroom 2 story townhouse is 1860 sq. ft, and sleeps 6 people comfortably. There is a trundle bed in the sitting area upstairs ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Waikoloa
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas M23
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: One King Bed
Guest Bedroom: One Queen Size ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Beach Resort
Looking for a luxurious and comfortable vacation rental in Waikoloa, Hawaii? Look no further than this stunning two bedroom and two bath condo at the Waikoloa Beach Villas.With a magnificent golf course view and an outdoor kitchen, this condo is...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa
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
Hawaii> Waikoloa Village
This brand new upscale luxury condo is located in the privately gated new Waikoloa Beach Villas Complex, close to the activity center with two pools, fitness workout room and spa areas.
Unit includes discounted GOLD GOLF KINGS' CLUB ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa,
Luxurious top of the line Hawaii vacation condo! Away from it all, yet central to everything at the Waikoloa Beach Resort – located on the sunny Kohala Coast of the Big Island. This secluded unit is just 20 minutes north of the Kona ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa
We have traveled from our island home in Honolulu numerous times over the years to explore the Big Island. The Big Island offers a diversity of amazing sights including a huge selection of beautiful sunny beaches, snow-capped Mauna Kea, and an ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa,
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas E4
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom Upstairs: One Full Size ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas M33
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Two Full Size ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas L22
Please scroll down for detailed information
All new appliances installed in 2023!
Bedding Configuration:
Master Bedroom: King ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
We have traveled from our island home in Honolulu numerous times over the years to explore the Big Island. The Big Island offers a diversity of amazing sights including a huge selection of beautiful sunny beaches, snow-capped Mauna Kea, and an ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa,
This brand new upscale luxury condo is located in the privately gated new Waikoloa Beach Villas Complex, close to the activity center with two pools, fitness workout room and spa areas.
Unit includes discounted GOLD GOLF KINGS' CLUB ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa
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 6
Hawaii> Waikoloa,
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas I22.
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas B3
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas A23
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: King Bed
Loft Area: ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
~Aloha~
Our condo is located in the sunny Waikoloa Beach Resort on the Big Island of Hawaii. It's not nicknamed the Gold Coast by coincidence. It is the sunniest part of the island with the least amount of rainfall. The Waikoloa Beach ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa,
This beautiful 2 bedroom, 2 bath villa has everything you need for a great vacation on The Big Island of Hawaii.
Master bedroom has a king bed and on suite bath. Guest bedroom has 2 full size beds. NEWLY remodeled guest bathroom with a ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa,
