The site, which has planning permission to build nine homes, has a guide price of £500,000 and could be worth in excess of £3 million once building is complete