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 = 186 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 = 186 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 = 186 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;

6237 Cohasset Road
Chico, CA 95973
Holly Hack with NextHome North Valley Realty, original listing - (530) 717-0579

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: --
Baths: --
Status: Active
SqFt: 4334 Square Feet
Agency: NextHome North Valley Realty
Agency Phone: (530) 717-0579

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential Multi Family-Other
Year Built: 2003
Notes: ODYSSEY ESTATES is a BREATHTAKING 7-acre gated and fenced property, meticulously designed to leave a lasting impression from the moment you enter. A striking concrete fountain greets you at the entrance, setting a sophisticated tone for the entire estate. Currently operating as a versatile event venue and winery, this unique property offers limitless possibilities for its future owner, whether you're envisioning grand weddings, intimate private parties, or large public events—ODYSSEY ESTATES is the perfect backdrop for them all. The estate is home to 18 rows of thriving Cabernet Sauvignon grapes, providing the potential for a variety of ventures. Whether you dream of producing your own wine, crafting artisanal grape juice, or creating unique products like grape popsicles or jam, the vineyard offers endless creative opportunities. Alternatively, ODYSSEY ESTATES could be transformed into a private family compound, with the expansive event parking area offering the perfect space to build your dream workshop or additional structures. This captivating estate boasts over 4,300 square feet of retail and entertainment space, making it an ideal investment for those seeking a multi-functional venue. Additionally, the estate features a stunning 2,800-square-foot event room, designed to host large gatherings, from weddings and private parties to corporate events. The high ceilings throughout both spaces create an open, grand atmosphere, enhancing the estate's charm and appeal. A beautifully designed balcony overlooks the main entryway, adding an elegant touch to the venue, while providing a picturesque setting for guests. One of the estate’s most charming features is its established pumpkin venue, which draws in crowds during the vibrant month of October. The property also includes a delightful 2-bedroom, 2-bath living quarters that offers flexible living options. Whether you choose to live there, use it as a short-term stay, house staff or caretakers, or offer it as a long-term rental, this space adds significant versatility to the estate. For those moments of relaxation, Odyssey Estates features a serene pond surrounded by comfortable lounge chairs. Here, you can unwind while listening to the gentle croaking of frogs, enhancing the tranquil and peaceful ambiance that defines this extraordinary property. With its impressive design and array of features, ODYSSEY ESTATES is a rare find, offering endless potential for both personal enjoyment and business ventures!!!
MlsNumber: --
ListingId: SN24188773


Listing Provided By: NextHome North Valley Realty, original listing
Phone: (530) 209-3782
Office Phone: (530) 717-0579
Agent Name: Holly Hack
Disclaimer: Copyright © 2024 NextHome, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 186 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;
Real Estate Expert Photo for Brian Voigt
Brian Voigt
ASCIIRemax
Call Today!: (530) 514-2901

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App