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, 50
No cleaning fee! After booking, you will need to provide your email address for the registration process at the MB. Thank you for your cooperation. Our unit is not part of a 2 bedroom or ...
- 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...
- 2 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
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
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
Adorable remodeled Ensuite unit in popular Maui Banyan. Conveniently located across from golden sandy beaches and just a short distance to dinning and shopping. This unit has everything you need, including a fully stocked kitchenette, a small ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Located in the heart of Kihei, this condo is a dream. With 2 bedrooms featuring a king and queen bed, 2 bathrooms with showers and hair dryers, and amenities like a washing machine, AC, and WiFi, guests will have a pleasant and comfortable stay....
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Relax in our cute studio apartment at the Maui Banyan Resort, just a few steps from the gentle, sandy shores. Take in glimpses of the ocean from the lanai and embrace the aloha spirit.
✓ Right across the street from Kamaole Beach II
✓ ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Relax in our pristine 1-bedroom condo at the Maui Banyan Resort, just a few steps from the gentle, sandy shores. Take in glimpses of the ocean from the lanai and embrace the aloha spirit.
✓ Right across the street from Kamaole Beach ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Discover Your Perfect Hawaiian Paradise in the Heart of Kihei.
Nestled in the vibrant community of Kihei, unit T303 at Maui Banyan offers an exceptional vacation experience that captures the essence of tropical Hawaiian living. This ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
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.
For long stays, (28+ nights), a long stay discount of 15% ...
- 2 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
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 ...
- 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
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 ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> KIHEI
This affordable one-room studio efficiency unit with king bed is a tropical retreat that has been stylishly remodeled with granite counters and walk-in shower. The unit is equipped with a convenience mini-kitchenette (mini-fridge with separate ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
The Maui Banyan Condo is a 2-bedroom, 2-bath condo close to Kamaole ll Beach. It is composed of a main unit and a studio.
Maui Banyan Resort is situated on 8 acres of beautifully landscaped grounds located in South Maui across the street ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kehei
Experience the comfort and luxury of our recently renovated Maui rental, a one-bedroom, two-bathroom condo nestled in the heart of Kihei at the Maui Banyan Hotel. Perfectly situated on the beachfront, this condo offers easy access to five ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
E Komo Mai to our luxury two bedroom unit with a partial ocean view from the lanai. 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...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Perfect for kids and grandparents! Most convenient unit in Maui Banyan!
We are so happy to be offering Maui Banyan Q109B. This unit is our home away from home in Maui. We chose this condo specifically because it is exactly what our family...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy the tropical lifestyle at Maui Banyan H-503, a beautifully renovated one-bedroom, two-bathroom Maui, Hawaii condo! With unbeatable amenities and ocean views from your own private top-floor lanai, you will never want to leave.
Maui ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This newly renovated unit has everything you need to vacation with peace of mind. The living area has a large couch that also doubles as a sofa bed making it the perfect place to sit and relax with family or even on your own watching television ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Located in building Q at the Maui Banyan, this two-bedroom condo has many upgrades and remodels. The Master bedroom has a queen bed and a full bathroom ensuite. The second bedroom has two full beds. There is a full bathroom just outside the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Maui Banyan #H-407 is a 1 bedroom, 2 bath unit on the 4th floor. It features an ocean view, air conditioning throughout, a fully equipped kitchen, washer and dryer, 2 flat-screen TVs, dual speaker Sonos system (will require download of Sonos ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Description
This recently remodeled condo with brand new furniture is just a 5-minute walk to Kamaole II Beach and walking distance to restaurants, stores and shops. It is a first floor, corner unit close to the tennis court and pool. You may...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Summary:
Aloha and welcome to our 1 bedroom condo, your home away from home! My family and I live on Maui and we are so excited to host your vacation. Don't get stuck with a major rental company that doesn't care about your individual group. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Description
Maui Banyan Resort is situated on 8 acres of beautifully landscaped grounds located in South Maui across the street from the popular Kamaole Beach Park II. This white sandy beach is perfect for swimming and snorkeling. It is a ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
Maui Banyan #H-414 is a 1 bedroom, 2 bath unit on the 4th floor. It features an ocean view, air conditioning throughout, a fully equipped kitchen, washer and dryer, 2 flat-screen TVs, telephone, and free wifi. There is a king bed and queen sofa ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Escape to paradise at Maui Banyan H-210, your ultimate Hawaiian retreat! Nestled across the street from the stunning Kamaole Beach 2, with picturesque views of the majestic West Maui Mountains, this location offers unparalleled beauty and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Maui
Beautifully remodeled top floor unit in low-rise building, directly across the street from the world-famous Kamaole Beach Park II. Cherry cabinetry, quartz counters, brushed nickel fixtures, all tile, no carpet. 65' Smart TV in living room. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Maui Banyan complex and condo are located just a short walk to the Kamaole Beach Park II. This is one of South Maui's most popular and Life Guarded Beaches.
Condo is fully furnished with all the comforts of your own personal home. Also ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Banyan #H-405 is a 1 bedroom, 2 bath unit on the 4th floor with a partial ocean view, a fully equipped kitchen, washer and dryer, 2 flat-screen TVs, a dvd player, and free Wifi. There is a new (April 2024) California king bed and a queen ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Banyan T209 offers the perfect Hawaiian getaway! Enjoy the gorgeous garden and Haleakala views!
As you enter, you are greeted by an open and inviting floor plan! The kitchen has been nicely updated and is equipped with everything you...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Are you ready for the ultimate island getaway in this beautiful studio, located in the heart of Kihei at the highly sought-after Maui Banyan Resort? Just a 5-min walk from the world-famous Kamaole II Beach, you'll be surrounded by soft white ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Summary:
Discover Maui at Maui Banyan P103A, a cozy studio moments from Kamaole Beach Park II. Perfect for 2 guests, this ground-floor retreat features a serene lanai surrounded by lush greenery. Wander to the nearby beach for stunning views,...
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
Experience paradise in this conveniently located ground floor condo at Maui Banyan in Kihei with no steps to the unit. Situated toward the front of the property, G-106 is the closest one-bedroom unit to the beach and has no stairs to the entry! ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Can be rented as a 2 bedroom, 1 bedroom, or studio.
We are in Building G, Unit 304.
Time to get away!
Great Location. 300' from the beach! Unit located right across the street from Kamaole Beach II. Kamaole Beach II is one ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Maui
Bring up to 6 friends and family for the vacation of a lifetime at Maui Banyan T 305B. Your condo features air-conditioning in all bedrooms and the main living space. Best of all, your resort is across the road from Kamaole Beach II, one of the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Located directly across the road from world-famous Kamaole Beach II, Maui Banyan H-214 is the ideal place for a couple or a small family getaway. The Maui Banyan resort has two beautiful pools with hot tubs, outdoor showers, and large pool ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Imagine staying a one-minute walk from Kamaole II Beach in Kihei, with several lifeguards on duty 365 days a year. That's an uncrowded sandy beach conducive to sunning, snorkeling, swimming, and sunset watching. In winter you can even spot ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Maui Banyan #H-412 is a 1 bedroom, 2 bath unit on the 4th floor. It features an ocean view, air conditioning in the living room, a fully equipped kitchen, washer and dryer, 2 flat-screen TVs, and free Wi-Fi. There is a king bed and queen sofa ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Bring up to 10 friends and family for the vacation of a lifetime at Maui Banyan T-305. Your condo is newly updated and features air-conditioning in all bedrooms and the main living space. Best of all, your resort is across the road from Kamaole ...
- 4 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Kihei
Summary:
Aloha and welcome to our studio condo, your home away from home! My family and I live on Maui and we are so excited to host your vacation. Don't get stuck with a major rental company that doesn't care about your individual group. We ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
