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 '%Palm Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Mauna Lani Resort-Palm Villas is a small, quiet, gated community of 44 luxury townhomes on the Kohala Coast of Hawaii. Your private Big Island dream vacation starts now.
You will be centrally located within the Mauna Lani Resort and its ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
You will instantly be drawn in by your peaceful surroundings in this spacious and welcoming upper floor, corner unit home. You'll no doubt be pleased with the open floor plan between kitchen, dining, and living area all feeding out to the lanai ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
Mauna Lani Palm Villas F4. Includes Mauna Lani Beach Club Pass.
Please scroll down for detailed information
PLEASE NOTE: The swimming pool at the Palm Villas will be closed for maintenance from October 7-12. The pool will re-open on...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Mauna Lani
We look forward to welcoming you to this never before rented slice of heaven! Palm Villas at Mauna Lani is a tropical paradise just minutes away from private beaches, the Mauna Lani fitness center, Luxury Hotels, Shops at Mauna Lani featuring ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea
E KOMO MAI TO THE PALM VILLAS
This 2BR/2Bath ground-floor Palm Villas unit is private and secluded, surrounded by 6 acres of lush landscaping. As our guest you have full access to the Auberge/Mauna Lani Fitness Center, located across the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waimea
Welcome to your slice of paradise in Mauna Lani, Hawaii! This stunning 2 bedroom, 2 bathroom ground floor condo is splendidly situated facing west to offer stunning sunset views over the Kalahuipua'a Historic Park.
As you step into this ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
Mauna Lani Palm Villas B4. Includes Mauna Lani Beach Club Pass. Please scroll down for detailed information
PLEASE NOTE: The swimming pool at the Palm Villas will be closed for maintenance from October 7-12. The pool will re-open on ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
Luxury Oasis at Palm Villas in Mauna Lani Resort on the Big Island of Hawaii
Welcome to your dream Hawaiian getaway at the Palm Villas located in the Mauna Lani Resort, where paradise meets perfection! Nestled within the prestigious Palm ...
- 2 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Kamuela
Book 5 nights and enjoy the 6th night free! Valid for new reservations from 10/10/24 for stays between 10/10/2024 - 12/8/2024!
Welcome to your dream vacation home at Pacific Palm Villas, Hali'i Kai, located in the heart of the exquisite ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
GIVE YOUR FAMILY A VACATION THEY WILL REMEMBER FOR A LIFETIME!
Two story townhouse with 3 bedrooms, a loft, and 3 full baths. Sleeps 8. Located in the world famous Mauna Lani Resort on the Big Island of Hawaii.
The Mauna Lani ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
Experience affordable luxury at the Palm Villas in the beautiful Mauna Lani Resort on the Big Island’s Kohala Coast. The Palm Villas is a small complex situated on the 17th Fairway in the heart of the Mauna Lani Resort within walking distance ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
We can’t wait to welcome you to this exceptional property located at the world renowned Mauna Lani Resort. The Palm Villas is a small, gated complex nestled between the 17th fairway and a historical preserve. With only 44 units in this ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kohala Coast
Enjoy the tranquil beauty of this Luxury Palm Villas ground floor, 2 bedroom, 2 bath condo. This special unit has been recently upgraded and includes new Air Conditioning, Kitchen Appliances and Washer/Dryer. The private lanai is complete with a...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
This stylish ground floor, 3-bedroom villa will provide the perfect location for your rejuvenating retreat. The property has undergone a recent renovation, designed with a modern tropical vibe. You will find luxe bedding, linens, and bathroom ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
WE UNFORTUNATELY HAD TO RAISE OUR NIGHTLY RATE DUE TO UNPRECEDENTED INSURANCE RATES IN HAWAII.This beautiful condo at the Palm Villas at Mauna Lani Resort is located on Pauoa Rd about 20 minutes north of Kona Airport. The property was built in ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
The Mauna Lani Resort is a world-famous, four-diamond resort with very nice restaurants, three pristine private beaches and miles of walking and jogging paths, two world-renowned golf courses, sunset cruises, fishing, whale watching, scuba, and ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kamuela
Experience an unforgettable Big Island retreat that stands apart from the rest at this beautiful condo in Mauna Lani Palm Villas Resort! From the tranquil setting to the luxury finishes, this wonderfully positioned corner condo offers a special ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
Welcome to the Palm Villas at Mauna Lani Unit G-22
The Palm Villas at Mauna Lani is located in the middle of the world famous Mauna Lani Resort. Situated between the north golf course on one side and the archeological preserve on the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
This property is what you have dreamed Hawaii would be … and is actually all about.
And this property is the answer to THREE questions you are asking as you search the Web looking for the “right” place!
1ST QUESTION. Why ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kamuela
In the heart of of Mauna Lani Resort Palm Villas overlooks Kalahuipua’a Historic Park.
Palm Villas at Mauna Lani Unit F22 Garden View 2 Bedroom 2 Bath + Loft
• 2nd floor walk-up, second floor condo with Loft area
• Kitchen ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waimea
