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, 20
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, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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
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 ...
- 2 bedroom
- 1 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
This is a lovely bridge level unit, which means no toting heavy luggage up or down any stairs! This tastefully designed one bedroom, one-and-a-half-bathroom condo offers outstanding ocean views and contemporary decor!
The kitchen is fully...
- 1 bedroom
- 2 bathroom
- Sleeps 2
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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapalua
This beautifully remodeled and spacious 1,000 sq. ft., 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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- One level condo with 17 stairs between parking and front door
- Travertine tile floors in living room, dining room, kitchen and bathroom and carpet in bedroom
- Contemporary galley kitchen with granite ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- 22 stairs between the driveway and front door
- Tile floors throughout this 2-story condo
- Updated kitchen with granite counters includes stovetop/oven, microwave, refrigerator with ice maker, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2024 and receive a 4-door rental car from one of our major rental car agency partners. The Car is complimentary, you pay only ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapalua
Construction Special: 5/12/25-7/11/25 $289/Night; There will be power washing, sanding, grinding, possible jackhammering and painting including scaffolding and ladders staged at the building. A plumbing inspection of the main lines will require ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Construction Special: 3/3/25-5/2/25 $279/Night; There will be power washing, sanding, grinding, possible jackhammering and painting including scaffolding and ladders staged at the building. A plumbing inspection of the main lines will require ...
- 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...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Bay Villas - 1-bedroom, 1.5-bathroom villa located in an exclusive gated oceanfront community
16 acres with sandy beach and ocean views
Two pools
Tennis courts
Newly renovated and furnished
AC
Free parking and No resort...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Experience the Luxury of Kapalua Maui from this extraordinary oceanfront villa overlooking Oneloa Bay, Maui. The position of the villa creates a more quiet and private space with direct oceanfront lawn access. Enjoy spacious living room and open...
- 2 bedroom
- 1 bathroom
- Sleeps 4
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 ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
