select * from products where cregion='Klein Karoo' and cprice between 10 and 50 and cstock>1
Klein Karoo South Africian Wine region
Browse Wines by Region
South Africa : Klein Karoo
Klein Karoo is a large, long region that extends eastward, paralleling the southern coast of the Cape, some distance inland. These warmer interior valleys get far less rain, and the hot daytime temperatures are best suited for the dessert and fortified spectrum of wines. Chenin Blanc is also grown here with some success.
