There is the school of thought that once you buy a property the strategy should be to never sell. But you can’t eat bricks.
This means that the property cannot by lived in by you or any other member of your super fund. You also can't rent it, while buying a holiday home in your SMSF and staying there is also not allowed.