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 Beach Resort' OR postalCode = 'Waikoloa Beach Resort' OR region like '%|Waikoloa Beach Resort|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Maximum occupancy strictly enforced in accordance with local ordinances.
Kolea 14F is nestled along tranquil blue waters and soft sand beaches of Anaeho'omalu Bay (A-BAY). Ideal for families or for individuals who enjoy gracious, ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas C23
PLEASE NOTE: Waikoloa Beach Villas C23 is listed for sale. Guests may be asked to accommodate showings/inspections with 24 hours notice. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
PROPERTY DESCRIPTION: Ours is the most spacious floor plan at Hali’i Kai with 1677 square feet, 1930 square feet if include the two lanais. This is a two-story Townhome with the entrance on the second floor, no elevator.
You will enjoy...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
PROPERTY DESCRIPTION: KOLEA PENTHOUSE VILLA 16F - 2BR, 2BA- TOP (3rd) FLOOR with a 3-Mountain Views, elegant tropical decor, and direct beach access. Sleep 4.
Experience the finest in luxury at Kolea. This beautiful 2-bedroom, 2-bath ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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 condo, you will get to enjoy Hali'i Kai's unique Ocean Club. Perched at the ocean's edge, it ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 13A. Includes Waikoloa Gold Golf Membership Discounts
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Beach Resort
11C is a prime location to enjoy those seamless Hawaiian sunsets. Situated right by the ocean, you will be able to smell the salt air as the winds of Waikoloa breeze on by. The condo is footsteps away from the Ocean Club, where you can enjoy ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas I2.
Please scroll down for detailed information
Waikoloa Beach Resort Gold Membership Golf benefits (discounted tee fees at the Waikoloa Beach ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 10G. Ocean Views!
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Guest ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas E23
Please scroll down for detailed information
Hilton Pool Pass: Valid for stays through June 30, 2025. Maximum 6 persons per pass (children ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Shores at Waikoloa Villa 21
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: 2 Full ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Fairway Villas H4
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom Downstairs: One Queen Bed
Guest Bedroom Upstairs: Two Twin ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Colony Villas 1002
Please scroll down for detailed information.
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: King Bed
Guest ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Shores at Waikoloa Villa 2
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: 2 Queen ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Fairway Villas at Waikoloa Beach Resort J23
Please scroll down for detailed information
Bedding Configuration:
Main Bedroom: King Bed
Guest Bedroom : 1 ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Beach Resort
Waikoloa Beach Villas M23
Please scroll down for detailed information:
Bedding Configuration:
Master Bedroom: One King Bed
Guest Bedroom: One Queen Size Bed
Additional Bed: Twin Size Roll-away Bed
Hilton Pool Pass: ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Shores at Waikoloa 331
Please sPcroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Living Room: Sleeper ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Fairway Villas G4
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom : Two Full Size ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas J2
Please scroll down for detailed information
Hilton Pool Pass: Valid for stays through 2025. Maximum 6 persons per pass (children under the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
Waikoloa Fairway Villas N24
This vacation rental is professionally managed by ResorticaHawaii
Please scroll down for detailed information
Bedding Configuration:
Main Bedroom: King Bed
Guest Bedroom : Two Twin Size Beds ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
Fairway Villas at Waikoloa E2
Please scroll down for detailed information
PLEASE NOTE: Waikoloa Fairway Villas E2 has been listed for sale. Guests may be asked to accommodate showings/inspections with 24 hours notice. Please reach ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
Waikoloa Colony Villas 101. Newly remodeled in 2023!
Please scroll down for detailed information
Hilton Pool Pass: Valid for stays through June 30, 2025. Maximum 6 persons per pass (children under the age of 5 are not counted towards ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
Vista Waikoloa B305. Ocean Views!
This vacation rental is professionally managed by ResorticaHawaii
Please scroll down for detailed information
Hilton Pool Pass: Valid for stays through June 30, 2025. Maximum 6 persons per pass ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
Waikoloa Beach Villas E22. Newly Renovated in 2024!
Please scroll down for detailed information:
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: King Bed
Living Room: Sleeper Sofa
Amenities:
Beach ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
Waikoloa Beach Villas N23
Please scroll down for detailed information:
Bedding Configuration:
Master Bedroom: One King Bed
Guest Bedroom: One Queen Size Bed
Living Room: Sleeper Sofa
Amenities:
Beach Equipment: All ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
Halii Kai 18G
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Guest Bedroom: Two Twin Beds
Living Room: Sleeper Sofa
Please note: There is a ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
Summary:
When choosing the perfect destination for your upcoming vacation, where you’ll stay is of the highest importance. Maximum occupancy strictly enforced in accordance with local ordinances.
The Space:
You want a place that ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
This luxurious resort condominium with spectacular views is located along the 12th fairway of the Waikoloa Beach Golf Course and is exclusive only to residents and guests. From the shimmering blue ocean and breathtaking fiery sunsets, to the ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Fairway Villas K31
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 J33
Please scroll down for detailed information
Hilton Pool Pass: Valid for stays through June 30, 2025. Maximum 6 persons per pass (children ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Colony Villas 1202. Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Guest ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
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 Beach Resort
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 Bed
Additional ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas J22
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
Unit 321 at the Shores is your home away from home. It's been remodeled with travertine marble bathroom, vessel sinks, bamboo flooring, new kitchen counters, etc. This unit is over 1200 square feet in area and furnished with Polynesian style ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas B23
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: King Bed
Loft Area: 1 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Colony Villas 302
Please scroll down for detailed information
Hilton Pool Pass: Valid for stays through June 30, 2025. Maximum 6 persons per pass ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Halii Kai 15H
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Queen Bed
Guest Bedroom: 2 ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Colony Villas 1303
Please scroll down for detailed information
Hilton Pool Pass: Valid for stays through June 30, 2025. Maximum 6 persons per pass ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
Waikoloa Beach Villas F2
Please scroll down for detailed information:
Hilton Pool Pass: Valid for stays through June 30, 2025. Maximum 6 persons per pass (children under the age of 5 are not counted towards the 6 person max). Use of ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
Private End Unit | Hilton Pool Pass | 140” Movie Projector Screen
Experience luxury and relaxation at Waikoloa Colony Villas 2201—your private, upscale retreat in the heart of Waikoloa Beach Resort – the sunniest part of the island!...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas C1
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom Upstairs: One Queen ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
Hilton Waikoloa Pool Pass for stays in 2024!
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Colony Villas 1102. Please scroll down for detailed information
*****Newly remodeled in late 2022. ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas F4
Please scroll down for detailed information
Hilton Pool Pass: Valid for stays through June 30, 2025. Maximum 6 persons per pass (children ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Fairway Villas O4.
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom Upstairs: One Queen ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas C4
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom Upstairs: One Queen ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Colony Villas 2705
Please scroll down for detailed information
PLEASE NOTE: There is ongoing construction in the adjacent resort area nearby Building ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Colony Villas 505. Please scroll down for detailed information
Hilton Pool Pass: For stays through June 30, 2025. Maximum 6 persons per pass (children under...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Beach Resort
Waikoloa Colony Villas 2101
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: Queen Bed
Guest Bedroom: King Bed
Amenities:
Beach Equipment: All of our vacation rentals include beach ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
