To sum up several preceding comments, I think the "trilemma" here (i.e. you can get at most two, not all three) is Cheap, Fertile, and Convenient. If you're not concerned about being close to much else in the way of civilization, there are options for low cost productive, sustainable living situations.
Here's a recent example in my region (paging Leila H. - nice secluded corner of Siskiyou!) with a modest two bed house on 40+ acres surrounded by public forest land, for $140k:
https://www.zillow.com/homedetails/10015-Eliza-Gulch-Rd-Yreka-CA-96097/15969513_zpid/
I helped a guy find a nice homestead-ready 160 acres with pasture and creeks for 100k earlier this year, same vicinity. Wildfire is a growing concern that's bringing some prices down here, but it's potentially a very manageable risk for those who know how to work with/around it, and won't be relying on bank loans.
Many rural parts of the state are struggling to retain people and economic activity right now, But if you're self-sufficient or entrepreneurial I think there's good reason to be optimistic for longer term stabilization as the next wave of sustainable/appropriate technology and lifestyle takes hold. That, and the weather's still pretty fantastic!