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, 20
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
With Kamaole Beach Park a short walk away and a 60’ swimming pool right in your community, Kihei Kai Nani 6-349 is an ideal vacation headquarters in Kihei, Maui. Park your car in the community’s free parking area, and walk up the stairs to ...
- 1 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
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
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
Kihei Kai Nani Bldg 9, #373 is a nicely-updated 1 bedroom, 1 bath unit on the third floor. It has a garden view, partial A/C (living room only), a fully-equipped kitchen, two Smart TVs, free wifi, and all new furniture. There is a queen bed and ...
- 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
Kihei Kai Nani #4-221 is a 2nd floor, 1 bedroom 1 bath unit with a fully equipped kitchen, washer & dryer, cable TV/DVD and free Wi-Fi. Phone service is included with long distance calling to the US mainland and Canada. It has a brand new, quiet...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani #3-116 is a beautiful ground floor, 1 bedroom / 1 bath, unit with a tropical garden view. The unit is equipped with a full kitchen, A.C. in the living room, ceiling fans throughout, cable TV/DVD, and complimentary Wi-Fi. Kihei Kai...
- 1 bedroom
- 1 bathroom
- Sleeps 2
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
Kihei Kai Nani #12-337 is an updated 1 bedroom, 1 bath unit on the 3rd floor. Enjoy outdoor living with a private 1500 sq ft. private balcony! It has a fully-equipped kitchen, window A/C in both the living room and bedroom, 2 flat-screen TVs, a...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Kihei Kai Nani Bldg 12, #136 is a 1 bedroom, 1 bath unit on the ground floor. It has a garden view, partial a/c in the living room only, a fully-equipped kitchen, 2 flat-screen TVs, a DVD player, free wifi, and telephone with free long distance ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Enjoy South Kihei on Maui! The Kamaole beaches are pristine; the air is beautiful, and Maui will benefit from your visit.
This fall we are offering special pricing for our carefully maintained Kihei Kai Nani condo. Consider: air ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Rates are for 2 persons with a $10/night/person for a 3rd or 4th person. Everything you will need to make your stay enjoyable is provided in this one-bedroom, ground-level condominium in Kihei Kai Nani in sunny Kihei on the island of Maui. The ...
- 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
Same day bookings (meaning arrival is within 24 hours of making the reservation) requires a phone call to Rentals Maui for confirmation.
Kihei Kai Nani #11-343 is a 1 bedroom, 1 bath unit on the 3rd floor. It has a fully-equipped kitchen, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
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
Beautiful newly renovated condo steps from the beach. There are restaurants, Cafe's, shop's and a market within walking distance. We have a gated pool and a coin laundry on site. Parking is not assigned and there is security....
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
