select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
Whether you're snorkeling with the sea turtles, Humpback whale watching in the winter, surfing, SUP’ing or just kicking back on the lanai to enjoy a rainbow, it doesn't get any better than this property. The Sands of Kahana sits on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> LAHAINA
The BEST of Maui oceanfront Resort living from high in the sky!!
Welcome to Paradise! Highly sought after Sands of Kahana Exclusive Ocean and Beach front Resort Living.
Leave your busy life behind and look forward to your home away from home ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
We are able to offer reservations in weekly increments with arrival and departures, Fridays, Saturdays, and Sundays.
On the beach in paradise is the Sands of Kahana. Tennis, pools, spa, restaurant, bar, beach activities center, barbecues and ...
- 3 bedroom
- 2 bathroom
- Sleeps 10
HI> Lahaina
PLEASE SEND AN INQUIRY BY CLICKING THE CONTACT HOST TAB BEFORE REQUESTING TO BOOK!
A Villa on the beach on the beautiful west coast of Maui! Sands Of Kahana is located in south Kihei. Tennis, pools, spa, restaurant, bar, beach activities ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
**Visitors arriving in Hawaii must either (1) present a negative COVID-19 test result, completed in the previous 72 hours, or (2) Upload proof of vaccination on Hawaii's Safe Travel App., or (3) self-quarantine for 10 days-two weeks. Please ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
** URGENT: Guests arriving in Hawaii must either (1) present a negative COVID-19 test result, completed in the previous 72 hours, (2) Be fully vaccinated two weeks prior to trip, or (3)self-quarantine for 10 days. Please check local regulations ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Lahaina
Whether you're snorkeling with the sea turtles, Humpback whale watching in the winter, surfing, SUP’ing or just kicking back on the lanai to enjoy a rainbow, it doesn't get any better than this property. The Sands of Kahana sits on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Remodeled 7/2020, Pictures from November 2020
Penthouse with direct ocean view and right on the beach. A Sandy Swimmable beach with snorkeling right outside your door. Fully remodeled 9th floor Penthouse unit offers the most amazing views and...
- 3 bedroom
- 3 bathroom
- Sleeps 9
HI> Lahaina
This oceanfront unit at the Sands of Kahana has breathtaking views of the islands of Lanai and Molokai.
The kitchen and bathrooms have recently been updated. There are two separate bedrooms with Californian King beds and two private bathrooms ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Whether you're snorkeling with the sea turtles, Humpback whale watching in the winter, surfing, SUP’ing or just kicking back on the lanai to enjoy a rainbow, it doesn't get any better than this property. The Sands of Kahana sits on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
WE ARE VERY EXCITED TO PRESENT THE NEW ADDITION TO QUAM PROPERTIES INVENTORY! THIS BEAUTIFUL RECENT FULL REMODEL HOME AT THE SANDS OF KAHANA! THE REMODEL INCLUDES ZONED AIR CONDITIONING, AN ALL-NEW KITCHEN, BATHROOMS, MOTORIZED BLINDS, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
This Non-Smoking condo is beautifully maintained and decorated with Oriental art and antiques. Other comparable direct oceanfront corner condos in our complex rent for more. The two bedroom/two bath corner units are among the largest on Maui. We...
- 2 bedroom
- 2 bathroom
- Sleeps 7
HI> Lahaina
Whether you're snorkeling with the sea turtles, Humpback whale watching in the winter, surfing, SUP’ing or just kicking back on the lanai to enjoy a rainbow, it doesn't get any better than this property. The Sands of Kahana sits on the ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
HI> Lahaina
Whether you're snorkeling with the sea turtles, Humpback whale watching in the winter, surfing, SUP’ing or just kicking back on the lanai to enjoy a rainbow, it doesn't get any better than this property. The Sands of Kahana sits on the ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Lahaina
Whether you're snorkeling with the sea turtles, Humpback whale watching in the winter, surfing, SUP’ing or just kicking back on the lanai to enjoy a rainbow, it doesn't get any better than this property. The Sands of Kahana sits on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
