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, 30
This 1 bedroom, 1 bathroom condo was just completely remodeled. The Beach is right in front of the oceanfront property. Incredible sunset views year round and just minutes away from shopping, grocery stores, restaurants and golfing.
The ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
Swimming Pool on property will be closed April 22 to May 6 2024 for refurbishment.
Welcome to our home at Kauhale Makai 612. Our home was fully and immaculately remodeled in March of 2023. Our beautiful and pristine two-bedroom condo ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Swimming Pool on property will be closed April 22 to May 6 2024 for refurbishment.
Welcome to our home at Kauhale Makai 610. Our home was updated in May of 2023. Our beautiful and pristine one-bedroom condo sits on the top (sixth ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
*Notice: Kauhale Makai Pool will be closed for maintenance starting April 22 through May 06, 2024
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...
- 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 ...
- 1 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 ...
- 2 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...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This 1 bedroom, 1 bathroom oceanfront condo on the 6th floor was just completely remodeled. The Beach is right in front of the property. Incredible sunset views year round and just minutes away from shopping, grocery stores, restaurants and ...
- 1 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
Serene, sunny, renovated AIR CONDITIONED oceanfront condo in Central Kihei , renovated oceanfront condo has all the comforts of home and all the amenities of a vacation getaway. One bedroom KING SIZE BED/1 bath condo sleeps up to 4 persons. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
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 background. Listen to the waves roll in while you drift off to a peaceful night of ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
*Notice: Kauhale Makai Pool will be closed for maintenance starting April 22 through May 06, 2024
Spacious and comfortable describe this ground floor condo with a beautiful garden view and partial ocean/mountain views. This unit, which ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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 ...
- 1 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
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
*Notice: Kauhale Makai Pool will be closed for maintenance starting April 22 through May 06, 2024
Relax on Maui in this remodeled condo at Kauhale Makai, the village by the sea. This clean and comfortable condo is a great place to relax ...
- 2 bedroom
- 2 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. Your condo is updated with hardwood floors, modern furniture, and all the little extras that will make your stay extra ...
- 1 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 a partial ocean view. It is equipped with central A/C, full kitchen, 70 inch SmartTV with expanded channels, high-speed WIFI and a safe ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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 ...
- 0 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Treat yourself to tropical living in this 2-bedroom, 2-bathroom condo with elevators. With unobstructed views of the nearby ocean, huge windows, a private balcony, and a pool, it doesn’t get any better than this!
Kauhale Makai 535 is a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
*Notice: Kauhale Makai Pool will be closed for maintenance starting April 22 through May 06, 2024
Newly renovated one-bedroom Ocean View Condo. Enjoy ocean and mountain views from the comfort of this gorgeous unit. The furnishings are a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KIHEI
*Notice: Kauhale Makai Pool will be closed for maintenance starting April 22 through May 06, 2024
Completely Renovated and remodeled into the perfect modern beach style condo. Completed in May 2016, this trendy beach haven is the perfect ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
*Notice: Kauhale Makai Pool will be closed for maintenance starting April 22 through May 06, 2024
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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
*Notice: Kauhale Makai Pool will be closed for maintenance starting February 26 through March 12, 2024.
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, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KIHEI
Notice: Kauhale Makai Pool will be closed for maintenance starting April 22 through May 06, 2024
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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KIHEI
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 looking at whales and boats and the mountains crossing the west Maui mountains ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
