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

10017 S Hwy 3
Callahan, CA 96014
Kathy Hayden with California Outdoor Properties, Inc - Fort Jones, original listing - (707) 455-4444

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 53 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Once a change-out station on the Old Oregon Trail, properties with the privacy, serenity and natural beauty of the Lil Bit of Heaven Ranch don't come along often! With a cozy and comfortable, 1,606 sf home, a 160-sf cabin from the 1800's, a 2,438 sf wood barn, two garages and several other sheds and outbuildings, rustic charm can be seen all over this far northern California property. Three year-round ponds and two seasonal ponds and irrigated pasture provide a place to enjoy nature, fishing, wildlife viewing and more. There is a fenced yard, garden area, small grape arbor and a variety of both heritage and newer fruit trees, including 19 apple trees. The pasture is currently leased and runs 22 head of cattle from spring to fall. There is room for horses/mules and riding. Views in all directions including Mt. Bolivar, the Russian Wilderness and Trinity Alps, plus local hills. It's just a couple minutes to Callahan and less than 15 minutes to the small Siskiyou County town of Etna.<br /> <br /> If you love the outdoors, hiking, trout fishing, deer hunting, bicycling, horseback riding and more are locally available. It's just a half hour to the on Pacific Crest Trail and there are numerous trail heads, mountain lakes and streams close by. Snow sports are available at Mt. Shasta Ski Resort and Mt. Ashland, both easy to drive to for a day. However, you may not want to leave home at all!<br /> <br /> Make an appointment for a private tour of the Lil Bit of Heaven Ranch!<br /> <br /> Property Highlights:<br /> 3 bed, 1.5 bath, 1606 sf Farm House<br /> 160 sf Cabin from the 1800's<br /> Barn<br /> 2 Garages<br /> Greenhouse, Garden Area, Orchard & Grape Arbor<br /> Several other Outbuildings & Sheds<br /> 3 Year-Round Ponds, Canoe or Fish!<br /> Fenced Irrigated Pasture<br /> Great Views<br /> Room for Horses, Cattle or Other Livestock
MlsNumber: --
ListingId: 20241296


Listing Provided By: California Outdoor Properties, Inc - Fort Jones, original listing
Office Phone: (707) 455-4444
Agent Name: Kathy Hayden
Disclaimer: Copyright © 2024 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','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;
Real Estate Expert Photo for CHASE COVINGTON
CHASE COVINGTON
ASCIIRelevant Realtors
Call Today!: (530) 510-1212

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App