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 '%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
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
Beautiful and clean 1-bedroom vacation condo in South Kihei Maui. Kihei Kai Nani complex is directly across the street from Kamaole Beach 2. Walk to restaurants, shopping and fun beach activities. Sleeps 2-4; Cal King bed and Queen sofa bed plus
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This 1BR/1BR, 2nd floor corner/end unit features a beautiful garden view and a remodeled tropical interior. The extra windows in the living room and bedroom create openness, ventilation and light. The trade winds and the peaceful garden setting
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This beautiful OCEAN/POOL view unit is situated in the best location of the complex, where you wake up to a calm morning light from Haleakala and enjoy a sip of your favorite drinks on lanai during the gorgeous sunsets. A communal laundry
- 1 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
Enjoy South Kihei on Maui! The Kamaole beaches are pristine; the air is beautiful, and Maui will benefit from your visit.
We are proud of our carefully maintained Kihei Kai Nani condo. Consider: air conditioning, new drapes, walk-in
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Clean and sleek condo in Kihei, Hawaii on the tropical island of Maui. Ideal for two couples or a family of four, your condo comes complete with a queen sized bed, a futon in the living room, linens, towels, cookware - all the amenities you
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
This property is hotel zoned, and not being affected by the recent proposed legislation.
-Professional Photos coming mid-December-
Kihei Kai Nanai 4-121 is a sweet little taste of “Old School Hawaii”. The owners lived here for many
- 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
