554 State Route 49, Constantia, NY 13042

$579,000 Asking Price

4 beds
3 baths
2,590  sqft
Built in 1845

**OPEN HOUSE ON SUNDAY MAY 19th 1-3** Unbelievable LAKEFRONT opportunity includes a gorgeous 4 bed/2.5 bath 2500+ sqft home, a 1 bed/1 bath guest house and an additional two story renovated 1 bed/1 bath carriage house .... all with 87 feet of Oneida Lake waterfront and over 2 acres of land! The main house is stunning and has been perfectly transformed from top to bottom with open floor plan providing lake views from every angle, amazing granite kitchen, hardwoods, tile, upgraded bathrooms, huge deck overlooking the lake and so much more. This property is the perfect entertaining paradise and what makes it even more amazing is you'll never run out of parking because there is also 257 feet of road frontage on Marsden Road with a separate driveway leading to the property and to your 1 bedroom guest house! You could build another house or garage!


Features & Amenities

Interior

General:
Breakfast Area,Ceiling Fan(s),Separate/Formal Dining Room,Separate/Formal Living Room,Guest Accommodations,Granite Counters,Home Office,Country Kitchen,See Remarks,Sliding Glass Door(s),In-Law Floorplan,Main Level Primary
Appliances:
Dishwasher,Electric Oven,Electric Range,Microwave,Propane Water Heater,Refrigerator
Laundry:
Main Level
Basement:
Crawl Space,Full
Flooring:
Carpet,Ceramic Tile,Hardwood,Varies
Heating:
true, Propane,Forced Air
Fireplace:
Fireplace, Fireplaces: 2

Exterior

General:
Concrete Driveway,Deck,Dock,Fully Fenced,Gravel Driveway,Private Yard,See Remarks, Shed(s),Storage
Style:
Two Story
Other Structures:
Shed(s),Storage
Parking:
No Garage

Construction

Roofing:
Asphalt
General:
Vinyl Siding, 2, Stone

Location

Originating MLS:
NYS
School District:
Central Square
County:
Oswego

Lot

Zoning:
352689-312-006-0002-003-000-0000
Fencing:
Full

Utilities

Utilities:
Cable Available,High Speed Internet Available,Water Connected, Circuit Breakers
Water:
Connected,Public
Sewer:
Septic Tank

Financial

Source:
NYS
Listing Agent Compensation:
0

This listing courtesy of:
Coldwell Banker Prime Prop. Inc., Laura Loomis-Patrick

About Cleveland, NY

Housing

Number of Units
1,496
Median Home Value
$111,772
Median Rent
$670

14.70% of housing units are renter occupied.

24.14% are vacant.

Commute

Car
76.76%
Public Transportation
0.35%
Walk to Work
0.77%
Work from Home
21.95%
Other
0.17%

The median travel time to work is 28 minutes.

People

Population
2,734
Median Age
46.30
Median Household Size
2.58

Education

High School
38.67%
Associate’s Degree
17.53%
Bachelor’s Degree
11.14%
Graduate Degree
6.48%

Disclaimer: Community and Demographic information uses data from the U.S. Census Bureau but is not endorsed or certified by the Census Bureau.

Message

Interested in this home?

Request more information: