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, rewritten_description,
(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
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
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,
- 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
Cozy 1BR Condo in the Heart of Kihei – Walk to Beach!
Escape to sunny Kihei, where this charming one-bedroom condo puts you just a short walk from Kamaole Beach Parks 2 & 3—perfect for sunbathing, swimming, and catching breathtaking
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
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 beach for
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Located in the heart of Kihei, this condo is a dream. With 2 bedrooms featuring two king beds with ceiling fans, 2 bathrooms with rainfall showers. A chef's kitchen fully stocked with many culinary appliances. It also includes a washer and
- 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
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
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
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
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
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
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 nearby beach
- 2 bedroom
- 2 bathroom
- Sleeps 4
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
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
You will LOVE this 1BR/1BA Luxurious, ceiling to floor totally remodeled single level floor plan. While you dine on your balcony, enjoy the partial ocean and mountain view. This condo is located on the cooler side of the building.
The
- 2 bedroom
- 1 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
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
This newly remodeled 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
- 2 bedroom
- 1 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 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
Discover Maui at Maui Banyan P103 apartment, a charming 1-bed, 1-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 beach for
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
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
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
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
Come enjoy this one-bedroom, two-bathroom condo (accessible by elevator or stairs) in South Kihei, right across from the stunning Kamaole Beach II, one of Maui's finest golden sand beaches. Freshly painted, new Air Conditioner in the living
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Discover Maui at Maui Banyan Q110A studio, a charming 1-bath studio steps from Kamaole Beach Park II, perfect for up to 2 guests. Conveniently located right next to the upper pool area which also includes six Weber BBQs. Relax on the lanai
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
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
Maui Banyan P302
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The Maui Banyan can be found in the heart of South Kihei, surrounded by palm
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Maui Banyan T-305A is the perfect vacation spot for a small family. Your studio condo is newly updated and features air-conditioning. Best of all, your resort is across the road from Kamaole Beach II, one of the most celebrated and beautiful
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Discover the best location in Maui Banyan with unit Q109A, a rare studio unit that can comfortably sleep four guests and features a full-sized refrigerator. Situated in the serene back section of the complex, this unit offers a tranquil retreat
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Bright and open Ocean View Condo. This unit has one bedroom with a queen bed and a pull-out sofa bed in the living room, allowing this unit to sleep up to four people. The Kitchen opens up to the dining and living areas, creating a wide-open
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
