The cheapest house I've seen in Boulder has been around $450K. If you want a condo or town home in Boulder, you're looking at about $270K and that's probably going to be on the out skirts of town and built in the early 90s.
There's also permanently affordable housing. They are subsidized properties that you have to qualify to purchase, but you can't re-sell them for more than you bought them for. I've always made too much money to qualify, even right out of undergrad with a BS.
However, like all programs like this that are a stupid fucking band-aid for NIMBY assholes interfering with the free market, they are neverr enough. It's an incredibly long line of people trying to get each home, and might as well be a lottery. These programs don't help the people they claim to. They are nothing more than ways for rich hippies to feel a little better after they vote for policies that set de-facto financial segregation firmly into place.
People aren't buying houses to flip in six months, they are buying them to hold onto long-term. It's pretty clear that public policy isn't going to shift towards affordable housing any time soon. So the only options are: continue to pay high rents and wait for people to lose their jobs/homes so they can be bought cheaper, or buy now and hope you don't become one of the former.
If we start seeing houses sold multiple times in the same year, or people starting buying homes that they clearly can't afford, then we have a problem. But I don't see evidence that is where the US is. The housing shortage is ensuring that only those top earners are competing. Price are driven up by the fact that the top 20% of buyers can afford to outspend the bottom 80% on housing by a factor of 5 or more.
An additional $500/mo can cover another 100k for a 30 year mortgage. A couple making around $10k/mo after taxes can spend $5k/mo on a mortgage and still live comfortably while a median income couple earning maybe $4k/mo can only spend $2k/mo before things get tight. So, the high income couple can easily afford a million dollar mortgage, but could stretch that to $1.2MM if they really had to while the median earner can only spend $400k MAX.
Check out Gunbarrel, it's about 7 minutes away from Boulder and is still somewhat reasonable. Although my SO bought her 30yr old condo for $165K in the Fall of 2014 and Zillow is now saying 302K, LOL.
Boulder itself has ALWAYS been expensive (even when I was in college in the early 90s) for housing. If you're serious about relocating, look at some less insane, but very close communities that the majority of the "Boulderites" live in:
NORTH: - Longmont - Gunbarrel
EAST: - Louisville - Lafayette - Erie
SOUTHEAST-ish: - Broomfield - Westminster - Northglenn - Thornton
You can have a "reasonable" commute, and a less insane house price in those areas. They are all bedroom communities for the area... Personally, I lived in Louisville and Lafayette at least half of my time in the county (the other in Boulder proper, renting, always).
There are always options.