Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 199 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 199 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 199 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

500 Old Long Valley Road
Clearlake Oaks, CA 95423

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $8,750,000
Beds: 7
Baths: Full: 6, ½: 3
Status: Active
SqFt: 9300 Square Feet
Agency: Golden Gate Sotheby's International Realty
Agency Phone: (707) 255-0845

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 145 acre(s)
Property Type: Residential-Other
Year Built: 2016
Notes: This extraordinary investment opportunity in Clearlake Oaks includes a historic family-owned winery, integrated vineyard, bed & breakfast, and a lakefront restaurant, all located in the Long Valley AVA, just north of Napa Valley. Stonehouse Cellars Winery & Bed & Barrel (139 acres): A multi-award-winning winery with 13.5 acres of Cabernet Sauvignon vines, a 15,000 case/year permit, and state-of-the-art winemaking facilities. The 5,000 sq. ft. Bed & Barrel offers a scenic guest experience, while the historic Stonehouse provides additional charm. Solar energy and pre-1913 water rights enhance operational efficiency. Residential Property (5 acres): A 2,300 sq. ft. ranch house with vineyard views and a 400 sq. ft. in-law cottage, featuring a pool and garages, perfect for boosting bed & breakfast occupancy. Stein & Wein Lakefront Restaurant (1 acre): A 1,600 sq. ft. restaurant with a boat dock, outdoor patio, and event capabilities, providing a unique dining and event venue with minimal competition on the lake. The restaurant complements the winery, offering potential shuttle services and maximizing revenue. This 145-acre winery estate offers multiple revenue streams and event-hosting potential, making it a highly profitable investment in California's wine and hospitality markets.
MlsNumber: --
ListingId: 325001781


Listing Provided By: Golden Gate Sotheby's International Realty, original listing
Phone: (707) 337-6615
Office Phone: (707) 255-0845
Agent Name: Austin Aaron
Disclaimer: Copyright © 2025 Bay Area Real Estate Information Services, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App