select * from products where cregion='Franken' and cprice between 10 and 50 and cstock>1
German Franken Wines
Browse Wines by Region
Germany:
Franken
This area is the longest geographically (it stretches 250 miles from the border with Franken in the north to Lake Constance (Bodensee) and Switzerland in the south). It is also the warmest and most southerly of German wine regions, and increased sunshine here lends wines a little more alcohol than in the rest of the country. Baden contains eight Bereich (wine districts). To the north of the area, Rieslings grown in granite soil are known for their charm, delicacy, and good acidity. M�ller-Thurgau, Grauburgunder (Pinot Gris, also called Rul�nder), and Weissburgunder make honeyed dry whites. Sp�tburgunder (Pinot Noir) also ripens well here, and can be made into either slightly sweet reds or well-colored, flavorful fine wines and aged in oak barrels. The village of Durbach specializes in rich Traminer from the steep vineyards overlooking the town. M�ller-Thurgau and Gutedel (Chasselas) also make surprisingly interesting wines in Baden.
