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;

6200 Road A23
Calpine, CA 96124

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $11,000,000
Beds: 3
Baths: 6
Status: Active
SqFt: 7388
Agency: GRAEAGLE ASSOCIATES, REALTORS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 158 acre(s)
Property Type: Farm And Agriculture
Year Built: 1991
Notes: THIS GRAND ADVENTURE and LIFESTYLE EXISTS AMONG 160 ACRES of PRISTINE OPEN GRAZING AND FOREST LANDS...THE FORSYTHE RANCH Located in the vast and open Sierra Valley... an opportunity of a Lifetime! LIVE. BREATHE. TAKE IT ALL IN. With the "Farmhouse Modern" theme....the level of design, vision, attention to detail and the consideration for the land, views and wildlife ALL combine to produce this Exceptional property. The MAIN HOUSE boasts over 5,200 square feet, including 3 bedrooms, HIS and HERS Office space, 5 1/2 bathrooms, a Workout Room, Walk-In Pantry, Laundry Room, wraparound deck and fabulous Outdoor Kitchen/Dining Space. Beautiful stone flooring throughout the lower level, Heat is constant and warm with Hydronic Steam wall units throughout, a very elaborate system that is 97% efficient (A/C too of course!). An Open Floor plan... the Great Room with open trusses, beautiful stone fireplace (propane) that opens to the spacious dining room and designer kitchen. All WOLF Appliances, Sub Zero Refrigerator, Island with Quartzite counter tops, custom cabinets, Bar Fridge, Warming Drawers, everything you would expect! Perfect size GYM includes all equipment, and a separate BATH across the hall. The outdoor kitchen is completely covered, lighting, outdoor fireplace, refrigeration, lots of space for family and friends. UPSTAIRS are two beautifully appointed bedrooms, each with their own stunning tiled bathrooms. THE MASTER SUITE/WING is beyond exceptional! Each has their own bath
MlsNumber: 20231096


Listing Provided By: GRAEAGLE ASSOCIATES, REALTORS, original listing
Name: GRAEAGLE ASSOCIATES, REALTORS
Phone: (530) 836-1234
Office Name: GRAEAGLE ASSOCIATES, REALTORS
Office Phone: (530) 836-1234
Agent Name: LEAH WEST
Disclaimer: Copyright © 2024 Plumas Association of REALTORS. 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