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 '%Hale Kamaole%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Hale Kamaole 159 is ready for your ideal Maui beach vacation! It is a recently renovated, exceptionally clean, 1 bedroom, 1 bath condo located in beautiful Hale Kamaole with pools and tennis courts, and you're right across from Kamaole Beach ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This Modern, Maui Vacation Rental unit #176, has it all. The owner of this condo also owns unit 170, both of which have been completely remodeled from top to bottom recently. Occupancy of these units is limited to only 2 adults. Ocean & garden ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
This outstanding condo, situated in the Kihei Hale Kamaole Resort, features ocean views from every room! Watch the whales from our lanai. The two bedroom plus loft, split level unit has over 1300 square feet of living area.
Completely ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
**7 Night minimum stay required**
Ocean Views Forever – also overlooks beach. Unit just completely Upgraded and remodeled with high end materials, finishes and furniture. Master Bedroom has King Size Bed, spacious Master Bathroom and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Hale Kamaole #215 is a charming vacation retreat in the heart of South Kihei, offering a perfect blend of comfort and convenience. Situated in a beautifully maintained low-rise complex surrounded by lush tropical gardens, this one-bedroom condo ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei-recently renovated condo., 1br (very comfortable new king size bed) & flat screen TV, 1 bath, living room w Queen size sofa bed ( just updated with a new sofa sleeper mattress), flat screen TV, wireless modem & high speed Spectrum ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Good Ocean View and mountain View. Very updated condo with extra spacious kitchen cabinets. New walk-in shower with remodeled bathroom cabinets. King bed in bedroom and queen hide-a-bed in living room. Rattan bedroom furniture. Comfy furniture ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This Fabulous, Maui Vacation Rental unit #174, has it all. The owners of this condo also owns unit 176, both of which have been completely remodeled from top to bottom recently. Occupancy of these units is limited to only 2 adults. Ocean & ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Experience an upscale Maui vibe from the moment you enter this newly remodeled condo, Hale Kamaole 150, located directly across the street from one of South Kihei's best beaches, Kamaole III. With dramatic ocean views right from your private ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Beautifully updated condo with partial Ocean View! Upstairs master bedroom has island style King bed and furniture. Remodeled master bath has walk-in tiled shower, new vanity and granite top. Downstairs bedroom has island style furniture with a ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Tennis court, garden and Ocean View. This condo has a king bed in master bedroom, queen hide-a-bed in loft area. Living room has nice, comfortable, rattan furniture with an air conditioner in the living room. Downstairs bedroom has two twin ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Beautiful ground floor unit with Ocean View from lanai, close to the pool & easy access to BBQ. New wooden flooring.The unit sleeps 2 people. Unit 172’s living room area, offers comfortable couch and 2 sitting chairs, also a large flat screen ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Welcome to the highly sought after Hale Kamaole 121! This perfectly located ground floor unit offers beautiful sunsets and ocean views right from your lanai.
As you enter you are greeted by the open comfortable feel of this beautifully ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Hale Kamaole 120
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Hale Kamaole is a South Maui condominium complex located across the street ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
E Komo Mai to our beautiful remodeled one bedroom ground floor unit which is located in South Kihei at the Hale Kamaole. The Hale Kamaole is located across from the famous Kamaole Beach Park featuring excellent swimming, long sandy beaches and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Hale Kamaole #318 is a spacious 2 bedroom, 2 bath partial ocean view unit on the third floor. It boasts a fully-equipped kitchen, washer and dryer, free Wifi, and phone service with long distance calling to the US mainland and Canada. There are ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
Beautiful condo conveniently located very close to world class beaches, shops, and restaurants! Gorgeous pool and ocean views second story unit with easy elevator ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Remodeled, ocean view, ground floor 1 bedroom, 1 bathroom condo at Hale Kamaole. The location is perfect here just steps away from the pool or cross the street and end up at Kamaole III beach park, a local and tourist favorite for sunsets, ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Special rates for available dates in June !!! Hale Kamaole #170 is an elegantly renovated one bedroom, one bath, ground floor unit ideally located close to the legendary Kamaole III Beach Park. The unit is situated so you can enjoy your morning ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Come experience this beautiful beach style remodeled ground floor condo. It is located close to pool and up on the top part of the property. Luxury furnishings throughout the unit. Amazing walk in tile shower. King size bed in bedroom, and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This Maui condo rental, has two bedroom’s plus a sleeping loft featuring Ocean, garden, and pool views ! Master bedroom has king bed. Unit has flat screen TVs & Blue-ray players in both bedrooms, a large flat screen/Blu-ray player in living ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Great Ocean and Garden Views. This two bedroom unit offers king beds in both the upper and lower bedrooms which is great for couples vacationing together. The remodeled kitchen has an elongated larger kitchen area with very nice wood cabinets ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Located in the heart of South Kihei, Maui, this unit has a Fantastic Ocean/Garden View. Just
remodeled and includes new furnishings from recent 2024 upgrades. All new expanded kitchen with
preparation and dining island, all new black ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
This roomy and comfortable 1140 sq feet upper level condo has 2 bedrooms and 2 baths with a loft and can sleep 6. The unit features a king-size bed in the master bedroom, two twin beds in the downstairs bedroom, and a full-size bed in the loft. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Aloha & welcome to our Hawaiian Home, and your vacation beach haven! Newly renovated, we hope you enjoy our elegant, spacious 'beach home' - a ground floor condo, located in the beautiful Hale Kamaole resort, close to the vibrant heart of the ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
One-bedroom ground floor condo with Garden View and easy access to two pools and BBQ area. King bed in bedroom, with Murphy bed in living room - to sleep 4 people comfortably. Totally remodeled unit, new appliances, furniture and bedding ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This two bedroom condo without a loft, has a good Ocean and Garden View. Master bedroom has king bed. Down stairs bedroom has king bed. Spacious kitchen cabinets. Wood and tile floor including lanai no carpet. This condo has lots of extra ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei-Recently renovated condo., 1 br (very comfortable king size bed) & flat screen TV, 1 ba, living room w Queen size sofa bed, large flat screen TV, wireless modem & high speed internet. Ceiling fans in bedroom & living room. New A/C in ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
Chic beautifully decorated condo conveniently located very close to world class beaches, shops, and restaurants! The unit offers an ocean view from the second story ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
This meticulously updated and well maintained air conditioned 2 bedroom with loft has everything you need to relax in luxury! Conveniently located very close to world ...
- 4 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kihei
Bright, airy corner unit with breathtaking ocean views and relaxing breezes – Enjoy an early morning cup of coffee with the native birds while overlooking the lush green vegetation of the Hale Kamaole complex and the sapphire ocean beyond. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Beautiful Ocean & mountain views and just steps away from the family friendly Kamaole Beach III. This top floor condo with two bedrooms and loft, has recently been updated with new carpeting and new paint. Master bedroom has a new king bed, ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
New everything, 2014 remodel. Travertine floor from entrance to Lanai, new carpet installed in bedroom. All new appliances. Bedroom has new King bed. Living room provides queen Hide a bed and comfortable siting chairs. Bath has tub/shower ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Ocean View from the couch, mountain View from the lanai. Artistically decorated with beautiful art pieces and glass art. King bed in bedroom with a queen hide-a-bed in living room. Flat screen TVs in front room and bedroom. Kitchen and bath ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This two bedroom corner unit with loft has an Ocean View from the living room & kitchen. Additional side window provides extra light. There is a King bed located in the master bedroom, the loft is enclosed with a queen bed, and the downstairs ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Cozy One Bedroom unit with both Ocean and Garden View, overlooking tennis court, close to pool and BBQ. Well appointed living room, with couch and two lazy boys providing comfortable viewing of the very large flat screen TV - especially after a ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Begin your day with the golden sunlight of the Valley Isle emerging over Haleakala and bringing the multicolored hues of Maui to life. Whether you’re in Hawaii for an action-packed island vacation or a relaxing retreat to the Paradise in the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Ocean and Garden Views. This two bedroom with loft has been remodeled with tile installed from the entrance to the lanai. Tile walk-in shower in downstairs bathroom. Both Bathrooms’ cabinets and counter tops have been recently remodeled. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Book your Spring or Summer getaway now!
Set in beautifully landscaped Hale Kamaole complex, Unit 255 features a private lanai with beautiful ocean views across from Kamaole III beach -- named one of the top beaches in the world! The ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Hale Kamaole is just a short walk from the Kamaole Beach III, where milder tides, full facilities and a lifeguard post makes for a low stress family atmosphere. Kamaole III is one of Maui’s favorite beaches and is great for snorkeling, a ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
*5 Night Minimum stay required*
*Maximum of 4 guest only*
Beautifully renovated, top floor condo on the cooler South side of the complex , away from the street noise and close to the upper pool, tennis court and BBQ area. Our condo ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Beautiful wood flooring through entire condo, tropical decor. Good Ocean View. Features large flat screen TV in living room, flat screen in bedroom. There is a king bed in the bedroom and a pull down queen Murphy bed in the living room. It has ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This one bedroom condo has a Ocean & Garden View. Artistically decorated with beautiful tiles used in kitchen and bathroom, walk-in tile shower. Updated completely in Hawaiian style. King bed in bedroom with queen hide-a-bed in living room. ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This beautifully remodeled condominium is professionally designed and includes upgraded air conditioning in the living room (September 2019/split system), a large screen SmartTV (52"), GE Profile series appliances, quartz countertops, West Elm ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
This two bedroom condo has a good Ocean and Garden View. Master bedroom has a King bed. Down stairs bedroom has two twin extra long beds. Pull out sofa bed in living room. Spacious kitchen cabinets. Carpet in bedrooms and tile floor. New ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Spectacular ocean and pool views! This condo is a recently remodeled two bedroom with additional loft. Upscale furnishings throughout with king bed in master bedroom, king bed in downstairs bedroom and 2 twin beds in loft area. Large flat ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Fabulous Ocean and Garden View – one of the BEST views on the property. There is new furniture and a king bed in the master bedroom, the loft has new furniture and a queen bed. Downstairs, the bedroom has new furniture with a king bed. The ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
Brand New Remodeled condo conveniently located very close to world class beaches, shops, and restaurants! Absolutely gorgeous ocean view second story unit with easy ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Kihei
This one bedroom unit has a great Garden View, and is located close to the pool and office. A brand new kitchen was installed with beautiful granite countertops. Two lazy boy recliners & comfortable rattan couch with queen hide-a-bed in living ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to our Ocean inspired condo! This popular unit completed a stunning remodel in 2024 and includes all new furniture, custom pantry and kitchen cabinetry, stainless steel appliances, tile flooring, quartz countertops and matching table. ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
