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 '%Sands of Kahana%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Welcome to your slice of paradise in West Maui! This exquisite 2-bedroom, 2-bathroom condominium is nestled within the renowned Sands of Kahana Resort, offering an unparalleled oceanfront experience that will leave you ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
***WOW - DIRECT OCEANFRONT - AC***
SANDS OF KAHANA
The Aloha Spirit invites you to come and experience firsthand the many activities and beautiful sunsets that await you at the Sands Of Kahana. Whether you're looking for a relaxing ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Imagine your next vacation in paradise and now imagine you are able to rent a condo that has all of the comforts of home and the views dreams are made of.
Sands of Kahana unit 326 on the second floor of the oceanfront building 3 (feels ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Your Maui Paradise Retreat Awaits! Ocean/ Beachfront Bliss at the highly sought after resort of Sands of Kahana with Air Conditioning!
Book with Confidence and get ready for an unforgettable escape to paradise! This Kahana, Maui condo ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Sands of Kahana unit 275 on the 7th floor in the ocean front building 2. Location, location, location! Located between Kaanapali and Kapalua you will the quaint town of Kahana. Kahana-Napili affords some of the best dining and Luaus on the ...
- 3 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Lahaina
Oceanfront Sands of Kahana Resort- beautiful, remodeled 2 bedroom, 2 bathroom condo
Oceanfront Pool and second pool
Restaurant and BBQ areas
Fitness Center
Tennis
AC
Walking distance to restaurants, stores and ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Sands of Kahana 264 is a two-bedroom, two-bathroom unit with panoramic views of the sunset, a premium seat for the whale show, and views of both neighboring Islands!
This unit has been updated with modern décor and furnishings. Both the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Oceanfront Sands of Kahana Resort- beautiful, remodeled oceanfront view - 2 bedroom, 2 bathroom Penthouse with 2 additional sleeper sofas
Oceanfront pool and second pool
Restaurant and BBQ areas
Fitness Center
Tennis
AC
Walking...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Oceanfront Sands of Kahana Resort- beautiful, remodeled, oceanfront view - 3 bedroom, 3 bathroom Penthouse!
Oceanfront Pool and second pool
Restaurant and BBQ areas
Fitness Center
Tennis
AC
Walking distance to restaurants and ...
- 3 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Lahaina
Spacious, remodeled 3Bdrm, 3Ba, beautiful oceanfront views!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental car from one of ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Sands of Kahana 392 is a spectacular 3 Bedroom 3 Bath Oceanfront Penthouse with a spacious 2,050 square feet interior offering unobstructed panoramic ocean views that go on forever. | | -Spacious fully equipped kitchen, everything you need to ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Concierge Realty is proud to present luxury villas at Sands of Kahana.
**Reservations are available in weekly (7 night) increments with arrivals and departures on Fridays, Saturdays, and Sundays only.
Please note: Please be aware ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
We are able to offer 7-night weekly rentals with check-in on Fridays, Saturdays, and Sundays only. This ad is for Saturday Check-In Only. Please inquire about the other specific check-in days.
On the beach in paradise are the Sands of ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
You'll find golfing on site at this beach condo. There's convenient onsite parking, so you can leave your vehicle behind and let your feet make short work of the 2-minute walk to Kahana Beach or the 12-minute walk to West Maui Mountains. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Concierge Realty is proud to present luxury villas at
**Reservations are available in weekly (7 night) increments with arrivals and departures on Fridays, Saturdays, and Sundays only.
Please note: Please be aware that air ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Superior 5 STAR Oceanfront View! Sands of Kahana 264 - Quam Properties
Sands of Kahana 264 is a two-bedroom, two-bathroom unit with panoramic views of the sunset, a premium seat for the whale show, and views of both neighboring ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Beautiful sunsets, outdoor grills for guests , great pool with spa for children, tennis courts, fitness center, and the property has its own beach facing the island of Molokai! You can even see lights on Molokai at night! Every 3 bedroom suite ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Discover this delightful 3-bedroom Beach Front gem in Kahana. This charming condo is the perfect home away from home for guests. With 1 king bed, 1 queen bed, and 2 full beds, and a sofa bed; everyone will have a comfortable place to rest. The ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina