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
Welcome to Kapalua Golf Villa: A One-of-a-Kind Maui Retreat
Check out video on instagram account: The_Ohana_Club
Discover the pinnacle of luxury and location ...
- 3 bedroom
- 4 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
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
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
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
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.
Your Ocean-View Escape in Kapalua – Luxury Condo with Lanai, Golf Course Views & Resort Pools
E komo mai (welcome) to your dream Hawaiian ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
This is a legally permitted vacation rental according to the County of Maui ordinances.
Oceanfront Bliss & Golf Course Serenity – Kapalua's Premier Escape Awaits
E komo mai (welcome) to the Hawaiian escape of your dreams, where ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
