For prospective buyers, it looked like a golden opportunity to settle in one of Scotland's most desirable spots where all but those with the deepest pockets are usually priced out of the market.