Sign up to get new listings emailed daily! JOIN SIGN IN
Sharon Ciminelli
REALTOR®, Lic. Real Estate Associate Broker
(716) 510-7489

246 N Main St, Herkimer, NY 13350

$218,500
  • 246 N Main St, Herkimer, NY 13350 Main Photo

43 Total Photos [Click to View All]

Active
LOT SIZE 19X150 SQUARE FEET5,844 MLS#S1668297
STATUSActive PROPERTY TYPELand - Residential SCHOOLHerkimer

Property Description

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

246 N Main St | MLS# S1668297

This land located at 246 N Main St, Herkimer, NY 13350 is currently listed for sale with an asking price of $218,500. The property has approximately 0.07 Acres. N Main St is located within the Herkimer school district. Search Herkimer real estate on www.sharonciminelli.com today.

Property Features

Property Type: Land - Residential
Lot Size: 0.07 Acres
Taxes: $5,674

Amenities

See Remarks

Feature Descriptions

Days on Site: 11
Lot: Other, Rectangular, Rectangular Lot, See Remarks
Lot Dimensions: 19X150
Parcel#: 120.25-2-9
Sewer: Connected, Storm Sewer
Topography: Other, SeeRemarks
Utilities: Cable Available, Electricity Available, Natural Gas Available, High Speed Internet Available, Phone Available, Sewer Available, Water Available, Sewer Connected
Water: Public

Local Schools

School District: Herkimer

Listed By / Shown By

Listing By

Agency Name: Keller-Williams Mohawk Valley
Agency Phone: 315-701-6900

Shown By

Agent Name: Sharon Ciminelli
Agent Phone: (716) 510-7489
Agency Title: MJ Peterson Real Estate

IDX logo

Estimate Your Payment

Estimated Payment

$ 1,022.85 per month $486.29 Principal & Interest $472.83 Property Tax $63.73 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 04/02/2026. The listing information on this page last changed on 04/02/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 04/02/2026 1:51:02 AM EST) or New York State Alliance MLS (last updated Thu 04/02/2026 1:50:33 AM EST). Real estate listings held by brokerage firms other than MJ Peterson Real Estate may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel