You got no answers because your questions are loaded.
You need hyperlocal help in Albany and there are probably 50 home inspectors and 700 real estate agents who work that market and are waiting to serve you.
If you are in Albany, then work your network, get some names, start interviewing and get your real estate on.
All this demographic and subjective quiz work is a waste of your time.
Get out your cash and figure things out on the ground in Albany.
And don't buy any of that river bottom land south of Radium Springs...