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, rewritten_description,
(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
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
Aloha!
Welcome to Kamaole Sands, one of Kihei's most sought-after resorts! Māla Nani at Kamaole Sands is our TOP ''A'' RATED, garden view home in the HIGHLY DESIRED BUILDING #7.
Our inviting ground floor unit is ideal for
- 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
• Split A/C units
• King bed
• Remolded 2019
• Close to swimming pool
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
- 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
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
Elevate your Maui experience at highly renowned Kamaole Sands resort condo. Lush, tropical grounds, swaying palm trees, waterfalls and ponds welcome you to your vacation oasis. Ideally located directly across from Kihei’s popular Kamaole Beach
- 3 bedroom
- 2 bathroom
- Sleeps 6
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 strive to provide an excellent service and environment for our guests, so did multiple upgrades for our condo:
July
- 1 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
Discover Kamaole Sands 4-411 - a beautifully upgraded 2-bedroom, 2-bathroom ocean-view condo in South Maui's premier resort community. Just steps from Kamaole III Beach, this spacious, top-floor unit offers the ideal combination of luxury,
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
A Pipe & Roofing Renovation will take place in Building 7 of Kamaole Sands from 5/5/25 to 8/11/25. During this time there will be noise and debris surrounding the building.
------------------------------------
Welcome to Kamaole
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to Kamaole Sands 4-407, a top-floor penthouse condo with stunning ocean views, perfect for your South Maui getaway. This spacious unit comfortably sleeps up to six guests, making it an ideal retreat for families or friends. Located in
- 3 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
- 2 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
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Enjoy a serene escape on the lanai, listening to the tropical sounds and savoring your favorite beverages. The garden view, with the distant West Maui mountains and a glimpse of the ocean, provides a calming backdrop.
The condo boasts a
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
GE/TA# 146897766401
Maui temperatures seem to keep going up so please note Kama'ole Sands 1-405 has a "three zone split air conditioning system". When the trade winds aren't blowing, you'll be glad 1-405 will be a cool place for you to
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Our well appointed two-bedroom condo has everything you need to live out your dream Maui vacation. Relax in comfort in this rare single level 1,036 square feet open floor plan. Take advantage of the great walking location. Stroll to the best
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Your island paradise awaits you and your family at this recently remodeled 3-bedroom, 3-bathroom condo located in beautiful sunny South Maui in Kihei at the KAMAOLE SANDS resort. Situated on the top floor of the satellite 4 building, unit 4-401
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kihei
Located on the third floor of highly desirable Building 5, Kamaole Sands 5-303 has been beautifully remodeled in an upscale, elegant Hawaiian tone. The unit overlooks the tropical courtyard, with great ocean views beyond.
Every amenity
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
A renovation has been approved for Unit 2-303 (three units over, one unit down from this this unit) starting May 24, 2025, and ending June 10, 2025. During this time there will be noise and debris surrounding the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Kamaole Sands 4-306 - a beautifully remodeled, third-floor condo designed for comfort, luxury, and an authentic Maui experience. This bright and airy one-bedroom retreat accommodates up to four guests and features a fully upgraded
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kamaole Sands 5-216
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Conveniently located across from Kamaole Beach III in the beautiful town
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to our Ohana, Maui Lemurian Condos. Located at Kamaole Sands resort in the heart of Kihei, our home away from home. Kamaole Sands is a beautiful, South Kihei resort, located directly across from Kamaole III Beach and easy walking
- 2 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
Come to Maui and stay in our beautiful Kamaole Sands property. This airy, open condo provides you with everything that you need for a comfortable and easy way to enjoy your Maui vacation.
The unit is in a perfect ground floor location –
- 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
Discover the Ultimate Island Escape: Exquisite Kamaole Sands Condo Steps from Maui's Pristine Beaches
Indulge in the island getaway of a lifetime in our upscale condo, nestled within the Kamaole Sands Beach Resort (Building 8) in the
- 2 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
Kamaole Sands 10-302
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Conveniently located across from Kamaole Beach III in the beautiful town
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Indulge in the ultimate Hawaiian getaway at Kamaole Sands 1-403, a spacious two-bedroom, two-bathroom haven with breathtaking ocean views from its expansive lanai. This inviting retreat boasts vaulted ceilings, three ceiling fans, and a
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Embark on a Maui retreat like no other with our newly renovated beach vacation rental, strategically located across the road from the sun-drenched shores of Kamaole Beach III.
The beach, with its pristine sand and crystal clear waves, becomes
- 1 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Join us under the sea in this 1,200-square foot two-bedroom with loft vacation condo located on the 4th floor with a central AC system. From the ocean artwork at the entryway, to the charming sea décor adorning the unit, Unit 9409 seems like
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KIHEI
