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, 20
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 ...
- 2 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 ...
- 2 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 ...
- 2 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 ...
- 2 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...
- 1 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
Enjoy a free 4-door rental car on any reservation six nights or more with an arrival date now through Dec 15, 2024. Rentals cars are available for pickup at the airport on arrival.
Fabulous 3 bedroom penthouse on the 9th floor featuring ...
- 3 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
Reservations are available in weekly (7 night) increments with arrivals and departures on Fridays, Saturdays, and Sundays only.
On the beach in paradise is the Sands of Kahana. Tennis, pools, spa, restaurant, bar, beach activities ...
- 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
We are able to offer 7 night weekly rentals with check-in on Fridays, Saturdays, and Sundays only.
Note: Please be aware that air conditioning is not available in the units. There are ceiling fans in each room and extra fans available ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
We are able to offer 7-night weekly rentals with Sunday check-In only. Please inquire about the other specific check-in days.
Note: Please be aware that air conditioning is not available in the units. There are ceiling fans in each room ...
- 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
