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!
*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 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
Relax in paradise! Top floor condo with a one level floor plan. All new furnishings, carpet and paint. Lovely lanai to watch the golfers go by and enjoy the views and smells of the island of Maui. There are 4 pools in the Kapalua Golf ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Modern Luxury at Kapalua Golf Villas – Your Ultimate Maui Retreat
Welcome to Modern Hawaii at Kapalua Golf Villas, a rare three-bedroom, three-bathroom retreat offering over 2,000 sq. ft. of beautifully remodeled living space. Nestled ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
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
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
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
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
Beautiful 2Bdrm Golf Villa, chefs kitchen, breathtaking views!
*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 car ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Relaxing 2Bdrm Golf Villa, upgraded, short walk to Kapalua Bay!
*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 car...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
Exquisite 2Bdrm luxury Golf Villa, remodeled, free Kapalua shuttle!
*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...
- 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
Welcome to Kapalua Golf Villas 15P3-4 by Gather, a luxury retreat located in the highly desirable Kapalua area on Maui. This beautifully remodeled villa, nestled along the 10th fairway of the world-famous Kapalua Bay Golf Course, offers ...
- 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
Ultimate 2Bdrm Golf Villa, lush green fairway views, remodeled!
*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 car...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Oversized 2Bdrm, sweeping ocean views, remodeled, premium upgrades!
*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...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapalua
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
Beautifully remodeled 2Bdrm Golf Villa with stunning ocean views!
*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 ...
- 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!
*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 3
Hawaii> Lahaina
Beautifully designed two bed, two bath Golf Villa with breath taking views!
*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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Lahaina
Welcome to Kapalua Golf Villa 27T5, a luxurious one-bedroom, two-bathroom condo located on the prestigious Kapalua Bay Course. This terrace-level villa (no stairs!) has brand new furnishings as of January 2025. The owners aimed to create their ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to Kapalua Golf Villa 27T7, an exquisite one-bedroom, 1.5 bathroom condo perfectly situated on the prestigious Kapalua Bay Course. Enjoy a private retreat with a serene lanai, ideal for romantic dinners, family gatherings, or ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
