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, 30
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
Bedding Configuration:
Master Bedroom: King Bed
Guest Bedroom: Two Twin Beds
Guest Bedroom: One Queen Bed
Loft ...
- 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
Mauna Lani Palm Villas B4. Includes Mauna Lani Beach Club Pass. Please scroll down for detailed information
This vacation rental is professionally managed by ResorticaHawaii
Bedding Configuration:
Master Bedroom: King ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waimea
Our beautiful three bedroom/two bath garden level condo in the world famous Mauna Lani Resort on the Big Island of Hawaii's prestigious Kohala Coast can be your unique vacation experience. The Mauna Lani Palm Villas is a small gated complex ...
- 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
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
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
Enjoy the tranquil beauty of this Luxury Palm Villas ground floor, 2 bedroom, 2 bath condo.
This special unit features central air conditioning, tile floors throughout the living area, high end carpet in the bedrooms, granite counter tops and...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
*Pool Closed October 23 - 28, 2023 for Maintenance*
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 ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kohala Coast
PLEASE BEWARE POOL WILL BE CLOSED OCT 6 - OCT 12, 2024 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 2005 in a small gated community ...
- 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
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> Kahola Coast
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