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 '%Kulalani%') AND sleeps>=1 order by rating desc LIMIT 0, 30
UNBELIEVABLE SPACIOUS TOWNHOME ILLUMINATED WITH A WALL OF NATURAL LIGHT!
Kulalani 904 is one of the newest homes developed within the resort. At a whopping 2673 square feet, this two story paradise will easily accommodate families as...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waimea
ALOHA!
E Komo mai. nou ka hale! Welcome to our home!
Kulalani is a beautifully landscaped, private, gated community within the Mauna Lani Resort.
Our brand new luxury golf villa boasts spectacular views of Mauna Kea and the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
KOHALA LUXURY RENTALS
KULALANI 501 - Two Master Suites, Two Levels, New Furnishings, Steps from the Pool!
Welcome to Kulalani 501 ~ A beautiful 2 bedroom 2.5 bath townhome retreat with vaulted 20 foot ceilings, three lanais including ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waimea
Brought to you by Paradise in Hawaii Luxury Homes.
Welcome to 'The Oasis at Kulalani' on the Big Island of Hawaii.
Welcome to the newest home in our Hawaiian Luxury Collection. 'The Oasis at Kulalani' is a wonderful almost new ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kamuela
Welcome to Hale Maluhia, (House of Peace) where we invite you to experience the warmth and Aloha that truly embody the spirit of the Hawaiian Islands!
This 3 bedroom, 2.5 bath townhome located within the lushly landscaped Mauna Lani ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kamuela
Your next dreamy Hawaiian vacation awaits you here in the Mauna Lani Resort at Kulalani 804 by Gather. This 2-floored openly designed 2 Bedroom, 2.5 Bathroom home sleeps up to 4 people with clean and luxurious furnishings. The entire home offers...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kamuela
Aloha and E Komo Mai "Welcome"
The perfect island vacation experience awaits you at Kulalani at Mauna Lani, located on Hawai`i Island’s Kohala Coast in the beautiful Mauna Lani Resort.
Our Kulalani luxury vacation villa is ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waimea
Welcome to Kulalani 1004, where comfort meets modern charm in this newly remodeled 2-bedroom, 2.5-bathroom townhouse-style condo. Situated within a private gated community, this unit offers a delightful golf course view, making it the perfect ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
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
Hawaii> Kamuela
Brought to you by Paradise in Hawaii Luxury Homes.
Welcome to Starfish House, a part of our Hawaiian Luxury Collection. The owners are the same as that of Sea Glass House at KaMilo which is one of our most elegant homes. Like Sea Glass ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kamuela
Kulalani 101. Includes Mauna Lani Beach Club Pass Please scroll down for detailed information
Unique Kulalani floor plan! Two Main Suites each with King Beds and their own lanai. Stunning bathrooms with tiled showers.
Bedding ...
- 2 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Mauna Lani Resort
This vacation rental is professionally managed by ResorticaHawaii
Kulalani 2403. Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
****PLEASE NOTE: There is a service dog that stays in this unit...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waimea
Enjoy the peaceful resort life at Kulalani 903, a luxurious and newly renovated townhome in one of the quietest areas at the Mauna Lani Resort. Completely refurnished in 2022, this sleek and modern townhome is perfect for families or small ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kamuela
Kulalani at Mauna Lani 2002
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Located in the gated Kulalani community, this spacious 3BR/2.5BA ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
This vacation rental is professionally managed by ResorticaHawaii
Kulalani 1805.
Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom (downstairs): King ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Mauna Lani Resort
Take advantage of our introductory rates! Desirable home in Kulalani at Mauna Lani
This neighborhood provides a perfect home base for exploring the Big Island and somewhere you will look forward to coming home to each day. Mauna Lani has ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kamuela
