select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
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...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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
HI> Kihei
Description
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 8
HI> Kihei
In Maui its all about LOCATION and this unit is in the perfect spot. Maui Banyan is one of the best places to stay in South Kihei.
This fantastic 1BR/2BA remodeled condo comes with fully equipped kitchen, washer/dryer, AC & sleeps up to 4 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
Read listings carefully!! This is not part of a 2 bedroom or lock-off!
Our beautifully renovated and decorated 1 bedroom 2 full bathrooms and fully equipped kitchen, unit is located in the H building close to the beach but away from the noise of...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Kihei
Bring up to 6 friends and family for the vacation of a lifetime at Maui Banyan T 305B. 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
Beautifully remodeled two bedroom, ocean view condo at the Maui Banyan. This lovely condo will sleep up to six people with a King bed in the master bedroom, a queen bed in the second bedroom, and a sofa bed in the living room. Completely ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Kihei
COMPLETELY RENOVATED!
**FULL REFUND IF CANCELLATION IS DUE TO POSITIVE COVID TEST OR TRAVEL RESTRICTIONS.**
Welcome to Pacific Pearl located in South Coastal Kihei Maui. This condominium is situated directly across from the popular Kamaole ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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 units in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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, telephone, and free wifi. There is a king bed and queen sofa ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
COMPLETELY RENOVATED!
**FULL REFUND IF CANCELLATION IS DUE TO POSITIVE COVID TEST OR TRAVEL RESTRICTIONS.**
This charming tropical retreat is located an easy three-minute stroll from the beach, across from the fantastic sandy Kamaole Beach II....
- 0 bedroom
- 1 bathroom
- Sleeps 2
HI> 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, and...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei
PLEASE NOTE: YOU ARE RENTING FROM A PRIVATE OWNER. ALL ACCESS INFORMATION WILL BE SENT TO YOU DIRECTLY FROM THE OWNERS. WE ARE NOT ASSOCIATED WITH THE MAUI BANYAN RESERVATION DESK. IF YOU DO NOT HAVE ACCESS INFORMATION 30 DAYS PRIOR TO YOUR ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Kihei
Perfect for couple or small family. This 1 BR/2BA ground floor unit is across the street from beautiful Kamaole Beach II. An open design creates a spacious living area. The fully equipped kitchen has everything you need to prepare and enjoy ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> 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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kihei