select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
An island paradise will be yours when you stay at this exquisite 1-bedroom, 2-bathroom vacation rental villa in Kapalua, Maui. Suitable for 2 adults, this villa offers access to the community pool and boasts both ocean and golf course views from...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Lahaina
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
HI> Kapalua
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...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> 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
HI> 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
HI> 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
HI> Kapalua
All new interior, very clean and tastefully decorated. On the Bay Golf course with a nice ocean view. Central air conditioning, free high speed internet and free unlimited long distance calling to U.S. & Canada. Bedding is 1 King and 1 Queen ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
Renovations of this newly renovated wonderful ocean view 2 bedroom Golf Villa in Kapalua were completed December 2012. Custom granite, cabinets and tile flooring. Golf, tennis, beach, and restaurants are all within walking distance. Central air ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
Come see for yourself why Kapalua Bay was named "Best Beach in the World" by Conde Nast magazine. Located on the Northwest tip of Maui, this tropical paradise has something for everyone.
This renovated 2,300 square foot, 3-bedroom residence ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kapalua
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
HI> Lahaina
This newly decorated top row Golf Villa is located on the Kapalua Bay Golf Course. Unobstructed panoramic views toward neighbor islands of Lanai and Molokai. Unit is on ground level with no stairs to climb. Covered parking and central air ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Lahaina
One bedroom, two bathroom, luxury Kapalua Golf Villa with air conditioned through out the condo, located in the prestigious Kapalua Resort, has been specifically designed for island style relaxation. The main entrance exposes a charmingly ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
HI> Kapalua
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, 495535 & 2353718- garden, partial & direct ocean views, direct ocean ...
- 0 bedroom
- 0 bathroom
- Sleeps 4
HI> Lahaina
This lovely villa is the quiet retreat you have been dreaming of! Spectacular ocean views and the quiet serenity of the Kapalua Golf Villas will be an experience to remember. Fresh modern design, clean lines, sunlight bathing every corner of ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Kapalua
This lovely villa is the retreat you have been yearning for. Come enjoy the serene and tranquil feel of the Golf Villas. Just steps from 3 gorgeous pools and a short walk to 5 world class beaches and dozens of restaurants. Enjoy snorkeling with ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Lahaina
