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, 50
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
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
Experience unparalleled ocean and white sand beach views from every room in this
luxurious oceanfront villa on Oneloa Bay. Ideally nestled in building #20, next to private
access steps to Oneloa Beach and the resort's three-mile coastal ...
- 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
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 6
Hawaii> Lahaina
FREE daily activities included with your stay value up to $1035! Complimentary admission, every day of your stay*: Lu’au, Golf, Whale Watch (seasonal), Dinner Sunset Sail, Snorkel Sail, Alpaca Farm Tour, Pineapple Farm Tour, and All Day ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Near Kapalua Golf Tournament! 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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Construction Special: 12/12/24- 2/15/2025 and then 3/3/25 - 5/2/25 $289/Night; Renovation work for Kapalua Bay Villas 29G-2 to begin 12/12/24 - 2/15/25. Work will include drywall, cabinets, counters, electrical. Building maintenance work at ...
- 2 bedroom
- 2 bathroom
- Sleeps 2
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
Much to do near this beautiful ocean view condo. This area is very walkable with amazing views and great trails to hike. You are in luck if you enjoy playing tennis, pickleball, golf, paddle boarding, boogie boarding, snorkeling, spear fishing, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
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
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
We welcome you to stay at Kapalua Bay Villa 12B4 this 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, Kapalua Bay welcomes you with genuine ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Experience oceanfront bliss at this beautiful Kapalua Bay Villa! This one-bedroom, two-bath townhouse-style villa offers gorgeous views of Maui's shoreline and Oneloa Bay. Tastefully updated with custom cabinetry and granite counters, it ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Bay Villas 1-bedroom, 1-bathroom villas located in the 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
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Bay Villas 1-bedroom, 2-bathroom villas 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
- 2 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 4
Hawaii> Lahaina
This beautiful ocean-view Kapalua Bay Villa is tastefully updated with custom cabinetry and granite counters throughout! Stainless steel appliances in the kitchen. Fabulous ocean views from the upstairs master suite and main living area ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
