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 = 'hana' OR postalCode = 'hana' OR region like '%|hana|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
Our units are open to the ocean breeze, and due to the coronavirus pandemic we have removed bedspreads, throw pillows, rugs and other items that are difficult to clean on a daily basis. Masks are required when outside of units. Plexiglass has ...
1 bedroom
1 bathroom
Sleeps 3
HI> Hana
We are located on 6 acres. Located close to Wainapanapa State Park and only 10 minutes from Hāna town. We are home to many rescue farm animals that are a loving part of our family. Peaceful- private- and relaxing. Outdoor bbq, fire pit , ...
1 bedroom
1 bathroom
Sleeps 2
HI> Hana
SUP 2019/0006
STHA20200001
Hawaii TA Tax:TA-081-974-0672-01
Hawaii GE Tax:GE-081-974-0672-01R
This is an Incredible opportunity to escape from the busy resorts and retreat to a private three acre estate with your loved one's, family, friends or ...
3 bedroom
2 bathroom
Sleeps 6
HI> Hana
Maui County Permit # STHA 2016/0006
Tax ID TA and GE 170-361-2416-01
As of October 15 Pre-boarding testing with negative results for Covid-19 is allowed to come to Maui without a 14 day quarantine.
Covid-19 Cleaning Fee of $50… Due to the ...
1 bedroom
1 bathroom
Sleeps 2
HI> Hana
Our units are open to the ocean breeze and due to the coronavirus pandemic we have removed bedspreads, throw pillows, rugs and other items that are difficult to clean on a daily basis. Masks are required when outside of units. Plexiglass has ...
2 bedroom
2 bathroom
Sleeps 6
HI> Hana
Entabeni Cottage, sits above the Road to Hana overlooking the Pacific Ocean on the north shore of Maui, Hawaii.
Maui County License & Permit: BBPH 2013/0006 and SUP2 2012/0011
Entabeni Cottage is a fully-equipped, 830 square foot home, ...
0 bedroom
2 bathroom
Sleeps 2
HI> Hana
The view of the ocean and coastal pasture makes guests exclaim "wow" as they enter the dutch doors of this cozy cottage.
This is a place to relax. You can watch the whales play and hear them sing at night. The cows lazily graze through the ...
0 bedroom
1 bathroom
Sleeps 2
HI> Hana
Our units are open to the ocean breeze, and due to the coronavirus pandemic we have removed bedspreads, throw pillows, rugs and other items that are difficult to clean on a daily basis. Masks are required when outside of units. Plexiglass has ...
0 bedroom
1 bathroom
Sleeps 2
HI> Hana
Our units are open to the ocean breeze and due to the coronavirus pandemic we have removed bedspreads, throw pillows, rugs and other items that are difficult to clean on a daily basis. Masks are required when outside of units. Plexiglass has ...
1 bedroom
1 bathroom
Sleeps 2
HI> Hana
As of October 15 Pre-boarding testing with negative results for Covid-19 is allowed to come to Maui without a 14 day quarantine.
Covid-19 Cleaning Fee of $50… Due to the heightened requirement for the protection of our guests, we are taking ...
2 bedroom
1 bathroom
Sleeps 4
HI> Hana
Discover paradise in Heavenly Hana, Maui, and surround yourself with the most breathtaking views in all of Hana.
Ekena means Eden in Hawaiian. This tropical paradise is perched high on a hill on nine acres of private property with 360 degree ...
2 bedroom
2 bathroom
Sleeps 4
HI> Hana
Maui County Permit # BBHA 2014/0002
This Hana cottage is tucked away on a lush hillside near Haleakala National Park.
Stay in this, fully equipped, one-bedroom Maui home. It's one of the most beautiful locations Hana has to offer. Perfect for ...
1 bedroom
1 bathroom
Sleeps 2
HI> Hana
Come and enjoy the natural beauty of Hana, the essence of Hawaii in an undeveloped paradise. Enjoy spectacular waterfalls, pools, rugged shorelines, and some of the best beaches on the island just outside your door.
Your romantic hideaway is ...
2 bedroom
2 bathroom
Sleeps 4
HI> Hana
Our units are open to the ocean breeze, and due to the coronavirus pandemic we have removed bedspreads, throw pillows, rugs and other items that are difficult to clean on a daily basis. Masks are required when outside of units. Plexiglass has ...
1 bedroom
1 bathroom
Sleeps 4
HI> Hana
Here time and nature move to a greater rhythm. Hana is nearby- a little town on the backside of Maui that is just about as far away as one could hope to travel... and still return. When it comes to natural attractions, Hana is blessed above all ...
1 bedroom
1 bathroom
Sleeps 2
HI> Hana