Rare Oneida Lake waterfront commercial and residential compound! An unparalleled business and living opportunity awaits on 2.4 manicured acres featuring dual waterfrontage, direct open-lake views, and creek frontage with an 80-ft dock and boathouse for protected boat mooring and guest arrivals. Currently operating as the popular Brew Haus, this high-visibility venue boasts on-tap beers, a full-service restaurant, expansive indoor/outdoor seating, and an outdoor stage with electricity for live bands and weekend events. The main building underwent an extensive overhaul in 2019, including a new roof, siding, windows, doors, HVAC, four bathrooms (3 half, 1 full), and a stunning gourmet commercial/residential kitchen with granite countertops, a massive center island, and three sinks. Above the venue sits a remodeled 4-bedroom residence offering private elevated deck space and breathtaking water views. The expansive grounds feature a concrete patio with pergola, outdoor bar and grill station, concrete parking lot, fenced pet areas, 100 lining trees, a restored large Quonset hut/barn, and a detached garage with workshop storage topped by a remodeled 2-bedroom apartment. Endless possibilities for an owner-operator or savvy investor seeking a premier destination on the lake! The square footage in the main building has been measured to be 6,100 square feet. Walk to the State Park, Short drive to the NYS thruway, between Utica and Syracuse, A view out every window, Sunsets don't get better!! Also listed as Commercial MLS# S1704330.
Active
$1,875,000
6266 Lakeshore Rd S, Canastota, NY 13032
6beds
6,100sqft
Single Family Residence
Built in 1900
2.4 Acres Lot
$-- Zestimate®
$307/sqft
$-- HOA
What's special
Breathtaking water viewsDirect open-lake viewsDual waterfrontagePrivate elevated deck spaceFenced pet areasOneida lake waterfront
- 7 days
- 603
- 38
Zillow last checked:
Listing updated:
Listed by:
Coldwell Banker Prime Prop. Inc. 315-762-4032,
Gretchen Loomis 315-762-4032,
Laura Loomis-Patrick 315-762-4032,
Coldwell Banker Prime Prop. Inc.
Source: NYSAMLSs,MLS#: S1704714
Originating MLS: Syracuse
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 2
- 1/2 bathrooms: 3
- Main level bathrooms: 3
Heating
- Heat Pump, Propane, Zoned, Baseboard, Forced Air
Cooling
- Heat Pump, Zoned, Central Air
Appliances
- Included: Dryer, Dishwasher, Exhaust Fan, Electric Water Heater, Gas Cooktop, Refrigerator, Range Hood, Washer
- Laundry: Main Level
Features
- Attic, Separate/Formal Dining Room, Eat-in Kitchen, Separate/Formal Living Room, Granite Counters, Great Room, Country Kitchen, Kitchen Island, Pantry, Storage, Bedroom on Main Level, Loft, Workshop
- Flooring: Hardwood, Laminate, Varies
- Basement: Crawl Space
- Number of fireplaces: 1
Interior area
- Total structure area: 6,100
- Total interior livable area: 6,100 sqft
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Detached, Garage, Storage
- Garage spaces: 4
Accessibility
- Accessibility features: Accessible Bedroom, Accessible Approach with Ramp, Accessible Doors
Features
- Levels: Two
- Stories: 2
- Exterior features: Blacktop Driveway, Concrete Driveway, Propane Tank - Leased
- On waterfront: Yes
- Waterfront features: Beach Access, Dock Access, Lake
- Body of water: Oneida Lake
- Frontage length: 500
Lot
- Size: 2.4 Acres
- Dimensions: 306 x 356
- Features: Rectangular, Rectangular Lot
Details
- Additional structures: Garage Apartment
- Parcel number: 30620026701400010230000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Two Story
- Property subtype: Single Family Residence
Materials
- Brick, Other, Stone, Vinyl Siding
- Foundation: Block
- Roof: Asphalt
Condition
- Resale
- Year built: 1900
Utilities & green energy
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Sewer Connected, Water Connected
Community & HOA
Community
- Features: Trails/Paths
Location
- Region: Canastota
Financial & listing details
- Price per square foot: $307/sqft
- Tax assessed value: $349,675
- Annual tax amount: $23,249
- Date on market: 8/26/2026
- Listing terms: Cash,Conventional
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 8/26/2026 | Listed for sale | $1,875,000$307/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Monthly payment
Climate risks
Neighborhood: 13032
Nearby schools
Schools provided by the listing agent
- Middle: Otto L Shortell Middle
- High: Oneida Senior High
- District: Oneida
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.





