A profile corner site at the end of what’s often described as the longest city street in Cork, Blarney St, is for sale.