If you have a job that requires you to be physically present at a location, then that simplifies the search process: You should live within a 15 minute drive or 30 minute bike ride from that location. Simply cruise the neighborhood and use zillow/realtor.com to get a feel for prices. Go on evening walks in eligible areas. Occasionally, you'll be among the first people to see a for sale by owner sign go up.
Also, go to estate sales and ask for the contact info of the executor if you like the house. Landlords putting houses up for rent will usually entertain offers, especially if it might mean avoiding realtor commissions or a couple of empty months.
Talk to someone about getting a construction loan. This will open up opportunities for "project" houses that might be otherwise great but can't qualify for regular loans because of their present condition.
No house is perfect, and if it was it would cost millions of dollars and be imperfect for that reason. So don't let the perfect be the enemy of the good. You'll settle on something that is good enough one way or another.
Keep in mind, it's perfectly fine to just say no to homeownership in MCOL/HCOL areas. Renting usually makes more financial sense. Do not make this a quest that you think your whole happiness in life depends upon. There are lots of ways to live. If rates keep rising, housing prices might crash anyway, and then won't you be glad not to have bought?
"Good schools" are a factor of living amongst wealthy people. Whether your kid or prospective kid is a "good student" will depend almost completely upon whether you read to them regularly starting from when they are babies, apply scientific reasoning and skepticism in your personal life, avoid the temptations to become absentee, keep them away from screens, etc. I still remember high school when friends of mine whose parents earned 3x what my parents earned and lived in the "good" elementary district were huffing spray paint. Their parents were absentee, let the TV be the babysitter, or never spent enough time with them to instill common sense and skepticism. So spending money does not necessarily fix parenting problems.
Also, if home prices in CO do not make sense, consider NW Arkansas or SE Missouri. The Ozarks have plenty of hiking opportunities, plenty of water, no real wildfire risk, no earthquake risk, a fast growing low-unemployment economy, affordable universities, and more. $200k will buy you a nice place there, and you can engineer a very high savings rate.