242 Union Street, Schenectady, NY 12305 (MLS # 202626197)

Welcome to an exceptional mixed-use property located in the heart of Schenectady's historic Stockade District. Rich in character and meticulously cared for, this remarkable building seamlessly combines professional office space with three beautifully updated apartments, creating an outstanding opportunity for an investor, owner-user, or entrepreneur looking for a unique property with multiple income-producing possibilities. The property features 12 individual offices, a conference room, and thoughtfully designed professional workspace, offering flexibility for a variety of business uses. Whether you're looking to establish your own headquarters, create a professional office center, lease individual spaces, or explore additional commercial opportunities, this property provides the space and versatility to make it happen. Adding even greater value are three beautifully updated apartments, providing excellent residential income potential. Each unit has been thoughtfully maintained and updated while preserving the character and charm that make properties in the Stockade District so desirable. Throughout the building, you'll find high ceilings, refinished hardwood floors, quality finishes, and a level of care that is immediately apparent. More than $300,000 in upgrades and renovations have been invested into the property, offering a buyer the opportunity to acquire a substantially improved asset with significant possibilities for continued growth and income. Outside, the property makes an impressive first impression with great curb appeal and a distinctive, castle-esque street presence that reflects the historic character of the surrounding neighborhood. A large paved parking lot with 15 dedicated parking spaces provides an exceptional convenience and a valuable amenity for both office occupants and residents. The property is conveniently positioned near downtown attractions, entertainment, restaurants, shopping, with quick access to the highway. Book your showing today

Last Updated	9/16/2026	Year Built	1908
County	Schenectady

SCHOOLS

High School	Schenectady

Additional Details

AIR	Central Air
AIR CONDITIONING	Yes
CONSTRUCTION	Brick, Fiber Cement
HEAT	Forced Air, Natural Gas
INTERIOR	Crown Molding, High Speed Internet
LOT	10019 sq ft
LOT DESCRIPTION	Cleared
LOT DIMENSIONS	10,157
PARKING	Paved
SEWER	Public Sewer
STORIES	2
STYLE	Multiple Dwelling Unit, Office
TAXES	13173.15
UTILITIES	Sewer Connected
WATER	Public

Location

 

Contact us about this Property

---