Centrally located to Albany and 5 minutes from the Rensselaer rail station, this property is a great investment opportunity! Currently being utilized to a 2-family, but could easily be converted back to a single family if desired.
The downstairs kitchen has been gutted, and ready for the new owners finishing touches, and also has a large enclosed front porch. While the upstairs offers generously sized rooms, and hardwood floors throughout.
Tons of potential in this brick beauty just waiting to be unlocked!
Pending
$219,000
111 Columbia Turnpike, Rensselaer, NY 12144
4beds
1,820sqft
Single Family Residence, Residential, Duplex
Built in 1948
-- sqft lot
$-- Zestimate®
$120/sqft
$-- HOA
What's special
Brick beautyHardwood floors throughoutGenerously sized roomsLarge enclosed front porch
- 44 days |
- 84 |
- 1 |
Zillow last checked: 7 hours ago
Listing updated: March 03, 2026 at 06:35am
Listing by:
Realty One Group Key 518-630-5360,
Mackenzie Shannon 518-461-0792
Source: Global MLS,MLS#: 202529294
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: Second
Bedroom
- Level: First
Den
- Level: First
Dining room
- Level: First
Kitchen
- Level: First
Kitchen
- Level: Second
Heating
- Oil
Cooling
- None
Appliances
- Included: Electric Oven, Refrigerator, Washer/Dryer
- Laundry: In Basement
Features
- Flooring: Wood
- Basement: Unfinished
Interior area
- Total structure area: 1,820
- Total interior livable area: 1,820 sqft
- Finished area above ground: 1,820
- Finished area below ground: 0
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Driveway
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Exterior features: None
Lot
- Size: 9,583.2 Square Feet
Details
- Parcel number: 382400 155.9119.2
- Special conditions: Standard
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential, Duplex
- Attached to another structure: Yes
Materials
- Brick
- Roof: Slate
Condition
- New construction: No
- Year built: 1948
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Rensselaer
Financial & listing details
- Price per square foot: $120/sqft
- Tax assessed value: $208,278
- Annual tax amount: $7,429
- Date on market: 2/24/2026
Estimated market value
Not available
Estimated sales range
Not available
$1,541/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 3/3/2026 | Pending sale | $219,000$120/sqft |
Source:  Global MLS #202529294 Report a problem | ||
| 2/24/2026 | Listed for sale | $219,000$120/sqft |
Source: Global MLS #202529294 Report a problem | ||
| 2/12/2026 | Pending sale | $219,000$120/sqft |
Source: Global MLS #202529294 Report a problem | ||
| 2/12/2026 | Listed for sale | $219,000$120/sqft |
Source: Global MLS #202529294 Report a problem | ||
| 11/17/2025 | Pending sale | $219,000$120/sqft |
Source: Global MLS #202529294 Report a problem | ||
| 11/8/2025 | Listed for sale | $219,000$120/sqft |
Source: Global MLS #202529294 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $157,000 |
| 2023 | -- | $157,000 |
| 2022 | -- | $157,000 |
| 2021 | -- | $157,000 |
| 2020 | -- | $157,000 |
| 2019 | -- | $157,000 |
| 2018 | -- | $157,000 -10.3% |
| 2017 | $5,743 | $175,100 |
| 2016 | -- | $175,100 |
| 2015 | -- | $175,100 |
| 2014 | -- | $175,100 |
| 2013 | -- | $175,100 +1.9% |
| 2012 | -- | $171,800 |
| 2011 | -- | $171,800 |
| 2010 | -- | $171,800 -4% |
| 2009 | -- | $179,000 |
| 2008 | -- | $179,000 +344.2% |
| 2007 | -- | $40,300 |
| 2006 | -- | $40,300 |
| 2005 | -- | $40,300 |
| 2004 | -- | $40,300 |
| 2003 | -- | $40,300 |
| 2002 | -- | $40,300 |
| 2001 | -- | $40,300 |
| 2000 | -- | $40,300 |
Find assessor info on the county website
Monthly payment
Estimated monthly payment
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.7 mi
- 7/10Howard L Goff SchoolGrades: 6-8Distance: 2.7 mi
- 8/10Columbia High SchoolGrades: 9-12Distance: 2.4 mi
Schools provided by the listing agent
- 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.
Local experts in 12144
- New York
- Rensselaer County
- Rensselaer
- 12144
- Hampton Manor
- 111 Columbia Turnpike
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Rensselaer Topics
