Active
7 App S, Constantia NY 13042
MLS# S1691180
$625,000
Price
8
Beds
5
Baths
9,200
Living Area (Sq.Ft.)
2
Lot Area (Acres)
$625,000
Price
8
Beds
5
Baths
9,200
Living Area (Sq.Ft.)
2
Lot Area (Acres)
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.
Status
Active
Property Type
Residential
Property Sub Type
MixedUse
Year Built
1950
Parcel Number
352601-313-013-0006-007-000-0000
Unit Number
--
Lot Features
Irregular Lot
Lot Size Dimensions
323X234
Community Features
TrailsPaths
Bath Rooms Full
4
Bath Rooms Half
1
Property Condition
Resale
Elementary School District
Central Square
Middle Or Junior School District
Central Square
High School District
Central Square
Location
Listing Agent
Laura Loomis-Patrick
Listing Office
Coldwell Banker Prime Prop. Inc.
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2026-06-19
Owner Pays
All Utilities
Rent Includes
All Utilities
Fire Places Total
1
Interior Features
Ceiling Fans
Flooring
Carpet, Hardwood, Varies, Vinyl
Fire Place
true
Heating
true
Heating Features
Propane, Forced Air
Appliances
Electric Water Heater
Electric
Circuit Breakers
Garage
true
Garage Spaces
2
Architectural Style
Detached, Fourplex
Exterior Features
Dock, Private Yard, See Remarks, Propane Tank Leased
Water Source
Connected, Public
Sewer
Connected
Roof
Asphalt, Metal
Utilities
Cable Available, High Speed Internet Available, Sewer Connected, Water Connected
View
true
View Features
Water
Parking Features
Paved, Unpaved
Foundation Details
Poured,Stone
Basement
Full, Sump Pump
Construction Materials
Vinyl Siding, Wood Siding
Patio And Porch Features
Covered, Porch
Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Listed By
Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.