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, 50
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
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
This vacation rental is professionally managed by ResorticaHawaii
Bedding Configuration:
Master Bedroom: King ...
- 5 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 ...
- 3 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
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 ...
- 4 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
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 of 44 units on 6 acres that are beautifully landscaped. Palm ...
- 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
