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 Harbor Shops, and the Mini-Golf Complex!
Kana‘i A Nalu means 'gentle surf, but we call it 'Dad's Paradise.' Kana‘i A Nalu is a ...
- 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
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
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
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
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
"Discover Maui's Beauty: Discounted Vacation Rentals for Your Perfect Island Escape - Book Today and Save!".
Oceanfront ocean view third floor! Gorgeous upgraded condo. Quiet home listen to the sounds of the sea.
Please review ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
"Discover Maui's Beauty: Discounted Vacation Rentals for Your Perfect Island Escape - Book Today and Save!".
Oceanfront ocean view ground level convenient to lawn and beach. Listen to the sounds of the sea
Please review 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
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
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
Summary:
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
