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, 50
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
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Escape to Paradise at White Sands Village in Kailua Kona! Unit#121 has all the essentials one needs for a Beachfront Vacation.
Welcome to your perfect Hawaiian getaway! Nestled in the heart of Kailua Kona, this 2-bedroom, 2-bathroom unit...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Hello ocean views! You can watch the sun sink into the ocean every night from your private lanai off this inviting top-floor condo. From this vantage point, you’ll get spectacular views of the sunsets and be able to hear the crashing of the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Summary:
Say aloha to your home away from home on the Big Island! Maximum occupancy strictly enforced in accordance with local ordinances.
The Space:
White Sands Village is an oceanfront condo complex in the gorgeous town of ...
- 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 king bed in the master ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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 ...
- 3 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 3 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 ...
- 3 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua 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
Summary:
Welcome to 222 White Sands Village! Maximum occupancy strictly enforced in accordance with local ordinances.
The Space:
Located directly across the street from Magic Sands Beach and LaAloa Beach Park, enjoy this 2 bedroom, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Enjoy a little piece of home away from home at this Beautiful 2 bed/2bath condo in White Sands Village, Kona's Premier Vacation Rental destination with ocean and mountain views.
This complex is located directly across the street from ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Special Rate! Last Minute Deal when you book to arrive 2/28 - 3/4/2025.
Steps from the beach at White Sands Village #334
No need to drive to the beach -- you're right across the street! Just steps away! Enjoy this beautiful 2BR/2BA...
- 3 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
Summary:
Say aloha to your Big Island vacation rental! White Sands Village is an oceanfront condo complex in the gorgeous town of Kailua-Kona. Maximum occupancy strictly enforced in accordance with local ordinances.
The ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Enjoy the private lanai across from iconic Magic Sands Beach. Central air conditioning and all the amenities you need for a relaxing Hawaii vacation. Upon entry, you are welcomed by the Hawaii vibe throughout. Kick back in the Primary ensuite on...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Summary:
Family and friends will love staying at White Sands Village. Maximum occupancy strictly enforced in accordance with local ordinances.
The Space:
This Big Island of Hawaii complex is right across the street from White Sands...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kailua Kona
White Sands Village 327 is a comfy condo w/ all of the pleasures from home as well as all the amenities you expect of your favorite vacation spot. Enjoy the pool and spa, walk across the street and take a dip in the ocean, or lounge on the lanai...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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(currently unavailable), free covered parking and free Wi-Fi. After ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
One of the best locations at this Alii Drive 3-story complex! Second floor, spacious end unit with breathtaking ocean views. An absolute perfect place to watch the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Summary:
Whether you’re after serenity along the ocean shores or adventure beneath the waves during your upcoming vacation, White Sands Village promises an unforgettable getaway immersed in a culture that only the Hawaiian Islands can ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kailua Kona
Summary:
As the largest and most diverse of Hawaii’s islands, the Big Island offers something for everyone—from lush rainforests and volcanic craters to pristine beaches and star-filled skies. Whether you’re seeking relaxation, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua Kona
