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.*

Listing Tools

Property Details of 2 Sunset Road

Property Details

Utilities and Appliances

Community

Other Details

Map Location

Listed by Sarah Weloth of Miranda Real Estate Group Inc

 "Based on information submitted to Global MLS as of July 7, 2026 8:13 AM UTC . All data is deemed reliable but is not guaranteed accurate by the MLS. All information should be independently reviewed and verified for accuracy. IDX information is provided exclusively for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing."

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from New England Lakeside Realty, Inc.. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.