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 '%Kauhale Makai%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Enter this fully and beautifully remodeled 2 bedroom condo to see the sparkling ocean below from the living room sliding doors. The light and bright space has a modern coastal aesthetic with wood flooring throughout, brand new stainless steel ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
• Oceanfront
• Central A/C
• King bed and queen bed
• Remolded March 2023
• Beach access from condo complex
Welcome to our home at Kauhale Makai 612. Our home was fully and immaculately remodeled in March of 2023....
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
• Oceanfront
• Central A/C unit
• King bed
• Remolded May2023
• Beach access from condo complex
Welcome to our home at Kauhale Makai 610. Our home was updated in May of 2023. Our beautiful and pristine ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
This beautiful 1 bedroom unit has everything for your Maui vacation. You will love the well maintained kitchen and bathroom. Enjoy your coffee on the balcony while ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kauhale Makai #211 is an ocean view 2 bedroom, 2 bathroom unit on the 2nd floor of the Anthurium building. It has central air conditioning, a fully-equipped kitchen, flat-screen TV, Blu-ray DVD, telephone, and wireless Internet. There is a queen...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Aloha! Welcome to this beautifully renovated 1-bedroom condo, where you'll find all the comforts of home in the stunning paradise of Maui. Completely remodeled in 2021, this condo features a bathroom with a stylish tiled walk-in shower and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei, Maui
Thank yourself with a stay in this newly remodeled condo at Kauhale Makai, the village by the sea. This remodel encompasses the stay-at-home charm of Hawaii with the added luxury of fresh and clean. Bask in the sun and AC while taking in the ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
Summary:
Family friendly with all the beach and kitchen amenities needed for a perfect vacation. Beautiful top/penthouse floor oceanfront Condo at Kauhale makai “village by the sea.”
The Space:
Enjoy epic ocean and mountain ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
We think our condo will be everything you are looking for to have a perfect vacation. #214 is located on the second floor; close enough to the ground to watch all the local bird and quail activity across the property grounds and yet high ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to Kauhale Makai 308 with ocean views. This 1bedroom/1bath offers the perfect Hawaiian escape! Enjoy a gorgeous Maui sunset or a peaceful morning on your private lanai. Watch whales breaching, during season, or dine alfresco with seating...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kauhale Makai #330 is an ocean view 1 bedroom, 1 bathroom unit on the 3rd floor of the Plumeria building. It has central air conditioning, a fully-equipped kitchen, flat-screen TV, Blu-ray DVD, telephone, and wireless Internet. There is a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Wake up to the sight of the Pacific Ocean sparkling in the sunshine. Fall asleep to the lull of waves rushing onto the white-sand and coral Waipu’ilani Beach. And in between make memories that will last a lifetime. That’s what awaits you at ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
Simply amazing beach front suite with the most gorgeous direct ocean front views. Relax on your balcony with the cool ocean breezes while whales breach in the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Aloha,
You've discovered a listing for a luxurious one-bedroom condo on the top 6th floor. Granite countertops, stainless steel appliances, tile floors, travertine bathroom, two 40' LED TVs.
The convenient floor plan allows ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Kauhale Makai 433 with stunning ocean views! This spacious 2bd/2bath offers the perfect paradise getaway! Enjoy a gorgeous Maui sunset or a peaceful morning on your private lanai. Watch whales breaching, during season, or dine ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Spacious and comfortable describe this ground floor condo with a beautiful garden view and partial ocean/mountain views. This unit, which sleeps 4, boasts a fully equipped kitchen, separate dining, central AC and a large bedroom with a ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kauhale Makai #222 is an updated, spacious (800 sq ft), ocean view, 1 bedroom unit on the second floor with an ocean view. It is equipped with central A/C, full kitchen, 70 inch SmartTV with expanded channels, high-speed WIFI and a safe for ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Guests rave about their accommodations and view from Kauhale Makai 506. You have a great view of the ocean from your balcony. This condo has hardwood floors, modern furniture, and all the little extras that will make your stay extra special. ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
When you stay at Kauhale Makai 535, you'll see firsthand why Kihei was once so popular with Hawaiian royalty! This 2 bedroom, 2 bathroom Maui retreat can accomodate up to 4 guests making it perfect for any island escape!
Sleek and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Newly renovated one-bedroom Ocean View Condo. Enjoy ocean and mountain views from the comfort of this gorgeous unit. The furnishings are a beautiful mixture of rattan and the bright pillows and upholstery create a lively atmosphere. The flooring...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Completely Renovated and remodeled into the perfect modern beach style condo. Completed in May 2016, this trendy beach haven is the perfect getaway. Enjoy Ocean Views from this ground floor condo located next to the pool and center courtyard. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Enjoy a stunning view of the Pacific Ocean and the West Maui Mountains from this two (2) bedroom Condo. This unit has a queen bed in the master bedroom, two twin beds in the second bedroom and a pull-out sofa bed in the living room, allowing ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Oceanfront property with beautiful beaches and outdoor activities just yards from your front door. #102 at Kauhale Makai is the perfect spot for a couple visiting Maui. This adorable studio has everything you need for a comfortable stay on one ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy Ocean Views from this one bedroom Condo. The bedroom has a queen bed and there is a pull-out sofa bed in the living room, allowing this unit to accommodate up to four (4) people. The fully equipped kitchen is perfect for making meals to ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy Ocean Views from this one bedroom Condo. The bedroom has a queen bed and the living room has a sofa bed, allowing the unit to accommodate up to four (4) people. The living room features a new flat-screen TV and has a mixture of rattan ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KIHEI
