I

Inspiration Vineyards & Winery
Phone: 707-237-4980
Fax: 707-237-4980
3360 Coffey Lane - Suite E
Santa Rosa, CA 95403

select left(BusinessName, 1) as FirstLetter, F.fw_wineryID, BusinessName, First, Last, WineryID, website, street, city, Abbr, zip, public_email, phone, fax from States S, fw_winery F , fw_wineryEvent FE where WineryID != '' AND FE.fw_wineryID = F.fw_wineryID and fw_eventID= 18 and F.archive <> 1 and F.ApprovedFlag = 1 and S.StateProvinceID = F.StateProvinceID order by BusinessName