select wein.*, region.name, weingut.id_region, weingut.name, rebsorte.name, qualitaet.name from wein left join weingut on wein.id_weingut=weingut.id left join region on weingut.id_region=region.id left join rebsorte on wein.grape=rebsorte.id left join qualitaet on wein.quality=qualitaet.id where wein.id=47;
The following text is optimized for Searchengines.
Please goto http://www.vinum-x-tellus.ie/ for further information.
Fine Wines from the regions - wine and Travel
This Site contain Information about
Italien Wines such as Riesling just as Chardonnay as well as Mittelrhein such as Wineregions just as Weisswein such as Wine+Holiday just like Vinum-X-Tellus and Mosel just like Lemberger such as Muskateller as well as Germany also Organic Wines and wine and sport as well as Spanish Wines and Terroir as well as St Laurent and Rosewine also Pinot Noir such as Sued Tirol just as Terroir just like Kerner such as Sachsen also Golfholidays such as Gutedel as well as Saar such as Vineyard just as Main just like Wine Presentations such as Spaetlese just like Spaetburgunder also Sweet Wines such as Barriquewine just as Portuguese Wines also Dry Wines as well as Gewuerztraminer just as Alsace such as wine and holiday just as Weihnachtsmarkt also Silvaner such as Grauburgunder as well as Grosses Gewaechs just like Whitewine and Wuerttemberg just as Trollinger just like On-Line Wineshop such as Holidays as well as winery just like Slow Food also Winzer and wine and travel just as Badische Bergstrasse just as Scheurebe also Rheinhessen such as Redwine and Elbe as well as wine also Cuvèe also Elbling and Pfalz and Austrian Wines as well as South African Wines just like Winzersekt just like Schwarzriesling and Christmas Markets as well as Rhein just as Eiswein as well as Mixed Cases also Auslese such as Qualitaetswein such as Dornfelder as well as Wine Tastings also German Wines also Bodensee also Mueller-Thurgau and Pinot Gris such as Rosèwein as well as Veneto as well as Traminer just like Weingut just like Franken just like Pinot Blanc such as Deutsche Weinstrasse and Wachau and Amarone just as Saale-Unstruht as well as Ahr also Wineshop such as Desert Wines and Winepresents and Baden and Nahe and Gruener Veltiner just as Deutscher Wein as well as Huxelrebe as well as Rotwein just as Sparkling Wine as well as Portugieser just as Kabinettwein as well as Ruwer also Neckar just like Beerenauslese just like Weissburgunder just like Semi-Dry Wines just like Mosel-Saar-Ruwer just like Rheingau as well as Baccus as well as Saale also Valpolicella also other wines
Schönhell is a southfacing steep site with deep loamy soil. The old, deep rooting wines produce specially in dry years wines of excellent quality, long lasting with a superior manifold of fruityness
Estate:
Weingut Fuerst Loewenstein
Region:
Rheingau
Article No.:
1009002
Site:
Schoenhell
Grape Variety:
Spaetburgunder
Quality Standard:
Spaetlese
Name:
Hallgartener Schoenhell Spätlese Trocken
Vintage:
2003
Bottle size:
0,75 liter
Soil:
deep loam with excellent water reserves
Manufacturing Process:
long sedimentation, spontaneuous fermentation and finished in wooden barrels
Analysis:
Alcohol:
13,0%
Residual Sugar:
1,1g/l
Acidity:
5,3g/l
Character:
Elegant fruit with fine forest cherries and pepper