<p>Unfortunately many SUNYs are located in out of the way locations and OP does not want rural.
Potsdam , Brockport, New Paltz, Cortland, Oneonta, Cobleskill, etc.
Geneseo and Binghamton are highly competitive for admission. Stony Brook may not meet the OP’s wish list either.</p>