Beau Harding
Licensed Real Estate Salesperson
REALTOR®
Glens Falls, NY

2 Sunset Road, Rensselaer, NY 12144

New - 16 Hours Ago
View Full Photo Gallery

Property Description

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

2 Sunset Road | MLS# 20265961

This multi-family property located at 2 Sunset Road, Rensselaer, NY 12144 is currently listed for sale with an asking price of $525,000. Sunset Road is located within the East Greenbush school district. Search Rensselaer real estate on beau-harding.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Multi Unit - Multiple
Fuel Type: Gas
Heating: Forced Air, Natural Gas
Home Style: Other
Lot Size: 0.17 Acres
Roof Type: Asphalt, Shingle
Stories: 2.0
Taxes: $5,793
Year Built: 1965

Feature Descriptions

Appliances: Refrigerator, Range, Oven, Gas Water Heater
Exterior: Cedar
Flooring: Ceramic Tile, Hardwood, Vinyl, Wood
Lot: Cleared, Corner Lot, Level, Views
Parcel #: 383200 134.13-10-1
Parking: Paved, Off Street, Driveway
Patio/Porch: Covered, Front Porch, Rear Porch
Road Frontage: Municipal Road, City Street
Road Surface: Paved
Sewer: Public Sewer
SQFT Total: 2304
Tenant Pays: Electricity, Snow Removal, Trash Collection
Units: 2
Utilities: Cable Available, Cable Connected, Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected, Phone Available, Sewer Available, Sewer Connected, Water Available, Water Connected
Water: Public

Local Schools

School District: East Greenbush

Estimate Your Payment

Estimated Payment

$ 1,804.30 per month $1,168.42 Principal & Interest $482.75 Property Tax $153.13 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Miranda Real Estate Group Inc

Shown By

Agent Name: Beau Harding
Agent Phone: (518) 683-8041 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 10/08/2026. The listing information on this page last changed on 10/08/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 10/08/2026 12:04:02 AM EST) or Global MLS (last updated Wed 10/07/2026 8:13:38 AM EST) or New York State Alliance MLS (last updated Thu 10/08/2026 12:03:10 AM EST) or Hudson Valley Catskill Region MLS (last updated Thu 10/08/2026 12:01:14 AM EST) or Berkshire MLS (last updated Wed 10/07/2026 8:13:19 PM EST) or OneKey MLS (last updated Thu 10/08/2026 12:00:27 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder