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 '%Shores at Waikoloa%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Shores at Waikoloa Villa 21. Newly remodeled in 2021!
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ Areas ***
...
2 bedroom
3 bathroom
Sleeps 4
HI> Waikoloa Village
Covid-19 Notice: Available amenities vary at each Complex, many have restricted use. Please inquire with KCV
Aloha and welcome to The Shores at Waikoloa Beach Resort, an upscale condominium complex only 20 minutes north of the airport. The ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Shores at Waikoloa 306
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ Areas ***
Bedding Configuration:
Master ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa Village
This 1 Bedroom 1 Bath unit has a comfortable breezy feeling. Comfortable King sized bed, fully appointed Kitchen, and a large wrap around lanai. This is the perfect place to wind down and enjoy your vacation. Head down to a fabulous restaurant, ...
1 bedroom
1 bathroom
Sleeps 4
HI> Waikola
Shores at Waikoloa 317. Newly remodeled!
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ Areas ***
Bedding ...
1 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa Village
This second floor unit has partial ocean and golf course views. We have a large wrap around lanai to enjoy the great views with table, chairs and patio recliners.
Kitchen has everything you need, Master bedroom has a king bed and guest bedroom ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa
This second floor unit has partial ocean and golf course views. We have a large wrap around lanai to enjoy the great views with table, chairs and patio recliners.
Kitchen has everything you need, Master bedroom has a king bed and guest bedroom ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa
Shores at Waikoloa 328
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ Areas ***
Bedding Configuration:
Master ...
1 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa Village
Shores at Waikoloa 303. Ocean Views! Updated Furnishings and decor.
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ...
2 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa Village
Shores at Waikoloa Villa 23
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ Areas ***
Bedding Configuration:
...
2 bedroom
3 bathroom
Sleeps 6
HI> Waikoloa Village
Located in the Kamani Court Building, this single level vacation rental offers plenty of natural light to brighten up your Big Island vacation. Between the open-concept living area or open-air lanai you are sure to find your perfect piece of ...
1 bedroom
2 bathroom
Sleeps 4
HI> Waikoloa
Located on the west coast of Hawaii Island (The Big Island) known for its many golf resorts, Shores at Waikoloa is a gated condominium resort community nestled between two Waikoloa golf courses. A stress-free alternative to mega-resorts-Shores ...
1 bedroom
1 bathroom
Sleeps 4
HI> Waikoloa
This budget-friendly 2 bedroom, 2 bathroom vacation home is located on the 3rd floor of the Tamarind Tower overlooking pool and resort water feature.
Located on the west coast of Hawaii Island (The Big Island) known for its many golf ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa
Surrounded by golf course views of the Waikoloa Beach Resort, this family friendly condo is the perfect way to explore the Big Island. The tropical resort features luscious greenery, koi ponds, a shared swimming pool, a fitness room, and BBQ ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa Beach Resort