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 '%Kaanapali Alii%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Aloha and Welcome!! You have arrived at the Kaanapali Alii, the Hawaiian word for 'royalty', and the Kaanapali Alii is one of the finest luxury condos to stay in West Maui. OUR CONDO UNIT HAS A MAXIMUM # OF GUESTS ( INCLUDES CHILDREN AND ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
"Alii is the Hawaiian word for Royalty' , and our condo is this and much more, it is Luxury at its Best. Welcome to the Kaanapali Alii Resort! When we say DIRECT OCEANFRONT, we mean it... This unit was completely redesigned and remodeled ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Maui Resort Rentals presents the premier Kaanapali experience...
• Free Maui Resort Rentals courtesy shuttle offering service between The Kaanapali Alii and a number of West Maui locations.
• 24/7 local guest service from ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Spectacular Ocean and West Maui Mountain views can be enjoyed from this luxurious 11th floor newly remodeled condominium. This family owned 2-bedroom vacation home offers vacation privacy in one of the most desired upscale resort locations in ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
*note: if you are booking a short stay for 7 or less days, please inquire first before doing a reservation request, unless your arrival date is less than 30 days away, in which case you're welcome to proceed with the reservation ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
**THE TOTAL AMOUNT LISTED IN THE "RATE CALCULATOR" REPRESENTS ROOM AND TAX ONLY. ADDITIONAL FEES APPLY.
See "Additional information about rental rates" by clicking AVAILABILITY or by scrolling down the profile to below the calendar. ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
The Kaanapali Alii is in on beautiful Kaanapali Beach - a prime destination in Maui and one of the top beaches in the world. The Alii is an oceanfront resort located between the Marriott and Westin, and has a fabulous courtyard and 3000 square ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
This property was remodeled in 2020 and was just added to our rental pool! We are still working on finalizing furniture then professional photos will be taken.
**THE TOTAL AMOUNT LISTED IN THE "RATE CALCULATOR" REPRESENTS ROOM AND TAX ONLY....
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
Maui Resort Rentals presents the premier Kaanapali experience...
• Free Maui Resort Rentals courtesy shuttle offering service between The Kaanapali Alii and a number of West Maui locations.
• 24/7 local guest service from ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Maui Resort Rentals presents the premier Kaanapali experience...
• Free Maui Resort Rentals courtesy shuttle offering service between The Kaanapali Alii and a number of West Maui locations.
• 24/7 local guest service from ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Maui Resort Rentals presents the premier Kaanapali experience...
• Free Maui Resort Rentals courtesy shuttle offering service between The Kaanapali Alii and a number of West Maui locations.
• 24/7 local guest service from ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Maui Resort Rentals presents the premier Kaanapali experience...
• Free Maui Resort Rentals courtesy shuttle offering service between The Kaanapali Alii and a number of West Maui locations.
• 24/7 local guest service from ...
- 2 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Lahaina
**THE TOTAL AMOUNT LISTED IN THE "RATE CALCULATOR" REPRESENTS ROOM AND TAX ONLY. ADDITIONAL FEES APPLY.
See "Additional information about rental rates" by clicking AVAILABILITY or by scrolling down the profile to below the calendar. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
'Alii' is the Hawaiian word for Royalty and our luxury condo is this and more. This oversized 2 bedroom, 2 bath DIRECT OCEANFRONT condo provides panoramic ocean views from all rooms and is located in building Three, the most ocean fronting ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
**THE TOTAL AMOUNT LISTED IN THE "RATE CALCULATOR" REPRESENTS ROOM AND TAX ONLY. ADDITIONAL FEES APPLY.
See "Additional information about rental rates" by clicking AVAILABILITY or by scrolling down the profile to below the calendar. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Maui Resort Rentals presents the premier Kaanapali experience...
• Free Maui Resort Rentals courtesy shuttle offering service between The Kaanapali Alii and a number of West Maui locations.
• 24/7 local guest service from ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Maui Resort Rentals presents the premier Kaanapali experience...
• Free Maui Resort Rentals courtesy shuttle offering service between The Kaanapali Alii and a number of West Maui locations.
• 24/7 local guest service from ...
- 3 bedroom
- 2 bathroom
- Sleeps 9
Hawaii> Lahaina
**THE TOTAL AMOUNT LISTED IN THE "RATE CALCULATOR" REPRESENTS ROOM AND TAX ONLY. ADDITIONAL FEES APPLY.
See "Additional information about rental rates" by clicking AVAILABILITY or by scrolling down the profile to below the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Long-term Hawai'i owners w/new property mgr invite you to enjoy 2 Bed/2Bath, highly-rated Ka'anapali Ali'i 232. In the premier private, luxury oceanfront condo/hotel-resort on award-winning South Ka'anapali Beach.
OVERVIEW
Kaanapali ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
The Kaanapali Alii has long been considered the most premiere luxury oceanfront resort on Maui located directly on the famous white sand Kaanapali Beach. Situated between the Maui Marriott and the Westin Maui Hotel, our 10th floor unit offers ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina