We will be staying at the Sheraton Long Island in Hauppauge. It is the closest hotel to the Brentwood Country Club. A cab ride between the two places will cost you about $5.00. They also provide airport and/or train station pick-up.
When you make your reservation, mention that you're booking a room for Stephanie and Jeremy's wedding. You will get a room with two doubles or one king for $109 a night.
We also recommend the Holiday Inn Express in Hauppauge. Rooms cost $129 a night. This hotel offers free transportation to and from the Brentwood Country Club for groups of ten or more.