LGBTQ couple leaving Florida for Massachusetts

Hello! My wife and I (lesbian couple) are looking to relocate to MA from FL and have a seemingly impossible wish list. We visited West Hartford in CT and LOVED it, but we're considering MA as well since we have some family in the Boston area. I know it's unrealistic to find everything on this list, but if we can get at least SOME that would be great:

• Walkable (sidewalks, a downtown area, etc)
• Within an hour of Boston (we both work remotely but you never know these days...)
• Good schools
• Semi-affordable (a house for under $550k)
• Extremely LGBTQ friendly (I know most of MA is, luckily) :)

My wife and I have both lived in cold climates so we know what to expect weather-wise.

Thank you in advance, and be nice to me please!