Can the wrong colour affect property value or street appeal?

It can. A fence colour that clashes with the house or surrounding properties may reduce curb appeal. Neutral, well coordinated colours tend to make a property look more attractive to buyers.