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, 30
Escape to paradise at this stunning 1-bed, 2-bath villa in Lahaina! With a spacious lanai, a fully equipped kitchen, and access to a community outdoor pool, this vacation rental offers the perfect blend of relaxation and luxury. Explore the ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Lahaina
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
All new interior, very clean and tastefully decorated. On the Kapalua Bay Golf course with excellent ocean views. All new photos coming soon. Central air conditioning, free high speed internet and free unlimited long distance calling to U.S. & ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 1 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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
This beautiful Golf Villa has stunning views of the 4th and 12th fairways of the Bay Golf Course, the blue Pacific Ocean's Napili Bay and the Pu'u KuKui Mountain chain. This 1432 square foot golf villa is truly an amazing home away from home. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 1 bedroom
- 2 bathroom
- Sleeps 3
Hawaii> Lahaina
Kapalua Golf Villas is one of Maui's most prestigious resorts! Kapalua Golf Villa 23P5&6 is a two-bedroom, two-bath unit that has everything you need to enjoy paradise! Stunning golf course and pacific ocean view!
This unit is very ...
- 2 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
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Located on the 11th fairway, this townhouse condo offers stunning panoramic views of the pacific ocean.
* Conveniently located near several quality restaurants: Ritz Hotel, Taverna, Sea House, Gazebo, Pour House and more.
* Access to ...
- 1 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
"The area of this condo was unaffected by the recent Lahaina Fires. Your visit will help Maui heal and rebuild after the fires. West Maui, has come back to life. Restaurants and shops are opening. Our Beaches, waterfalls and hikes are ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Our condo has everything you need for a perfect vacation.
COMFORT: Central air conditioning, remodeled kitchen, new furniture, newly carpeted and painted, king bed, new sleeper sofa with memory foam mattress. Enjoy beautiful sunsets from...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Welcome to this Luxurious Kapalua Golf Villa with Panoramic Ocean Views! Spacious open floor plan with large private lanai offers seamless indoor/outdoor living space! Impeccable quality upgrades in this renovated spacious 2-story Golf Villa, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Kapalua Golf Villa 23P7 is a tastefully renovated two-bedroom, two-bath unit that has everything you need to enjoy paradise, including a stunning golf course and Pacific Ocean views!
Kapalua Golf Villas is one of Maui's most prestigious ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
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. Central AC, is private, and has a panoramic ...
- 1 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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
* Special Offer - Book any KBM Resorts villa in Hawaii for 6 nights or more with a checkin date on or before December 15, 2023 and booked after May 11, 2023 and receive a 4-door rental car from one of our major rental car agency partners. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
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
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
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 6
Hawaii> Lahaina
Governor Green advised that only returning residents and authorized emergency relief workers should travel to West Maui through Oct. 17th. This property is currently on request and we will need verification that you are either a returning ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina