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 '%Maui Kamaole%') AND sleeps>=1 order by rating desc LIMIT 0, 50
LOCATION: MAUI KAMAOLE, South Kihei (Kamaole III Beach Area), Maui, Hawaii, USA
Transient Accommodation Registration ID:
Fred Coombes TA-214-745-7024-01 GE-214-745-7024-01
Mary Coombes TA-043-043-6352-01 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Beautiful updated bedroom furniture and King bed in this Ground floor one-bedroom Condo. The kitchen opens up to the dining and living areas providing an open living space. The bedroom has a king bed and a flat-screen TV. The living room has a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> KIHEI
Maui Kamaole #J-103 is a 1 bedroom, 2 bath unit on the ground floor. It has split system air conditioning in both the living room and bedroom, a fully equipped kitchen, washer and dryer, flat-screen TV, telephone service, California king bed, ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Maui Dream Place is our vacation home rental property in Maui, Hawaii. This two story condo has plenty of space for your family, plus hotel-style amenities which include access to two swimming pools, hot tubs and tennis courts. In our opinion, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Personal Touch: We stock everything you need: dish soap, laundry soap, paper towels, napkins, Kleenex, TP, garbage bags, coffee filters etc... All you need to bring is you! We provide the definition of a care free vacation, if this interests ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Condo was fully renovated, new cabinets, tile floor, granite countertops, stainless appliances and new A/Cs. The Master Bedroom boasts a California King bed, ensuite bathroom, and private courtyard. The modern kitchen is very well stocked and ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This 1050+ square foot 2BR/2BA condo is in the highly desired Maui Kamaole complex, one of the newer condo complexes with some of the largest units in South Maui. Our home is spacious with 2 large bedrooms (plus a pull-out memory foam sleeper ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to our beautiful oceanview Maui Kamaole I-103 condo. This is a large 1040 sq ft 1-bed 2-bathroom ground-floor condo. The bedroom boasts a comfortable king-sized bed, the large livingroom a queen-sized Murphy bed (no pull-out sofa). The ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
With an incredible "Aloha" OCEAN FRONT view, G-212 is a light and bright elegantly upgraded condo across the street from Kamaole Beach Park III. Maui Kamaole's sweeping green lawn and lush tropical gardens rise up from South Kihei Road on ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
Our ground floor unit is located in the Melia "M" Cluster, and is among the newest and most private buildings in the Maui Kamaole complex. We completed an extensive remodel of our condominium, including - new tile floors throughout; new tiled, ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Maui Kamaole, located in South Kihei near Wailea, is a tranquil, low-rise residential complex situated on 23 beautifully landscaped acres. There are two large swimming pools, tennis courts, Jacuzzi s, and best of all, it’s just a short 5 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Personal Touch:
We stock everything you need: dish soap, laundry soap, paper towels, napkins, Kleenex, TP, garbage bags, coffee filters etc... All you need to bring is you! We provide the definition of a care free vacation, if this ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This ocean view, two-bedroom, two-bath condominium is located near the front of Maui Kamaole and is located up one flight of stairs on the second level. Inside you will notice it is designed in the style of a townhouse with the master bedroom on...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Partial ocean view remodeled unit located in the nicest complex in Kihei. This 2 bed, 2 bath unit was renovated in 2019. The complex boasts 2 pools and 2 hot tubs and is considered one of the quietest on the island. This unit is uniquely ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Beautiful VRBO Premier Partner Designation and 5 Star Property is in the B building, across from main pool and a 5 min walk across from Kihei's favorite beach. 2 bedrooms, 2 bath, over- sized unit with many high quality, unique upgrades rarely ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
Welcome to your slice of paradise! Incredible ocean views, quiet, private and relaxing. The perfect place and location to call home during your stay in Maui.
Note: Travelers to Hawaii will no longer be required to quarantine for 10 days ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Garden Paradise at the beautiful Maui Kamaole
Don't get us wrong- the entire Maui Kamaole property is gorgeous in itself, but this condo is one to behold. It is located in a quiet corner of the property in one of the last buildings to be ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Kamaole #J-119 is a beautiful ground floor, 1 bedroom, 2 bath ocean view unit in a great location. It features a full kitchen with a microwave convection oven combo in lieu of a conventional oven. It features air conditioning throughout, an...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Between the ocean views, floods of sunlight, and adorable tropical accents you are sure to find your piece of paradise in this cozy South Maui Condo. Every room has an abundance of storage space and furnishings so you can make yourself at home. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to Maui Kamaole A112! 1040 sq.ft.
Tastefully remodeled, beautifully appointed and comfortable. Ocean views from the living room, kitchen, and second bedroom! Fully equipped, modern kitchen. The Master bedroom has a king-sized bed, ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
With its superior location at one of the top-rated resorts in Southernmost Kihei, just a block from Wailea, this 2-bedroom, 2-bath luxury condo sleeps up to six and features Tommy Bahama furnishings, two resort pools and hot tubs, two tennis ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> KIHEI
Book now through February 1, 2025 and enjoy an exclusive deal—stay 5 nights and get the 6th night free! This offer applies to all new bookings made within this period. Don’t miss out on this special promotion—plan your getaway ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Stunning ocean views from this spacious Maui retreat at the popular Maui Kamaole in South Kihei. This two-bedroom condo is amongst 14 of the largest floor plans at 1,224 square feet, and features high ceilings and lots of room to entertain. The ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Kamaole #A-203 is a front row, two bedroom, two bath unit with panoramic ocean views, and a fully equipped kitchen. Both bedrooms are equipped with A/C, ceiling fans, and televisions. The primary bedroom is a loft which features a King bed ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Mana Hale, Maui Kamaole D-112 is a totally renovated gorgeous ground floor, 1 bed 2 bath partial ocean view condo. It features a full kitchen, brand new air conditioning system, new amenities including large screen TV, Roku players, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Fourth night free! Every fourth night free! Offer good on new reservations for dates between September 20 and November 30, 2024. Discount applied on final payment. Call or email WaileaRentals for details.
Luxury on a Budget in a ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Luxury and privacy meet at Maui Kamaole K-208 in South Kihei, Hawaii. This two-story vacation condo offers tropical garden views and relaxing comfort for up to six guests with two bedrooms and two full bathrooms.
Step inside to ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Maui Kamaole #A-104 is a 1 bedroom, 2 bath wonderful ocean view unit on the ground floor. It has air conditioning in the living room and bedroom, a fully-equipped kitchen, washer and dryer, 2 flat-screen TVs, and free WIFI. There is a king bed ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
This condo is the Maui Getaway you've been dreaming of. This charming 1 Bed/2 Bath is fully equipped and has everything you need to make you feel at home. Take in the mesmerizing Maui Sunset or just put your toes in the sand right across the ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Maui Kamaole! This wonderful place Bed/2 Bath condo is the perfect location for your Maui vacation. It is conveniently located across the street from beautiful Kamole Beach Park 3 and is nearby shops and restaurants. This updated, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Discover Your Perfect Hawaiian Getaway at Maui Kamaole!
Maui Kamaole D-102 is nestled in the heart of sunny Kihei, and our exclusive vacation rental offers the perfect blend of luxury, comfort, and island charm.
This unit boasts 2 ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to your home away from home in sunny South Kihei! This spacious 2-bedroom, 2-bath condo at Maui Kamaole offers the perfect blend of comfort and Hawaiian charm.
Features:
• Fully equipped kitchen for preparing island-inspired ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Kamaole #G-101 is a 1 bedroom, 2 bath unit located on the front row of the complex on the ground floor. The great location makes access to the beach quick and convenient. Enjoy the southern facing ocean views from the large sized lanai, ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Kamaole #G-210 is a second floor 2 bedroom, 2 bathroom, ocean view unit with air conditioning throughout, a full kitchen with dishwasher, washer/dryer, TV/DVD, a telephone, and complimentary wireless Internet. Extra large floor plan with ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Maui Kamaole #A-201 is a 2 bedroom, 2 bath ocean view unit on the second floor. It has air conditioning throughout, a fully-equipped kitchen, washer and dryer, 2 flat-screen TVs, Blu-ray player, telephone, and free Wifi. There is a California ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
You’ll enjoy the best of Maui when you stay at Maui Kamaole H-101, a garden-level condo within a low-rise complex. There’s no better way to experience the natural beauty of the island than to stay in a home that opens directly onto ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Maui Kamaole #L-202 has one of the most sought after views and locations in the entire complex!!! The front of the unit features a commanding sweeping ocean view and view of west Maui in the day with beautiful tropical sunsets and twinkling ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Kamaole #J-120 is a beautiful ground floor, 1 bedroom, 2 bath ocean view unit. It features a full kitchen, air conditioning, washer / dryer, and wireless internet. There is a California king bed with a Tempur-Pedic mattress topper in the ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Kamaole #F-210 is a 2 bedroom, 2 bath unit on the second floor. It has room unit air conditioning in the living room and both bedrooms, ceiling fans, a fully-equipped kitchen, washer and dryer, 3 flat screen TVs, DVD, free wifi, and ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
This light and bright ground floor unit has beautiful ocean views. The recently updated decor has a mid-century modern vibe with vintage Hawaiian accents. One of the larger units, this condo has over 1000 square feet of living space, large ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to Maui Kamaole G-202, your luxurious top-floor two-story condo with breathtaking ocean views with newly installed Split-AC! This premium retreat is nestled in one of South Kihei's top-rated, low-density resorts, just two blocks from ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Maui Kamaole #D-109 is a 1 bedroom, 2 bath unit on the ground floor. It has room unit air conditioning in both the living room and bedroom, a fully equipped kitchen, washer and dryer, two flat-screen TVs, telephone service with long distance ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Kamaole #H-211 is a second-floor, two-bedroom, two bath unit with an ocean view, located at the front of the complex, within walking distance from Kamaole Beach Park III across the street. This unit offers air conditioning in both bedrooms ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
*ENJOY WEEKLY DISCOUNTS! A quiet and beautiful setting for a wonderful Hawaiian getaway! Our condo is one of the newest in the complex. The main room has a large vaulted ceiling and is spacious, open and filled with light. Each bedroom has ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Our bright and airy garden unit awaits you! This large, well-maintained, quietly located 1 bedroom, 2 bathroom unit is fully furnished to meet all your needs and ensure your comfort. The kitchen is well-equipped including many nonstandard ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Maui Kamaole Vacation Condo Rental. WE ARE NOT A MANAGEMENT COMPANY. RENT DIRECTLY FROM THE OWNER AND SAVE!
New King size bed, new paint and drapes.
Maui Kamaole B114 Vacation Rental is located at the front of the property, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei Maui
Check out weekly and monthly discounts to extend stay and get even lower per nightly rates. Christmas dates still available. A magical time on Maui with the return of the whales. Book now while still available!
Hawaii is a special ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Set on a grassy hilltop with expansive ocean views in beautiful South Kihei is Anthurium House at Maui Kamaole. Surrounded by lush tropical landscaping, this extra spacious (1,061 SF) 1BR/2BA ground floor condominium unit enjoys an unbeatable ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Whether you are just 1 person or a party of up to 6, this is an amazing, oceanview condo located in sunny Kihei on the south part of the island. It is a 2 bedroom, 2 bath, 2 story newly remodeled property in a family friendly, community called ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Relax in your personal piece of paradise! This spacious one-bedroom condo is located on the ground floor and has a private lanai with peaceful ocean views. This condo will accommodate two people with a queen bed in the bedroom. The fully ...
- 2 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
