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 Ridge%') AND sleeps>=1 order by rating desc LIMIT 0, 20
*Enjoy the 5th night free for stays between now and December 15, 2024. Does not inclde the dates of November 24-30, 2024. Discount is applied at check-out.
*Please note that the Kapalua Resort and this property were not affected ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
*Please note that the Kapalua Resort and this property were not affected by the Lahaina fires, nor were our surrounding areas or Napili, Kahana and Kā‘anapali. West Maui communities of Kā‘anapali, Nāpili, Honokōwai, and Kapalua are ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Hawaii Life Vacations is proud to present Kapalua Ridge Villas #16 2/1. Nana Kumole, which means spectacular view in Hawaiian, is a two bd./three-bath residence sitting on the top row of villas affording it maximum view planes with ...
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Kapalua
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
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Aloha and Welcome Home to Kapalua Ridge #321- an antique coastal chic 1bd/2ba. brand new (May ‘22) vacation rental offering with 180 Degree Panoramic ocean, sunset, and outer island views. This residence changed ownership in early 2022 and we ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
60% Off Hotel Prices!
*Enjoy the 5th night free for stays between now and December 15, 2024. Does not include the dates of November 24-30, 2024. Discount is applied at check-out.
*Please note that the Kapalua Resort...
- 1 bedroom
- 2 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
- 2 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 ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
The Ridge Villas at Kapalua Resort are known for some of the best ocean and mountain views on Maui. Located on the hillside of Kapalua, this architecturally appealing resort offers spacious one, two and a rare three bedroom villa options. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Kapalua Ridge Villa 612. This large 1 bedroom, 2 bathroom 1125 sq ft condo features an open floor plan with a large private shaded lanai. Admire Honolulu Bay, sunsets, whale watching, sailboats, & more. This condo has ocean views from...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
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 ...
- 2 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Lahaina
The Stice Team of Hawaii Life Vacations kindly invites you to join us at our elegantly upgraded large upper floor one bedroom Kapalua Ridge #2321 residence overlooking the beauty of the Kapalua Bay course greens, renowned Kapalua Pine Trees, and...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Kapalua Ridge Villa 2212, with stunning ocean views! This villa is located in highly sought after Kapalua Ridge! As you enter this spacious villa you will be drawn to the expansive private lanai overlooking unobstructed views of the ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
60% Off Hotel Prices!
*Enjoy the 5th night free for stays between now and December 15, 2024. Does not include the dates of November 24-30, 2024. Discount is applied at check-out.
*Please note that the Kapalua Resort...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Lahaina
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 4
Hawaii> Lahaina
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 ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Transcending Ritz Carlton finishes with a larger room, a huge ocean view, a quiet and serene setting, and at a much lower cost- you have found your dream vacation rental home at the Kapalua Ridge Villas residence #1421. This is probably the most...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
The Ridge Villas at Kapalua Resort are known for some of the best ocean and mountain views on Maui. Located on the hillside of Kapalua, this architecturally appealing resort offers spacious one, two and a rare three bedroom villa options. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
The Ridge Villas at Kapalua Resort are known for some of the best ocean and mountain views on Maui. Located on the hillside of Kapalua, this architecturally appealing resort offers spacious one, two and a rare three bedroom villa options. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
This charming one bedroom two bathroom on the ground floor of Kapalua Ridge Villa has easy access from the carport with no stairs. This unit has air conditioning and free high-speed wireless internet. 1 King bed. Queen sleeper sofa. Minimum ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
