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!
Active
$509,900
554 State Route 49, Cleveland, NY 13042
6beds
3,890sqft
Single Family Residence
Built in 1845
2.11 Acres Lot
$-- Zestimate®
$131/sqft
$-- HOA
What's special
Waterfront estatePrivate dockStunning lake views
- 26 days |
- 2,610 |
- 116 |
Zillow last checked:
Listing updated:
Listed by:
Move Real Estate 315-925-4288,
Thomas Tarry JR 315-430-4894,
Jodi Tarry 315-558-3966,
Move Real Estate
Source: NYSAMLSs,MLS#: S1687685
Originating MLS: Syracuse
Originating MLS: SyracuseLoading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bathrooms: 4
- Main level bedrooms: 1
Heating
- Propane, Forced Air
Appliances
- Included: Dishwasher, Electric Oven, Electric Range, Microwave, Propane Water Heater, Refrigerator
- Laundry: Main Level
Features
- Ceiling Fan(s), Separate/Formal Dining Room, Separate/Formal Living Room, Guest Accommodations, Kitchen Island, See Remarks, Sliding Glass Door(s), In-Law Floorplan, Main Level Primary
- Flooring: Carpet, Ceramic Tile, Hardwood, Varies
- Doors: Sliding Doors
- Basement: Full
- Number of fireplaces: 2
Interior area
- Total structure area: 3,890
- Total interior livable area: 3,890 sqft
Video & virtual tour
Property
Parking
- Total spaces: 1
- Parking features: No Garage, Shared Driveway
- Garage spaces: 1
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Open, Porch
- Exterior features: Concrete Driveway, Deck, Dock, Gravel Driveway, Private Yard, See Remarks, Propane Tank - Leased
- On waterfront: Yes
- Waterfront features: Beach Access, Dock Access, Lake
- Body of water: Oneida Lake
- Frontage length: 87
Lot
- Size: 2.11 Acres
- Dimensions: 87 x 450
- Features: Rectangular, Rectangular Lot, Wooded
Details
- Parcel number: 35268931200600020030000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Two Story
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Block
- Roof: Asphalt,Shingle
Condition
- Resale
- Year built: 1845
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Connected, Public
- Utilities for property: Cable Available, High Speed Internet Available, Water Connected
Community & HOA
Community
- Subdivision: Section 13206
Location
- Region: Cleveland
Financial & listing details
- Price per square foot: $131/sqft
- Tax assessed value: $275,000
- Annual tax amount: $11,406
- Date on market: 6/4/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/4/2026 | Listed for sale | $509,900-11.9%$131/sqft |
Source:  NYSAMLSs #S1687685 Report a problem | ||
| 9/30/2024 | Listing removed | $579,000$149/sqft |
Source: NYSAMLSs #S1530729 Report a problem | ||
| 5/19/2024 | Price change | $579,000-3.3%$149/sqft |
Source: NYSAMLSs #S1530729 Report a problem | ||
| 5/3/2024 | Price change | $599,000-4.2%$154/sqft |
Source: NYSAMLSs #S1530729 Report a problem | ||
| 4/20/2024 | Listed for sale | $625,000+97.2%$161/sqft |
Source: NYSAMLSs #S1530729 Report a problem | ||
| 3/24/2021 | Listing removed | -- |
Source: Owner Report a problem | ||
| 6/26/2020 | Sold | $317,000+0.7%$81/sqft |
Source: Public Record Report a problem | ||
| 6/18/2020 | Pending sale | $314,900$81/sqft |
Source: Owner Report a problem | ||
| 1/21/2020 | Listed for sale | $314,900+2.3%$81/sqft |
Source: Owner Report a problem | ||
| 10/9/2019 | Listing removed | $307,900$79/sqft |
Source: Owner Report a problem | ||
| 8/1/2019 | Price change | $307,900-0.6%$79/sqft |
Source: Owner Report a problem | ||
| 4/19/2019 | Price change | $309,900+0.6%$80/sqft |
Source: Owner Report a problem | ||
| 1/24/2019 | Price change | $307,900-0.6%$79/sqft |
Source: Owner Report a problem | ||
| 10/12/2018 | Price change | $309,900-1.6%$80/sqft |
Source: Coldwell Banker Prime Properties #S1126492 Report a problem | ||
| 9/4/2018 | Price change | $314,900-1.6%$81/sqft |
Source: Coldwell Banker Prime Properties #S1126492 Report a problem | ||
| 8/6/2018 | Price change | $319,900-1.5%$82/sqft |
Source: Coldwell Banker Prime Properties #S1126492 Report a problem | ||
| 7/19/2018 | Price change | $324,900-1.5%$84/sqft |
Source: Coldwell Banker Prime Properties #S1126492 Report a problem | ||
| 7/6/2018 | Price change | $329,900-2.9%$85/sqft |
Source: Coldwell Banker Prime Properties #S1126492 Report a problem | ||
| 6/17/2018 | Listed for sale | $339,900+145.4%$87/sqft |
Source: COLDWELL BANKER PRIME PROP,INC #S1126492 Report a problem | ||
| 3/23/2018 | Sold | $138,500-44.6%$36/sqft |
Source: Public Record Report a problem | ||
| 8/14/2017 | Price change | $249,900-3.8%$64/sqft |
Source: Syracuse #S1059805 Report a problem | ||
| 7/5/2017 | Price change | $259,900-3.7%$67/sqft |
Source: Syracuse #S1059805 Report a problem | ||
| 5/24/2017 | Price change | $269,900-3.6%$69/sqft |
Source: Syracuse #S1059805 Report a problem | ||
| 4/19/2017 | Price change | $279,900-3.4%$72/sqft |
Source: Keller Williams - Syracuse #S1059805 Report a problem | ||
| 1/25/2017 | Listed for sale | $289,900+2315.8%$75/sqft |
Source: Keller Williams - Syracuse #S1059805 Report a problem | ||
| 9/2/2011 | Sold | $12,000-95.6%$3/sqft |
Source: Public Record Report a problem | ||
| 10/28/2005 | Sold | $272,000+92.9%$70/sqft |
Source: Public Record Report a problem | ||
| 12/9/1999 | Sold | $141,000$36/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $275,000 |
| 2023 | -- | $275,000 |
| 2022 | -- | $275,000 |
| 2021 | -- | $275,000 |
| 2020 | -- | $275,000 |
| 2019 | -- | $275,000 |
| 2018 | -- | $275,000 |
| 2017 | $9,369 | $275,000 |
| 2016 | -- | $275,000 |
| 2015 | -- | $275,000 |
| 2014 | -- | $275,000 |
| 2013 | -- | $275,000 |
| 2012 | -- | $275,000 -4.6% |
| 2011 | -- | $288,300 |
| 2010 | -- | $288,300 |
| 2009 | -- | $288,300 |
| 2008 | -- | $288,300 +3% |
| 2007 | -- | $279,900 +125.4% |
| 2006 | -- | $124,200 |
| 2005 | -- | $124,200 |
| 2004 | -- | $124,200 |
| 2003 | -- | $124,200 |
| 2002 | -- | $124,200 |
| 2001 | -- | $124,200 -11.3% |
| 2000 | -- | $140,000 |
Find assessor info on the county website
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 13042
Nearby schools
GreatSchools rating
- 4/10Aura A Cole Elementary SchoolGrades: PK-5Distance: 5 mi
- 5/10Central Square Middle SchoolGrades: 6-8Distance: 10.9 mi
- 5/10Paul V Moore High SchoolGrades: 9-12Distance: 11.8 mi
Schools provided by the listing agent
- District: Central Square
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- New York
- Oswego County
- Cleveland
- 13042
- 554 State Route 49
Nearby cities
Nearby zip codes
Other Cleveland Topics
