re: Has anyone had their house be a movie set?

I have, and I've represented people negotiating location agreements. You will sustain damage. You don't want to do it for the money. Also, not all productions are equal - some have enough solvency to cover damage, some do not.

Example: Company loans a speed boat to a movie. When returned, it had holes drilled in it. The production was shut down, the accounting office closed so the marina would have lost money BUT they charged enough to be able to repair the damage.