grar-logo
  • Buy
  • Rent
  • Commercial
  • Find a REALTOR®
    Price range
    $
    $
    Bedrooms
    Bathrooms
    Home type
    Square feet
    Lot size
    Heating
    Cooling
    Parking spots
    Garage
    Basement
    Year built
    Max HOA
    Tours
    1 home
      1 home available
      538-40 State Rt 49, Constantia, NY 13042
      Closed Nov 15, 2024
      538-40 State Rt 49, Constantia, NY 13042
      $725,000
      7beds
      4.5bath
      5,350sqft
      5.13acres
      House for Sale

      538-40 State Rt 49, Constantia, NY 13042

      Listing by: Michael DeRosa Exchange
      1 - 1 of 1 results
      © 2025 Greater Rochester Association of REALTORS®. All Rights Reserved.
      Display of MLS Data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals.
      Equal opportunity
      Membio
      grar-logo
      538-40 State Rt 49, Constantia, NY 13042
      Closed Nov 15, 2024
      $725,000
      7beds
      4full,1half bath
      5,350sqft
      5.13acres

      538-40 State Rt 49, Constantia, NY 13042

      City/Town:Constantia   Post Office: Cleveland     

      House for Sale by Michael DeRosaMichael DeRosa Exchange.

      Data checked -. Listing last updated 506 days ago.
      1. Overview
      2. Details
      3. More 

      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!

      Internet Serviceability
      Details
        Property type
      Residential
        Year built
      1926
        Heating
      Propane, Zoned, Baseboard, Forced Air, Hot Water, Steam
        Cooling
      Zoned, Central Air
        Total rooms
      19
        Garage
      Yes (3 space)
        City/Town
      Constantia
        Post Office
      Cleveland
        Parking spots
      -
      S1519337
      MLS ID
      Closed
      Status
      Nov 15, 2024
      Closed
      Levels  Levels
        Roof
      Asphalt,Shingle
        Laundry features
      In Basement, Main Level
        Fireplace
      Yes
        Pets allowed
        Architectural Style
      Cottage, Colonial, Historic Antique, Ranch
        Basement
      Full
      Interior features
      Attic, Separate Formal Dining Room, Entrance Foyer, Separate Formal Living Room, Granite Counters, Great Room, Kitchen Family Room Combo, Living Dining Room, Pantry, Natural Woodwork, Bedroom On Main Level, Convertible Bedroom, Main Level Primary, Primary Suite, Workshop
      Exterior features
      Barbecue, Concrete Driveway, Patio
      Lot features
      Appliances included
      Dryer, Dishwasher, Electric Water Heater, Free Standing Range, Microwave, Oven, Refrigerator, Washer
      Construction materials
      Vinyl Siding, Wood Siding, Copper Plumbing, Pex Plumbing
      Flooring
      Hardwood, Tile, Varies, Vinyl
      Utilities
      Water source
      Parking features
      Monthly taxes
      $889
      Yearly taxes
      $10,671
      School district
      Central Square
      Schools
      -
      Senior community
      No
      HOA
      -
      HOA Amentities
      Open Houses
      In-Person
      No upcoming in-person open houses
      Virtual
      No upcoming virtual open houses
      Contact Agent
      Listing By:
      MD
      Michael DeRosa
      Kelli Ide
      Kelli Ide
      MD
      Michael DeRosa
      NY Licensed R.E. Broker, Michael DeRosa Exchange
       
       
      Kelli Ide
      Kelli Ide
      NY Licensed Assoc. R.E. Broker, Michael DeRosa Exchange
       
       
      Location
      Take 81 North to Exit 32. Then take Route 49 East for 11 miles. Property is located in the Hamlet of Bernhards Bay.
      For Sale Nearby
      No nearby homes are For Sale Nearby.
      Recently Sold
      No nearby homes have been Recently Sold.
      538-40 State Rt 49, Constantia, NY 13042, is a 7 bedroom, 4 bathroom, 5350 sqft. Single Family Residence built in 1926. This property is currently available for sale and was listed on Greater Rochester Association of REALTORS® on 1-31-2024. The MLS# for this Single Family Residence is MLS# S1519337.
      Display of MLS Data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals.
      Copyright ©2026 Greater Rochester Association of REALTORS®