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 Ridge%') AND sleeps>=1 order by rating desc LIMIT 0, 15
OCEAN VIEWS EVERYWHERE! Full of Hawaiian charm, this spacious, comfortable and modern condo has sweeping ocean views from every room and lanai. Walk or take the Kapalua Shuttle to the Beach, Golf, Restaurants, trail heads or the general store....
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
“Nana Kumole” in Kapalua Ridge Villas
Hawaii Life Vacations is proud to present Kapalua Ridge Villas #16 2/1. Nana Kumole which means spectacular view in Hawaian, is a two bd./ three bath residence sitting on the top row of villas ...
- 2 bedroom
- 3 bathroom
- Sleeps 5
HI> Kapalua
Welcome to Kapalua Ridge Villa 323, with magnificent ocean views. This villa is located in highly sought after Kapalua Ridge! As you enter this spacious villa you will be immediately drawn to the breathtaking views of Molokai and the magical ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
This lovely villa is a feast for the eyes. You will feel the weight of the world dissolve as you enter this island paradise.
This is a true 5 star experience! You'll be tempted not to leave the luxury of this well appointed villa. Every ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapalua
This Kapalua Ridge Villa is located on top of the ridge near World Class Kapalua Beach. It offers it's visitors a panoramic view of the Pacific Ocean. Tropical breezes keep this scenic location pleasant and comfortable even on the warmest Maui ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapalua
Read Covid-19 concessions at the end of this listing.
Kapalua Ridge 711-13 is a stunningly beautiful remodeled Honolua Bay/Sunrise ocean view with more than 2200 square feet of space. Every detail has been thought out & executed with class & ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kapalua
This enchanting ridge villa, is newly remodeled to include all the high end upgrades you would expect to find in a 5 star resort. It has an attached covered carport for 2 cars, a lovely garden off the master suite and beautiful ocean views. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapalua
Enjoy 5 star accommodations in an exclusive private villa paradise!
Custom Designed and Fully Upgraded Ridge Villa with Ocean Views from Every Room!
Designed from the onset to take advantage of its unique Island setting, Kapalua Ridge Villa...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Kapalua
This charming 1 bedroom 2 bathroom ground floor Kapalua Ridge Villa for rent has easy access from carport with no stairs. This unit has air conditioning and free high speed wireless internet. Bedding is 1 Cal King and 1 Queen sleeper sofa. 1100 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapalua
This charming 1 bedroom 2 bathroom upstairs Ridge Villa has easy access from carport . Great views from main level and the upstairs bedroom suite. Very spacious lanai with views toward mountain, golf course and ocean. New photos coming soon. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Beauty surrounds you in this lovely 1 bedroom 2 bath split level villa. One of few with an ocean view from the master suite! New king size sealy posturepedic firm in the master suite 2017! While you will feel nestled in and pleasantly ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapalua
Kapalua Resort has an inherent richness of beauty and culture. From snorkeling with the sea turtles in pristine waters on white sandy beaches, or taking in the beautiful views while whale watching from the Kapalua coastal trail, this property ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> LAHAINA
Kapalua Resort has an inherent richness of beauty and culture. From snorkeling with the sea turtles in pristine waters on white sandy beaches, or taking in the beautiful views while whale watching from the Kapalua coastal trail, this property ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> LAHAINA
Property Highlights
• Five minute walk to three world-class beaches, including Kapalua® Bay, rated the "Best Beach in the World" by Dr. Beach, and “Best Beach in the US,” by Conde Nast
• UNRIVALED, year-round sunset, ocean, coastal,...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Lahaina
Kapalua Ridge Villas 2521 located in the highly desirable and luxurious area of Kapalua is the perfect home away from home for a small family, group of friends or a couple looking for a romantic getaway. Enjoy being away from the crowds but near...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
