A few times my wife and I have talked about 'downsizing' and have gone looking at single or duplex condo units - I could never live in an apartment - and my biggest concern has been ' where would my music room be, relative to the people next door' ... Consequently, we've never moved ...
Dave, I feel for you in this situation, and while I don't know you personally, I think I know enough about you to have some thoughts ...
The first is: the FINGER LAKES region?!? ... admittedly,I don't know the area except that I doubt it is anything like Philly, or south/central NJ ... I think you are far more a 'metropolitan' type guy, than an upstate NY guy, no matter how beautiful it may be ...
Secondly, as wrinkles stated, you should check out the music job market ...
Thirdly, you recently stated you were excited about providing a space for musicians to do some recording or whatever in your studio - how will that play out up state?
I wish you the, best my friend ... and heed the advice of the sage John C ...