HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 7 App S, Constantia, NY 13042
ACTIVE
0
$625,000

7 App SConstantia, NY, 13042

8 Beds4.5 Baths9,200 SqFt2 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.
1 / 50

Est. Monthly

$2,962/MO

$625,000

7 App S, Constantia, NY

8 Beds4.5 Baths9,200 SqFt2 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.

StatusActive
Property TypeResidential
Property SubtypeMixed Use
Year Built1950
Days on Market1 day

Est. Monthly Payment

$2,962.48

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

7 App S

Constantia, NY 13042 • Oswego
8
Beds
4.5
Baths
9,200
SqFt
2
Acres
Status
Active
Property Type
Residential
Property Subtype
Mixed Use
Year Built
195076 years ago
Days on Market
1 day
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $18,100
Property History
  • Listed for sale
    Jun 19, 2026 • NYSAMLS • S1691180
    $625,000
Mortgage Calculator
Estimated monthly payment for this property
$2,962.48
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    NYSAMLS
  • MLS#
    S1691180
  • Listing Office
    Coldwell Banker Prime Prop. Inc.
  • Last Updated
    1 hour ago

Appliances

  • Appliances
    Electric Water Heater

Climate & Systems

  • Heating
    • Propane
    • Forced Air

Interior Features

  • Flooring
    • Carpet
    • Hardwood
    • Varies
    • Vinyl
  • Basement
    • Full
    • Sump Pump
  • Interior Features
    Ceiling Fans

Parking

  • Parking Features
    • Paved
    • Unpaved
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    2 acres
  • Lot Features
    Irregular Lot
  • View
    Water
  • Patio & Porch
    • Covered
    • Porch
  • Exterior Features
    • Dock
    • Private Yard
    • See Remarks
    • Propane Tank Leased

Type

  • Property Type
    Residential
  • Property Subtype
    Mixed Use
  • Architectural Style
    • Detached
    • Fourplex

Structure

  • Construction
    • Vinyl Siding
    • Wood Siding
  • Roof
    • Asphalt
    • Metal
  • Foundation
    • Poured
    • Stone

Condition

  • Year Built
    1950
  • Condition
    Resale
  • Days on Market
    1 day
  • Water
    Connected
  • Sewer
    Connected
  • Electric
    Circuit Breakers
  • Utilities
    • Cable Available
    • High Speed Internet Available
    • Sewer Connected
    • Water Connected

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 7850 State Highway 5, St Johnsville, NY 13452ACTIVE$565,000

    7850 State Highway 5, St Johnsville, NY 13452

    Commercial SaleMixed Use0.82 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 2241-2275 Duanesburg Road, Princetown, NY 12056ACTIVE$575,000

    2241-2275 Duanesburg Road, Princetown, NY 12056

    5,162 SqFt1.17 Acres

    LISTING BY HOMECOIN.COM

  • 12 1/2 Delaware Avenue, Albany, NY 12210ACTIVE$575,000

    12 1/2 Delaware Avenue, Albany, NY 12210

    3,654 SqFt0.1 Acres

    LISTING BY COLDWELL BANKER PRIME PROPERTIES

  • 165 Madison Avenue, Albany, NY 12202ACTIVE$575,000

    165 Madison Avenue, Albany, NY 12202

    3,272 SqFt0.1 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 2015 Rosa Road, Schenectady, NY 12309ACTIVE$575,000

    2015 Rosa Road, Schenectady, NY 12309

    5,473 SqFt0.22 Acres

    LISTING BY RE/MAX CAPITAL

  • 259 Young Street, Wilson, NY 14172ACTIVE$580,000

    259 Young Street, Wilson, NY 14172

    6 Beds4 Baths10,862 SqFt0.1394 Acres

    LISTING BY HOWARD HANNA WNY INC.

  • 4139 Lake Road, Williamson, NY 14589ACTIVE$589,900

    4139 Lake Road, Williamson, NY 14589

    3 Beds3 Baths4,983 SqFt0.2 Acres

    LISTING BY REAL BROKER NY, LLC

  • 9 N Main Street, Jamestown, NY 14701ACTIVE$595,000

    9 N Main Street, Jamestown, NY 14701

    28,452 SqFt1.1 Acres

    LISTING BY CENTURY 21 TURNER BROKERS

  • 572 2nd Avenue, Troy, NY 12182ACTIVE$599,000

    572 2nd Avenue, Troy, NY 12182

    6,381 SqFt0.28 Acres

    LISTING BY HANNA COMMERCIAL

  • 23 Industrial Drive, Schroon, NY 12870ACTIVE$599,900

    23 Industrial Drive, Schroon, NY 12870

    2,160 SqFt4.5 Acres

    LISTING BY EXP REALTY