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 (`headline` like '%haleakala%') AND sleeps>=1 order by rating desc LIMIT 0, 50
We invite you to stay in our peaceful home on the North Shore of Maui, within walking distance to a local coffee shop, small grocery and near the Road to Hana and Haleakala. Only available to book with the owner Amy - Beware of scammers ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Haiku
Enjoy this 2nd floor unit featuring gorgeous views throughout the unit of Maalaea Bay, the grand volcano Haleakala and the sparkling Kihei lights at night. The unit is tastefully decorated with the spirit of Aloha and has a portable a/c unit in ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailuku
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.
SUMMARY: Walk out the...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Haiku-Pauwela
Welcome to Haleakala Cottage at Huelo Point Lookout, your ideal starting point for a Hawaiian adventure, especially if you're planning to explore the iconic Road to Hana. Our cozy cottage on Maui's unspoiled north shore is surrounded by lush ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Haiku
This detached private home has 2 bedrooms, 1 California King and 1 Queen bed, with
luxury linens, comforters, and pillows. The cottage has a great room feel, with the kitchen, dining, and living room all open, looking onto the West Maui ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kula
Welcome to our spacious 655 square feet, one-bedroom condo in Kihei, Maui (C511), just 100 yards from the pristine shores of Kamaole Beach Park 2! Dive into a world of underwater wonders as you snorkel right across the street alongside ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
IF you have been hearing on the news that Short Term Rentals on Maui might be phased out beginning in 2025, NO WORRIES about booking at Sugar Brech Resort. We are located in a Country Zoned Hotel/Resort area. Only those in Apartment Zones are ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Ocean Views from the Lanai, are so awesome, you may never want to leave the condo! Everyday brings a one-of -a kind Sunrise over Haleakala. Everyday, turtles feed among the gentle waves of our private beach, which is steps away. During whale...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Wailuku
Enjoy bed and breakfast on the mountain in a tranquil contemporary designed guest-suite with private entrance and patio garden in a friendly and local neighborhood where a unique experience awaits you on the slopes of Maui’s Haleakala ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kula
Haleakala Shores #A-408 is a 2 bedroom, 2 bath unit on the 4th floor, with window unit A/C in the living room and master bedroom, a fully-equipped kitchen, washer and dryer, 2 flat-screen TVs, telephone with long distance calling to the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Ekahi 33E offers a rare setting with views of the ocean, Ekahi's greenbelt and Haleakala. In Ekahi's lower village it's a short walk to the main pool and Keawakapu Beach. Renovation completed Jan 2020 & new to the rental market, 33E is ...
- 1 bedroom
- 3 bathroom
- Sleeps 2
Hawaii> Kihei
Recently remodeled. New everything! New flooring throughout. New Beautiful Hawaiian Bedroom King set with a firm Beauty-rest mattress bed with custom closets. New A/C. This place is great for honeymooners with the ocean making waves every ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailuku
2022 winnebago Solis. Queen bed linens pots pans French press camp chairs beach chairs refrigerator stove large yeti cooler bbq grill table tiki torches.Outdoor shower mosquitoe netting.Camping is good...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
You cannot get closer to the beach in South Kihei for this rate. This corner, front row unit features expansive ocean views from the living room and lanai, and just across the street awaits one of the most beautiful beaches in all of the islands...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
This is a large, two story house with the owners living in part. You have a private entrance, one bedroom and full, private bathroom plus decks front and back.
Located at 2600 ft elevation on the west slope of Haleakala, this is a quiet ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kula
Haleakala Shores #B-102 is a 2 bedroom, 2 bath ground floor unit in a great location with a view of the pool, a fully equipped kitchen, washer and dryer, TV, dvd, free wifi, and telephone service with long distance calling to the continental US ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Indulge in the ultimate Maui escape at Haleakala Shores A-302, a meticulously appointed two-bedroom, two-bath ocean-view condo nestled within the coveted A Building of the Haleakala Shores complex. Immerse yourself in luxury and comfort with a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Haleakala Shores #A-212 is a spacious 2 bedroom 2 bath condo that is just across from Kamaole Beach III and has tropical garden views from the covered lanai. This fantastic property is within walking distance to restaurants, shops and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
SUMMER AND FALL SPECIAL: RATES RECENTLY DROPPED DRASTICALLY TO ENCOURAGE TRAVEL TO MAUI. MAUI NEEDS TOURISM!
Please call me for questions: (626) 484-2124 or email me at mauivacation1993@gmail.com
PLEASE NOTE: The sample rental ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
*** Low season fall 2024 discount. 15% off nightly rate on all travel dates from September 10 - December 15, 2024.
Two couples can enjoy a perfect Maui getaway at Haleakala Shores A-309, with two bedrooms and bathrooms, there’s plenty ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Haleakala Shores #A-411 is a 2 bedroom, 2 bath unit on the 4th floor. It has a partial ocean view, a fully-equipped kitchen, washer and dryer, 2 flat-screen TVs, telephone with long distance calling to the continental US and Canada, and free ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
*****************************************************************************************************
**** THE CONDO OWNERS WILL REQUIRE FROM ALL OUR GUESTS, a signed copy of their rental agreement. It will be provided upon reservation ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
Haleakala Shores B509 offers views of the beautiful Maui waters, West Maui mountains, and Haleakala! Your perfect Maui getaway starts here in this spacious top floor unit at Haleakala Shores! Enjoy the open feel with vaulted ceilings and large ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Island Surf 601A
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Enjoy spectacular sunrises over Haleakala volcano from the window of this ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Embark on a Hawaiian getaway like no other at Grand Champions 27 in sunny Wailea! This exquisite two-bedroom, two-bathroom condo offers airy and spacious interiors flooded with natural light and stunning views of the Wailea Blue Golf ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
Haleakala Shores- Relaxing two bedroom, two bath condo - just across the street from Kamaole Beach Park III and easy walking to shops and restaurants. Features a queen size bed in the master and two twin beds in second bedroom. Each bedroom ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Haleakala Shores #B-309 is a 2 bedroom / 2 bath, upstairs unit with a fully equipped kitchen, Washer/Dryer, Partial A/C, and Cable TV/DVD. It is right across the street from Kamaole Beach #3. With a King bed in the Master bedroom and two twins ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
The Blue Door on Church Street is the perfect home for your Maui adventures. Get out of the hectic hotel zones and experience Hawaii in relaxed, luxurious accommodations. We are nestled below beautiful I'ao Valley in historic Wailuku Town. Walk ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Wailuku
Book your 5 night stay in September or October and get the 6th night free. Experience more for less!
Haleakala Shores A403 offers a great location with peeks of the water and West Maui mountains. This 2-bedroom/2-bath condo is perfect for...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Highly cleaned and sanitized for your vacation. Ask about our AlohaSafeStay program.
If you have a stay that qualifies for housekeeping services, traditional housekeeping service will be performed every 7th day. This includes refreshing...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei, Maui
After snorkeling and lounging by the pool, unwind with a pina colada and fresh catch dinner on your private lanai with Haleakala view. This air-conditioned 884sf condo features ceiling fans, WiFi, flat screens, DVD, washer/dryer, full kitchen ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
After a hot day at the beach, relax at Ke Kīhāpai Bed & Breakfast at the 2400 foot elevation with unobstructed views of our dormant volcano, Haleakalā. Breathe the fresh air with an upcountry view of town, the north shore of Maui and ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kula
Located just 5 minutes from the entrance of Haleakala Crater Road. At an elevation of around 3,000 feet, guests welcome the day as the sun rises over Haleakala and sets in the ocean or behind Mauna Kahalawai (West Maui Mountains). Guests might ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kula
This adorable bed & breakfast in Makawao is the perfect spot for your escape. With a cozy bedroom featuring a queen bed, a lovely living room with two sofa beds, and a bathroom equipped with a shower and hair dryer, guests will feel right at ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Makawao
