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 (city = 'Haiku-Pauwela' OR postalCode = 'Haiku-Pauwela' OR region like '%|Haiku-Pauwela|%') AND sleeps>=1 order by rating desc LIMIT 0, 20
25% discount for Dec 16 to Dec 23, 2023
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Haiku-Pauwela
Maui Permit STPH2015/0006 - 3 bedroom, 1 bath, (sleeps 2-5) fully equipped & renovated kitchen, FREE HIGH SPEED WIFI, new appliances, dishwasher, coffee maker, toaster, blender, washer/dryer (not shared), Bedroom 1 = Queen Bed, Bedroom 2 = Queen...
3 bedroom
1 bathroom
Sleeps 5
Hawaii> 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
Hawaii> Haiku-Pauwela
We invite you to stay in our quaint and nicely decorated Haiku Surf Cottage on the North shore of Maui. IMPORTANT!!! Beware of scammers advertising our home on CL. Only available to rent from Amy - the real owner.
2 bedroom
1 bathroom
Sleeps 4
Hawaii> 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
Hawaii> Haiku-Pauwela
Relax & enjoy the peace & quiet, coastal ocean views, lush tropical setting & complete privacy at your modern cottage with private lanai.
2 bedroom
1 bathroom
Sleeps 4
Hawaii> 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. Room 3 is the only room on the top floor of the house. The rest of the ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Haiku-Pauwela
Maui County Bed and Breakfast Permit number BBPH 20090014
2 bedroom
1 bathroom
Sleeps 4
Hawaii> 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
Hawaii> Haiku-Pauwela
Maui County Rental permit - STPH 2014/0004
5 bedroom
5 bathroom
Sleeps 10
Hawaii> Haiku-Pauwela
Maui County Rental permit - STPH 2013/0016
5 bedroom
5 bathroom
Sleeps 10
Hawaii> 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
Hawaii> 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
Hawaii> Haiku-Pauwela
Maui County Bed and Breakfast Permit number BBPH 20090014
2 bedroom
1 bathroom
Sleeps 2
Hawaii> Haiku-Pauwela
Maui County Rental permit - STPH 2013/0024
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Haiku-Pauwela
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
Hawaii> Haiku-Pauwela
This charming house is the perfect place to relax with its quiet and breezy atmosphere. Its set on its own private 1/2 acre within minutes to the beach. Located just down the road from one of the worlds biggest waves Jaws and some of Maui's ...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Haiku-Pauwela
Our 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 goats and ...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> 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 6
Hawaii> Haiku-Pauwela
The Ha’iku Hale is taken care of by a local family that seeks to uphold the values of Hawai’i’s culture. Designed to be a sanctuary in the middle of paradise to retreat & rejuvenate.
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Haiku-Pauwela
