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 '%Kapalua Bay Villa%') AND sleeps>=1 order by rating desc LIMIT 0, 30
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. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> 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
Hawaii> Kapalua
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
Hawaii> 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
Hawaii> Lahaina
Kapalua Bay Villa offers a tranquil setting with close proximity to many of Maui's top rated beaches, champion golf courses, and restaurants. Kapalua Bay Villa 34B4 will not disappoint you with its breathtaking ocean views, tastefully ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This beautifully remodeled and spacious 1,000 sqft, one bedroom, and one bathroom ocean view condo are situated at the front of the resort overlooking Oneloa Bay and the island of Molokai. Enjoy beautiful sunsets & watch the whales breach from ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Hale I Ke Kai - which translates in Hawaiian to 'Home Towards The Sea'.
From the moment you enter, you will be mesmerized by the breathtaking ocean views from every room of villa 'Hale I Ke Kai'. This impressive villa stands ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Lahaina
Amongst the best Oceanfront locations at the Kapalua Bay Villas this property has Superlative Ocean and Molokai views. Building 26 is the closest to the ocean in this private gated community. This unit is on the leeward side offering protection ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Aloha!
Welcome to Another, "Platinum Maui Vacations" villa; take a tour with us through "Hale O Nana Nani" - which translates in Hawaiian to "Home with a beautiful view".
From the moment you enter, you will be drawn to...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Experience luxury at Kapalua Bay Villa Located on the ground level! Kapalua Bay Villa 22G2 is a Two Bedroom, Three Bathroom unit with a spectacular 180° ocean view! Featuring an open floor plan and an expansive inside and outside lanai! You ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Manhattan Modern Marvel meets Maui at Kapalua Bay Villas Residence #24B1/2. For those who know and love Kapalua, look no further than this oceanfront 2bd./3ba 2,036 sq.ft. luxury townhome. She has undergone an elegant top to bottom $1M remodel ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Lahaina
We welcome you to stay in our lovely one bedroom, one-in-a-half bathroom condo, located in building #20, next to private access steps to the beach and the boardwalk connecting to the resort's three mile coastal trail, and short walk to the ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Lahaina
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
Hawaii> Lahaina
This is a lovely bridge level unit, which means no toting heavy luggage up or down any stairs! This tastefully remodeled one bedroom, one bathroom condo offers outstanding ocean views and vibrant tropical decor! With oversized windows from the, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Enter into the stunning, open concept beautiful Bay Villa with ocean views and breathe in the fresh, tropical air. This extra-large villa boasts over 1,500 square feet of indoor living space and an additional 300 sq. ft. of outdoor relaxation. ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
This tastefully designed one-bedroom, one-bathroom condo offers outstanding ocean views and contemporary décor! The kitchen is fully equipped with granite countertops, custom cabinetry, optimal storage space, stainless steel appliances, and a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Experience luxury and comfort in this stunning and spacious two-bedroom, three-bathroom Kapalua Bay Villa. Situated on the bluffs above Kapalua Beach, the elevated location offers expansive ocean views, the perfect vantage for whale watching, ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Kapalua Bay Villas 1-bedroom, 1-bathroom villa located in the exclusive gated oceanfront community.
16 Acres with sandy beach and ocean views.
Two pools
Tennis
Newly renovated and furnished.
AC
Free parking and No resort ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
We welcome you to stay in our lovely one bedroom, one bathroom condo, just a short walk to the beautiful beaches located in Kapalua. Set along the picturesque waters of Namalu Bay, Montage Kapalua Bay welcomes you with genuine island hospitality...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Experience ultimate luxury and comfort in this expansive two-bedroom, three-bathroom villa featuring beautiful ocean views and upgraded finishes. Experience the Kapalua Bay Villas at this one-of-a-kind villa. Recent upgrades throughout, ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Experience ultimate luxury and comfort in this vast two-bedroom, three-bathroom villa. Massive, elevated location with beautiful ocean views and upgraded finishes. Experience the Kapalua Bay Villas at this one of kind villa. Recent upgrades ...
- 2 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
This unit has a clean and fresh aesthetic, in the living room, you will find comfortable seating, including the Queen sleeper sofa, an LCD flat screen TV for relaxing after a fun day outdoors and incredible scenic views, large floor to ceiling ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina