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 (city = 'Kula' OR postalCode = 'Kula' OR region like '%|Kula|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Skylights in the loft bedroom provide a beautiful view of the night sky. Enhance your stargazing experience by visiting the star dome. This clear domed bubble tent provides an unobstructed view of the night sky and is equipped with a heater ...
1 bedroom
1 bathroom
Sleeps 2
HI> Kula
This detached private home has 2 bedrooms, 1 California King and 1 Queen bed, with luxury linens, comforters, and pillows. The cottage has a great room feel, with the kitchen, dining, and living room all open, looking onto the West Maui ...
2 bedroom
1 bathroom
Sleeps 4
HI> Kula
Jewel of Keokea is a tranquil contemporary design vacation guest-suite with private entrance and patio garden in a private home in a friendly and local neighborhood where a unique experience awaits you on the slopes of Maui’s Haleakala ...
1 bedroom
1 bathroom
Sleeps 3
HI> Kula
G & Z Upcountry Bed & Breakfast Cottage, situated on half an acre in Kula Maui is adjacent to the hosts' 6-acre farm. TMK 2-2-2-006-101-0000-000
A large jacaranda and two avocado trees shade the wide-open lawn. At an elevation of around 3,000 ...
1 bedroom
1 bathroom
Sleeps 2
HI> Kula
This dream come true Maui vacation home allows you to enjoy both the sunrise and sunset from the privacy of your own home away from home. This private gated retreat on 33 acres has stunning panoramic ocean, multi-island and mountain views. ...
1 bedroom
2 bathroom
Sleeps 2
HI> Kula
Permit#BBMP2017/0006 TAT#TA-101-081-2928-01 Experience panoramic ocean views and breathtaking sunsets at this private custom home in Keokea, Maui, located at an idyllic elevation just below the famous Thompson walking road and the Oprah Winfrey ...
2 bedroom
3 bathroom
Sleeps 4
HI> Kula
Maui County permit: STMP 2014/0001
TA-001-935-7696-01 / GE-001-935-7696-02
TMK-230140190000
Nestled on four stunning acres on the slopes of Haleakala (House of the Sun), our Haleakala Princess home is all about the views. From the north ...
3 bedroom
3 bathroom
Sleeps 6
HI> Kula
Open a wall of glass doors breathing in balmy tropical breezes and experience Kula; scenic, serene, satisfying.
Inspired island living in an exquisite architecturally designed home, both casual/comfortable, and luxurious. This home has it all ...
3 bedroom
3 bathroom
Sleeps 6
HI> Kula
SPECIAL COVID ANNOUNCEMENT JUNE 30, 2021
Beginning July 8, travelers entering the state who have been fully vaccinated in the United States may bypass quarantine without a pre-travel test. Learn more at https://HawaiiCOVID19.com/travel
See the ...
1 bedroom
2 bathroom
Sleeps 4
HI> Kula
Maui County Rental permit: STMP 2014/0001
TA-001-935-7696-01 / GE-001-935-7696-02
TMK-230140190000
Haleakala Princess Estate is a very unique vacation rental in Upcountry Maui. This home was designed for Abigail Kapiolani Kawananakoa and has ...
2 bedroom
2 bathroom
Sleeps 4
HI> Kula
This is a large, two story house with the owners living in part. You have a private entrance, one or two bedrooms and one and a half private bathrooms. Located at 2600 ft elevation on the west slope of Haleakala, this is a quiet neighborhood ...
1 bedroom
1 bathroom
Sleeps 2
HI> Kula
Unit: Kula Treat | Maui Guidebook
Committed To Clean
We’re committed to enhanced cleaning protocols developed in partnership with experts in health and hospitality. Here’s what we’re doing to clean and sanitize:
We use cleaners and ...
2 bedroom
1 bathroom
Sleeps 4
HI> Kula
Unit: Kula Jewel | Maui Guidebook
Committed To Clean
We’re committed to enhanced cleaning protocols developed in partnership with experts in health and hospitality. Here’s what we’re doing to clean and sanitize:
We use cleaners and ...
3 bedroom
3 bathroom
Sleeps 7
HI> Kula
