$575,000
Schenectady, NY 12309
MLS# 202610875
4 baths | 5473 sqft

1 / 45
Property Description
Incredibly versatile beautifully maintained turnkey restaurant. Over 4300 of space on the main level could be divided into multiple spaces and or other businesses, with separate entrances. Currently a fully functioning restaurant, with full bar, cafe seating, a private dining room, and approx. 1200 sq ft that could be additional dining currently or a completely different business. There is also a residential apartment upstairs originally set up to be a 2 BR owners unit or additional offices about 600 Sq ft. The full basement offers offices, a full bath, walk in coolers/freezers, and tons of dry good storage. You couldn't rent this space for what you could own it for, excellent investment opportunity. Just 1/2 mile from Ellis Hospital, 1.5 miles to Rivers and Union College, and 2 miles to Proctors. Sale includes all FFE excepting some personal effects.
Details
Maps
Contract Information
Original List Price: 575000
List Price/SqFt: 105.06
List Price/Acres: 2613636.36
Status: Active
Property Sub Type: Mixed Use
List Price: $575,000
Listing Contract Date: 2026-01-21
Current Price: $575,000
Location
City/Town (Mail): Niskayuna
Street Number: 2015
Street Name: Rosa
Street Suffix: Road
County: Schenectady
State/Province: NY
Postal Code: 12309
Geo Lat: 42.824835
Geo Lon: -73.911297
Property Detail
Stories: 2
Number Of Buildings: 1
Business Name: Maya Thai Bistro Formerly Cella Bistro
Parking Y/N: Yes
Lot Size Square Feet: 9600
Zoning: Mixed
Lot Size Dimensions: 80 X 120
Lot Size Acres: 0.22
Building Area Total: 5473
Building Available SQFT: 5473
Main Road Frontage: 80
Year Built: 1968
Bathrooms Total: 4
Parcel, Tax, HOA
Parcel Number: 421500 40.37-2-26
Tax Annual Amount: 16444
Tax Section: 40.37
Total Taxes Description: Estimated
Tax Block: 2
Tax Lot: 26.000
School District: Schenectady
High School: Schenectady
Directions & Remarks
Directions: Rosa Road, between Gerling & Donnan Ave
Public Remarks: Incredibly versatile beautifully maintained turnkey restaurant. Over 4300 of space on the main level could be divided into multiple spaces and or other businesses, with separate entrances. Currently a fully functioning restaurant, with full bar, cafe seating, a private dining room, and approx. 1200 sq ft that could be additional dining currently or a completely different business. There is also a residential apartment upstairs originally set up to be a 2 BR owners unit or additional offices about 600 Sq ft. The full basement offers offices, a full bath, walk in coolers/freezers, and tons of dry good storage. You couldn't rent this space for what you could own it for, excellent investment opportunity. Just 1/2 mile from Ellis Hospital, 1.5 miles to Rivers and Union College, and 2 miles to Proctors. Sale includes all FFE excepting some personal effects.
Sewer
Public Sewer: 1
Current Use
Mixed Use: 1
Restaurant: 1
Architectural Style
Bar/Tavern/Lounge: 1
Commercial: 1
Mixed Use: 1
Restaurant: 1
Retail: 1
Financial Details
General Taxes: 8446
General Taxes Description: Estimated
School Taxes: 7998
School Taxes Description: Estimated
Cooling
Central Air: 1
Basement
Full: 1
Lot Features
Corner Lot: 1
Construction Materials
Block: 1
Other: 1
Photos - the contractual owner of the photos
Photo Owner: Broker
Possession
At Closing: 1
Business Type
Restaurant: 1
Flooring
Ceramic Tile: 1
Hardwood: 1
Laminate: 1
Showing Requirements
Agent to Accompany: 1
Occupied: 1
Special Listing Conditions
Standard: 1
Roof
Asphalt: 1
Rubber: 1
Water Source
Public: 1
Heating
Forced Air: 1
Natural Gas: 1
Interior Features
Ceramic Tile Bath: 1
Chair Rail: 1
Parking Features
Parking Total: 15
Paved: 1
Private: 1
Possible Use
Apartment Plus: 1
Business: 1
Mixed: 1
Office: 1
Office Plus: 1
Office/Retail: 1
Restaurant: 1
Retail: 1
Tavern: 1
Tavern Plus: 1
Other: 1
Laundromat: 1
Medical/Dental: 1
Subdividable: 1
Sale Includes
Building & Land: 1
Security Features
24 Hour Security: 1
Status Change Info
Status Change Date: 2026-01-21
Property Features
Architectural Style: Bar/Tavern/Lounge; Commercial; Mixed Use; Restaurant; Retail
Basement: Full
Construction Materials: Block; Other
Cooling: Central Air
Current Use: Mixed Use; Restaurant
Business Type: Restaurant
Flooring: Ceramic Tile; Hardwood; Laminate
Heating: Forced Air; Natural Gas
Interior Features: Ceramic Tile Bath; Chair Rail
Lot Features: Corner Lot
Parking Features: Paved; Private
Possession: At Closing
Possible Use: Apartment Plus; Business; Mixed; Office; Office Plus; Office/Retail; Restaurant; Retail; Tavern; Tavern Plus; Other; Laundromat; Medical/Dental; Subdividable
Roof: Asphalt; Rubber
Sale Includes: Building & Land
Security Features: 24 Hour Security
Sewer: Public Sewer
Showing Requirements: Agent to Accompany; Occupied
Special Listing Conditions: Standard
Water Source: Public
Listing Courtesy of RE/MAX Capital
Listing Agent: Jeffrey P Decatur
518-369-5333 | jeffreydecatur@gmail.com
518-369-5333 | jeffreydecatur@gmail.com

