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, rewritten_description,
(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 (city = 'hana' OR postalCode = 'hana' OR region like '%|hana|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Entabeni Cottage, sits above the Road to Hana overlooking the Pacific Ocean on the north shore of Maui, Hawaii.
1 bedroom
2 bathroom
Sleeps 2
Hawaii> Hana
The view of the ocean and coastal pasture makes guests exclaim "wow" as they enter the dutch doors of this cozy cottage.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Hana's Heaven - a charming 2 bedroom cottage complete with full kitchen, living room and 3 lanais. Wake every day to the sunrise and ocean expanse. Off the beaten track, this home away from home is quiet and serene, the perfect place to relax
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Hana
Maui County Permit # STHA 2016/0006
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
The Hamoa Bay Bungalow is HANA MAU'Is most charming vacation hide-away. Balinese inspired, private, with partial ocean views, secluded and romantic.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Discover paradise in Heavenly Hana, Maui, and surround yourself with the most breathtaking views in all of Hana.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Hana
Popolana” – Unit 2 – is our one and only oceanfront studio condominium. Just 100′ off the water, this lovely unit has warm tropical decor with bamboo walls and rattan furniture, a queen-size bed, granite counter tops, hardwood floors and
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Ka’ahumanu – Unit 5 – is a top-floor, deluxe oceanfront 2-bedroom/2-bath unit with a king bed in master bedroom, a queen bed in the 2nd bedroom and a queen hide-a-bed in the living room. Beautiful kitchen with porcelain tile floors,
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Hana
Maui County Permit # STHA 2016/0006
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
Aloha!
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Exuding to the comfort and ambiance of an authentic Hawaiian beach house, the Manini cottage offers a coveted, secluded location. Nestled oceanfront on Hana Bay's edge, it features an open living space and a covered ocean deck with unobstructed
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
OCEANFRONT SPLENDOUR IN PERFECT HARMONY WITH NATURE
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Hana
The farm cottage is set at the top of our 5 acre exotic fruit farm. Enjoy your stay by touring the property and relaxing in our cozy home away from home. The cottage is equipt with everything you'll need without the clutter. From the living
1 bedroom
1 bathroom
Sleeps 2
Hawaii> HANA
Ala Aina Ocean Vista is a unique, 100% solar-powered private ohana with front and back private entrances situated on a former banana plantation. Nestled in an exotic lush tropical setting, our accommodation promises peace and quiet and offers
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Hale Nanea is close to everything Hana, yet far enough away that it's private and peaceful at night. The cottage is well equipped and very comfortable with custom Bali furnishings.
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
Maui County Permit #STHA 2016/0005
4 bedroom
2 bathroom
Sleeps 6
Hawaii> Hana
Hana Homestead is our eco friendly home in the heart of Hana town. The spectacularocean views, large decks, new hot tub and inferred saunaandmodern rustic elegance of this unique home is just the beginning.A3 minute stroll will bring you toHana
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Hana
The house sits in the middle of the 4 acres surrounded by lawn, flowers, fruit trees and forest. Guests are welcome to harvest the fruit and flowers. It is very quiet, and on clear nights it is like a bowl of stars turned upside down on our
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
SPECIALS
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Hana
“Kaihalulu” – Unit 105 – is an ocean view studio unit located ground floor in the Mauka (upper) building. There is a queen-size bed, a spacious covered lanai with a small dining table and comfy chairs and a great view. The unit has
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Waikaloa - Unit 1 is a 1 BR/1BA oceanfront unit. Just 100′ off the water, this lovely unit has warm tropical decor with bamboo walls and rattan furniture, a King-size bed, granite counter tops and hardwood floors. The stunning view is
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
Situated on a well groomed acre, Luana Cottage offers privacy as well as easy access to hiking, swimming, and exploring the beautiful Eastern side of Maui.
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Hana
“Mokuhano” – Unit 205 – is an upper floor, ocean view studio located in Hana Kai’s Mauka Building. There is a king-size bed in the living/bedroom area, open-beam ceilings and tiled floors throughout. The view of the bay is enhanced by
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Nanu’alele – Unit 4 – is an oceanfront 1-bedroom, 1-bath unit. This top floor, corner unit enjoys amazing views of Hana Bay and Waikaloa Beach and is very private. There is a queen-size bed in the bedroom and a queen-size commercial grade
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
SUP 2019/0006
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Hana
Beautiful spacious studio with 1 queen bed, full kitchen (fridge, stove, oven, microwave, Keurig), ceiling fan, full private bathroom and wrap around covered deck. You'll be surrounded by the sights of trees and sounds of ocean and birds. The
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
We are a licensed vacation rental:
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
The Hana Ocean Palms Bungalow is located across from one of Hana's most beautiful oceanfront pools - Waioka Pond (Venus Pool). The property is nestled in a coconut palm grove and surrounded by almost an acre of lush tropical flowers, fruit
3 bedroom
2 bathroom
Sleeps 4
Hawaii> Hana
Aloha!
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
“Ka’uiki” – Unit 101 – is a one bedroom, one-bath unit. Located in Hana Kai’s upper (Mauka) building, this vacation rental is a corner, ground floor unit with easy access. There is a king-size bed in the bedroom and twin day beds in
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
"Alau” – Unit 202 – is an upper-floor, lofted, ocean-view studio located in Hana Kai’s Mauka Building. The unit accommodates up to 4 guests with 1 queen bed on the main floor and another queen bed in the loft. *Note* SLEEPING IN THE LOFT
2 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
“Waiohinu” – Unit 204 – is an upper floor 1-bedroom, ocean view unit located in Hana Kai Maui’s Mauka (upper) building. 204 accommodates 1-4 guests with 1 king bed and a queen hide-a-bed. There is a pass-thru window from the kitchen to
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
“Helani” – Unit 103 – is a 1-bedroom/1-bath condo conveniently located in Hana Kai’s Mauka (upper) building. There is a king-size bed in the bedroom and a comfy queen-size hide-a-bed in the living room, tiled tub/shower combination,
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
“Puhele” (Unit 206) is a premium oceanview studio located on the upper floor of the Mauka building. There is a king bed in the loft and a queen hide-a-bed on the main floor. Sliding glass doors open onto a spacious lanai with an amazing view
2 bedroom
1 bathroom
Sleeps 3
Hawaii> Hana
Beautiful studio with 1 queen bed, fridge, microwave, coffee maker, ceiling fan, full private bathroom with river rock shower, 2 covered decks, and parking right in front of your door. You'll be surrounded by the sights of trees and sounds of
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
“Honokalani” – Unit 201 – is a 1-bedroom, 1-bath unit located in Hana Kai’s upper (Mauka) building. This vacation rental is a corner, upper floor unit with a king-size bed in the bedroom and a queen hide-a-bed in the living room and
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
“Kama” – Unit 107 – is a 1-bedroom, partial ocean view condo located in Hana Kai’s Mauka (upper) building. This is a ground floor, corner unit with a King-size bed in the bedroom and a full size futon couch in the living room. There is
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
“Lanakila” – Unit 203 – is an upper floor 1-bedroom, 1-bath unit located in Hana Kai Maui’s Mauka (upper) building. This unit has an open kitchen featuring a koa bar and koa accents, hardwood floors, stainless appliances, granite
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
KAMAAINA RATES AVAILABLE. Inquire for more details.
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Hana
Aloha!
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Hana
Aloha!
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Hana
Kaumaka, which means "beloved" in Hawaiian, offers a four-star experience plus a spectacular oceanview at the beachfront Hana-Kai resort. Outstanding ground floor location means no stairs! Hear the pebbles dashing the shores of Kapueokahi Beach
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Beautiful studio with 1 queen bed, private bathroom with river rock shower, 2 covered decks, and parking right in front of your door. You'll be surrounded by the sights of trees and sounds of ocean and birds. The property is 2 acres of lush Hana
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
Hana Maui
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
“Kuakahi” – Unit 106 – is a ground-floor, partial ocean view studio in the Mauka (upper) building. Our most affordable unit, it has a queen-size bed, a spacious covered lanai, porcelain tile floors, granite countertops, bar seating,
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
The Ho'okipa Surf Suite Studio at Heavenly Hana Paradise features a private lanai and entrance, surrounded by fresh ginger, gardenia, and tropical greenery. The en suite bathroom includes plush bath towels, hand towels, complementary toiletries,
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Hana
