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, ...
- 2 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 ...
- 3 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 air-conditioned one-bedroom, two-bathroom suite on the third floor has you covered with homey comforts that perfectly merge with resort amenities. Sleeping four in one king bed and 1 queen sofa bed, this unit encourages conversation and ...
- 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, ...
- 2 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy a charming two-bedroom and two-bathroom unit with a partial ocean view. If you decide to go with couples, a larger family, or friends the unit does offer an adjoining door between the spaces. Combined the two-bedroom unit sleeps up to ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Paradise at your doorstep! Relax at our centrally-located 2-bedroom condo at Maui Banyan Resort. This newly renovated and meticulously maintained home provides a true home away from home experience. Situated just a short garden path walk from ...
- 2 bedroom
- 2 bathroom
- Sleeps 7
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...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Summary:
Discover Maui at Maui Banyan P106 apartment, a charming 1-bedroom, 2-bath apartment 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 ...
- 2 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Slip into Kihei’s easy-going island lifestyle while enjoying homey conveniences in this 1 bedroom 2 bathroom unit at the Maui Banyan. Sleeping up to four in 1 King bed and 1 Queen sofa bed, this 722-square-foot suite says “aloha” with ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Book 5 nights, get the 6th free. Applies to new reservations from 9/4/24 for stays between 9/4/24 - 11/21/24.
Your dream Maui vacation awaits you at this beautifully upgraded condominium located across the street from Kamaole II Beach ...
- 2 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 ...
- 1 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
