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, 20
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:
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex....
- 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
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex. ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Village
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas N1. Please scroll down for detailed information
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex....
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa Village
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex. The scope of work to include Ohia Wood Posts a, 2nd and 3rd floor railings, trellises and A/C enclosures at each building. Each building will be ...
- 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
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex....
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa Beach Resort
This vacation rental is professionally managed by ResorticaHawaii
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex. The scope of work to include Ohia Wood Posts a, 2nd and 3rd floor railings,...
- 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
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex....
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Welcome to our Big Island Kahuna with a Touch of Nostalgia condo in Waikoloa! We are excited to have you as our guests. This beautifully appointed 3-bedroom, 3-bathroom townhome at Waikoloa Beach Villas offers both privacy and convenience. ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
This vacation rental is professionally managed by ResorticaHawaii
Waikoloa Beach Villas L2
Please scroll down for detailed information
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex. ...
- 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
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex. The scope of work to include Ohia Wood Posts a, 2nd and 3rd floor railings, trellises and A/C enclosures at each building. Each building will be ...
- 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
Luxurious tropical island vibe. Relax and take in all Hawaii has to offer with fully furnished condo in walking distance to shops, restaurants, beaches and entertainment.
The Space: Highly desirable location for both privacy and ...
- 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,
Come share the enjoyment of our home away from home in Hawaii!
Enjoy your stay at this Hawaiian plantation style villa adjacent to the King's Shops and a short walk to the scenic Anaeho'omalu Bay. The villa is located on the 3rd green of ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
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 ResorticaHawai
Waikoloa Beach Villas E4
Please scroll down for detailed information
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the complex. ...
- 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
PLEASE NOTE: Waikoloa Beach Villas will be restoring exterior woodwork throughout the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
