Extension allows you to lock tabs based on address. If you lock a website you'll be asked for prompt on close.
Update: Added deadlock feature, allows you to have your tabs reopened even if you close them after warning. Selecting this option is not recommended. Deadlock can be found in Lock it extension options.