I wish I could effectively search the DY website. This came up a few years back. If I recall correctly, it was definitely not shot in Detroit. I want to say it was Lake George or Lake Champlain in New York state, but I'm not positive.

Anyone better at searching the DY archives?