Where is Scotland's most expensive street? The average price of houses in this road are almost £1.2m, according to a Bank of Scotland report.