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