538 40 State Rt 49
Constantia, NY 13042
- 7 beds
- 5 baths
- 5,350 sqft
- ~5 acre lot
- $135 per sqft
- 1926 build
- – on site
More homes
Welcome to Bayside Manor & Barn, a scenic lakeside estate on the north shore of Oneida Lake. Situated on 5.1 acres, w/stunning sunset & sunrise views of the lake, this sprawling estate features a main house, 2 bd carriage house, 1 bd cottage and 500 ft of lakeshore with peninsula & dock. The Manor house is an elegant 4-bd, 2.5 bath colonial, w/3100 square feet, including the finished 3rd floor space. The spacious living room with wood burning fireplace, flows directly into the tiled porch that overlooks the beautiful lake vista. From this viewpoint, enjoy some of the most beautiful sunsets & sunrises. Lake views from 3 of the 4 bedrooms, offers the perfect view to wake up to. The renovation of the barn, retains the original character w/exposed beams, wood burning stove & barn doors, while providing modern conveniences in this 1800 sq ft space, w/heated floors, modern kitchen, bathroom w/walk-in shower, & beautiful outdoor patio. The 950 sq ft, 1 bd cottage is currently rented for $900/mo. The property also contains a detached, 2-car garage. Main House & Guest House are operated as AirBnB Rentals, or enjoyed as a year-round home!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Feb 13, 2025
•
MLS# S1519337 —
The Building
-
Year Built:1926
-
Year Built Details:Existing
-
Construction Materials:VinylSiding,WoodSiding,CopperPlumbing,PexPlumbing
-
Architectural Style:Cottage,Colonial,HistoricAntique,Ranch
-
Roof:Asphalt,Shingle
-
Basement:Full
-
Basement:true
-
Foundation Details:Block
-
Exterior Features:Barbecue,ConcreteDriveway,Patio
-
Window Features:ThermalWindows
-
Patio And Porch Features:Patio
-
Building Area Total:5350.0
-
Building Area Source:PublicRecords
Interior
-
Rooms Total:19
-
Interior Features:Attic,SeparateFormalDiningRoom,EntranceFoyer,SeparateFormalLivingRoom,GraniteCounters,GreatRoom,KitchenFamilyRoomCombo,LivingDiningRoom,Pantry,NaturalWoodwork,BedroomOnMainLevel,MainLevelPrimary,PrimarySuite,Workshop
-
Flooring:Hardwood,Tile,Varies,Vinyl
-
Fireplace:true
-
Fireplaces Total:3
-
Laundry Features:InBasement,MainLevel
-
Stories:3
-
Stories Total:3
Room Dimensions
-
Living Area:5,350 Sqft
Location
-
Directions:Take 81 North to Exit 32. Then take Route 49 East for 11 miles. Property is located in the Hamlet of Bernhards Bay.
The Property
-
Property Type:Residential
-
Property Subtype:SingleFamilyResidence
-
Property Condition:Resale
-
Parcel Number:312.10-01-01
-
Lot Size Dimensions:500X300
-
Lot Size Acres:5.13
-
Lot Size Area:5.13
-
Lot Size Units:Acres
-
Frontage Length:500
-
View:true
-
View:Water
-
Waterfront:true
-
Waterfront Features:BeachAccess,DockAccess,Lake
-
Water Body Name:Oneida Lake
-
Other Structures:Barns,Outbuilding,Other
-
Road Frontage Type:MainThoroughfare
Listing Agent
- Contact info:
- Agent phone:
- (315) 406-7355
- Office phone:
- (315) 406-7355
Taxes
-
Tax Annual Amount:10671.0
-
Tax Assessed Value:272100
Beds
-
Bedrooms Total:7
-
Main Level Bedrooms:3
Baths
-
Total Baths:5
-
Full Baths:4
-
Half Baths:1
-
Main Level Baths:3
The Listing
Heating & Cooling
-
Heating:Propane,Zoned,Baseboard,ForcedAir,HotWater,Steam
-
Heating:true
-
Cooling:Zoned,CentralAir
-
Cooling:true
Utilities
-
Utilities:CableAvailable,HighSpeedInternetAvailable,WaterConnected
-
Electric:CircuitBreakers
-
Sewer:SepticTank
-
Water Source:Connected,Public
Appliances
-
Appliances:Dryer,Dishwasher,ElectricWaterHeater,FreeStandingRange,Microwave,Oven,Refrigerator,Washer
Schools
-
Elementary School District:Central Square
-
Middle Or Junior School District:Central Square
-
High School District:Central Square
The Community
-
Subdivision Name:Oneida Lake
-
Senior Community:false
Parking
-
Garage:true
-
Garage Spaces:3.0
-
Attached Garage:false
-
Parking Features:Detached,Garage,CircularDriveway,Driveway,GarageDoorOpener
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
11/15/24
Nov 15, 2024
|
Sold | NYSAMLS | $725,000 | -3.3% |
|
10/4/24
Oct 4, 2024
|
Pending | NYSAMLS | $749,400 | |
|
9/26/24
Sep 26, 2024
|
Price Changed | NYSAMLS | $749,400 | -0.0% |
