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
*Enjoy the 5th night free for stays between now and December 22, 2024. Discount is applied at check-out.
*Please note that the Kapalua Resort and this property were not affected by the Lahaina fires, nor were our surrounding areas...
- 2 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
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 ...
- 2 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
- 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
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 1622 by Gather, a beautifully maintained two-bedroom, three-bathroom condo that accommodates up to five guests in Lahaina, Hawaii. Perched on the top row of the Kapalua Ridge Villas, this stunning residence offers ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
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 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 ...
- 3 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 ...
- 3 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
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
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> 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
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Lahaina Fire:
Lahaina’s Front Street area sadly is not available to visit. The rest of Maui is open. We welcome and need you to visit our beautiful island. Fun activities, restaurants and stores in this area are open. We thank you for ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapalua
Kapalua Ridge Villas 1521 is situated at the top of Kapalua Ridge, providing the best ocean views from your private lanai! This 1 bedroom, 2 bathroom villa sleeps up to 4 guests making it perfect for small families or for a couple looking for a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Ridge Villa two bedroom, three bathroom, luxury condo in the prestigious Kapalua Resort
Air conditioned throughout
Ocean and golf course views
Two Swimming Pools
Scenic walk to Kapalua Bay and restaurants
Spacious lanai ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Just a short distance to Ironwoods, D.T. Flemings, Oneloa Bay, and Kapalua Beach, offering pristine sands and turquoise waters.
Unwind in Style and Comfort:
The apartment features a fully equipped kitchen, perfect for whipping up ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
- 1st floor villa with panoramic ocean views including Molokai Island and Makaluapuna Point
- Tile entry, kitchen, bathroom, living and dining rooms and carpet in bedroom
- Updated open kitchen with granite counters and stainless steel ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
- Second floor villa with two bathrooms and two ocean view lanais
- Carpet and tile floors throughout the villa
- Golf course, ocean and the islands of Lanai and Molokai are all on view from this comfortable and tranquil villa
- 20 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
- 2nd floor villa with panoramic ocean views
- 20 steps/eight stairs between parking and front door
- Tile entry and bathrooms, carpet in living room, dining room and bedroom
- Open kitchen with stainless steel appliances to include –...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
- 1st floor villa with 8 stairs from designated covered parking and front door
- Porcelain tile floors throughout
- Updated open kitchen with granite counters and stainless steel appliances includes – fridge with ice maker, stove/oven, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- 2nd floor villa with 8 stairs from designated covered parking and front door
- Tile floors in entry, kitchen, bathrooms and carpet in bedroom, living and dining rooms
- Updated open kitchen with granite counters and stainless steel ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
- 2nd floor, 2 story villa with 8 stairs from parking
- Tile floors throughout
- Updated open kitchen with granite counters and high end appliances includes – fridge with ice maker, stove/oven, microwave, dishwasher, cookware, tableware ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Ridge Villas Ocean View 1 Bedroom
- The Ridge Villas are perched high above with views of Kapalua Bay Course’s fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa is closest to Oneloa Beach- Second floor unit with 15 stairs from parking to the villa- Tile flooring in kitchen, bathroom and carpeted in living room and bedroom- Fully equipped kitchen with stainless steel appliances includes ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Ridge Villas Ocean View 2 Bedroom 2 Bath
- The Ridge Villas are perched high above with views of Kapalua Bay Course’s fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
-...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Ridge Villas Gold Partial Ocean View 2 Bedroom 2 Bath
- The Ridge Villas are perched high above with views of Kapalua Bay Course’s fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- 1st floor villa overlooking Kapalua Bay Golf Course’s 6th fairway
- 19 stairs between parking and front door
- Two interior stairs between front door and living room/kitchen/second bedroom
- Tile entry, kitchen and bathrooms, carpet...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- The Ridge Villas are perched high above with views of The Kapalua Bay Course’s Fairway.
- Very spacious lanai with views toward mountain, golf course, and ocean.
- Second floor unit, two-level townhome, with multiple stairs ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- 1st floor villa with two stories overlooking Oneloa beach
- Stairs between parking and front door
- Interior stairs to access Master bedroom
- Tile in kitchen, bathrooms and dining room with bedroom carpeted
- Granite counters and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Ridge Villas Fairway View 1 Bedroom
- The Ridge Villas are perched high above with views of Kapalua Bay Course’s fairway - Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Bedroom...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Ridge Villas Gold Ocean View 2 Bedroom 2 Bath
- The Ridge Villas are perched high above with views of Kapalua Bay Course’s fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- Fully equipped kitchen with stainless steel appliances includes stovetop/oven, microwave, and refrigerator with ice maker, coffeemaker, cookware, tableware- Master Bedroom with 1 king bed, ceiling fan, TV and lanai
- Guest bedroom with 2 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Ridge Villas Gold Ocean View 1 Bedroom
- The Ridge Villas are perched high above with views of Kapalua Bay Course’s fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- ...
- 1 bedroom
- 1 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
