Calling investors. This 4-unit brick property sits on a high-traffic corridor in East Greenbush with excellent visibility. Featuring large parking lot on right side and outside of garage. separate electric meters, and decades of family ownership with solid maintenance. Three units are currently rented. The largest apartment is 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
Claudia Premium Mortgage , 518 265- 9756 to get pre approved.
Pending
$400,000
209 Columbia Turnpike #4, Rensselaer, NY 12144
4beds
2,640sqft
Quadruplex, Multi Family
Built in 1950
-- sqft lot
$388,900 Zestimate®
$152/sqft
$-- HOA
What's special
Large parking lotWindow world windowsHardwood floorsLarge cleared rear lotEnclosed back porch
- 155 days |
- 41 |
- 0 |
Zillow last checked:
Listing updated:
Listed by:
Howard Hanna Capital Inc 518-371-4500,
Joyce Brown 518-596-5835
Source: Global MLS,MLS#: 202530943
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 2
- 1/2 bathrooms: 2
Heating
- Natural Gas
Cooling
- None
Appliances
- Laundry: In Basement
Features
- Flooring: Hardwood
- Basement: Full,Heated,Unfinished,Walk-Out Access
Interior area
- Total structure area: 2,640
- Total interior livable area: 2,640 sqft
- Finished area above ground: 2,640
- Finished area below ground: 0
Property
Parking
- Total spaces: 12
- Parking features: Off Street, Garage
- Garage spaces: 1
Features
- Exterior features: None
Lot
- Size: 0.41 Acres
Details
- Parcel number: 382400 155.13183
- Special conditions: Other
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Traditional
- Property subtype: Quadruplex, Multi Family
- Attached to another structure: Yes
Materials
- Brick
- Roof: Asphalt
Condition
- Year built: 1950
Utilities & green energy
- Electric: Fuses
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Rensselaer
Financial & listing details
- Price per square foot: $152/sqft
- Annual tax amount: $7,644
- Date on market: 2/1/2026
- Ownership: Mix use
- Tenant pays: Hot Water, Cable TV, Electricity
Estimated market value
$388,900
$369,000 - $408,000
$1,789/mo
Price history
| Date | Event | Price |
|---|---|---|
| 2/21/2026 | Pending sale | $400,000$152/sqft |
Source: | ||
| 2/1/2026 | Listed for sale | $400,000$152/sqft |
Source: | ||
| 1/24/2026 | Pending sale | $400,000$152/sqft |
Source: | ||
| 12/18/2025 | Listed for sale | $400,000$152/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: Hampton Manor
Nearby schools
GreatSchools rating
- 7/10Red Mill SchoolGrades: PK-5Distance: 0.5 mi
- 7/10Howard L Goff SchoolGrades: 6-8Distance: 2.2 mi
- 8/10Columbia High SchoolGrades: 9-12Distance: 2.2 mi
Schools provided by the listing agent
- Elementary: Red Mill
- High: Columbia
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- New York
- Rensselaer County
- Rensselaer
- 12144
- Hampton Manor
- 209 Columbia Turnpike Unit 4




