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, 30
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
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> 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
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
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
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
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
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
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
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
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
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#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
Maximum occupancy strictly enforced in accordance with local ordinances.
Say aloha to your Big Island vacation rental! White Sands Village is an oceanfront condo complex in the gorgeous town of Kailua-Kona. Guests will find themselves in...
- 2 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
Maximum occupancy strictly enforced in accordance with local ordinances.
Say aloha to your Big Island vacation rental! White Sands Village is an oceanfront condo complex in the gorgeous town of Kailua-Kona. Guests will find themselves in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua Kona
Maximum occupancy strictly enforced in accordance with local ordinances.
Family and friends will love staying at White Sands Village. This Big Island of Hawaii complex is right across the street from White Sands Beach. Spend your days ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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
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
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 provide. Here, on...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kailua Kona
