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, 50
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 ...
- 2 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 ...
- 2 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 ...
- 3 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 ...
- 3 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/29/25. During this time there will be noise and debris surrounding the building.
------------------------------------
Ocean and mountain...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Freshly remodeled throughout including a gourmet kitchen, Kamaole Sands 4-213 has been thoroughly updated to “second home” standards by its owners. Every guest convenience has been anticipated and addressed in this bright, open corner unit ...
- 2 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 ...
- 2 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, ...
- 2 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
Best views at Kamaole Sands! 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 with no road noise. Air conditioning ...
- 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...
- 3 bedroom
- 2 bathroom
- Sleeps 6
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 ...
- 2 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 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands unit #10301 on the third-floor: Plush new furnishings enhance the living room, with a brand new flat screen TV and a pull-out sofa couch for additional comfort. Sliding glass doors open from the living room to a fully furnished ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Kamaole Sands unit #10208 is located on the second floor: With all the space, comfort, and amenities necessary to accommodate an unforgettable Maui retreat, there is no place better than this recently remodeled one-bedroom/two-bathroom condo ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands 3-104 has some features that separate it from other condos and make it a great choice for your vacation:
1) The lanai is not only oversized and covered, but it also faces SW. This means you ALWAYS have the choice between full ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands 1-307 is a stunning second home for the new owners. This premium unit features an end unit location with stunning ocean views across the perfectly manicured lawn of Kamaole Sands.
Completely remodeled from top to bottom, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands unit #10-213 located on the second floor: This charming one-bedroom/one-bathroom partial ocean view features modern Hawaiian décor throughout the space. The open-concept layout and design were curated with style and comfort in ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to our one-bedroom condo in Kamaole Sands located in desirable Building 5, unit 307. As new owners we have just finished extensive update of our condo which includes but not limited to:
-New Split AC system in both living room and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
One bedroom, two bath, non-smoking condo has a great location in one of Kihei's best condominium complexes., has a large pool, a child’s pool, two jacuzzis, workout facilities and free WiFi .
The condo is fully furnished with ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Book with us and come to Maui to explore everything we have to offer!
Sought after building 10 third floor unit with large lanai lanai and ocean views. Constantly getting updated from the new owner with new TV's, new refrigerator, new ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This Aloha themed two-bedroom S. Kihei vacation rental located on the 4th floor has all the ingredients for a memorable stay on Maui. The sunlight and wide layout of the living room create an ideal space to sit back and enjoy the flat screen ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Kamaole Sands #2-401 is a beautifully renovated 3 bedroom, 3 bath unit on the top floor with a gorgeous tropical garden view that showcases the sparkling pool, as well as the fountain and a partial view of the ocean. It features split system A/C...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
Discover the ultimate South Maui escape at Kamaole Sands 4-411, a beautifully renovated 2-bedroom, 2-bath condo with stunning ocean views. Located in the heart of Kihei, just steps from Kamaole Beach Park, this luxurious condo blends modern ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Our Kamaole Sands condo 8-106 has everything you need for the perfect Maui vacation.
-King bed and lovely en suite bathroom in the master suite.
-King sized sleeper sofa in the living room (yes, KING!) can sleep two more.
-Full second ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands #6-101 is a 1 Bd 2 Bath unit with a great location in the complex. Central A/C throughout the condo ensures a comfortable stay. It has a full kitchen, televisions in both the living room and the bedroom, and complimentary wifi. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha!
--We also own another Maui Condos & Sunriver OR Vacation Properties, see below for VRBO #'s
We invite you to escape away from it all to our piece of paradise. Just across the street from one of the best beaches in Maui. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands #5-414 is a breathtakingly beautiful penthouse suite with a gorgeous ocean view! Our condo is located in the desirable building #5 in the heart of the richly manicured tropical oasis of Kamaole Sands located across from Kamaole ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Kamaole Sands #7-403, a spacious fourth floor (top level), 2 bedroom, 2 bath unit with a partial ocean view. Located across the street from Kamaole Beach III, Kamaole Sands #7-403 is great for fun-filled days and quiet evenings. A full ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
This third floor 818sf villa offers expansive views of our beautiful gardens and partial ocean views. Start the day with Maui coffee on the lanai and end it with dinner prepped at home. Enjoy air conditioning, WiFi, flat screens, DVD, ceiling ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
Kamaole Sands #4409: Upon entry, you will be greeted with tropical touches that will make you ready to call this 2-bedroom partial ocean view home! The cool tile flooring will guide you onto the lanai with views of the ocean in the distance. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KIHEI
Book with confidence, this nicely updated 1 bedroom, 2 bathroom (818 sq ft.) condo at Kamaole Sands. This condo is managed by PMI Maui, a local Real Estate Brokerage that specializes in vacation rentals. We are located within a mile of the ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands #7-305 is a 1 bedroom, 2 bath unit located in the inner courtyard of the complex. It has a large lanai, split system air conditioning in both the living room and bedroom, a washer and dryer, and a fully-equipped kitchen. There is a...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Condo, 1 Bedroom, 2 Baths, (Sleeps 1-4).
_______________________________________________
NO CONSTRUCTION TAKING PLACE ON BLDG 9, UNTIL 2025. Our goal is to provide a clean, relaxing and enjoyable vacation for our guests. Your vacation is ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Book with confidence, this newly remodeled 2 bedroom, 2 bathroom (1188 sq. ft) condo that is located at Kamaole Sands. This condo is managed by PMI Maui, a local Real Estate Brokerage that specializes in vacation rentals. We are located within a...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
A pipe and roofing renovation project will take place in building 4 of Kamaole Sands from July 1, 2024- October 11, 2024. There will be noise surrounding the building at this time. ...
- 1 bedroom
- 2 bathroom
- Sleeps 3
Hawaii> Kihei
This third floor, perfectly located, inner courtyard condo in Buildin #1 has a highly desirable single level floor plan. Situated at the end of the building, this unit offers increased privacy and views, with an extra window to watch the ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
