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, 20
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 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kapalua
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 6
Hawaii> Lahaina
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 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 ...
- 1 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 ...
- 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. Central air conditioning, free high-speed internet and free unlimited long distance calling to U.S. & Canada. Bedding is 1 King ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Family Vacation, End of Summer Rates: Aug/Sept 2024!
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! ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapalua
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
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 ...
- 1 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 ...
- 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
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 ...
- 2 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 ...
- 2 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> 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 ...
- 1 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 6
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
