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 Terrace%') AND sleeps>=1 order by rating desc LIMIT 0, 15
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
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
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
Enjoy superior oceanfront living in a prime location at B102, a 2 bedroom, 2.5 bath condo only steps away from the beaches at Mauna Lani Resort. Located on the ground floor of the world renowned Mauna Lani Terrace, this very desirably located ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Kamuela
1 bedroom, 2 bath Deluxe unit - steps from the beach!
Located on the second floor (with stairs access)
Beautiful view of the ponds
Airy & bright living room with comfortable furnishings
Master Bedroom has a king bed and television
2 person ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Kamuela
J104 is a gorgeous renovated 2-bedroom, 2-bathroom condo with easy access to the Mauna Lani's private Beach Club. Located on the first floor and only steps away from the ocean and ancient Hawaiian fishponds, the condo's covered lanai opens to a ...
- 2 bedroom
- 3 bathroom
- Sleeps 5
HI> Kamuela
A104 is a beautiful oceanfront 2 bedroom / 2.5 bath deluxe unit. Enjoy gorgeous ocean and sunset views from the large covered lanai that is only steps away from the sandy beach. Complete renovations provide guests with brand new tile flooring, ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Kamuela
The Mauna Lani Terrace is located within the world class Mauna Lani Resort. It is on the ocean and adjacent to the royal fish ponds and between two beautiful white sand beaches. The water is crystal clear with one of Hawaii’s healthiest ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Kohala Coast
Enjoy superior oceanfront living in C102, a condo only steps away from the beach. Located on the ground floor of the world renowned Mauna Lani Terrace, this very desirably located unit overhangs historic Hawaiian fish ponds and offers ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
HI> Kamuela
**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.
Ocean Front Mauna Lani Terrace – Walk ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Kohala Coast
The Mauna Lani Terrace is a premier oceanfront property located within the 5-star Mauna Lani Resort on the Kohala Coast of the Big Island. Adjacent to the Mauna Lani Bay Hotel on the only beachfront condominium site in the Mauna Lani Resort, the...
- 1 bedroom
- 2 bathroom
- Sleeps 2
HI> Waimea
Mauna Lani Terrace Unit D201 is perfectly situated between the Mauna Lani Bay Hotel and the Mauna Lani Beach Club in the highly desired vacation destination of Mauna Lani Resort. You will be close to shopping, dining, championship golf, and, ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
HI> Waimea
Sophisticated, contemporary three bedroom condominium located at the point where the ancient fish ponds meet the Pacific. Enjoy the wide, unobstructed view from your lanai with your morning coffee and your sunset cocktail.
Recently renovated, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kamuela
Oceanfront condo located only steps away from the beach and the Mauna Lani Resort! J201 is a charming, partially refurnished deluxe unit with 2 bedrooms and 2.5 bathrooms. Its perfect location in the exclusive "J" building offers up close ocean ...
- 2 bedroom
- 3 bathroom
- Sleeps 5
HI> Kamuela
This stunning property is now accepting longer-term stays at reduced rates. Please inquire for details.
Please note that the Mauna Lani Terrace pool will be closed for maintenance from April 25th to approximately May 10th, 2022.
Recently ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
HI> Kamuela