I know the answer.
Me and Brad played there a couple weeks ago, I'm 90% sure that is Renaissance Golf Club in Haverhill, Mass. Its the 5th hole, and a par 5 of about 550 in length. I was down near the pond.
The tee shot is like 150 feet up from the fairway.
To be honest the course wasn't all that special. The holes on the hillside where that hole is are very cool, but the rest of the course wasn't very nice. One par 4 for example is completely cut DEEP into the side of a hill, and it doglegs around the hill with a drop-off on the right. It just made no sense to do the amount of dirt-moving they did.
The course had a lot of hype because they built it, then tore it up, re-designed it, then built it again and the project took VERY long. It's a Brian Silva design.