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, 20
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
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
