Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Advisor Realty

Property view
Listing view 2
Listing view 3

2 Sunset Road, 
Rensselaer, NY 12144

$525,000


5

Beds


3

Baths


2,304

Sq Ft


Multi-Family

Active

Listed by

Sarah Weloth

Miranda Real Estate Group Inc

518-348-2060

Last updated:

October 28, 2026, 10:55 PM

MLS#

20265961

Source:

NY MLSUC

About This Home

2 Sunset Road

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 with potential rental income of 4,500/month. 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.*

Home Facts

Multi-Family

3 Baths

5 Bedrooms

Built in 1965

Price Summary

525,000

$227 per Sq. Ft.

MLS #:

20265961

Last Updated:

October 28, 2026, 10:55 PM

Added:

25 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

3

Interior

Living Area:

2,304 Sq. Ft.


Structure

Structure

Building Area:

2,304 Sq. Ft.

Year Built:

1965


Lot

Lot Size (Sq. Ft):

7,405


Finances & Disclosures

Finances

Price:

$525,000

Price per Sq. Ft:

$227 per Sq. Ft.

Source:NY MLSUC
The information being provided by Hudson Valley Catskill Mls is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2026 Hudson Valley Catskill Mls All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.