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 Golf Villa%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Aloha and welcome to Kapalua located on the West side of Island of Maui. Our 1 bedroom 2 bath villa has been renovated with only top-of-the-line materials and furnishings. Full-size kitchen features granite counters and stainless-steel ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
Premium 1Bdrm villa, sweeping ocean views, masterfully remodeled!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental car from one...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
This fabulous ocean/golf course view villa offers a relaxing vacation! Enjoy early morning rainbows and breath-taking sunsets! This one bedroom, two-bathroom villa offers all the comforts of a home. A fully equipped kitchen, that features ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Aloha future guests!
Welcome to one of Platinum Maui Vacations nicest Kapalua Golf Villas!
All properties in our "ohana", (family), have Hawaiian names. We call this Kapalua Golf Villa, Hale O Nani', which means 'Home of ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Our Kapalua Golf Villa sits on the 4th hole of the Bay Course. You will be street level with just three steps down to the entry. Enjoy watching golfers while having your coffee or have happy hour with beautiful ocean view sunsets from our ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Our condo, 26T8 Kapalua Golf Villas, has everything you need for a perfect vacation:
COMFORT: Central air conditioning, remodeled kitchen, new furniture, newly carpeted and painted, king bed upstairs, and new sleeper sofa with a memory ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Golf Villa #25V1 has ocean views on the Kapalua golf course from this 1Br/1.5Ba condo. Updated furniture with a kitchen remodel. There are flat-screen TV's in both the living room and bedroom. Golf Villa #25V1 has ocean views that await ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Golf Villa 23P5&6 is a two-bedroom, two-bath unit that has everything you need to enjoy paradise, including stunning golf course and Pacific Ocean views! Kapalua Golf Villas is one of Maui's most prestigious resorts, surrounded by the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Enjoy the luxury of this spectacular Kapalua Golf Villas unit located in the world renowned Kapalua Resort. This two-bedroom, two-bath unit is the perfect getaway for all vacationers. The property is located near stunning beaches, hiking, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Escape to Paradise at our Luxurious Kapalua Golf Villa!
Welcome to your dream Hawaiian vacation at this exquisite 2-bedroom, 2-bathroom retreat, nestled in the highly sought-after Kapalua Golf Villas. From the moment you step foot into ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Beautiful 2Bdrm Golf Villa, chefs kitchen, breathtaking views!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental car from one of...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Complete renovations in this terrace-level (no stairs!) villa were completed late 2013. Walls were taken down to bare studs and everything was replaced. The owners had one thing in mind - make it their home away from home. In that quest they ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Golf Villa 15T1 is a one-bedroom, two-bathroom condo situated right on the Kapalua Bay Course. Spacious lanai for family time or entertaining! Hawaiian-inspired décor and furnishings. This private unit has a panoramic view, and central ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Breathtaking 2Bdrm remodeled villa, ocean and golf fairway views!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental car from one...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Golf Villa #16 P 1 & 2
This pristine ground floor two bedroom, two bathroom air-conditioned Golf Villa is in a perfect location within the Kapalua Resort community. Great golf and ocean views are yours while you relax on the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapalua
The Kapalua Golf Villas are one of the most esteemed resort communities in West Maui. Located in the center of the Kapalua Resort with sweeping views of Molokai and Lanai, these elegant one and two-bedroom condominiums neighbor two of Hawaii's ...
- 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
Exquisite 2Bdrm luxury Golf Villa, remodeled, free Kapalua shuttle!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental car from ...
- 3 bedroom
- 2 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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Lahaina
Located in the highly desirable area of scenic Kapalua, this luxury Maui rental recently underwent a nearly $300k remodel and is now ready to welcome its guests to pristine island living. Kapalua Golf Villas 15P3-4 is nestled on the 10th fairway...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Oversized 2Bdrm, sweeping ocean views, remodeled, premium upgrades!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental car from ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Ocean view 2Bdrm, views of Molokai and Lanai, private balcony!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental car from one of...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Kapalua Golf Villa 27T5! Gorgeous Villa with captivating views! This well appointed 1bedroom/2bath offers an exquisite vacation experience. You will immediately be drawn to the large private lanai! Enjoy outdoor living, with ample seating. Take ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
We welcome you to stay in our luxurious one bedroom, two-bathroom condo, located on the ground floor, and situated directly on the Kapalua Bay Golf Course. Kapalua Golf Villas is one of Maui's most prestigious resorts, surrounded by the ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
Welcome to Kapalua Golf Villa 21T1 offering stunning ocean views! This 1-bedroom/2-bath villa is the perfect Hawaiian retreat! With a spacious lanai, spend your days relaxing and gazing at the beautiful Maui waters.
As you enter, you will...
- 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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- Two story villa with 2 stairs from designated parking and front door- - Hardwood floors in living, dining rooms and carpet in bedrooms- - Open kitchen with granite counters includes – fridge with ice maker, stove/oven, microwave, dishwasher,...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
QUICK NOTE: We have several other AHMMMAZing vacation properties as well, be sure to check out: 648997 (located in the same building as this property) 213217, 231489, 122599 & 2353718- garden, partial & direct ocean views, direct ocean front ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Stunning 1 Bdrm upgraded villa with ocean views, custom remodel!
null
*Special Offer- Book any KBM Resorts villa in Hawaii for 6 nights or more with an arrival date now through Dec 15, 2025 and receive a 4-door rental car from one ...
- 2 bedroom
- 2 bathroom
- Sleeps 3
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
This is a legally permitted vacation rental according to the County of Maui ordinances.
Stunning ocean-view condo in Kapalua Maui
Welcome to your dream vacation rental by Maui Life Realty! This beautifully renovated 2-bedroom, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Golf Villas Ocean View 1 Bedroom
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Bedroom with 1 king bed or 1 queen bed
- ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Golf Villa Unit 16P7 Fairway View 2 Bedroom 2 Bath
- 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Golf Villas Partial Ocean View 1 Bedroom
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Bedroom with 1 king bed or 1 queen ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Golf Villas Ocean View 2 Bedroom 2 Bath
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Master bedroom with 1 king bed and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
This is a legally permitted vacation rental according to the County of Maui ordinances.
Large Ocean-View Condo in Kapalua, Maui
This beautiful Golf Villa has stunning views of the 4th and 12th fairways of the Bay Golf Course, the ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Golf Villas Gold Partial Ocean View 1 Bedroom
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Bedroom with 1 king bed or 1 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Golf Villas Gold Fairway View 1 Bedroom
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Bedroom with 1 king bed or 1 queen ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- 1st floor villa with 3 stairs between parking in front of condo and front door
- Carpet in living room, dining room, bedroom and tile floors in kitchen and bathrooms
- Kitchen with black stainless steel appliances includes – fridge ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Golf Villas Gold Fairway View 2 Bedroom 2 Bath
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Master bedroom with 1 king bed ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Golf Villas Gold Ocean View 2 Bedroom 2 Bath
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Master bedroom with 1 king bed and...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Golf Villas Fairway View 2 Bedroom 2 Bath
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Master bedroom with 1 king bed or 1 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Golf Villas Gold Partial Ocean View 2 Bedroom 2 Bath
- Situated along Kapalua’s Bay Course fairway
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Master bedroom with 1 king...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- 1st floor villa with 2 stairs between parking in front of condo and front door
- Updated open kitchen with granite counters includes – fridge with ice maker, stove/oven, microwave, dishwasher, cookware, tableware and unique chef’s table...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
