select * from (Select a.`postalCode`,a.`uniturl`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `region`, `source`, `property_type`, `location_type`, `suitability`, `features`, `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) 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, 15
This spacious Wailea condo was recently remodeled (aug 2020) and is ready for you to enjoy on your next Hawaiian vacation!
The deluxe unit features new appliances and furniture. In this deluxe condo, you will find a King sized bed and two ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
HI> Kihei
Beautiful Kama'ole Beach 2, has excellent snorkeling, boogie boarding, or just bathing in the sun. The beach has lifeguards and restrooms. Picnic tables and BBQ's on the grassy area of the beach. A beautiful scenic coastal trail near by for ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
HI> Kihei
Aloha,
This beautiful condo has recently received a complete renovation. It is a perfect location for your stay here in Maui. One of the best beaches is just across the street and several restaurants and shopping are just steps away as well.
...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei
Property Description
In the heart of Kihei, you have some of the best beaches, a pool, BBQ areas, and Free Parking.
Aloha! We take pride in maintaining a clean, comfortable yet affordable priced, accessible access ground floor building 6-150 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
This remodeled 1BR/1BA Garden View Unit in South Kihei will provide you with a great accommodation at an affordable price. Located directly across from one of the most desirable beaches, Kamaole II Beach, you will find your private and peaceful ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Beautiful garden and partial ocean view upgraded condo. Clean, comfortable and plenty of natural light.
We are taking extra care to disinfect frequently touched surfaces between reservations.
Garden and partial ocean view. Upgraded condo ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> 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. Our unit is located in Building 8. Walk to restaurants, shopping and beach fun activities. Sleeps 2-4; ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> 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
HI> Kihei
Enjoy this meticulously maintained Kihei Kai Nani condo! Consider: air conditioning, new kitchen, walk-in shower, firm and comfortable king-size bed. Our condo is fully equipped with everything you need to enjoy a fantastic Maui vacation. The ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> 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
HI> 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 ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
HI> Kihei
Enjoy our Kihei Kai Nani condo and its amenities. Our first-floor, air-conditioned condo is only steeps away from the famous Kamaole 2 Beach, right across the street! The washer and dryer save guests the inconvenience and expense of using the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Kihei
