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 = 'Haiku-Pauwela' OR postalCode = 'Haiku-Pauwela' OR region like '%|Haiku-Pauwela|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
[PERMIT- BBPH2012-0004]
2 bedroom
1 bathroom
Sleeps 6
Hawaii> Haiku-Pauwela
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 Rental permit - BBPH 2011/0001
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Haiku-Pauwela
Pineapple Cottage enjoys a 5-star rating. Enjoy peace and quiet overlooking a private gulch and stream with a bit of with ocean view. Pineapple Cottage offers hardwood floors, shaker cabinets, granite countertops, newly purchased leather sofa,
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
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Haiku-Pauwela
Maui County Rental permit - STPH 2014/0004
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 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
3 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
Maui Permit STPH2015/0006. 1 bedroom, 1 bath, (sleeps 2) fully equipped & newly renovated kitchen, FREE WIFI, new appliances, coffee maker, toaster, blender, washer/dryer, new queen bed, linens, towels, beach towels, beach chairs (2), outdoor
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Haiku-Pauwela
A pole and beam structure with lots of teak on the interior and lush tropical surroundings outside. Guests enjoy the experience of living in a unique tree house style structure with all the amenities of a 5 Star hotel but with greater privacy
2 bedroom
2 bathroom
Sleeps 3
Hawaii> Haiku-Pauwela
Surrounded by green with ocean & mountain views, is a quiet, cozy and private retreat with 2 separated spaces (studio + screen porch) taking in pleasingly mellow sounds of nature! Locally-favorite beaches, hikes, towns and restaurants just
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Haiku-Pauwela
*Please note, our calendar only accepts bookings 9 months in advance, if you wish to book beyond this time restraint please message us your desired dates for approval.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Haiku-Pauwela
Spacious two story home on 2 acres land surrounded by palm trees, flower farm and fruit orchard with gorgeous sunset views towards the Kahalawai Mountains. The ground floor offers a large bedroom with 2 double beds, shower bath and dressing
3 bedroom
3 bathroom
Sleeps 6
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
The North Shore Guest House is conveniently located on Maui's famous North Shore. Spacious, very comfortable, peaceful and quiet THREE (3) BEDROOM/TWO (2 BATHROOM HOME with a large living room and open-style kitchen. A king size bed in the
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Haiku-Pauwela
Maui is one of the most beautiful and breathtaking islands on Earth.Explore the magic of Maui in style and comfort with our premium 4x4 Jeep equipped with a rooftop tent, enabling you to seamlessly transition from one thrilling adventure to
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Haiku-Pauwela
Hunter Hales “KALA” is one of two identical 810 sqft cottages on one half acre lot privately located just behind the Haiku Town center. This listing is for “KALA”cottage. Conveniently located at the start of the Road to Hana. Enjoy the
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Haiku-Pauwela
