While crews were working on a water main project on July 21, an unmarked main was hit on the Newaygo side of Hesperia. Now, the boil water advisory is over.