I'm trying to find out what colonial southern mansion was "bought" by Ben Gates in National Treasure that is shown in the closing
Scene.

Yes, I've wondered about that lovely house as well. But from what I can see in the last frames I don't think this house is in this country due to the surrounding countryside and foliage.