246 N Main St

Herkimer, NY 13350

**A Visionary Investment Awaits in the Heart of Herkimer** 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.

Listing courtesy of Delbert Ball of Keller-Williams Mohawk Valley (315) 868-3933



The data relating to real estate on this website comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS’s. Real estate listings held by firms other than are marked with the IDX logo and detailed information about them includes the Listing Broker’s Firm Name.

All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change, or withdrawal. Neither the listing broker(s) nor shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. © Last checked: 2026-03-22 08:39 PM UTC CNYIS, UNYREIS, WNYREIS. All rights reserved.