The terraced property in one of Newcastle's most desirable locations also has a garden and private rear yard