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 Village' OR postalCode = 'Waikoloa Village' OR region like '%|Waikoloa Village|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Totally furnished and centrally located and less than 6 miles to several of the most beautiful beaches on the Big Island of Hawaii! It sits above the beautiful Kohala Coast. Just 9 Miles from Waimea where the famous Parker Ranch is located, ...
3 bedroom
2 bathroom
Sleeps 8
HI> Waikoloa Village
In this spot of paradise you will be swept away by breathtaking coastal views and rainbow mountains. This secluded property has a unique privacy that few homes have. The situation of the home on the property maximizes the Waikoloa breezes and ...
4 bedroom
2 bathroom
Sleeps 10
HI> Waikoloa Village
***COVID Update***
-Please refer to the State of Hawaii Tourism Authority Website for the most up to date information.
-Contact free check-in available with our lock box.
-Previous guests have rated our space "sparkling clean"!
-We have also ...
4 bedroom
3 bathroom
Sleeps 10
HI> Waikoloa Village
Hawaiian charm and modernity! Our spacious 1446 square foot, 2 bedrooms, 2.5 bath condo at the Waikoloa Colony Villas is located within the prestigious Waikoloa Beach Resort which offers spectacular views of Hualalai, Mauna Loa and Mauna Kea ...
2 bedroom
3 bathroom
Sleeps 4
HI> Waikoloa Village
Come and enjoy a luxurious laid-back island living in our new home located in the beautiful new neighborhood in Waikoloa Beach Resort – Ainamalu. This gated community Ainamalu "Protected, Peaceful Land" is the newest resort community in the ...
3 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa village
Beautiful one bedroom and one bath condo located at the highly desirable Waikoloa Villas in Waikoloa Village. You are just a short drive to the best beaches on the island and are conveniently located to many great restaurants, a grocery store, ...
1 bedroom
1 bathroom
Sleeps 2
HI> Waikoloa Village
Native-Hawaiian Owned — Fairway Villas unit G34
Your next perfect vacation begins at this spacious 1233 sq ft condo on the 3rd floor of Fairway Villas Building G (unit G34)! This condo sleeps up to 6 people in a master bedroom (king bed), a ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa Village
Concierge Realty is proud to present luxury villas at The Bay Club in Waikoloa Beach.
ARRIVALS ARE FRIDAY, SATURDAY, SUNDAY AND MONDAY ONLY. RESERVATIONS AVAILABLE IN SEVEN NIGHT INCREMENTS ONLY.
The Bay Club, located in Waikoloa Beach ...
1 bedroom
1 bathroom
Sleeps 4
HI> Waikoloa Village
Your Island Paradise Awaits You! Feel right at home in our spacious 1700 square foot, 3 bedroom, 2 1/2 bath Villa with an attached garage. This beautifully decorated Villa is just steps away from the resort style pool featuring a lava rock ...
3 bedroom
3 bathroom
Sleeps 6
HI> Waikoloa Village
This pristine 3 bedroom, 3 bathroom home has 1,725 square feet in 2 stories with expansive outdoor spaces and backs up to Hole 3 of the prestigious Waikoloa Beach Resort Golf Course.
Master Bedroom: enjoy serenity in your master suite. King ...
3 bedroom
3 bathroom
Sleeps 8
HI> Waikoloa Village
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 and welcome to the Big Island of Hawaii. Our recently remodeled home is steps away from Shopping, Dining, Entertainment, and World Famous A’ Bay Beach- great for swimming and snorkeling. Covered parking is included. Great for all types ...
2 bedroom
2 bathroom
Sleeps 6
HI> Waikoloa Village
Waikoloa Colony Villas 304
Please scroll down for detailed information
PLEASE NOTE: The Mauka Pool and Hot Tub will be closed for renovations from mid-April for approximately 6 weeks barring any unforseen issues/delays. The Makai Pool ...
2 bedroom
3 bathroom
Sleeps 4
HI> Waikoloa Village
We look forward to having you as our guests! This tastefully decorated 3 bedroom, 3 bathroom town home is very private yet close to the pool and walking distance to the Queen's Shops where you will find an outdoor mall with restaurants and local...
3 bedroom
3 bathroom
Sleeps 8
HI> Waikoloa Village
Sit back & relax at this stunning 2 bdrm/ 2 bath condo. Enjoy the fully equipped kitchen, comfortable dining, living rooms, and outside ground floor lanai with a BBQ. The 2nd floor features 2 bdrms, 2 bath, washer and dryer. Free WiFi & parking ...
2 bedroom
2 bathroom
Sleeps 5
HI> Waikoloa Village
