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 = 'Haiku-Pauwela' OR postalCode = 'Haiku-Pauwela' OR region like '%|Haiku-Pauwela|%') AND sleeps>=1 order by rating desc LIMIT 0, 15
A peaceful getaway in the Maui countryside. Areca Suite is the perfect place to relax, unwind & enjoy the ocean view & tropical setting in your own private 2 bedroom/1 bath apartment with coastal ocean views from the lanai, living / dining room...
2 bedroom
1 bathroom
Sleeps 4
HI> Haiku-Pauwela
Live like a Local your home away from home ! The Proximity offer's Perfect temperatures year round, Trade Winds and Tropical Ocean Breeze make this home worth coming home to visit year after year !
A Warm Aloha Welcome to our Pe'ahi Point ...
1 bedroom
1 bathroom
Sleeps 2
HI> Haiku-Pauwela
Imagine relaxing in your hammock or private Jacuzzi at this exquisite honeymoon/vacation retreat where you are the only guests -- surrounded by unspoiled natural beauty, brilliant rainbows, sunsets over the ocean -- in complete privacy...
Have...
1 bedroom
1 bathroom
Sleeps 2
HI> Haiku-Pauwela
Enjoy your stay near "Jaws" the backyard of big wave WSL Jaws challenge competition on the North shore.
The Dolphin studio is a Maui family owned vacation rental since 2019.
Hana is 39 miles from your rental, bamboo forests and spectacular ...
0 bedroom
1 bathroom
Sleeps 2
HI> Haiku-Pauwela
Maui Permit STPH2015/0006 -- 3 bedroom, 1 bath, (sleeps 2-5) fully equipped & newly renovated kitchen, FREE WIFI, new appliances, coffee maker, toaster, blender, washer/dryer (not shared), Bedroom 1 = Queen Bed, Bedroom 2 = Queen Bed, Bedroom 3 ...
3 bedroom
1 bathroom
Sleeps 5
HI> Haiku-Pauwela
E Komo Mai! Ho'okipa Rose, Peaceful, Tropical home in the quaint town of Haiku. Lovely 2 bedroom, 2 bath, 1000 sq. ft. cottage located on private, two acre property. Fully equipped kitchen with everything you need to prepare meals. Upscale ...
2 bedroom
2 bathroom
Sleeps 4
HI> Haiku-Pauwela
Located in the heart of the north shore of Maui, this charming 3-bedroom residence is a refuge for those who want to experience the beauty of Maui in comfort and tranquility. The house is 2254 square feet and has a beautiful view of a Hawaiian ...
3 bedroom
2 bathroom
Sleeps 8
HI> Haiku-Pauwela
This lovely 3 bedroom, 2 bath plantation style home is located in the heart of Haiku. It has an open floor plan, vaulted ceilings and windows all around. You will enjoy lots of light and views of the lush garden, pool and spa. With high quality ...
3 bedroom
2 bathroom
Sleeps 6
HI> Haiku-Pauwela
Hale Leialoha is a beautiful 2 bed 2 bath plantation style cottage located in "upcountry" Maui in the picturesque town of Haiku. Our Maui vacation rental is permitted (BBPH 2017/0004, SUP 2017/0010) and perfect for your memorable Hawaiian ...
2 bedroom
2 bathroom
Sleeps 6
HI> Haiku-Pauwela
This recently built comfortable cottage is located on the north shore of the island of Maui, tucked away in the quiet countryside of Haiku but relatively close to major attractions! Enjoy a relaxing vacation in a rich tropical setting with ...
1 bedroom
2 bathroom
Sleeps 4
HI> Haiku-Pauwela
Our brand-new, two bedroom farm house has a very unique feel with detailed craftsmanship (built by the owner). The home is 1000 square fee. It has an open concept with a 500 sq. ft. deck and views of the ocean, mountains, and our farm. We have ...
2 bedroom
1 bathroom
Sleeps 4
HI> Haiku-Pauwela
Imagine relaxing in your hammock or private jacuzzi at this exquisite honeymoon/vacation retreat where you are the only guests -- surrounded by unspoiled natural beauty, brilliant rainbows, sunsets over the ocean -- in complete privacy...
Have...
2 bedroom
2 bathroom
Sleeps 4
HI> Haiku-Pauwela
Maui Permit #BBPH 2009/0002 , Hawaii Permit #SUP2 2002/0005
Hawaii Tax I.D. TA035-442-8928-01 TMK (2)2-7-035-010-0000
Maui's Ultimate Private, Romantic Cottage! ...a unique architectural Polynesian Pole home on Magical Maui.
Secluded, ...
1 bedroom
1 bathroom
Sleeps 2
HI> Haiku-Pauwela
Holomakai B and B is a vacation rental with three bedrooms for rent individually on Maui’s north shore. Each room has a private bathroom, ac, tv and WiFi. The rest of the house, the entrance, fully equipped kitchen, living room and spacious ...
1 bedroom
1 bathroom
Sleeps 2
HI> Haiku-Pauwela
North shore Maui ocean view B and B is a vacation rental with three bedrooms for rent individually on Maui's north shore. Each room has a private bathroom, ac, tv, and Wifi. The rest of the house, the entrance, fully equipped kitchen, living ...
1 bedroom
1 bathroom
Sleeps 2
HI> Haiku-Pauwela
