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, 20
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
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 sits on the top (sixth floor) of the unit. The complex offers two elevators and laundry ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
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 floor) of the complex. The complex offers two elevators and laundry access on each floor. Our ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha! Welcome to this beautifully renovated and redecorated 1-bedroom condo, offering all the comforts of home in the paradise of Maui. The fully remodeled condo (in 2021) features bathroom with a beautifully tiled walk-in shower and all new ...
- 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 ...
- 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
Summer Special Prices in Effect! 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 ...
- 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
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 ...
- 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
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. ...
- 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 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
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...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
