554 State Route 49, Cleveland, NY 13042

Local realty services provided by:HUNT Real Estate ERA
554 State Route 49,Cleveland, NY 13042
$509,900
  • 6 Beds
  • 5 Baths
  • 3,890 sq. ft.
  • Single family
  • Active
Listed by: thomas tarry jr, jodi tarry
Office: move real estate
MLS#:S1687685
Source:NY_GENRIS

Price summary

  • Price:$509,900
  • Price per sq. ft.:$131.08

About this home

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...

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:1845
  • Listing ID #:S1687685
  • Added:1 day(s) ago
  • Updated:June 06, 2026 at 02:42 PM

Rooms and interior

  • Bedrooms:6
  • Total bathrooms:5
  • Full bathrooms:4
  • Half bathrooms:1
  • Rooms Total:14
  • Flooring:Carpet, Ceramic Tile, Hardwood, Varies
  • Dining Description:Separate Formal Dining Room
  • Kitchen Description:Dishwasher, Kitchen Island, Microwave, Refrigerator
  • Basement:Yes
  • Basement Description:Full
  • Living area:3,890 sq. ft.

Heating and cooling

  • Heating:Forced Air, Propane

Structure and exterior

  • Roof:Asphalt, Shingle
  • Year built:1845
  • Building area:3,890 sq. ft.
  • Lot area:2.11 Acres
  • Lot Features:Rectangular, Wooded
  • Architectural Style:Two Story
  • Construction Materials:Vinyl Siding
  • Exterior Features:Deck, Dock, Open, Porch
  • Foundation Description:Block
  • Levels:2 Stories

Utilities

  • Water:Connected, Public, Water Connected
  • Sewer:Septic Tank

Finances and disclosures

  • Price:$509,900
  • Price per sq. ft.:$131.08
  • Tax amount:$11,406

Features and amenities

  • Appliances:Dishwasher, Microwave, Refrigerator
  • Laundry features:Main Level
  • Amenities:Deck, Dock

Parking

  • Parking description:No Garage, Shared Driveway
  • Garage:Yes
  • Garage spaces:1