select * from products where cregion='Yarra Valley' and cprice between 10 and 50 and cstock>1
Premium Australian Wine From Yarra Valley And Other Surrouding Regions Near Melborne Available On E-WineGifts.com
Yarra
Valley :
This is yet another dynamic region, with new vineyards
appearing every year, boasting excellent premium Australian wine. At only an hour's drive
from Melbourne it is the second coolest region
in the state, and quite rainy. The area is known
for its rolling hills and vineyards featuring
a variety of grapes including Chardonnay, Cabernet
Sauvignon, Riesling, Gewurztraminer and Pinot
Noir.
