Very Prominent Corner Property - Mixed-Use Building - Commercial/Residential - High Traffic Location - Corner of Columbia Street (State Route 23B) and Eighth StreetThis property holds great potential for a new owner/developer. Storefronts have 32' of frontage on Columbia Street and 42' on 8th Street.The large open storefront was once two storefronts. The separate entrances are still intact. Rent the storefront as one unit or bring them back to two units. Each Storefront has an office behind the showroom. The attached garage, which faces Columbia St and the workshop behind it, could be another rentable commercial unit . There are two residential units on the second floor (one currently only used as storage). There are also two 3rd-Floor attics that could be used for additional storage, or finished as a media room or home office. Current commercial and retail space total is 4553 square feet (422.99 m). If you finish the attics it brings the total square footage to a whopping 6830 square feet (634.53 m) of useable space.There were at one time, two distinct residential apartments on the second floor. One is mostly intact with living room, den, two bedrooms, large kitchen, bathroom with screened side porch off the kitchen. A second apartment was converted to extra storage, with an inventive hand powered parcel lift to the unit. There are a great deal of original details throughout both residential units (see photos). Currently, there is only pull-down stair access to the second residential unit (now storage)This property is in the Hudson Opportunity Zone, which could be of great benefit to a user/developer who uses capital gains for the purchase and renovation of this property (speak to your financial advisor to understand the full financial benefits that could be realized under the Opportunity Zone).The property sits in the R-5 district, which is a residential district allowing one or two family residences. But commercial use of this property goes back more than 100 years and commercial use is grandfathered as soft retail. Due to its long commercial history and location we have confirmed with Code Enforcement that the grandfathered "soft retail" status will pass on to a new buyer. Soft retail is nearly any store or shop that does not include selling food or drink. Speak with agent for more information about the zoning.The neon Niver Inc sign won't convey. At this price the Property is being sold As-Is