I'm looking at moving to a significantly nicer [edit: than where I am now, that is], coastal region with excellent schools and within occasional-but-not-daily commute distance of two top-tier US cities, including by rail (some of you may be be able to guess the area, at this point), and the housing prices (4-bedroom with some land, even) are surprisingly affordable. Nothing like that, certainly. Houses within daily commute range of one (but not both) of those cities can be had for way under that, too, some miles away from where I'm looking, especially if you'll accept good-but-not-excellent schools.
I guess if you're somewhere insanely expensive and won't go somewhere that's not, then... you're gonna pay a lot for housing. Go figure. "Here's the 97% of the country that's not like that, just throw a dart at a US map and you'll probably hit a place with much cheaper housing"—"No, I won't, because reasons"—"Uh, OK then, kinda sounds like a choice, good luck"
The train comment makes me guess somewhere on the mid-Atlantic east coast: DC, Baltimore, Philadelphia or NYC are all fairly close together, and a train ride from NYC to DC I think is only ~3 hours