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 '%Kapalua Bay Villa%') AND sleeps>=1 order by rating desc LIMIT 0, 15
The furnishings in this tastefully decorated ocean view Bay Villa are all brand new (2018). Custom flooring, cabinetry, and granite throughout. This Kapalua condo has high definition LCD TV"s, free long-distance calling to U.S. and Canada, free ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This beautifully remodeled and upgraded Kapalua Bay vacation rental condo is new to our inventory and has outstanding ocean views. Custom cabinetry, travertine flooring and granite throughout. This is a bridge level unit so there are no stairs ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
This direct Ocean Front 2 bedroom Kapalua Bay Villa is very nicely upgraded. Just steps away from 2 world class beaches, tennis courts and pool. Central air conditioning, free high speed wireless internet and unlimited long distance calling to ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Lahaina
This gorgeous Beach Front Villa occupies the top two floors of building 21. It has two completely private master bedrooms with en-suite. Main floor master has a private lanai. Both master suites have spectacular ocean views. There are 3 ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Lahaina
Kapalua translates to "arms embracing the sea" in Hawaiian. Enjoy one of the most special places on Maui at this 1-bedroom 1-bath Kapalua Bay Villa. Enjoy expansive views & the fresh island breeze from this second level unit with large bay ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kapalua
Beautiful oceanfront Kapalua Bay Villa ideally located in building #20, next to private access steps to the beach and the boardwalk connecting to the resort's three mile coastal trail. This spacious bridge level unit places you just
steps away ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Lahaina
This beautifully remodeled and upgraded Kapalua Bay Villa has outstanding ocean views. Custom cabinetry, travertine and granite throughout. High definition flat panel TV, high speed wireless internet, free unlimited long distance calling to U.S....
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Nestled in the luxurious KAPALUA BAY RESORT, you can vacation in the lap of luxury while enjoying an abundance of amenities. From one of the finest locations in paradise, you will enjoy world class sunsets from your bedroom or living area ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapalua
Fabulous ocean views from every room in this 1750 sq. ft. luxury townhouse condominium. Complete makeover of this Oceanfront Kapalua Bay Villa was completed in May 2006. The upstairs master suite has a 60" Flat Panel high definition TV and ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
This ocean front Kapalua Bay vacation rental is new to our inventory and complete make over finished September 2014. All new everything including custom cabinetry, granite, flooring and upgraded furnishings. This brand new ocean front ground ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
OUR PICTURES REALISTICALLY REPRESENT; (taken in 2018)
Hawaii State Tax ID # TA‐183-831-8080-01
Aloha! Welcome to another Exclusive member of the Platinum Maui Vacation Ohana! All villas in this program are given Hawaiian names. This Kapalua ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
MAUI IS CALLING AND YOU MUST GO
Your Tropical Paradise Found
Kapalua Bay Villa 31-B2
Inhale the delightful island air and feel the ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
This clean and fresh oceanfront townhouse style villa has great views toward Molokai and is an easy walk to Kapalua Bay and Ironwoods beaches. Unit is being completely re-furnished in February 2017. Pool and tennis courts are just steps away. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Complete makeover of this Fabulous "Deluxe" upgraded condo was completed in July 2008. All new everything from custom cabinetry, warm travertine stone flooring, elegant granite counters and luxurious furnishings. Complete with central air ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
Are you an individual or couple in need of a sanctuary for rest and relaxation? Maybe you are a family in need of quality time and recreation. Regardless of your situation, we invite you to explore the countless possibilities this Kapalua Bay ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Lahaina
