Red Roof Inn Donaldsonville is located 4.3 miles off the Sunshine Bridge that takes you over the Mississippi River. .