# 246 N Main st, Herkimer, NY 13350 > **TL;DR:** land, $218,500 ($37/sqft), 5,844 sqft. Est. $1,169/mo. Listed 223 days. ## Property at a Glance | Attribute | Value | |-----------|-------| | Price | $218,500 | | Price/sqft | $37 | | Square Feet | 5,844 | | Property Type | Land (Other) | | Status | Pending | | Days on Market | 223 | ## Estimated Monthly Costs | Category | Amount | |----------|--------| | Principal & Interest (20% down, 30-year at 6.5%) | $1,105 | | Estimated Insurance | $64 | | **Total** | **$1,169** | ## Description ### Agent 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. ## Location - **Address:** 246 N Main st, Herkimer, NY 13350 - **County:** Herkimer - **Coordinates:** 43.027798, -74.987733 - **Google Maps:** https://www.google.com/maps?q=43.027798,-74.987733 ## Virtual Tour & Media - **Video Tour:** https://www.propertypanorama.com/instaview/syr/S1668297 ## Listing Agent - **Name:** Delbert Ball · **License:** 10401246417 - **Brokerage:** Keller Williams Realty Syracuse - **Broker Phone:** (315) 701-6900 - **Listing URL:** [View original listing](https://www.realtor.com/realestateandhomes-detail/246-N-Main-St_Herkimer_NY_13350_M93691-69280?f=listhub&s=BNARNY&m=S1668297&c=propsimple) ## Photos ![246 N Main st - Photo 1](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2773491074r.jpg) ![246 N Main st - Photo 2](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1775390056r.jpg) ![246 N Main st - Photo 3](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f154490834r.jpg) ![246 N Main st - Photo 4](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2209734267r.jpg) ![246 N Main st - Photo 5](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1213902488r.jpg) ![246 N Main st - Photo 6](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2607638782r.jpg) ![246 N Main st - Photo 7](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2211048338r.jpg) ![246 N Main st - Photo 8](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3165296852r.jpg) ![246 N Main st - Photo 9](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f669350963r.jpg) ![246 N Main st - Photo 10](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f63264210r.jpg) ![246 N Main st - Photo 11](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1454879433r.jpg) ![246 N Main st - Photo 12](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4224092298r.jpg) ![246 N Main st - Photo 13](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3055804145r.jpg) ![246 N Main st - Photo 14](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2307584965r.jpg) ![246 N Main st - Photo 15](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f231155967r.jpg) ![246 N Main st - Photo 16](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2541592911r.jpg) ![246 N Main st - Photo 17](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2825226694r.jpg) ![246 N Main st - Photo 18](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f628730591r.jpg) ![246 N Main st - Photo 19](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f329727730r.jpg) ![246 N Main st - Photo 20](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1209293185r.jpg) ![246 N Main st - Photo 21](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1454879433r.jpg) ![246 N Main st - Photo 22](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f63264210r.jpg) ![246 N Main st - Photo 23](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f331389948r.jpg) ![246 N Main st - Photo 24](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3619142752r.jpg) ![246 N Main st - Photo 25](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4207887139r.jpg) ![246 N Main st - Photo 26](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2420121744r.jpg) ![246 N Main st - Photo 27](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1126934140r.jpg) ![246 N Main st - Photo 28](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f852236695r.jpg) ![246 N Main st - Photo 29](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f338975286r.jpg) ![246 N Main st - Photo 30](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f472789481r.jpg) ![246 N Main st - Photo 31](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3197212590r.jpg) ![246 N Main st - Photo 32](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3099871380r.jpg) ![246 N Main st - Photo 33](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f363913862r.jpg) ![246 N Main st - Photo 34](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3023437256r.jpg) ![246 N Main st - Photo 35](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4257597130r.jpg) ![246 N Main st - Photo 36](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3194113707r.jpg) ![246 N Main st - Photo 37](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3618394858r.jpg) ![246 N Main st - Photo 38](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1275315800r.jpg) ![246 N Main st - Photo 39](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4224092298r.jpg) ![246 N Main st - Photo 40](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3055804145r.jpg) ![246 N Main st - Photo 41](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2307584965r.jpg) ![246 N Main st - Photo 42](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f231155967r.jpg) ![246 N Main st - Photo 43](http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2825226694r.jpg) --- **MLS#:** S1668297 | **Updated:** 2026-10-20 **Source:** listhub *Copyright © 2026 New York State Alliance of MLSs, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.* [View on PropertySimple](https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06) --- ## Structured Data ```json { "@context": "https://schema.org", "@type": "RealEstateListing", "@id": "https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06#listing", "url": "https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06", "name": "246 N Main st, Herkimer, NY 13350", "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.", "image": [ "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2773491074r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1775390056r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f154490834r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2209734267r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1213902488r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2607638782r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2211048338r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3165296852r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f669350963r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f63264210r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1454879433r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4224092298r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3055804145r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2307584965r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f231155967r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2541592911r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2825226694r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f628730591r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f329727730r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1209293185r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f331389948r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3619142752r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4207887139r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2420121744r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1126934140r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f852236695r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f338975286r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f472789481r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3197212590r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3099871380r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f363913862r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3023437256r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4257597130r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3194113707r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3618394858r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1275315800r.jpg" ], "primaryImageOfPage": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2773491074r.jpg", "caption": "246 N Main st - Herkimer, NY" }, "datePosted": "2026-03-21", "dateModified": "2026-10-20T17:42:44.424Z", "mainEntity": { "@type": "Place", "@id": "https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06#property", "name": "246 N Main st, Herkimer, NY 13350", "address": { "@type": "PostalAddress", "streetAddress": "246 N Main st", "addressLocality": "Herkimer", "addressRegion": "NY", "postalCode": "13350", "addressCountry": "US" }, "geo": { "@type": "GeoCoordinates", "latitude": 43.027798, "longitude": -74.987733 }, "image": [ "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2773491074r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1775390056r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f154490834r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2209734267r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1213902488r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2607638782r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2211048338r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3165296852r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f669350963r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f63264210r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1454879433r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4224092298r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3055804145r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2307584965r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f231155967r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2541592911r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2825226694r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f628730591r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f329727730r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1209293185r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f331389948r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3619142752r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4207887139r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f2420121744r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1126934140r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f852236695r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f338975286r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f472789481r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3197212590r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3099871380r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f363913862r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3023437256r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f4257597130r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3194113707r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f3618394858r.jpg", "http://lh.rdcpix.com/c3e6049775c4445c2d93d1e2091d99b7l-f1275315800r.jpg" ], "identifier": { "@type": "PropertyValue", "propertyID": "MLS", "value": "S1668297" }, "additionalProperty": [ { "@type": "PropertyValue", "name": "Property Subtype", "value": "Other" }, { "@type": "PropertyValue", "name": "Property Type", "value": "Land" } ] }, "offers": { "@type": "Offer", "@id": "https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06#offer", "url": "https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06", "price": 218500, "priceCurrency": "USD", "businessFunction": "http://purl.org/goodrelations/v1#Sell", "availability": "https://schema.org/LimitedAvailability", "seller": { "@id": "https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06#agent" } }, "provider": { "@type": "Person", "@id": "https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06#agent", "name": "Delbert Ball", "worksFor": { "@type": "Organization", "@id": "https://www.propertysimple.ai/listing/246-n-main-st-herkimer-ny-13350-b540c2d248494c11ba277bfa66b16e06#brokerage", "name": "Keller Williams Realty Syracuse", "telephone": "(315) 701-6900", "logo": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/06772b51120e11ef8d230242ac110002k-c960063012r.png" } } } } ```