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 '%Palm Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 15
This 2BR, 2 Bathroom ground floor apartment is tucked away in a private corner of the Palm Villas and surrounded by lush gardens and banana, mango and papaya trees. The Palm Villas is the lowest density condo complex at Mauna Lani with only 44 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Waimea
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
HI> 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 should I ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kamuela
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
HI> Kamuela
Mauna Lani Palm Villas F4. Includes Mauna Lani Beach Club Pass.
Please scroll down for detailed information
***PLEASE NOTE: Due to current Covid 19 protocols there may be modified hours for Pool Services, Fitness Rooms or Community/BBQ ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
HI> Waimea
Please visit the Safe Travels Hawaii website https://hawaiicovid19.com/travel/
for current COVID-19 restrictions, testing and quarantine requirements.
Experience affordable luxury at the Palm Villas in the beautiful Mauna Lani Resort on ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Kamuela
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
HI> Waimea
*POOL & HOT TUB CLOSED OCTOBER 25 - 31, 2021*
We apologize for any inconvenince. The pool and hot tub are undergoing routine maintenance and repairs during that time and will not be accessible.
Please make sure you follow the Hawaii ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kohala Coast
The LoveRentals portfolio is comprised of curated, professionally managed vacation rental homes around the world. We only select professional property managers that meet our high standards. Book with peace of mind knowing that you will have the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
HI> Kamuela
