Welcome to 283 State Route 49 in Constantia! Set on 4.74 acres with approximately 300 feet of waterfront, this spacious 2,274-square-foot ranch offers a rare opportunity to create your ideal waterfront retreat. Built in 1952, the home features three bedrooms, three full baths and a three-car garage, providing plenty of room for vehicles, storage and recreational equipment. Enjoy expansive outdoor space, scenic water views and direct waterfront access. The property is being sold in as-is condition, offering tremendous potential for renovation, investment or year-round living. Bring your vision and take advantage of this unique waterfront setting!
Active
$899,900
283 State Route 49, Cleveland, NY 13042
3beds
2,274sqft
Single Family Residence
Built in 1952
4.74 Acres Lot
$-- Zestimate®
$396/sqft
$-- HOA
What's special
Direct waterfront accessScenic water viewsExpansive outdoor spaceThree-car garageThree bedrooms
- 53 days
- 510
- 27
Zillow last checked:
Listing updated:
Listed by:
Coldwell Banker Prime Prop,Inc 315-752-0320,
Roberta M. Harrington 315-752-0320
Source: NYSAMLSs,MLS#: S1702579
Originating MLS: Syracuse
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
- Main level bathrooms: 3
- Main level bedrooms: 3
Heating
- Oil, Other, See Remarks, Wood
Cooling
- Other, See Remarks
Appliances
- Included: Dryer, Dishwasher, Electric Water Heater, Microwave
- Laundry: Main Level
Features
- Ceiling Fan(s), Living/Dining Room, Sliding Glass Door(s), Bedroom on Main Level, Bath in Primary Bedroom, Main Level Primary
- Flooring: Carpet, Ceramic Tile, Hardwood, Varies
- Doors: Sliding Doors
- Basement: Full
- Number of fireplaces: 2
Interior area
- Total structure area: 2,274
- Total interior livable area: 2,274 sqft
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Detached, Electricity, Garage, Circular Driveway
- Garage spaces: 3
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Deck, Porch
- Exterior features: Dirt Driveway, Deck, Gravel Driveway
- On waterfront: Yes
- Waterfront features: Beach Access, Lake
- Body of water: Oneida Lake
- Frontage length: 300
Lot
- Size: 4.74 Acres
- Dimensions: 300 x 2000
- Features: Rectangular, Rectangular Lot
Details
- Parcel number: 35268931201600010072000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Attic/Crawl Hatchway(s) Insulated, Cedar
- Foundation: Block, Slab
- Roof: Asphalt,Shingle
Condition
- Resale
- Year built: 1952
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Connected, Public
- Utilities for property: Cable Available, Electricity Connected, Sewer Available, Water Connected
Community & HOA
Community
- Features: Trails/Paths
- Subdivision: Bernhard Homestead Tr
Location
- Region: Cleveland
Financial & listing details
- Price per square foot: $396/sqft
- Tax assessed value: $270,300
- Annual tax amount: $10,936
- Date on market: 8/11/2026
- Listing terms: Cash,Conventional
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 8/11/2026 | Listed for sale | $899,900$396/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $270,300 |
| 2024 | -- | $270,300 |
| 2023 | -- | $270,300 |
| 2022 | -- | $270,300 |
| 2021 | -- | $270,300 |
| 2020 | -- | $270,300 |
| 2019 | -- | $270,300 |
| 2018 | -- | $270,300 |
| 2017 | $8,586 | $270,300 |
| 2016 | -- | $270,300 |
| 2015 | -- | $270,300 |
| 2014 | -- | $270,300 |
| 2013 | -- | $270,300 |
| 2012 | -- | $270,300 |
| 2011 | -- | $270,300 |
| 2010 | -- | $270,300 |
| 2009 | -- | $270,300 |
| 2008 | -- | $270,300 +3% |
| 2007 | -- | $262,400 +64% |
| 2006 | -- | $160,000 |
| 2005 | -- | $160,000 |
| 2004 | -- | $160,000 |
| 2003 | -- | $160,000 |
| 2002 | -- | $160,000 |
| 2001 | -- | $160,000 |
| 2000 | -- | $160,000 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: 13042
Nearby schools
Schools provided by the listing agent
- High: Paul V Moore High
- 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.





