Tom Arthur's in-laws second home was "flipped" to escape a tax on second homes the SNP government has introduced.