A city centre pub 'a stone's throw' from St James' Park has hit the market, being put up for sale for £550,000.