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 IF (ISNULL(`price`), 1,0), `price` asc LIMIT 0, 15
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
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
HI> 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
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
Maui County Bed and Breakfast Permit number BBPH 20090014
TA-200-805-1712-02
If you are looking for peaceful Hawaii away from the crowded resorts and neighborhoods look no further you have found it.
Welcome to the Bamboo Valley Inn: Haleakala ...
2 bedroom
1 bathroom
Sleeps 4
HI> Haiku-Pauwela
Check out our featured article in HI magazines favorite places to stay in Maui in our photos! We invite you to stay in our super clean and nicely decorated Haiku Surf Cottage. It's the only vacation rental on our side of the island that is ...
2 bedroom
2 bathroom
Sleeps 4
HI> 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
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
Relax & enjoy the peace & quiet, coastal ocean views, lush tropical setting & complete privacy at your modern cottage with private lanai.
We follow the VRBO/CDC cleaning protocol guidelines. Our cleaners use cleaning and disinfecting ...
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...
1 bedroom
1 bathroom
Sleeps 2
HI> 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
HI> Haiku-Pauwela
Pineapple Cottage enjoys a 5-star rating. Enjoy peace and quiet overlooking a private gulch and stream, with ocean views. We are minutes away from restaurants and shopping, beaches are 15 minutes away. Cottage offers hardwood floors, shaker ...
2 bedroom
1 bathroom
Sleeps 4
HI> Haiku-Pauwela
Maui County Rental permit - BBPH 2011/0001
TA-063-891-2512-01/ GE-063-891-2512-01
TMK-270360090000
Romantic, unique, charming coral rock cottage perched on the edge of Maliko Gulch. Swing in the hammock, or play tennis on the clay court. This is...
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
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
