The waterfront property is in a highly sought-after area of the Fife town.