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 (city = 'wailuku' OR postalCode = 'wailuku' OR region like '%|wailuku|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
It isn’t just a dream ! You can “really have it all here “ 50 Shades of blue !
Come relax and enjoy yourself in our beautiful, yet extremely comfortable, beachfront accommodations 20 feet from the waves .
This condo has beach access...
2 bedroom
2 bathroom
Sleeps 5
HI> Wailuku
If you are looking for the closest proximity to a perfect white sandy beach then look no further! Enjoy ten miles of pristine beach with views of Haleakala and Kaho'olawe in the background just steps from your front door. Spot turtles and see ...
0 bedroom
1 bathroom
Sleeps 4
HI> Wailuku
Ocean Views from the Lanai, are so awesome, you may never want to leave the condo! Everyday brings a one-of -a kind Sunrise over Haleakala. Everyday, turtles feed among the gentle waves of our private beach, which is steps away. During whale...
1 bedroom
1 bathroom
Sleeps 2
HI> Wailuku
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
If you are looking for the closest proximity in Maalaea to a perfect white sandy beach then look no further! Enjoy ten miles of pristine sandy beaches with views of Haleakala and Kaho'olawe in the background just steps from your front door. Spot...
1 bedroom
1 bathroom
Sleeps 4
HI> Wailuku
Newly remodeled, ocean side condo in Maalaea Harbor. 2 bedroom and 2 bath. Large outdoor lanai over looking the ocean. Lounge at the ocean side pool or walk a few steps to the beach. Some of the best views for seeing whales and sea life right ...
2 bedroom
2 bathroom
Sleeps 6
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
Committed To Clean
We’re committed to enhanced cleaning protocols developed in partnership with experts in health and hospitality. Here’s what we’re doing to clean and sanitize:
We use cleaners and disinfectants effective against ...
1 bedroom
1 bathroom
Sleeps 2
HI> Wailuku
If you are looking for the closest proximity in Ma'alaea to a perfect white sandy beach then look no further! Enjoy ten miles of pristine sandy beaches with views of Haleakala and Kaho'olawe in the background just steps from your front door. ...
1 bedroom
1 bathroom
Sleeps 4
HI> Wailuku
NEW to VRBO, by KNOWLES MAUI
• Recent full-condo remodel, new everything
• Third-floor corner unit with unobstructed ocean and outer island views
• Heated freshwater beachside swimming pool
• On Sugar Beach – the longest beach in ...
2 bedroom
2 bathroom
Sleeps 6
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
E Komo Mai “welcome” to Kana'i A Nalu 210! This tropical Kana'i A Nalu condo is located in the heart of Ma'alaea. It's ideal for a romantic getaway, as well as the family looking for kid-friendly beaches and all the comforts of home ...
2 bedroom
2 bathroom
Sleeps 6
HI> Wailuku
** Newly Updated Unit ** There is a five-night minimum stay requirement for this unit. | | Beach front resort Makani A Kai # B-1 is a deluxe condo with a decidedly home-like floor plan, a bit different than the usual vacation units you see. It...
2 bedroom
2 bathroom
Sleeps 4
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
Remodeled in October 2021. Completed in February 2022. Top floor condo. New everything! New flooring throughout. New Beautiful Hawaiian Bedroom King set with a firm Beauty-rest mattress bed with custom closets. New A/C. This place is great for...
1 bedroom
0 bathroom
Sleeps 4
HI> Wailuku