The guaranteed sophomore transfer offer means your stats were too weak to be admitted as a freshman. If you prove yourself at another 4 year university with a 3.0 or higher then you can transfer to Northeastern. It is not limited to Boston residents and is not offered to all rejected applicants.