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!
Closed
$200,000
111 Columbia Turnpike, Rensselaer, NY 12144
4beds
1,820sqft
Single Family Residence, Residential, Duplex
Built in 1948
-- sqft lot
$-- Zestimate®
$110/sqft
$1,513 Estimated rent
Home value
Not available
Estimated sales range
Not available
$1,513/mo
Zestimate® history
Owner options
List your home for rent
$1,513/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$1,513/mo
Rent Zestimate®
Refinance and save
$1,171/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$1,171/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Brick beautyHardwood floors throughoutGenerously sized roomsLarge enclosed front porch
Zillow last checked:
Listing updated:
Listed by:
Mackenzie Shannon 518-461-0792,
Realty One Group Key
Bought with:
Melissa Mitchell, 10401262208
KW Platform
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
Property
Parking
- Total spaces: 4
- Parking features: Driveway
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Exterior features: None
Lot
- Size: 9,583 sqft
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 & neighborhood
Location
- Region: Rensselaer
Price history
| Date | Event | Price |
|---|---|---|
| 4/23/2026 | Sold | $200,000-8.7%$110/sqft |
Source:  Global MLS #202529294 Report a problem | ||
| 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
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $241,000 +53.5% |
| 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
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.
- New York
- Rensselaer County
- Rensselaer
- 12144
- Hampton Manor
- 111 Columbia Turnpike
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Rensselaer Topics
