Login

209 Columbia Turnpike #4, Hampton Manor, NY 12144

Local realty services provided by:CENTURY 21 North East
209 Columbia Turnpike #4,East Greenbush, NY 12144
$400,000
  • 4 Beds
  • 4 Baths
  • 2,640 sq. ft.
  • Multi-family
  • Active
Listed by: joyce brown
Office: howard hanna capital inc
MLS#:202530943
Source:Global MLS

Price summary

  • Price:$400,000
  • Price per sq. ft.:$151.52

About this home

Calling investors and owner-occupants — location, location, location! This 4-unit mixed-use brick property sits on a high-traffic corridor in Rensselaer with excellent visibility. Featuring two large parking lots, separate electric meters, and decades of family ownership with solid maintenance. All units are currently rented, offering upside potential. The spacious #2 unit (approx. 1,300 sq ft) is ideal for an owner-occupant or a premium rental, while additional highlights include hardwood floors, an enclosed back porch, a large cleared rear lot, Window World windows, and an 11-year-old furnace. Conveniently located minutes from Albany, the train station, major highways, restaurants, and bus lines — a turnkey opportunity for investors or owner-occupants looking to build long-term value heading into 2026. For financing questions or to explore loan options that fit this property, contact: Christian Gonzalez-Borrero Licensed Mortgage Loan Officer | Haus Capital Corp. Cell

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an independent agent affiliated with the CENTURY 21®  brand to contact me about my real estate needs. By clicking Send message, 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 an independent agent affiliated with the CENTURY 21®  brand 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® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:1950
  • Listing ID #:202530943
  • Added:4 day(s) ago
  • Updated:December 23, 2025 at 03:20 PM

Rooms and interior

  • Bedrooms:4
  • Total bathrooms:4
  • Full bathrooms:2
  • Half bathrooms:2
  • Living area:2,640 sq. ft.

Heating and cooling

  • Heating:Natural Gas

Structure and exterior

  • Roof:Asbestos Shingle
  • Year built:1950
  • Building area:2,640 sq. ft.
  • Lot area:0.41 Acres

Schools

  • High school:Columbia
  • Elementary school:Red Mill

Utilities

  • Water:Public
  • Sewer:Public Sewer

Finances and disclosures

  • Price:$400,000
  • Price per sq. ft.:$151.52
  • Tax amount:$7,644
The information being provided by Global 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.  © 2025 Global MLS All rights reserved.

New listings near 209 Columbia Turnpike #4