As far as upscale, I would think Latham/Loudonville/North
Colonie, Bethlehem, Niskayuna, Clifton Park and maybe East Greenbush in terms of suburbs. Not sure about south of Albany that is that far out. Bethlehem is just south of Albany, but I'm thinking that you want something that is a bit more south of the area. Maybe Saugerties, a nice part of Hudson or Catskill, the Valatie/Kinderhook area and the Ravena area.