246 N Main St, Herkimer, NY

House

For Sale

Listed price in listed location currency (USD).

$218,500

002

MLS® S1668291

Key Facts
Description
Map

Key Facts

Type Business

Levels Commercial Sale

Size 5844 sqft

Garage

Taxes $5,674

Days Active 13

Lot Size

Approx. Age 1900

Avg. Price Per Sqft $37

MLS® Number S1668291

Property Address: 246 N Main St, Herkimer, NY, 13350

Average square foot calculated using Size range provided by listing agent.

Description

**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.

MLS® NumberS1668291

Laundry Level

Central VacNo

FireplaceNo

Acreage

Exterior

Garage

Approx. Age1900

BasementFull

Driveway

Garage Spaces

Heat

A/C

Heating Fuel

Extras

Price History

-End Date

Not Sold YetSold Price

For Sale

Mar 21, 2026List Date

$218,500List Price

Commute

Commute

Starting Address

Destination Address

Like what you see?

Complete the form and we'll be in touch. No login necessary.

Add a Comment

I want to view this property

Yes, I'd like to receive free weekly market insights and buying and selling tips. Unsubscribe at any time.

By checking this box, and clicking "Take a Tour", I am confirming that I have read and agree to Zoocasa's Data Processing & Privacy Policy, and to Zoocasa's Terms of Use.

By checking this box, and clicking "Take a Tour", I am electronically signing and consenting to receive marketing communications (about real estate brokerage services and one or more properties that I may buy, sell, or rent), that may be delivered to me via email, telephone and/or text messaging (using "automated technology" such as an automatic telephone dialing system, and/or an artificial or prerecorded voice), from Zoocasa, eXp Realty® and its independent contractor real estate agents, and/or its or their affiliates, using the contact information I provided. Consent is not a condition of purchase. I may opt-out at any time by emailing [email protected] or calling 1-844-683-4664.

Similar Listings

Comparable Properties

Company

Stay Connected

1-844-683-4663

[email protected]

800 - 1070 Douglas Street, Victoria, BC, V8W2C4

Download Our App

US Real Estate Listings Canada Real Estate Listings

Owned by

A group of people at an event are laughing and cheering, with one man enthusiastically greeting a seated couple in the front row.

The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA.

eXp Realty holds real estate brokerage licenses in multiple states. Zoocasa (Canada), Inc. holds real estate brokerage licenses in multiple provinces. For information on licenses please contact us at [email protected]

For listings in Canada, the trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.

MLS® Compliance Statements
Tony King – Designated Managing Broker, Broker Operations – TX. Texas Real Estate Commission information about brokerage services
Texas Real Estate Commission Consumer Protection Notice

eXp Realty® is committed to adhering to the guidelines of The New York State Fair Housing Regulations. To view The Fair Housing Notice - Please Click Here. Standardized Operating Procedure for Purchasers of Real Estate Pursuant to Real Property Law 442-H. To View - Please Click Here.

eXp Realty of California, Inc. | CA DRE# 01878277 | Deborah Penny – Designated Broker
eXp Realty of Southern California, Inc. | CA DRE# 02187306 | Gina Saad – Designated Broker
eXp Realty of Greater Los Angeles, Inc. | CA DRE# 02188471 | Anita Cruz – Designated Broker
eXp Realty of Northern California, Inc. | CA DRE# 01951343 | Ryan Rosas Penny – Designated Broker
Fair Housing and Reasonable Accommodations
DMCA Notice