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 '%White Sands Village%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Hale Lihi Lani
Ocean View Vacation Rental at White Sands Village.
We are located 4 miles south of charming Kailua-Kona Village and directly across from Kona's spectacular Magic Sands Beach. You will enjoy beautiful ocean views and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
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
Hawaii> Kailua-Kona
This lovely and quiet 2 bedroom, 2 bath condo is located on the second floor, there is an elevator to assist as well as open stairs. There is 2 queen sized beds with a large open kitchen, living room area that leads to the spacious lanai that ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Enjoy this two-bedroom, two-bathroom White Sands unit. Newly updated kitchen and freshly painted home. Relax on the lanai and soak in the ocean views or chill out in the air conditioning and stream your favorite show. Located on the iconic Alii ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
White Sands Village#206 is a spectacular addition to Knutson & Associates Vacation Rental Inventory.
Welcome to the best location you can rent that's this close to the only major white sands beach in Kona! This premium unit is located on ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Ocean View Vacation Rental at popular White Sands Village Complex.
We are located 4 miles south of charming Kailua-Kona Village and directly across from Kona's spectacular Magic Sands Beach. Picture yourself enjoying beautiful ocean ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Almost oceanfront, well equipped condo conveniently located in White Sands Village on Alii Dr - just 4 miles from Kona Village Center- 2nd floor w/elevator access right outside the unit -sleeps up to 4 people with a queen bed in the master ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaulua-Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
Say aloha to your home away from home on the Big Island! White Sands Village is an oceanfront condo complex in the gorgeous town of Kailua-Kona. Guests will find ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua 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
Hawaii> Kailua-Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
Welcome to 222 White Sands Village! Located directly across the street from Magic Sands Beach and LaAloa Beach Park, enjoy this 2 bedroom, 2 bath condo with ocean ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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 6
Hawaii> Kailua-Kona
Our condo has one of the best views of White Sands Beach since we are second from the front! Our condo is naturally cool because our lani is shaded from the sun by facing north. We have Central Air Conditioning system. We have very comfortable ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
White Sands Village#213 is a spectacular 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
Hawaii> Kailua Kona
White Sands Village#325 is a great new addition to Knutson & Associates Vacation Rental Inventory. The location is the Best of the BEST in the Kuakini Tower at White Sands Village! This is the TOP FLOOR CORNER UNIT! GORGEOUS OCEAN VIEWS FROM ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KAILUA KONA
Our condo is the perfect place to 'get away from it all' and kick back. We are located across the street from White Sands Beach, a premier boogie-boarding beach that attracts swimmers and snorkelers alike. White Sands beach amenities include ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> Kailua Kona
Welcome to White Sands Village, # 221! Located just across the street from Magic Sands beach, along the iconic Alii Drive, this new partly renovated 2-bedroom, 2-bathroom condo has all the amenities you could need! Desk for zoom calls, central ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
White Sands Village#225 is a great addition to Knutson & Associates Vacation Rental Inventory. The location is the Best in the Kuakini Tower at White Sands Village!
Corner West Facing Location, incredible Ocean views to enjoy from the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
No need to drive to the beach -- you're right across the street! Just steps away! Enjoy this beautiful 2BR/2BA condo in White Sands Village across the street from White Sand Beach (also known as "Magic Sands Beach.")
*This property is ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
White Sands Village#231 is a beautiful addition to Knutson & Associates Vacation Rental Inventory.
Quiet, Peaceful & Ocean views!!
NEW OWNERSHIP & NEW CHANGES AS OF JANUARY 2024!
All new bed linens, comforters, couch, recliner with ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
