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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
As one of the treasured 2 bedroom OCEANFRONT residences at the Kaanapali Alii resort in the heart of Kaanapali Beach, residence 1-405 delivers the finest in modern luxury resort living.
Tastefully remodeled and elegantly appointed, the ...
- 3 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 ...
- 3 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 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
Boasting a breathtaking 10th floor oceanfront vantage point, this stunning residence delivers awe-inspiring Pacific Ocean views that stretch from Molokai to Lanai and beyond. Enjoy one of West Maui's world-famous sunsets any time of the year ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Kaanapali Alii 112 is a charming ground-floor one-bedroom, two-bath garden view condo that comfortably accommodates up to four guests. Perfectly situated just steps away from the pool, this condo is a favorite among visitors seeking convenience ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Upon entering Kaanapali Alii 163, you immediately notice the beautiful wood floors that fill the living room, kitchen and dining room. The open floorplan of this two-bedroom plus sleeping den vacation rental is conducive to sparking conversation...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Discover the perfect Hawaiian escape at Kaanapali Alii 296, a stunning two-bedroom condo that offers a blend of luxury and comfort. Spanning 1,807 square feet, this residence features an open floor plan adorned with elegant tile floors ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
From the moment you enter Kaanapali Alii 352 you will notice the clean, modern, and colorful details that combine perfectly to make this a desired Maui vacation residence. The soft-colored (white/gray) flooring and minimalist white walls are ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Kaanapali Alii 364, a stunning sixth-floor condo that offers a perfect blend of luxury and comfort in the heart of Kaanapali. This beautifully designed vacation rental features elegant tile flooring throughout the spacious living and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Kaanapali Alii 482 is a premier vacation rental nestled within the prestigious beach vacation destination of Kaanapali. This luxurious condo offers a perfect blend of comfort, style, and breathtaking views, making it an ideal retreat for anyone ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kaanapali Alii 483 is a beautifully appointed one-bedroom plus sleeping den vacation rental that promises a luxurious stay in Maui. Start your mornings on the private lanai, sipping a cup of freshly brewed Maui coffee while watching the sun rise...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Escape to paradise in this stunning 1,513 square foot mountain view condo at Kaanapali Alii. Perched on the ninth floor, this one-bedroom, two-bath vacation rental with an additional den comfortably accommodates up to four guests, offering a ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Kaanapali Alii 143, a stunning two-bedroom plus den residence designed for ultimate comfort and style in the heart of Maui. This spacious retreat offers ample room for your entire group, making it the perfect getaway. The den can be ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Natural light and colorful garden views fill the residence of Kaanapali Alii 445. This two-bedroom vacation condo steps from Maui’s famous Kaanapali Beach is the perfect retreat for the dream Hawaii vacation. Modern features like wood ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Luxuriously remodeled, this 2 bedroom den ground-floor gem delivers partial ocean views, an expansive 1850 sq ft of interior living area, and a sleeping capacity of up to 8 guests. The oversized outdoor living space and lawn area effectively ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
This elegantly remodeled 2 bedroom oceanfront ground-floor residence at the Kaanapali Alii delivers sweeping ocean views from Lanai to Molokai and beyond. Step outside onto the adjacent lawn area and enjoy unparalleled access to the world-famous...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
