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, 50
$350/NT+TAX SPECIAL PLUS $100 LAVA LAVA BEACH CLUB CARDS FOR A LIMITED TIME!
UNBELIEVABLE SPACIOUS TOWNHOME ILLUMINATED WITH A WALL OF NATURAL LIGHT!
Kulalani 904 is one of the newest homes developed within the resort. At a ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kamuela
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
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 ...
- 4 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kamuela
Located in beautiful Kulalani within the Mauna Lani community, Kulalani 1701 by Gather tropical villa is beautifully decorated and flooded with natural light. A corner unit with two-story high windows and ceilings in the living room, and two ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
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
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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waimea
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
Kulalani 1702. Includes Mauna Lani Beach Club Pass
This vacation rental is professionally managed by ResorticaHawaii
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom: King Bed
Guest ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Mauna Lani Resort
Kulalani 705
Includes Mauna Lani Beach Club Pass
Please scroll down for detailed information
Bedding Configuration:
Master Bedroom (downstairs): King Bed
Guest Bedroom: Two Twin Beds
Guest Bedroom: One Queen ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Mauna Lani Resort
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 one with a built in ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waimea
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 ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Mauna Lani Resort
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
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 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
* New Rental Property*
Welcome to Hawaii Magic! This luxurious two-bedroom townhouse in Kulalani offers a perfect blend of comfort and style. With spacious living areas, modern finishes, it’s an ideal retreat for relaxation. Enjoy the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
New vacation rental now available in a tranquil Hawaiian Resort at Kulalani, Mauna Lani Resort.
If you're looking for the perfect place to spend your Hawaiian vacation, then you need not look any further than this lovely two bedroom, 2.5 bath...
- 2 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kamuela
