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 = 234 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 = 234 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 = 234 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;

9200 Bowen Centers Rd.
Yreka, CA 96097
Kathy Hayden with California Outdoor Properties, Inc - Fort Jones, original listing - (707) 455-4444

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3417 Square Feet
Agency: California Outdoor Properties, Inc - Fort Jones
Agency Phone: (707) 455-4444

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 100 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: Nestled below a hilltop, with a commanding view of Shasta Valley and Mt. Shasta, this lovely and spacious Siskiyou County home offers 3,417 sq.ft. of quiet country living! You'll enjoy it's beautiful northern California views from both inside and outdoors on the large decks. The kitchen includes custom cabinetry, Corian counters, a large island, double ovens, & instant hot water. There is a formal dining room, large living room and a downstairs bedroom and bath. The primary bed and bath is upstairs along with several more bedrooms and a bath. A four-car garage plus a metal RV shop and and metal carport offer extensive room for parking and storage. The landscaping is low maintenance with good clearance around the home. There is plenty of room for horses, gardening, small livestock or just space and privacy between you and the neighbors!<br /> <br /> <br /> It's just a few minutes outside the Siskiyou County seat of Yreka, population approx. 7,800 with convenient access to shopping, a small hospital, and branch of College of the Siskiyou's. It's also less than an hour to Mt. Ashland and Mt. Shasta Ski Parks for winter sports, Ashland, Oregon for entertainment and Medford, OR and it's airport. If you're looking for a beautiful custom home with land and amazing views, this is one you'll appreciate.<br /> <br /> Make an appointment for your private tour today!<br /> <br /> Property Highlights:<br /> 3,417 Sq.Ft., 5 Bedroom, 3.5 Bathroom Custom Home<br /> Two Stories, Built in 1996<br /> Office Area with Built-in Desk and Cabinetry<br /> 4 Car Attached Garage<br /> Metal RV Shop Building and Metal Carport<br /> Low Maintenance Landscaping and Large Decks to Enjoy the Views<br /> Room for Horse or Other Livestock<br /> Fenced around the House<br /> Amazing Views (Mt. Shasta, Shasta Valley, Eddy's)<br /> Siskiyou County<br /> Far Northern California
MlsNumber: --
ListingId: 20250383


Listing Provided By: California Outdoor Properties, Inc - Fort Jones, original listing
Office Phone: (707) 455-4444
Agent Name: Kathy Hayden
Disclaimer: Copyright © 2025 LandLeader. 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 = 234 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 Donna Clair Broker Owner
Donna Clair Broker Owner
ASCIIHeritage Properties
Call Today!: (530) 340-1080

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App