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, 50
Special Offer!
Stay 7 nights or more and enjoy one night free, or stay 6 nights or fewer and receive $100 off your stay.
Valid for stays now through June 30, 2025. Discount automatically applied at ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Large 1Bdrm with 180-degree ocean views perfect for taking in whale watching!
*Special Offer- Book any KBM rental home in Hawaii for 6 nights or more with an arrival date between Jan 1 - Dec 31, 2025 and receive a complimentary 4-door ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Aloha and Welcome Home to Kapalua Ridge #321- a coastal chic 1bd/2ba. brand new (May ‘22) vacation condo with 180 Degree Panoramic ocean, sunset, and outer island (Molokai) views. We are proud to share our condo with you that was recently ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Kapalua Ridge 2321 by Gather, exclusively offered by the Stice Team. This elegantly upgraded, one-bedroom, two-bathroom upper-floor residence offers an idyllic retreat for up to four guests in Kapalua, Maui. Located in the serene ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Kapalua Ridge 1421 by Gather, exclusively offered by the Stice Team—a luxurious escape perched high in the prestigious Kapalua Resort. This one-bedroom, two-bathroom second-story townhome invites you into over 1,000 sq. ft. of ...
- 2 bedroom
- 2 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 ...
- 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
Large 1Bdrm with 180-degree ocean views perfect for whale watching!
*Special Offer- Book any KBM rental home in Hawaii for 6 nights or more with an arrival date between Jan 1 - Dec 31, 2025 and receive a complimentary 4-door rental rental...
- 2 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
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
