538 40 State Rt 49
Constantia, NY 13042

  • 7 beds
  • 5 baths
  • 5,350 sqft
  • ~5 acre lot
  • $140 per sqft
  • 1926 build
  • on site

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!

New York State Alliance MLS logo Listing courtesy of NYSAMLS / Michael DeRosa Exchange

Last checked: Checking… • Last updated Apr 15, 2024 •

MLS# S1519337 —

Monthly cost estimate

538 40 State Rt 49

Asking price

$749,500

Expense Monthly cost
Mortgage

$4,013

Taxes $889
Insurance $206
Utilities $318 See report
Total $5,426/mo.*
*This is an estimate

Explore the Area

Map View Options

My Commute

Never miss new listings

Be the first to know about new listings between $600,000–$900,000 in this neighborhood

* indicates a required field

We’ll never spam you or sell your details. You can unsubscribe whenever you’d like.

Walk Score®

Provided by WalkScore® Inc.

Bike Score®

Provided by WalkScore® Inc.

Air Pollution Index

Provided by ClearlyEnergy

Worst Moderate Best

Sale history

Date Event Source Price % Change
1/31/24
Listed / Active NYSAMLS $749,500
10/21/23
Listed / Active NYSAMLS

Finding records…

No additional history available

If new records are added for this property, we’ll share them here.

Want to see this home?


House For Sale

When do you want to see it?

Or Call Us 1-800-241-3327

Listing provided by broker:

Michael DeRosa

Michael DeRosa Exchange

Want a closer look?

Go see 538 40 State Rt 49

538 40 State Rt 49

Or Call Toll Free 1-800-241-3327

We guarantee that we’ll never spam you.

* indicates a required field

Yes, I would like more information from Estately. Please use and/or share my information with Estately and their designated agent to contact me about my real estate needs.
By submitting this request, I agree Estately and their designated agent may contact me by phone or text message about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Policy.

More homes

Newest listings in Constantia, NY

Similar sold homes

This house located in Constantia, NY 13042 is currently for sale for $749,500. 538 40 State Rt 49 is a 5,350 square foot house with 7 beds and 5 baths that has been on Estately for 89 days. This house is in the attendance area of Paul V Moore High School.

This site was last updated on 04/29/2024. All properties are subject to prior sale, changes, or withdrawal.

Copyright © 2024 Estately, Inc. Data displayed here has not been verified by Estately.