David E. Cornwell
Licensed Real Estate Salesperson
REALTOR®
Walton, NY
Office: (607) 865-7000 (607) 437-8941

554 State Route 49 , Cleveland, NY 13042

New - 4 Hours Ago

50 Total Photos [Click to View All]

Property Description

Discover the possibilities with this unique waterfront estate situated on 2.11 acres along the shores of Oneida Lake. Offering three separate residential buildings, this exceptional property presents a rare opportunity for investors, vacation rental operators, multi-generational living, or those seeking a private lakeside retreat with income potential. The main residence features 4 bedrooms and 2.5 bathrooms, providing ample space for year round living or accommodating large groups. Complementing the main home are two additional guest houses, each offering 1 bedroom and 1 full bathroom, creating ideal accommodations for visitors, extended family, or short term rental guests. Enjoy direct access to Oneida Lake with 87 feet of waterfront access and a private dock, perfect for boating, fishing, kayaking, and taking in stunning lake views. The expansive grounds offer privacy, recreation space, and endless opportunities to enhance the property's appeal. This property is an outstanding Airbnb or vacation rental investment opportunity. Whether you're looking to expand your investment portfolio, create a family compound, or establish a premier lakeside getaway, this versatile property offers incredible potential. Properties with this combination of acreage, waterfront access, multiple residences, and income-producing possibilities are rarely available. Don't miss your chance to own a truly unique Oneida Lake retreat!

554 State Route 49 | MLS# S1687751

This commercial property located at 554 State Route 49 , Cleveland, NY 13042 is currently listed for sale with an asking price of $509,900. State Route 49 is located within the Central Square school district. Search Cleveland real estate on david-cornwell.timberlandproperties.com today.

Gallery

Property Features

Property Type: Commercial - Business
Basement: Full
Heating: Propane, ForcedAir
Lot Size: 2.11 Acres
Roof Type: Asphalt, Shingle
Stories: 2.0
Taxes: $11,406
Year Built: 1845

Amenities

PropaneTankLeased

Feature Descriptions

Body of Water: Oneida Lake
Flooring: Hardwood, Varies
Lot: Rectangular, RectangularLot
Lot Dimensions: 87X450
Parcel#: 352689-312-006-0002-003-000-0000
Parking: Driveway
Parking Notes: Driveway
Sewer: SepticTank
Utilities: WaterConnected
Water: Public
Water Features: BeachAccess, DockAccess, Lake

Local Schools

School District: Central Square

Demographics

Listed By / Shown By

Listing By

Agency Name: Move Real Estate
Agency Phone: 315-925-4288

Shown By

Agent Name: David E. Cornwell
Agent Phone: (607) 437-8941
Agency Title: Timberland Properties

IDX logo

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless. Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/04/2026. The listing information on this page last changed on 06/04/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 06/04/2026 1:20:33 AM EST) or Global MLS (last updated Thu 06/04/2026 1:07:23 AM EST) or New York State Alliance MLS (last updated Thu 06/04/2026 1:18:53 AM EST) or Hudson Valley Catskill Region MLS (last updated Thu 06/04/2026 12:11:27 AM EST) or OneKey MLS (last updated Thu 06/04/2026 1:17:34 AM EST). Real estate listings held by brokerage firms other than Timberland Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

All information is deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither broker(s), nor agent(s) shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless.

Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel