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
If you book 2 weeks or more I’ll credit $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...
- 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
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
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
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
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
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
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 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 freezer ...
- 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
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
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
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
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
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
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
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
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
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
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
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
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
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
Hawaii Tax ID: TA-075-907-0720-01
TMK: 390040050052
Practical and budget friendly! This quaint one bedroom unit is perfect for a small family looking to come and enjoy all the wonders Maui has to offer. Right across the street are some...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
