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 (`propertyName` like '%Nihi Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 15
One of the best locations in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over 300 yards to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. The plantation style ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
One of the best locations in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over 300 yards to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. The plantation style ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
HI> Koloa
One of the best locations in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over 300 yards to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. The plantation style ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
Enjoy one of the the most convenient locations in Poipu with this newly remodeled condo at Nihi Kai! Nestled in the hill leading to Poipu Crater, this property is situated high up on the hill enough to have amazing ocean views and sunsets from...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
One of the best locations in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over 300 yards to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. The plantation style ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
HI> Koloa
The absolute best location on Kauai with views of South Coastline to Ni?ihau and unforgettable sunsets! This spacious, fully furnished 2BR/2BA apartment located on the majestic South Shore of Kauai is just steps from to shopping, dining and ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
One of the best locations in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over 300 yards to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. The plantation style ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
FULL AIR CONDITIONING.....Want more than just a ceiling fan or air conditioning in one room only? We have you covered with FULL AC throughout.
My goal is to provide you with the fastest response times and the best service. We're always ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
HI> Koloa
One of the best locations in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over 300 yards to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. The plantation style ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
An ideal location in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over five minute walk to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. Unit 403 is just over 300 ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
Affordable Luxury Awaits You on Kauai in Poipu
Lovely décor and amenities await you. Both bathrooms completely remodeled and AC now installed.
This 2-story, garden view, non-smoking condominium has over 1500 sq. ft., including the 4 lanais. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
Welcome back to paradise!!
This beautiful 2-bedroom 2-bath home is located at Nihi Kai Villas, one of the nicest resorts on Kauai's south shore. Beautifully decorated, immaculately maintained, and offering one of the loveliest garden views at ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
One of the best locations in sunny Poipu Beach Kauai, Nihi Kai Villas Resort is just steps away from the Poipu shoreline and a little over 300 yards to world-famous body surfing Brennecke’s Beach and Poipu Beach Park. The plantation style ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
PLEASE NOTE: The Nihi Kai Villas will be under going construction with each building having the roof replaced. Our building will be closed August 30th through October 29th, 2021. Please submit your dates for details of construction during your ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
TOTAL split system AIR CONDITIONING
Nihi Kai Villas are located in a quiet residential area of sunny Poipu. This resort area has the absolute best weather on the island. Winter features sunny days, while other parts of the island can be ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
HI> Koloa
