The consequences of a second vote would have to be a "best of three" vote then farce.
The consequences of staying in the EU are manifold the organisation is disintegrating and even if it survives on paper the strains of unregulated immigration and the political movements towards nationalism will make the object of "Ever Closer Union" and "Free Movement of Labour " will be unattainable.

Better out now while the waters are relatively calm.