select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
Oceanfront condo on third floor with beautiful ocean views! Sleeps a family of 5. Includes Split AC.
We are taking extra care to disinfect frequently touched surfaces between reservations.
Reserve this spacious 952 sq. ft. 2 bedrooms, 2 baths...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Wailuku
Kanai a Nalu 218
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 A Nalu ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> 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
HI> Wailuku
It isn't a dream-- 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, just 20 ft from our beach edging the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Wailuku
Welcome to "Limahana Maha" (Crew Rest) at Maalaea Bay, 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
HI> Wailuku
This 2nd floor condo has tropical courtyard, pool and ocean views. The heated complex pool offers lovely ambiance with the lighting of the pool at night. The master suite has a new king bed with recently remodeled bathroom featuring a nice ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
***The VRBO "Booking Assistance" number does not have all the updated information about our condo, so please feel free to contact the owner for accurate information. Also, please talk to the owner directly about our thoughtfully updated ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Oceanfront ocean view third floor! Gorgeous upgraded condo. Quiet home listen to the sounds of the sea.
We are taking extra care to disinfect frequently touched surfaces between reservations.
This two-bedroom two full bath oceanfront condo ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailuku
Located on the second floor, this unit offers spectacular views of the blue Pacific and has a private lanai featuring uninterrupted views of the Maalaea Bay, Kihei, Wailea, Makena, Upcountry and Haleakala. The heated complex pool offers lovely ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Maalaea
Oceanfront condo on top and 4th floor. Experience the moon and sunrise over Mount Haleakala and ocean! Clean, beautiful condo with all the comforts of home!.
We are taking extra care to disinfect frequently touched surfaces between ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Oceanfront ocean view ground level convenient to lawn and beach. Listen to the sounds of the sea.
We are taking extra care to disinfect frequently touched surfaces between reservations.
This remodeled two-bedroom two full bath condo is 952 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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 6
HI> Maalaea
Oceanfront condo on third floor with beautiful ocean views! Gorgeous upgraded property. Quiet home listen to the sounds of the sea.
We are taking extra care to disinfect frequently touched surfaces between reservations.
As of December 2019,...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
Oceanfront condo on 4th and top floor with beautiful ocean views! HIGH-END gorgeous upgraded property. Quiet home listen to the sounds of the sea.
We are taking extra care to disinfect frequently touched surfaces between reservations.
If ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Wailuku
This 4th floor unit offers spectacular views of the beach, tropical courtyard and ocean views. The heated complex pool offers lovely ambiance with the lighting of the pool at night. Master bedroom has a comfy king bed with an ensuite walk-in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Wailuku
