Chard's most expensive streets and properties, and least, have been revealed by an analysis of sold house price data over the past five years.