No, that's not how .NET works. In .NET, you can specify the @ character in front of a string literal to make it a verbatim string literal. So for example:
@"C:\windows\temp"
Will contain the path to the temporary directory, without the "\T" being converted to a tab. But the content of a variable will always be used verbatim, so a site property should never have this problem.