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 '%Mauna Lani%') AND sleeps>=1 order by rating desc LIMIT 0, 15
The pool will be closed for repairs on 9/6/21 - 11/7/21.
Ideally situated between 2 world-class resorts in a private, gated community, this fantastic 3 bedroom and 2.5 bath villa provides easy access to breathtaking beaches and world-class ...
3 bedroom
3 bathroom
Sleeps 8
HI> Waimea
Welcome and aloha to Hale Papa Kea at Kulalani, a beautiful, fully furnished and professionally decorated 2 bedroom, 2 ½ bathroom townhouse with 1,631 sq/ft of living space and 398 sq/ft of outdoor lanai space to enjoy during your Hawaii ...
2 bedroom
3 bathroom
Sleeps 4
HI> Kamuela
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
This is the most coveted Mauna Lani view that spans the Signature Hole, dramatic ocean vistas, and distinctive lava flow features. The beautiful lanai is furnished with a dining table for four and two loungers with ottomans. In the living area ...
2 bedroom
3 bathroom
Sleeps 6
HI> Waimea
Aloha and welcome to Halenani, the premiere estate on Hawaii's sunlit Kohala Coast. Halenani is unique in its ability to create a paradise oasis within paradise itself.
The superb landscape design, ponds and gardens surrounding the home sing ...
7 bedroom
7 bathroom
Sleeps 16
HI> Kamuela
Mauna Lani Terrace E201 offers a nice ocean view out over the ponds. This one bedroom villa has been nicely upgraded to include granite counters and stone floors. The living area has a sleeper sofa with two chairs that faces a LCD television ...
1 bedroom
2 bathroom
Sleeps 4
HI> Waimea
STVR-21-559570
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 advantage of our Kings Club membership at the famed Waikoloa Beach Resort ...
3 bedroom
3 bathroom
Sleeps 7
HI> Waimea
This newly renovated 2-bedroom condo at the Mauna Lani Resort is now available for your next vacation. This condominium/townhome is bright and airy and spans two floors with large windows to allow in the natural light. This popular floor plan ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kamuela
New listing Hale Mele house, your luxurious Hawaiian retreat in the prestigious gated community of Champion Ridge. Perfectly located on the sunny “Gold Coast” of South Kohala in one of the most desired resorts on the Big Island with ...
5 bedroom
11 bathroom
Sleeps 10
HI> Kamuela
Our condo, # 1703, is beautiful and a perfect fit for any family. It is well stocked and equipped for your vacation. Our unit is truly a home away from home. Our accommodations are well decorated, and you’ll find yourself very comfortable in ...
2 bedroom
3 bathroom
Sleeps 5
HI> Waimea
This deluxe 2 bedroom, 2.5 bath condo at the Mauna Lani Terrace has the most desirable floor plan with 2 master bedrooms on a single level with stair-free access! F201 features million-dollar ocean and lagoon views and is only a short walk away ...
2 bedroom
3 bathroom
Sleeps 4
HI> Kamuela
Welcome to the Mauna Lani Resort!
**Effective January 1, 2022 the state of Hawaii has added a 3% county tax. The new tax rate is 17.962%** This goes into effect for guests arriving after the new year for both hotel and rental guests.
...
3 bedroom
4 bathroom
Sleeps 8
HI> Kamuela
Mauna Lani resort Community with access to the private Beach Club, secluded oceanfront trails, grocery store, restaurants, shopping. Free standing, one level, luxurious, updated, newly furnished home with private backyard in gated community for ...
3 bedroom
4 bathroom
Sleeps 6
HI> Kamuela
Mauna Lani Villages 329 is a modern, newly renovated three bedroom townhome located right in the middle of the exclusive Mauna Lani Resort, where guests are able to access private beach clubs, secluded oceanfront trails and restaurants and ...
3 bedroom
4 bathroom
Sleeps 4
HI> Kamuela
Enjoy oceanfront living at D102, a spacious villa at the acclaimed Mauna Lani Terrace. Re-furnished in 2021, the villa has two master bedrooms on each side of a spacious living room and kitchen area. The master bedroom has a king size bed and ...
2 bedroom
3 bathroom
Sleeps 4
HI> Kamuela
