An ‘eyesore’ plot of redundant land has been described as an “exciting opportunity” for developers after hitting the market.