I'll be happy to help you with any more information that may be helpful in your decision making. nycHero1@gmail.com
That would depend on what your needs are? Will you be working in Manhattan and going away on weekends? Do you have a large family ?The Manhattan real estate prices have historically continued to increase so Manhattan real estate can be a good investment.... On the other hand if you can find a rent stabilized Manhattan apartment, they have rules about how much time you can spend somewhere else as it must be your primary residence...You might be able to find a "deal " upstate" especially through some Goverment programs but in those it usually has to be your primary residence and many NYC coops and condos don't allow pied -a terres..There are many legal, financial and tax considerations so I would definitely consult a good local attorney and accountant.
Please check back and contact me when you are ready as I would be glad to help you find something here and Upstate. (I am in the process of changing Brokers)