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

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

Layout spacer

    Layout spacer

      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 246 Main st, Herkimer, NY 13350
      IN ESCROW
      0
      $218,500

      246 Main stHerkimer, NY, 13350

      5,844 SqFt
      **A Visionary Investment Awaits in the Heart of Herkimer** Building only FOR SALE Where commerce meets opportunity, this magnificent mixed-use property stands as a beacon for the astute investor seeking a portfolio-defining acquisition. With an impressive annual revenue stream of forty-four thousand dollars already flowing, this multi-tiered gem delivers immediate returns while promising extraordinary future appreciation as downtown revitalization transforms the surrounding streetscape. The ground floor commands attention with a versatile commercial retail space primed for an ambitious entrepreneur's dream venture, complemented by generous garage storage that adds undeniable utility and value. Ascend to the second story, where two thoughtfully appointed apartments—secured under one-year leases—provide the steady, reliable income that savvy investors covet. The third floor elevates the revenue model entirely, featuring two turnkey short-term rental apartments already generating premium nightly returns in an increasingly popular market. Five separate electrical meters and individual gas services ensure each unit operates independently—a remarkable infrastructure advantage that simplifies management and maximizes profitability. With four bedrooms and five bathrooms distributed throughout the residential spaces, this property offers exceptional flexibility and tenant appeal. Nestled within a walkable community boasting Myers Park, convenient healthcare facilities, and the charm of Herkimer County Community College nearby, the location delivers both livability and lasting desirability. The renowned Diamond Mines and the majestic Adirondack Mountains beckon visitors year-round, fueling consistent short-term rental demand. Downtown revitalization waits for no one. Seize this extraordinary opportunity before the transformation reshapes the landscape—and the price point—forever.
      1 / 43

      Est. Monthly

      $1,036/mo

      $218,500

      246 Main st, Herkimer, NY

      5,844 SqFt

      **A Visionary Investment Awaits in the Heart of Herkimer** Building only FOR SALE Where commerce meets opportunity, this magnificent mixed-use property stands as a beacon for the astute investor seeking a portfolio-defining acquisition. With an impressive annual revenue stream of forty-four thousand dollars already flowing, this multi-tiered gem delivers immediate returns while promising extraordinary future appreciation as downtown revitalization transforms the surrounding streetscape. The ground floor commands attention with a versatile commercial retail space primed for an ambitious entrepreneur's dream venture, complemented by generous garage storage that adds undeniable utility and value. Ascend to the second story, where two thoughtfully appointed apartments—secured under one-year leases—provide the steady, reliable income that savvy investors covet. The third floor elevates the revenue model entirely, featuring two turnkey short-term rental apartments already generating premium nightly returns in an increasingly popular market. Five separate electrical meters and individual gas services ensure each unit operates independently—a remarkable infrastructure advantage that simplifies management and maximizes profitability. With four bedrooms and five bathrooms distributed throughout the residential spaces, this property offers exceptional flexibility and tenant appeal. Nestled within a walkable community boasting Myers Park, convenient healthcare facilities, and the charm of Herkimer County Community College nearby, the location delivers both livability and lasting desirability. The renowned Diamond Mines and the majestic Adirondack Mountains beckon visitors year-round, fueling consistent short-term rental demand. Downtown revitalization waits for no one. Seize this extraordinary opportunity before the transformation reshapes the landscape—and the price point—forever.

      StatusIn Escrow
      Property TypeLand
      Property SubtypeOther
      Days on Market59 days

      Est. Monthly Payment

      $1,035.68

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      246 Main st

      Herkimer, NY 13350 • Herkimer
      —
      Beds
      —
      Baths
      5,844
      SqFt
      —
      Acres
      Status
      In Escrow
      Property Type
      Land
      Property Subtype
      Other
      Days on Market
      59 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $5,674
      Property History
      • Listed for sale
        Mar 21, 2026 • NYSAMLS • S1668297
        $218,500
      Mortgage Calculator
      Estimated monthly payment for this property
      $1,035.68
      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#
        S1668297
      • Listing Office
        Keller-Williams Mohawk Valley
      • Last Updated
        4 days ago

      Lot & Grounds

      • Lot Features
        • Other
        • Rectangular
        • Rectangular Lot
        • See Remarks
      • Exterior Features
        See Remarks

      Type

      • Property Type
        Land
      • Property Subtype
        Other

      Condition

      • Days on Market
        59 days
      • Water
        Public
      • Sewer
        Connected
      • Utilities
        • Cable Available
        • Electricity Available
        • Natural Gas Available
        • High Speed Internet Available
        • Phone Available
        • Sewer Available
        • Water Available
        • Sewer Connected
      Also Listed On
      • NYSAMLS
        1 related listing
        In Escrow$218,500

      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 →
      • 0 Roses Brk Road, Stamford, NY 13788ACTIVE$199,000

        0 Roses Brk Road, Stamford, NY 13788

        LandOther104.76 Acres

        LISTING BY COUNTRY PRIDE REALTY

      • L1 County Route 7, Hannibal, NY 13074ACTIVE$209,000

        L1 County Route 7, Hannibal, NY 13074

        LandOther10 Acres

        LISTING BY CANAAN REALTY

      • 2511 Pine Avenue, Niagara Falls, NY 14301ACTIVE$219,000

        2511 Pine Avenue, Niagara Falls, NY 14301

        3 Beds4,822 SqFt0.0559 Acres

        LISTING BY ICONIC REAL ESTATE

      • 8660 Wolcott Road, Clarence, NY 14032ACTIVE$220,000

        8660 Wolcott Road, Clarence, NY 14032

        1 Bed1 Bath958 SqFt15.6 Acres

        LISTING BY HUNT REAL ESTATE CORPORATION

      • 1350 St Paul Street, Rochester, NY 14621ACTIVE$224,900

        1350 St Paul Street, Rochester, NY 14621

        12 Beds13,734 SqFt1.07 Acres

        LISTING BY RE/MAX REALTY GROUP

      • Placid Terrace, Lansing, NY 14850ACTIVE$224,900

        Placid Terrace, Lansing, NY 14850

        LandOther0.85 Acres

        LISTING BY WARREN REAL ESTATE OF ITHACA INC.

      • 129 Hornbrook Road, Danby, NY 14850ACTIVE$225,000

        129 Hornbrook Road, Danby, NY 14850

        LandOther50 Acres

        LISTING BY HOWARD HANNA S TIER INC

      • 18 Main St, Fairfield, NY 13406ACTIVE$229,000

        18 Main St, Fairfield, NY 13406

        6 Beds3,717 SqFt

        LISTING BY KELLER-WILLIAMS MOHAWK VALLEY

      • 5492 Nutting Street Road, Henderson, NY 13650ACTIVE$230,000

        5492 Nutting Street Road, Henderson, NY 13650

        1 Bed1 Bath608 SqFt1.2 Acres

        LISTING BY LAKE ONTARIO REALTY, LLC

      • 89 Pine Street, Lockport City, NY 14094ACTIVE$234,500

        89 Pine Street, Lockport City, NY 14094

        3 Beds5,274 SqFt0.09 Acres

        LISTING BY BERKSHIRE HATHAWAY HOMESERVICES ZAMBITO REALTORS