The Fairfield Inn and Holiday Inn Express are both very close, convenient and nice (but pricey).

FAIRFIELD INN E GREENBUSH (Marriott)
124 TROY RD
East Greenbush, NY 12061
Telephone: 518-477-7984
Price: $99 - $109
Includes: Pool and Breakfast


Holiday Inn Express Hotel & Suites East Greenbush
8 Empire Drive
RENSSELAER, NY UNITED STATES 12144
Toll-Free: 1-800-465-4329
Tel: 1-518-286-1011
Price: $99 - $109
Includes: Pool and Breakfast


The Econo Lodge cheaper.  It is a little further away (not much) and is in a more rural setting.

ECONO LODGE CASTLETON-ON-HUDSON
1666 COLUMBIA TURNPIKE
Castleton On Hudson, NY 12066
Telephone: 518-477-2606
Price:  $75


Please Check Travelocity for the best price, directions and details.  Search under "Sand Lake."