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, 30
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> Wailuku
We are again accepting vacation rental reservations, as FEMA now has enough housing for fire survivors! Enjoy our deep "calendar re-boot" discounting (already reflected in our newly published rates) from now until mid November.
You can ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Wailuku
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 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
Updated discounted rates are now available. Book now!.
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 experience with us. ...
- 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
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, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
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
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
Updated discounted rates are now available. Book now!.
Oceanfront ocean view third floor! Gorgeous upgraded condo. Quiet home listen to the sounds of the sea.
Please review the property description and pictures carefully prior to...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
Updated discounted rates are now available. Book now!.
Oceanfront ocean view ground level convenient to lawn and beach. Listen to the sounds of the sea
Please review the property description and pictures carefully prior to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
Updated discounted rates are now available. Book now!.
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 ocean views that seem ...
- 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
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
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
Updated discounted rates are now available. Book now!.
Oceanfront ocean view 2nd floor! Quiet home listen to the sounds of the sea.
Please review the property description and pictures carefully prior to booking, and call/email if ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
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
Welcome to a white sand beach from the front door of one of Maui’s most conveniently located condo complexes. Kanai A Nalu is nestled on Maalaea Bay, offering guests breathtaking ocean views & soothing sounds of the ocean. Amenities include a...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailuku
This updated 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 features new ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maalaea
Family vacations are best experienced at a Maui oceanfront condo! Less than a 2 minute walk from Maui's longest sandy beach, Kanai A Nalu 408 is a top floor oceanfront abode with designer furnishings in an absolutely gorgeous location. Centrally...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
