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 '%Kihei Kai Nani%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Aloha,
We have some of the best beaches in the heart of Kihei, a 60x30 pool, BBQ areas, shuffleboard, and Free Parking.
We take pride in maintaining a clean, comfortable, yet affordable, accessible ground floor unit 6-150 condo at ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kihei
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
The Kihei Kai Nani complex sits on 5.19 acres. This owner's condo unit 262, is one of the most desirable locations in southern Kihei. The condo is nicely updated with new wood flooring in the living area, fresh paint on the walls and a new ...
- 1 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 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
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
Enjoy our Kihei Kai Nani condo and its amenities. Our first-floor, air-conditioned condo is only steps away from the famous Kamaole 2 Beach, right across the street! The washer and dryer save guests the inconvenience and expense of using the ...
- 2 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
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
