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, custom_url,
(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 '%Kihei Kai Nani%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Looking for the best view at Kihei Kai Nani? It is unit #206! This updated, corner penthouse boasts stunning beach and ocean views from the living room and lanai (patio). Relax to the sounds of the ocean and enjoy sunset views every night from
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani is located in the heart of South Kihei, at 2495 South Kihei Road, just a step away from some of the best beaches Maui has to offer. Its convenient location is also a walking distance to many restaurants, cafes, tourist gift shops,
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
The Kihei Kai Nani Resort is a popular, long established, South Maui vacation destination located in a fine area. Our Deluxe 1-bedroom condo has a beach and ocean view. The interior is 621 sq.ft. and the lanai is an additional 100 sq. ft. We
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani 340
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Blissful Hawaiian beach days await within a short stroll of this Kihei Kai
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
This property is hotel zoned, and not being affected by the recent proposed legislation.
LOCATION! LOCATION! LOCATION! Welcome to Kihei Kai Nani!
Kai Nani is centrally located in sunny South Kihei with easy access to famous Kamaole
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Tucked away within the quiet rearward part of this tranquil, low-rise resort and nestled in the Maui tropical greenery that sways just off the lanai, Kihei Kai Nani 238 is an elegant second floor one-bedroom condo is less than a two-minute
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Aloha from the beautiful valley isle! We are proud to share our little slice of paradise with you and your ohana. This unit is located directly across the street from Kamaole Beach park II located in KIHEI KAI NANI. There are restaurants,
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani 368 is a one-bedroom, one-bathroom condo located on the 3rd floor that offers one window A/C unit and can accommodate up to 4 guests. Please note that this condominium does not have an elevator. Enjoy the tranquil setting on your
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani 120
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Your next beach getaway awaits at this ground-floor, tropical-themed condo
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani 113
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
This little slice of Hawaiin paradise is ideally located only 200-yeards
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani 211
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Minutes from the bay, this stunning, nautical-themed condo offers a
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Hawaii Tax ID: TA-185-511-9360-01
TMK: 390200030090
This ground floor Kihei Kai Nani 169 condo is only a short walk from Kamaole white sand beach and plenty of shopping and dining just waiting for you. On site
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani 170
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Your tropical escapade awaits at this ground-floor, family-friendly condo
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Freshly remodeled unit top to bottom in a prime South Kihei location.
***Please note: This property is Hotel Zoned and NOT in danger of the possible upcoming short term rental ban.***
The layout:
Bedroom: King size bed with
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
FREE daily activities included with your stay value up to $554! Complimentary admission, every day of your stay*: Whale Watching (seasonal), Sunset Dinner Cruise, Molokini Snorkel Trip, Alpaca Farm Tour, Pineapple Farm Tour, and Tea Farm Tour.
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Welcome to your perfect Maui getaway at Kihei Kai Nani 8-363, where Aloha Chic design meets stunning sunset, sunrise and mountain views. This thoughtfully appointed 1-bedroom condo is at the back of the property, furthest from the main road,
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
