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 '%White Sands Village%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Paradise has been found in this beautiful two bedroom, two baths upgraded renovated condo in White Sands Village! Ocean view from this third floor condo with absolutely no steps to access the unit. Completely handicap accessible and no need to...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua-Kona
White Sands Village#213 is a spectacular new addition to Knutson & Associates Vacation Rental Inventory.
Welcome to the best location White Sands Village has to offer. This premium unit is located on the 2nd floor & faces DIRECTLY towards Magic...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona
CANCELLATION POLICY: Full amount due 60 days out, after which there is no refund. We highly recommend travel insurance for your contingencies. NOTE: EARLY CHECK-IN/LATE CHECK-OUT ARE RARELY AVAILABLE- Do yourself a favor and book the extra ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> kona
This condo is in a wonderful location and has a great view directly across the street from Magic Sands beach. This 2 bedroom, 2 bath fully air conditioned condo has an ocean view, and is fully equipped for a comfortable and enjoyable stay when ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kailua-Kona
Treat yourself to a relaxing vacation in this lovely furnished tropical retreat with a well-appointed kitchen, beautiful swimming pool, spa, dry sauna, barbecue, tennis courts, free covered parking and free Wi-Fi. Plus, get all the activities ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua-Kona
Stay 70 yards from famous Magic Sands Beach (White Sands Beach). Its Time to come on over and Holo Holo (vacation) with us here in beautiful, sunny, HAWAII. Your unit is located on the Big Island's famous Alii Drive directly a cross the street ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kailua-Kona
White Sands Village is Kona's Premier Vacation Rental destination with ocean and mountain views. It's located directly across the street from Magic Sands Beach; the only white sand beach between Kailua & Keauhou.
The complex has a beautiful ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Kailua Kona