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 '%Kamaole Sands%') AND sleeps>=1 order by rating desc LIMIT 0, 30
Aloha!
Quick note:
--We also own 2 other Maui Condos & Sunriver Oregon Vacation Properties, see below for VRBO #'s
We invite you to escape to our newest place in paradise. We now have something for everyone at Kamaole Sands. We...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Toast epic sunsets on the lanai of this modern 1,200sf suite with Pacific view. Tropical style rolls out with a spiral staircase to loft and master bedrooms, modern kitchen flowing into the open living area, laundry, ceiling fans, AC, WiFi, flat...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KIHEI
Gather during the day, and then retreat at night in this higher floor air-conditioned 1,036sf condo. It's all about convenience with the full kitchen for dining ease, furnished lanai, flat screen TVs, WiFi, washer/dryer, ceiling fans and DVD ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KIHEI
Kamaole Sands unit #6204: When guests enter this condo they will recognize the stylish hardwood floors that flow throughout the entire space. The open-concept layout and design were curated with style and comfort in mind so that guests will ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
This comfortable and clean condo has a king bed in the bedroom, queen sleeper sofa in the living room and 2 full baths. It will accommodate up to four people.
The condo is fully equipped with everything you need – even including beach ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
Those on the go enjoy “coming home” to this casual 884sf condo with its stylish kitchen for making meals and snacks to share on the lanai. Special touches include ceiling fans, WiFi, washer/dryer, air conditioning, flat screens, DVD and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
Casual comforts and tropical décor prevail in this air-conditioned 818sf suite with its full kitchen for meal convenience. Savor pina coladas on the lanai while mapping out tomorrow’s agenda. Amenities include a washer/dryer, ceiling fans, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
Casual island living defines this 818sf ground floor suite cooled by ceiling fans and air conditioning. Following the weekly Mai Tai party, grill fresh mahi mahi to enjoy on your lanai. Conveniences include a full kitchen, DVD, flat screens, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
After sunrise at Haleakala Crater, shop Upcountry for local produce to cook in your kitchen and share on this 818sf condo’s furnished lanai. It’s all about vacation ease with the tasteful décor, washer/dryer, flat screens, DVD, WiFi, air ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
Welcome to Kamaole Sands! Remodeled bathrooms, 1 bedroom, 2 bath, spacious 818 sq. ft. unit offers a King size bed in the bedroom and a pullout sofa bed in the living room, allowing this unit to fit 2 adults comfortably. It is equipped with a ...
- 1 bedroom
- 2 bathroom
- Sleeps 3
Hawaii> Kihei
Aloha!
Welcome to Māla Nani at Kamaole Sands. Which means "beautiful gardens"! This TOP ''A'' RATED, garden view home is in the HIGHLY DESIRED BUILDING #7 at Kamaole Sands.
Kamaole Sands is one of the most popular resorts in all ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Completely remodeled, luxury condo in Kihei, Maui. 2 bedroom, 2 bathroom, third floor, end unit in Building 10 of Kamaole Sands. Kamaole Sands is directly across the road from Kamaole III Beach Park and Building 10 is closest to the beach. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands has acres of luxuriant tropical gardens and private spots for picnics by the fountain pond. Stroll along golden sand beaches and enjoy an ocean full of water sports including snorkeling! Shopping and restaurants are just minutes ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei, Maui
This beautiful, large two bedroom, two bath townhouse type unit is decorated in light, airy island decor. The living room has a cathedral ceiling with a circular oak staircase to the second floor master bedroom and bath. Interior amenities ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
New Split Air-conditioning System in all rooms! Welcome to our 2BR/2BA corner unit with partial Ocean View located at the Kamaole Sands in South Kihei. Just steps away from Kamaole Beach park and close to shopping, dinning and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Kamaole Sands 2-206 is set back from the road, making it quiet and private with a spacious open feel. It comfortably sleeps up to four guests. This spacious condo is 818 square feet, with beautiful tile plank flooring throughout.
Unlike ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
A Pipe & Roofing Renovation will take place in Building 10 of Kamaole Sands from 9/8/25 to 12/8/25. During this time there will be noise and debris surrounding the building.
------------------------------------
Ocean and mountain ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
A Pipe & Roofing Renovation will take place in Building 4 of Kamaole Sands from 7/1/24 to 9/27/24. During this time there will be noise and debris surrounding the building.
------------------------------------
Freshly remodeled ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands unit 6-302 was fully remodeled in September 2019, this bright one bedroom, two full bathroom retreat awaits you. Enjoy views of the Pacific from your third story lanai, freshly prepared meals in your fully stocked kitchen and a ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Desirable Kamaole Sands condo - across the street from Kam III beach. Great walkability – restaurants, groceries and amenities nearby. The home has been recently updated and refurnished to make for an enjoyable stay – new mini-split a/c, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands #4-308 is a third floor one bedroom two bath unit with a lovely partial ocean view from the spacious lanai. This spacious unit provides split system air-conditioning in both the living room and the bedroom, as well as a ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands ground floor gem located in inner courtyard (building 7) steps from several great South Kihei Beaches with beautiful views. Lanai opens to immaculately manicured lawn and grounds. Close to BBQs, and pool area (large pool, kids ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
“Kam III” is the most popular beach on Maui’s Kihei coast, whether it’s for activities like snorkeling, swimming, and boogie boarding, or witnessing Hawaii’s most spectacular sunsets.
This condo lies just across the street from ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Offered first time in 17 years for vacation rental! Ground Floor Stunning Ocean View Remodeled/Furnished, 2/2 from the Best location in Building 10! Unobstructed views from the Living room, Master bedroom (spectacular) and kitchen. Air ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
Kamaole Sands #6-106 is a 1 Bd 2 Bath unit with a great location in the complex. It is beautifully renovated (Nov 2021) and the brand new split system A/C in both the living room and bedroom ensures a comfortable stay. It has a full kitchen, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to our newly renovated beautiful seaside single-story 2 bd 2 ba condo at the highly rated Kamaole Sands, located yards away from the stunning Kamaole III beach, Maui's famed "postcard beach" that is fantastic for snorkeling, swimming and...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Condo, 1 Bedroom + Convertible bed(s), 2 Baths, (Sleeps 2-4)
Custom remodel on second floor of desirable BUILDING 3, one bedroom, two full bathrooms condominium with beautiful view from the spacious lanai. Air conditioning in both living...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Please check out my comfortable quiet (end unit, Building #5 2nd floor) 1 bedroom condo 2 baths (818 sq ft) with views of the pool, partial ocean view, remodeled kitchen and bathrooms, recently painted, new carpets and conveniently located to ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Imagine being steps away from your morning beach walk...
Imagine sunsets and people-watching from your lanai...
(blah, blah, blah...)
Seriously, while it is easy to hype up our location, we are equally committed to provide you the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Kamaole Sands 8-409
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Located in the sought-after Kamaole Sands resort community, this 2BR/2BA ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
