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 '%Mauna Lani Golf Villas%') AND sleeps>=1 order by rating desc LIMIT 0, 20
Please note that the pool will be closed while the pool deck is being resurfaced. This project will start on Monday, May 6, 2024 and is projected to take 3-4 weeks. We apologize for any inconvenience this may cause. Thank you in advance for your...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea
STVR-21-559570
Seeking a flawless, worry-free spot for your next get away?
Look no further….Come, relax and make yourself at home in our well-appointed, high-end furnished, corner villa inside the Mauna Lani Beach Resort. Take ...
- 4 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea
The Golf Villas at Mauna Lani E23
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Located on the Kohala Coast, in the heart of the luxurious, ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kamuela
Spend you vacation relaxing in this spacious 3 bedroom, 3 bath, BBQ Kitchen villa that is located at the private and beautiful - The Golf Villas of the Mauna Lani. The Golf Villas is a luxury gated community nestled on the famed South Course at...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kamuela,