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

211 Main Street
Sierra City, CA 96125

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $568,000
Beds: 5
Baths: 5
Status: Active
SqFt: 4055
Agency: REMAX Success

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12,632 sqft
Property Type: Residential
Year Built: 1935
Notes: Welcome to an enchanting property in picturesque Sierra City, located in the heart of California Gold Country. This remarkable property offers the discerning buyer a unique opportunity with 3 structures: the primary residence is a 1930s log cabin, the second home, built in 1974, features 2 bedrooms and 1 bathroom, and a third mixed use building has commercial and residential options. Situated on a large parcel with majestic trees, you can breathe in the fresh air and revel in the tranquility of the surroundings. Enjoy morning coffee or relax with a glass of wine as you soak up nature’s beauty on the expansive front deck while watching the activities of this historic and charming mountain town.<br /> Experience the timeless allure of a log cabin crafted with precision and attention to detail. The solid log walls exude a sense of strength and character, creating a cozy and welcoming atmosphere. The interior of the log cabin is spacious with vintage architectural character. The living area features a striking stone fireplace, ideal for cozy evenings during colder winter months. While maintaining its rustic charm, the cabin has a well equipped kitchen, large bathrooms and comfortable bedrooms that offer a cozy retreat after days enjoying all the mountains have to offer.<br /> Embrace a lifestyle filled with outdoor adventures and natural wonders as you explore the nearby hiking trails, boating, fishing, or swimming in cool alpine waters in the Lakes Basin. Winter sport options are spectacular, and the Pacific Crest Trail runs through town. Discover the charm of the local town and friendly community, and this beautiful property that harmoniously blends mountain character with natural surroundings. Call now to schedule a private viewing and experience the magic of this log cabin retreat. Don’t miss your chance to own a piece of nature’s paradise and create cherished memories that will last a lifetime!
MlsNumber: NS23126622


Listing Provided By: REMAX Success, original listing
Name: REMAX Success
Phone: (805) 434-2737
Office Name: RE/MAX Success
Office Phone: (805) 434-2737
Agent Name: Renee Neel
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, 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