Duanesburg is a great, small community just 35 minutes West of Albany. Routes 20, 30 and 7 all run through it as well as easy access to route 88 in which you can pick up the throughway. It is a three hour drive to NYC but I do know that there are train routes in Schenectady (40 min ) that you might be able to pick up if you want.
Duanesburg also has a great school system , a community center with pool, several churches, friendly people , a Hannaford grocery store and many other perks with small town living.
Check out the Duanesburg/Delanson web page.