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 (`propertyName` like '%Nihi Kai%') AND sleeps>=1 order by rating desc LIMIT 0, 50
OFFERING DISCOUNTS FOR:
MAY 28 TO JUNE 2 AND AUGUST 18 TO OCTOBER 23!
This large 1400 square-foot, two-bedroom, single level, beautifully furnished condo has spectacular ocean views from the front lanai, living room, master bedroom, ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
NIHI KAI 802 AT KOLOA KAI VACATION RENTALS
Ocean View Comfort and Convenience in Poipu
Welcome to Nihi Kai 802, a beautifully remodeled 2-bedroom, 2-bathroom condo offering breathtaking ocean views and a peaceful setting in Poipu. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
NIHI KAI 510 AT KOLOA KAI VACATION RENTALS
Your Garden View Escape in the Heart of Poipu
Welcome to Nihi Kai 509, a beautifully updated 2-bedroom, 2-bathroom condo in the heart of Poipu. Located within walking distance to ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> 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
Hawaii> Koloa
Help us celebrate 20 years of NKV602 by booking now to save 20% on 2025 bookings!! Prices shown reflect the discount.
Welcome back to paradise!!
This beautiful 2-bedroom 2-bath home is located at Nihi Kai Villas, one of the nicest ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
NIHI KAI 203 AT KOLOA KAI VACATION RENTALS
Polynesian-Inspired Luxury in the Heart of Poipu
Welcome to Nihi Kai 203, where the beauty of Kauai meets the comforts of modern living. This beautifully remodeled 2-bedroom, 2-bathroom ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Experience the epitome of family-friendly vacationing at Nihi Kai 806, just a stone's throw away from the pristine Poipu Beach and Brennecke's Beach. Embark on a leisurely five-minute stroll to indulge in swimming, snorkeling, and boogie ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Experience Island Paradise at Nihi Kai 507 in Poipu, Kauai!
Relax and unwind in this professionally decorated and remodeled, well-appointed, highly sought-after 2BR/2BA split-level condo. Equipped with AC in both bedrooms and all living...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
Unbeatable location, unforgettable views—welcome to your South Shore escape! This spacious 2BR/2BA condo at Nihi Kai Villas offers sweeping views of Kauai’s south coastline all the way to Ni?ihau, with breathtaking sunsets right from your ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Po'ipu
NIHI KAI 509 AT KOLOA KAI VACATION RENTALS
Your Garden View Escape in the Heart of Poipu
Welcome to Nihi Kai 509, a beautifully updated 2-bedroom, 2-bathroom condo in the heart of Poipu. Located within walking distance to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Stellar location just steps from the ocean! Have fun on the ocean view pool deck by day and watch beautiful sunsets in the evening! At Nihi Kai 601, enjoy a bright, warm, and welcoming villa within this oceanfront tropical garden resort. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Koloa
