Search
Mixed-Use Property with Office Space
New
For Sale
$575,000

242 Union Street, Schenectady, NY 12305

Commercial Sale, Schenectady, NY

Property SizeContact for details
Lot Size0.23 Acres
Days on Market3

Property Features for 242 Union Street

General Information

Property type Commercial Sale
Property subtype Other
Zoning Multi Residence
Parking 15
Security features Security
Interior features T1 Internet, Crown Molding
Lot features Cleared
High school Schenectady
Elementary school district Schenectady
Middle school district Schenectady
High school district Schenectady
Directions I 890 West to Broadway exit 5 Right on Broadway Left on State St Right on Erie Left on Union Property on the left.
Standard status Active
APN 421500 39.63-4-20.1
Lot size 0.23 Acres

Taxes and HOA fees

Tax Annual Amount 13173

Utilities

Sewer type Public Sewer
Heating system Forced Air, Natural Gas
Cooling system Central Air
Water source Public

Amenities

conference room

Building Details

Year built 1908
Floors in Building 2
Building materials Brick, Fiber Cement
Roof type Rubber
Architectural style Other
Listing Agency: Venture Fox Realty Group LLC
Listed By: Sean Martin · License #10401359018
Added: Sep 16 Changed: Sep 18 Last Checked: Sep 18 at 3:06PM
MLS# 202626197

Copyright © 2026 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Investment Insights

Based on property information with market context.

This 1908 brick and fiber-cement mixed-use building combines a professional office component with three updated apartments. The commercial area includes 12 individual offices and a conference room, while the building also offers high ceilings, refinished hardwood floors, crown molding, T1 Internet, central air, and forced-air natural gas heating. Public water and sewer serve the property, which has a rubber roof.

Set on 0.23 acres in Schenectady’s historic Stockade District, the property includes a large paved parking lot with 15 dedicated spaces. Its Union Street location provides access to downtown attractions, entertainment, restaurants, shopping, and the highway. Multi Residence zoning supports the property’s mixed-use configuration.

Key Highlights

  • Three updated apartments within a mixed‑use building
  • 12 individual offices plus a conference room
  • 15 dedicated parking spaces in a large paved lot

Property Analytics

Unlock full access to Insights Subscribe to Realmo Intelligence
Open Analytics

Current Use

Knowledge Wand General Contractor Caring Companions of the Capital ... Nursing Home Herweyer Financial Financial Advisor DocTrax Physician Samson's Classroom Training Center

Suggested Use

Top Pick (Bike/Boat/Book/etc) Store Acupuncture Tech Support Center Butcher Storage Facility HVAC Service

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

3
Residential units
Yes
Highway access

Location Intelligence

Trade Area within ½ mile

1,896
Businesses Nearby

Demographics for 12305, NY

6,085
Population
4,103
Households
1.5
Avg Household Size
37
Median Age
34%
College-Educated
88%
High-School Grad
1.5 sq mi
ZIP Area
4,057
Density / Sq Mi
$50,308
Median Household Income
$34,228
Median Earnings
$1,067
Median Rent
$162,500
Median Home Value
Check the figures for this property Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics

Market

Vacancy Rate% for Office in Northeast region

13.1% 2019
15.4% 2020
17.6% 2021
19.1% 2022
20.2% 2023
20.9% 2024
19.9% 2025
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

Frequently Asked Questions

What type of property is this?
Mixed-use property - Includes professional offices, updated apartments, and dedicated on-site parking.
Where is this mixed-use property located?
The property is located at 242 Union Street Schenectady, NY.
What is the asking price?
The asking price for this property is $575,000.
What are key features of this property?
This property features: Three updated apartments within a mixed‑use building; 12 individual offices plus a conference room; 15 dedicated parking spaces in a large paved lot
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message