Lake Homes Realty
Enter City, Zip or MLS
Waterfront

7 apps landing

Constantia, NY 13042

$625,000

8 BEDS 5 BATHS
9,200 SQFT2 AC LOT
Residential - MixedUse
Waterfront
Image 1
Image 2
Image 3
Image 4
Bedrooms 8
Total Baths 5
Full Baths 4
Square Feet 9200
Acreage 2
Status Active Under Contract
MLS # S1691180
County Oswego
More Info
Category Residential - MixedUse
Status Active Under Contract
Square Feet 9200
Acreage 2
MLS # S1691180
County Oswego
Opportunity knocks on the shores of Oneida Lake! This versatile property features a 19-slip marina, a fully operating waterfront bait and tackle shop, three year-round homes, and a spacious barn. The waterfront includes the bait shop and the "Blue House" (3 BR, 1.5 BA), which currently rents weekly to fisherman. Across the road sits the "White House" (3 BR, 1 BA) with a fireplace, porch, and beautiful lake views, (also rented weekly), alongside a barn and a duplex offering two 1 BR, 1 BA units (one owner-occupied, one rented weekly). Black Creek runs next to the property, providing a serene ambiance and sound of a flowing waterfall. Boasting abundant parking and a shared driveway with the highly trafficked Cleveland State Pier, this unique property offers prime visibility, rental history, and endless potential. Square footage is measured to be 9,200 sqft (by agent) and includes all the buildings together (minus the barn). Bait and tackle shop inventory is negotiable. Vacant lot at the West end of the property does not convey. There are no photos inside the duplex as both sides are occupied. This sale also includes tax parcel #313.13-06-07. Also Listed as Commercial MLS#S1691182.
Location not available
Listing
Street
Satellite

Exterior Features

  • Style Detached, Fourplex
  • Construction Single Family
  • Siding VinylSiding, WoodSiding
  • Exterior Dock, PrivateYard, SeeRemarks, PropaneTankLeased
  • Roof Asphalt,Metal
  • Garage Yes
  • Garage Description Paved, Unpaved
  • Water Connected, Public
  • Sewer Connected
  • Lot Description IrregularLot

Interior Features

  • Appliances ElectricWaterHeater
  • Heating Propane, ForcedAir
  • Basement Full,SumpPump
  • Fireplaces 1
  • Living Area 9,200 SQFT
  • Year Built 1950

Financial Information

  • Parcel ID 352601-313-013-0006-007-000-0000

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Coldwell Banker Prime Prop. Inc. - (315) 762-4032
Listings identified with the NYSAMLS IDX logo are provided courtesy of the NYSAMLS IDX Program.
Information Is Believed To Be Accurate But Not Guaranteed. © 2026 NYSAMLS, Inc.
Listing data is current as of 07/30/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.