A burning red light attached to the rear of a load at night should be visible for at least:

At night, if you are hauling a load that extends more than four feet beyond the rear of the vehicle, you are required to attach a burning red light to the rearmost point of the load. The light must be visible for at least 500 feet.
DMV Writen Test