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 '%Kanai A Nalu%') AND sleeps>=1 order by rating desc LIMIT 0, 20
We are 1/2 mile from the Maui Ocean Center Aquarium, Pacific Whale Foundation, Ma‘alaea Harbor, and the mini-golf complex!
We have loved Kana‘i A Nalu since our dad purchased this condo in 1986!
Kana‘i A Nalu means 'gentle ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maalaea
You can really “have it all” here-- a fully air conditioned beachfront condo at Maalaea's most sought after resort Kanai a Nalu. You'll vacation in the sunniest, driest part of Maui, edging the gorgeous blue Pacific!
You ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Wailuku
This beautiful top floor condo is located in the 80 unit complex of Kanai A Nalu (Unit #419) and features all the comforts of home overlooking Maalaea Bay, Haleakala, Kihei, and all of the South Shore with Maalaea Beach just steps away! Miles ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
Approximately 1100 square feet of generously furnished up-scale living above a beach with breath-taking unobstructed views across blue Maalaea Bay to other islands and Maui's south shore below the Haleakala volcano. Watch whales and relax on ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
SUMMER RATE SPECIALS!
Indulge in the ultimate oceanfront experience with this meticulously crafted two-bedroom, two full bath condo spanning 952 sq ft. Nestled on the second floor, revel in breathtaking vistas of the majestic ocean, ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Wailuku
This condo has what you come to Maui for. Twenty feet from the water. In our opinion we have the best Maui location on Maui(peaceful, central, uncrowded and non 'touristy' Maalaea), the best building in Maalaea - Kanai a Nalu (first one on the...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maalaea
"Stay Longer, Save More: Enjoy Lower Rates on Your Ideal Vacation Rental".
Please review the property description and pictures carefully prior to booking, and call/email if you have any questions. We want to ensure you have a wonderful ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
Welcome to Limahana Maha (Crew Rest) at Maalaea Bay, in Maui! Lovely spacious 2 bedroom, 2 bath condo on a soft sandy beach that extends for 7 miles with spectacular ocean, Island and Mountain views, including Haleakala National Park. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
Kanai A Nalu #311 is an updated 2 bedroom, 2 bath unit. It's located on the 3rd floor, centralized in the middle of the complex. The ocean view is absolutely fantastic! Unit 311 has a fully equipped kitchen, washer / dryer, Cable TV/DVD, and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
Beachfront paradise! Enjoy whale watching and beautiful sunsets from your lanai and Sugar Beach in front of Kanai A Nalu (gentle surf). Your 'home away from home' has all of the comforts you need to make your island vacation unforgettable! ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
"Stay Longer, Save More: Enjoy Lower Rates on Your Ideal Vacation Rental".
Oceanfront ocean view third floor! Gorgeous upgraded condo. Quiet home listen to the sounds of the sea.
Please review the property description and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
"Stay Longer, Save More: Enjoy Lower Rates on Your Ideal Vacation Rental".
Oceanfront ocean view ground level convenient to lawn and beach. Listen to the sounds of the sea
Please review the property description and pictures ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
Enjoy direct, forever ocean front views across Maalaea Bay, all the way to the outer islands, and experience a total seaside immersion just steps from the pristine Pacific in this well-maintained and newly renovated shore-front condo, which ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
"Stay Longer, Save More: Enjoy Lower Rates on Your Ideal Vacation Rental".
Maalaea Banyan is located in a quaint harbor village on Maalaea Bay. Watch turtles, dolphins and whales directly from the oceanfront lanai (balcony). Enjoy the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
Kana'i A Nalu 312
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Sitting oceanfront along five miles of white-sand coastline is the Kana’i ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
Quiet, serene, overlooking a fabulous ocean view. A super location in the seaside community of Maalaea- situated between Kihei and Lahaina. This apartment is updated and up graded and has a tropical decor- open floor plan. King bed in the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maalaea
This updated and spacious 3rd-floor condo offers amazing views overlooking the beach and tropical courtyard with a heated community swimming pool giving a lovely ambiance of light at night. Decorated with Aloha spirit, this unit features a fully...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Maalaea
Hawaii Life presents a new addition to the "The Hotel Collection" with Kanai A Nalu I 203 - centrally located in Maalaaea town, you are close to everything Maui has to offer. Watch and listen to the ocean waves from this direct ocean front ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maalaea
This updated and spacious 4th-floor condo offers amazing views overlooking the beach and tropical courtyard with a heated community swimming pool giving a lovely ambiance of light at night. Decorated with Aloha spirit, this unit features a fully...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
This freshly painted and spacious 4th-floor condo has an ocean-facing lanai overlooking the tropical courtyard with amazing views of Ma'alaea Bay, Kihei, Wailea, Makena, the Upcountry, and Haleakala! Decorated with Aloha spirit, this unit ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maalaea