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 '%Kaanapali Alii%') AND sleeps>=1 order by rating desc LIMIT 0, 15
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
HI> Kaanapali
Ocean and West Maui Mountain views can be enjoyed from this luxurious 5th floor condo. This 2-bedroom vacation home is located in one of the most desired upscale resort locations in Hawaii. The Alii is maintained like a hotel, with an ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Lahaina
Condo 455 is a 2 bedroom condo wrapped with large windows and peaceful views of the West Maui Mountains. Perfect for groups as this condo offers many separate spaces within a welcoming open plan living area. Some guests can enjoy the lanai while...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Brand new to VRBO: we have not taken professional photos yet. We appreciate your patience as we work to get this done.
**THE TOTAL AMOUNT LISTED IN THE "RATE CALCULATOR" REPRESENTS ROOM AND TAX ONLY. ADDITIONAL FEES APPLY.
See "Additional ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Getting to Hawai‘i - Info & Resources for Managing COVID-19 (hawaiicovid19.com)
PLEASE SEE NEW RULES INTERNATIONAL TRAVEL TO HAWAII NOV 8, 2021
"Alii is the Hawaiian word for Royalty' , and our condo is this and much more, it is ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
The Kaanapali Alii is in West Maui, 5 minutes north of Lahaina, on beautiful Kaanapali Beach - a prime destination in Maui and #9 on Trip Advisor’s top beaches in the world. The Alii is an oceanfront resort located between the Marriott and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> 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
HI> Lahaina
Getting to Hawai‘i - Info & Resources for Managing COVID-19 (hawaiicovid19.com)
PLEASE SEE NEW RULES INTERNATIONAL TRAVEL TO HAWAII NOV 8, 2021
Aloha and Welcome!! You have arrived at the Kaanapali Alii, the Hawaiian word for ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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
HI> 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.
If you...
- 3 bedroom
- 2 bathroom
- Sleeps 8
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> 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.
If you...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
-INTRODUCING DEEP CLEAN EVERY TIME:
At Maui Resort Rentals the health and safety of our guests and team members is of utmost importance to us. Our commitment to cleanliness is embodied in our nearby 8000 sq. ft. operations warehouse and our ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Reserve 216 and enjoy all the advantages of a ground floor Garden View location at Kaanapali Alii. This exceptionally private 2 bedroom Garden View condo offers easy access to the beach and pool. No elevators involved! Plus the interior ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina