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, 50
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 ...
- 3 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
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
April in Maui - Blooming Deals on Vacation Rentals! #BookNow #MVR #KVR.
Oceanfront ocean view third floor! Gorgeous upgraded condo. Quiet home listen to the sounds of the sea.
Please review the property description and pictures ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailuku
The true spirit of “aloha” awaits you at this highly desirable upgraded two bedroom/two bath spacious Kana'i A Nalu beachfront condominium in Maalaea. Upon first entering, you will be greeted by breathtaking views of the pristine blue ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maalaea
