DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 235' at line 10
Koloa, United States One of Kauai's most prestigious and spacious beach front resorts, Poipu Kai Resort provides spacious, fully home equipped, carefully maintained vacation accommodations on Kauai's sunny Poipu Beach. Poipu Kai Resort features a wide range of sizes from economy studios to one, two, and three bedroom condos and homes. With seventy acres of tropical gardens, Poipu Kai is one of Kauai's most spacious, lowest density resort condo-hotels in Hawaii. Verdant lawns with winding paths connect Poipu Kai Resort's two white sand beaches; Brennecke-Poipu Beaches, and Shipwreck Beach. The Poipu Kai Resort also features six swimming pools, nine hard and soft tennis courts, jogging paths, restaurant, and hot tub spas. Concierge and other guest services are available.