Sharon FronkRealtor® · Howard Hanna
LoadingActive
$126,000 price cut · was $825,000
$699,000
42 Queechy Lake Drive
Canaan, NY 12029 · Columbia County
5,860Sq Ft
0.52acres lot
$119Per Sq Ft
Est. P&I $3,535/moGet pre-qualified
Commercial 45 days on market
MLS# 202622779 Updated 1 week ago
Sharon’s Take
This 5,860 square foot commercial property on Queechy Lake offers a waterfront site with dock access, positioned for restaurant or hospitality use. Architectural plans are complete for a kitchen, dining area, lounge, and second-floor office and storage space, with an outdoor deck overlooking the lake. Septic system design has received approval from the New York Department of Environmental Conservation and Columbia County Board of Health, with installation estimates prepared. The property, on 0.52 acres in Canaan, provides opportunity to serve both local residents and Hudson Valley and Berkshires visitors.
Sharon Fronk · Howard Hanna Capital Region
About this property
Imagine serving dinners lakeside or welcoming boaters to one of the docks for a refreshing lemonade!! This is the amazing opportunity that awaits one's vision in reviving the nostalgic Backwater Grill restaurant on beautiful Queechy Lake - one of the most pristine lakes in New York state. Here sits an opportunity to cater to the residents surrounding Queechy Lake or visitors to the Hudson Valley and Berkshires. Architectural drawings are in place showcasing the layout of the kitchen, dining area and lounge. A second-floor space includes additional room for storage and an office. The gem of the design, however, is the outdoor dining deck poised on the edge of the lake. Careful work has been done to design a septic system to handle the needs of the restaurant with special consideration given to the sensitivity of being on the lake. Both DEC and the Columbia County Board of Health have approved the design with estimates for installation in place. With so much of the planning work already completed, it's time to put ''hammer to nail'' and bring an all new Backwater Grill back to the anticipating public. It's also an opportunity to compliment the work and vision taking place up the road at the former Queechy Lake Motel. What a dynamic duo for Canaan and the visiting public has never been so fortunate!
Is it priced right?
The price signals we can read on this listing today. For a true sense of value against recent Canaan sales, Sharon will pull the comparable closings and walk you through them.
Price per sq ft
$119
Days on market
45
Price reduced
$126,000
from $825,000
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the compsProperty details
25 facts pulled straight from the MLS listing.
Overview
Property TypeCommercial
Sub-TypeBusiness
Days on Market45
StatusActive
MLS Number202622779
ListedJuly 28, 2026
ZoningCommercial
Interior
Living Area5,860 sq ft
Exterior & Lot
Lot Size0.52 acres
Lot Features
Road FrontageLevelWaterfront
Parking
Off StreetPartially Paved
Exterior Features
WaterfrontLake FrontLakeWaterOff StreetPartially Paved
Building & Construction
Architectural Style
Other
Sewer
Other
Water Source
Well
Financial
List Price$699,000
Price per Sq Ft$119
Assessed Value$400,000
Original List Price$825,000
Est. Monthly P&I$3,535/mo
Location
CountyColumbia
School DistrictChatham
Listing Details
Listed ByMichael Stasi of Corcoran Country Living
Data SourceSpark Platform / Global MLS
Last UpdatedSep 4, 2026
Estimated monthly payment
per mo$4,787
- Principal & Interest$3,535
- Property Tax$1,049
- Insurance$204
Loan Term
Tax estimated at the Columbia County rate. Insurance and PMI are estimates. Sharon can connect you with a lender for real numbers.
Get pre-approved →What's nearby
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Commute Planner
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
- Start42 Queechy Lake Drive, Canaan, NY 12029
Try a preset
Schools
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Chatham
Assigned school district
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
About Canaan, NY
Canaan is in Columbia County, NY. There are currently 5 active listings here, ranging from $346,500 to $1,950,000. Listings in this address fall under the Chatham school district. Priced near the area median of $699,000.
See Sharon's Canaan community guide
Sharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Corcoran Country Living · Listed by Michael Stasi (38867)
Contact: 732-241-1723
MLS #202622779 · Source: Global MLS, Inc.
IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.
