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 '%Maui Banyan%') AND sleeps>=1 order by rating desc LIMIT 0, 20
If you book 2 weeks or more I’ll credit you $150 after check in. You can use this to support local restaurants! Unit is not part of a 2 bedroom or lock-off! Read listings carefully. The Maui Banyan is located in a hotel zone. You will love our...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Your dream vacation awaits you on the Island of Maui in this beautifully upgraded condominium located across the street from Kamaole II Beach Park. Surrounded by lush tropical landscape, Maui Banyan is just steps away from restaurants, shops, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Local Owners! Renovated and upgraded! Steps from Kamaole Beaches! The perfect spot to relax and enjoy all that Maui has to offer.
Everything you need to make your stay comfortable and convenient is here.
•Split Air Conditioning ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to our home, this spacious 1 bedroom 2 full bath Condo was remodeled in March 2017, new kitchen, flooring and furniture, including a queen sleeper. This unit offers 2 AC located in bedroom and living area. You'll love the amenities and...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
3% processing fee applies to all reservations and will be added to all quotes before a reservation can be confirmed.
This stylishly remodeled top floor unit (with elevator) has a well-equipped modern kitchen with granite counters, ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
PLEASE NOTE: YOU ARE RENTING FROM A PRIVATE OWNER. ALL ACCESS INFORMATION WILL BE SENT TO YOU DIRECTLY FROM THE OWNERS. OUR ONLY ASSOCIATION WITH THE MAUI BANYAN RESERVATION DESK IS FOR THEM TO ISSUE PARKING PASSES AND POOL CODES, THEY DO NOT ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This unit is located in South Kihei, which is on the southwest side of Maui, an easy drive to nearly all of Maui’s landmarks and outdoor activities. Kamaole II Beach is right across the street from the Resort and offers excellent swimming, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
In Maui its all about LOCATION and this unit is in the perfect spot. Maui Banyan is located in prime South Kihei where the weather is sunny and beautiful year round. It’s across the street from Kamaole Beach II which is one of the few beaches ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Central Air Conditioned upgraded condo in the very sought after Maui Banyan Resort. Stroll through tropical walkway to the 2 pools, with hot tub and lounge chairs, bbq grills on property, and just across the street from one of the best beaches ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This beautiful, peaceful, and centrally-located 2 bedroom condo is steps away from beautiful Kamole II beach. It is a short 5 minute walk to all of the best shops and restaurants Kihei, Maui has to offer. The condo features 3 beds + 1 queen ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei
The Maui Banyan can be found in the heart of South Kihei, surrounded by palm trees and with a view of the West Maui Mountains and the islands of Lanai and Molokai. The condominium includes one-bedroom garden, complete with fully-equipped ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Summary:
Discover Maui at Maui Banyan H109 apartment, a charming 1-bedroom, 2-bath condo steps from Kamaole Beach Park II. Conveniently on the first floor, it hosts up to 4 guests. Relax on the lanai amidst lush greenery, stroll to the nearby...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha!
Thank you for considering our ocean view condo in paradise! Our condo is right across Kamaole Beach Park II in the G building on the South side of the Maui Banyan Resort. The G building is the most sought after as it is closest to the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
We would like to welcome you to Maui Banyan H-308, a spacious 1-bedroom, 2-bathroom, tastefully furnished vacation rental condominium with private lanai and a sweeping ocean view.
NEW! Now offering a 10% discount for 7+nights on select ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Your dream Maui vacation awaits you at this beautifully upgraded condominium located across the street from Kamaole II Beach Park.
Surrounded by lush tropical landscape Maui Banyan is just steps away from restaurants, shops, and ocean ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
As Maui residents, my wife and I can truly say there is no better place to live or vacation than Maui Banyan. We bought our condo with a long term goal in mind... retirement later but fun now. We shopped countless others all over Maui until ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Maui Banyan Q-109 is an idyllic condo for an idyllic vacation. Not only is the ground-floor unit across the street from Kamaole Beach II and a short walk from Kamaole Beaches I and III, but it’s also within a gorgeous resort that features ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Remodeled Summer 2022! The cozy, beachy decor in this Maui vacation rental is sure to make you feel right at home in your piece of paradise. This South Shore Kihei property is conveniently located just across the street from Kamaole Beach Park ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Conveniently located across the street from Kamaole Beach Park II, this large 3-bedroom, 3-bathroom S. Kihei vacation rental offers ample space for everyone in your entire family/group to allow for maximum comfort. The owners were very ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> KIHEI
*3% processing fee applies to all reservations and processing fee for your length of stay will be calculated and added to all quotes before a reservation can be confirmed.
This affordable one-room studio efficiency unit is a tropical ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei