Now available at a New Price! Unlock the potential of this well-maintained mixed-use investment property located in the sought after East Greenbush School District! Featuring two fully rented residential units plus a versatile commercial space on the lower level with its own separate address, this property offers multiple income streams and excellent flexibility. Continue leasing the occupied units for maximum cash flow, or owner-occupy one of them and use the commercial space to operate your business while generating rental income from the apartments above. Positioned on a high-visibility road with outstanding frontage, your business will benefit from exceptional exposure. Conveniently located just minutes from shopping, restaurants, major highways, HVCC, Regeneron, the Rensselaer Train Station, and more, this is a perfect opportunity for investors or entrepreneurs seeking a property with strong income potential and a prime location. Basement offers potential rental opportunity, with 1 full bathroom and estimated monthly rent of $1,500. *Please note that any business going in will need a use variance and approval from the Town of North Greenbush Zoning.*
Multi-familyProperty Type
1965Year Built
7,405 sq ftLot Size
$228Price/Sq.Ft.
8 spacesParking
Listing by Sarah Weloth• Miranda Real Estate Group Inc
Now available at a New Price! Unlock the potential of this well-maintained mixed-use investment property located in the sought after East Greenbush School District! Featuring two fully rented residential units plus a versatile commercial space on the lower level with its own separate address, this property offers multiple income streams and excellent flexibility. Continue leasing the occupied units for maximum cash flow, or owner-occupy one of them and use the commercial space to operate your business while generating rental income from the apartments above. Positioned on a high-visibility road with outstanding frontage, your business will benefit from exceptional exposure. Conveniently located just minutes from shopping, restaurants, major highways, HVCC, Regeneron, the Rensselaer Train Station, and more, this is a perfect opportunity for investors or entrepreneurs seeking a property with strong income potential and a prime location. Basement offers potential rental opportunity, with 1 full bathroom and estimated monthly rent of 1,500. * Please note that any business going in will need a use variance and approval from the Town of North Greenbush Zoning. *
Global MLS #202621063
Oct 7, 2026
Relisted
—
Oct 7, 2026
Price Changed
$525,000
$228/sq ft
Jul 21, 2026
Listing Removed
—
Jul 6, 2026
Listed
$575,000
$250/sq ft
Year
Property tax
Land + Additions
Assessment*
2026
$6,976
$3,400 + $43,400
$46,800
2025
$6,976 (+2.6%)
$3,400 + $43,400
$46,800
2024
$6,796 (−0.9%)
$3,400 + $43,400
$46,800
2023
$6,857 (+5.5%)
$3,400 + $43,400
$46,800
2022
$6,499 (−15.6%)
$3,400 + $43,400
$46,800
2021
$7,704 (+13.9%)
$3,400 + $43,400
$46,800
2020
$6,767 (+3.9%)
$3,400 + $43,400
$46,800
2019
$6,515 (+3.7%)
$3,400 + $43,400
$46,800
2018
$6,283 (+8.6%)
$3,400 + $43,400
$46,800
2017
$5,784 (+4.8%)
$3,400 + $43,400
$46,800
2016
$5,518 (+2.3%)
$3,400 + $43,400
$46,800
2015
$5,395 (−0.5%)
$3,400 + $43,400
$46,800
2014
$5,420
$3,400 + $43,400
$46,800
Public record
Beds
5
Baths
2.5
Stories
2
Lot width
136 ft.
Lot depth
68 ft.
Lot size
7,405 Sq. Ft.
Year renovated
—
Finished Sq. Ft.
2,304
Unfinished Sq. Ft.
—
Total Sq. Ft.
2,304
Year built
1965
Style
Multi-Family (2-4 Unit)
County
Rensselaer County
APN
383200A13401300100010000000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 10, 2026.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 96° expected this year, 15 days in 30 years
3/10 Wind Factor
6% chance of strong winds in next 30 years
2/10 Air Factor
0 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Rensselaer, NY • 12144
Average low and high temperatures (°F)
30
17
32
17
50
30
61
40
68
50
81
60
85
65
81
58
76
53
63
43
48
33
34
21
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
88/ 100
Very good sunlight
Sunscore
This home receives average direct sun exposure in Rensselaer. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10 hrs
5 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 2 Sunset Rd
There isn’t enough information to generate an accurate estimate at this time. Learn More