Liberalism follows money, not the other way around. The poorer, and therefore cheaper, a place is, the more right-leaning it will be in general. If you want a decent split of small town charm, affordability, and liberalism, the first place that comes to my mind is Laramie. Maybe Greeley? But it smells like cow poop.
Also, side note, don't get suckered into buying a pretty house in a bad location. Buy the location, then make the house your own. Like gardening? Even tiny back yards can have very productive gardens. Want a unique house? Learn how to nail 2x4s and file permits, and make it unique yourself. But no matter how hard you work, you can't make your house closer to useful and enjoyable amenities and people. That's why things are cheap in Kansarado - because there is nothing there that makes life appealing, other than inertia, owning a farm, or being a hardcore conservative.