$219,000
PENDING

111 Columbia Turnpike Rensselaer, NY 12144

Estimated payment $1,771/month

Total Views 3,999
4 Beds
1.5 Baths
1,820 Sq Ft
$120 Price per Sq Ft

Highlights

  • Traditional Architecture
  • Wood Flooring
  • Den
  • Red Mill School Rated A
  • No HOA
  • Bathroom on Main Level

About This Home

***MULTIPLE OFFERS RECEIVED*** Centrally located to Albany and 5 minutes from the Rensselaer rail station, this property is a great investment opportunity! Currently converted 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!

Listing Agent

Mackenzie Shannon

Realty One Group Key License #10401345052 Listed on: 11/08/2025

Realty One Group Key

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,429

Year Built

  • Built in 1948

Lot Details

  • 9,583 Sq Ft Lot

Parking

  • 2 Car Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slate Roof

Interior Spaces

  • 1,820 Sq Ft Home
  • Dining Room
  • Den
  • Wood Flooring
  • Unfinished Basement
  • Laundry in Basement
  • Electric Oven
  • Washer and Dryer

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Bathroom on Main Level

Schools

  • Columbia High School

Utilities

  • No Cooling
  • Heating System Uses Oil

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Legal Lot and Block 19.002 / 1
  • Assessor Parcel Number 382400 155.9-1-19.2

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,429

Year Built

Built in 1948

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 1948
  • Directions: From downtown Albany, home is on left side of Columbia Tnpke
  • Above Grade Finished Sq Ft: 1820.0
  • Architectural Style: Duplex-Over/Under, Traditional
  • Lot Size Acres: 0.22
  • New Construction: No
  • Parking Features Parking Total: 4.0
  • Garage Yn: Yes
  • Appliances Refrigerators: Yes
  • Flooring:Wood: Yes
  • Laundry Features:In Basement: Yes
  • Architectural Style:Traditional: Yes
  • Directions Remarks: Agent to Agent Remarks: Garage is currently rented to a cleaning company, and has water hook up. Please do not disturb anything in the garage when looking around. The downstairs unit underwent a complete mold remediation due to the previous tenants hoarding.
  • Directions Remarks: Public Remarks: ***MULTIPLE OFFERS RECEIVED*** Centrally located to Albany and 5 minutes from the Rensselaer rail station, this property is a great investment opportunity! Currently converted 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!
  • Special Features: None

Interior Features

  • Flooring: Wood
  • Basement: Unfinished
  • Appliances: Electric Oven, Refrigerator, Washer/Dryer
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Living Area: 1820.0
  • Bedroom Level: Second
  • Den Level: First
  • Dining Room Level: First
  • Kitchen Level: First
  • Bathroom Levels Full Bathroom 1: 2nd
  • Bathroom Levels Half Bathroom 1: 1st
  • Appliances:WasherDryer: Yes
  • Appliances:Electric Oven: Yes
  • Basement:Unfinished: Yes

Exterior Features

  • Exterior Features: None
  • Roof: Slate
  • Construction Type: Brick
  • Waterfront: No
  • Exterior Features:None37: Yes
  • Construction Materials:Brick: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Driveway
  • Attached Garage: No
  • Total Parking Spaces: 4.0
  • Property Detail:Garage Spaces: 2.0
  • Property Detail:Parking YN: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Garage: Yes

Utilities

  • Sewer: Public Sewer
  • Cooling: None
  • Heating: Oil
  • Laundry Features: In Basement
  • Water Source: Public
  • Cooling Y N: No
  • Heating Yn: Yes
  • Heating:Oil: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Parcel Tax HOA:Association YN: No

Schools

  • Junior High Dist: East Greenbush

Lot Info

  • Parcel #: 382400 155.9-1-19.2
  • Lot Size Sq Ft: 9583.2

Tax Info

  • Tax Annual Amount: 7429.42
  • Tax Block: 1
  • Tax Lot: 19.002

MLS Schools

  • HighSchool: Columbia

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $5,332 $157,000 $20,000 $137,000
2023 $5,415 $157,000 $20,000 $137,000
2022 $5,481 $157,000 $20,000 $137,000
2021 $5,538 $157,000 $20,000 $137,000
2020 $4,992 $157,000 $20,000 $137,000
2019 $5,016 $157,000 $20,000 $137,000
2018 $5,016 $157,000 $20,000 $137,000
2017 $5,842 $175,100 $22,000 $153,100
2016 $5,659 $175,100 $22,000 $153,100
2015 -- $175,100 $22,000 $153,100
2014 -- $175,100 $22,000 $153,100
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/17/2025 11/17/25 Pending -- -- --
11/08/2025 11/08/25 For Sale $219,000 -- $120 / Sq Ft
Source: Global MLS

Source: Global MLS

MLS Number: 202529294

Global MLS

APN: 2400-155.9-1-19.2