- Overview
- Description
- Property Details
- Location
- Getting Around
$475,000
6 Beds
5 Baths4 full baths + 1 half bath
3,890sqft
554 State Route 49, Constantia, NY 13042
$475,000
Get Pre-Approved
Single Family Residence
Built in 1845
$-- HOA
2.11 acres lot
$122/sq.ft
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 gues...
Continue Reading- Houzeo last checked: 55 minutes ago
- Listing updated: August 19, 2026 at 6:26 pm
- Listing Provided by: Thomas Tarry JR (315) 430-4894 DRE #10491210949, Jodi Tarry (315) 558-3966 DRE #10401282542 | Move Real Estate (315) 925-4288
- Source: New York State Alliance of MLSs, Buffalo-NY | MLS#: S1687685
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
--
Year Built
1845
HOA Fees
-
Finished Area
3,890 sqft
Lot Size
2.11 acres lot
Basement Area
- sqft
MLS Name
New York State Alliance of MLSs, Buffalo
MLS Number
S1687685
MLS Status
Active
Days on Market
93
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 09:00 AM
Rates starting from 6.8%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
