240 Brennan Road

Active

$375,000

Est: $2,231/moGet pre-approved

3 beds2 baths1,680 sqft

240 Brennan Rd, Columbia, NY 13357

Single FamilyProperty Type

9.9 acresLot Size

2006Year Built

$223/sq ftPrice per sq ft

Description

Welcome to 240 Brennan Road, Ilion—where 9.9 acres of privacy, space, and incredible potential meet the convenience of one-level living. Set back from the road and surrounded by sprawling lawns, mature trees, and beautiful countryside, this 1,680-square-foot ranch offers 3 bedrooms, 2 full bathrooms, and room to grow both inside and out. Step inside to a spacious, functional layout featuring hardwood flooring and a welcoming living room centered around a brick fireplace. The kitchen offers abundant...Welcome to 240 Brennan Road, Ilion—where 9.9 acres of privacy, space, and incredible potential meet the convenience of one-level living. Set back from the road and surrounded by sprawling lawns, mature trees, and beautiful countryside, this 1,680-square-foot ranch offers 3 bedrooms, 2 full bathrooms, and room to grow both inside and out. Step inside to a spacious, functional layout featuring hardwood flooring and a welcoming living room centered around a brick fireplace. The kitchen offers abundant cabinetry, generous counter space, and an island, flowing into the dining area for easy everyday living and entertaining. First-floor laundry adds convenience, while the primary bedroom offers its own spacious bath. The possibilities extend far beyond the main level. The partially framed basement is already plumbed for an additional half or full bathroom, creating an excellent opportunity to finish additional living space, a recreation area, guest quarters, or a potential in-law suite. Above, an expandable attic provides even more opportunity for future living space while still offering plenty of room for storage. Outside, 9.9 acres provide the privacy and freedom you've been searching for, with a combination of open lawn and wooded surroundings. Even more appealing, the lot offers subdivision potential, opening the door to additional possibilities for the next owner, subject to applicable municipal approvals. Major improvements include a new roof and a water drainage system around the home, adding value and peace of mind. With nearly 10 acres, expansion potential on multiple levels, subdivision possibilities, 3 bedrooms, 2 full baths, and 1,680 square feet of single-level living, 240 Brennan Road isn't just a home—it's a property packed with possibilities.

19 days on Market

Listed by: Brandon Mosher 315.868.4596 riverhillsbrandon@gmail.com • River Hills Properties LLC Lf

Last updated: 09/22/2026 02:02 AM • Source: New York State Alliance of MLSs (Buffalo), MLS#: S1716626

Location

Listing Courtesy of River Hills Properties LLC Lf

Add your commute

Payment Calculator

Get preapproved with Rocket Mortgage¹

$2,231 per month

30 year fixed, 7.03% Interest

Principal and Interest

$2,002

Property Taxes

$229

HOA Dues

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Property Information for 240 Brennan Road

Property Details

Taxes: $2,745 / year
MLS Type: Residential / Single Family Residence
County: Herkimer County
Architectural Style: Ranch
Has Waterfront: No

Building Information

Stories: 1
Year Built: 2006
Lot Size: 9.90 AC / 431,244 SF

Summary

Location and General Information

Cross Street: Spohn Road
Directions: Brewer Road to Sphon Road to Brennan Road

Latitude: 42.949991
Longitude: -75.057287
MLS Area Major: Columbia-212000
Has Senior Community: No
Township: Not Applicable

Taxes and HOA

Parcel Number: 212000-125-004-0001-053-300-0000
Tax Annual Amount: $2,745.00

Tax Assessed Value: 110000

School Information

Elementary School District: Mount Markham
High School District: Mount Markham

Middle Or Junior School District: Mount Markham

Parking

Garage Spaces: 0.0
Has Garage: No

Parking Features: No Garage

Virtual Tour

Virtual Tour URL Unbranded: https://www.propertypanorama.com/instaview/syr/S1716626

Property

Lot Information

Lot Features: Irregular Lot, Rural Lot
Lot Size Acres: 9.9

Lot Size Area: 9.9
Lot Size Units: Acres
Lot Size Square Feet: 431244.0

Property and Assessments

Building Area Total: 1680.0
Living Area: 1680.0

Property Condition: Resale
Property Sub Type: Single Family Residence
Property Type: Residential
Year Built: 2006
Year Built Details: Existing
Attic: Full

Building Features

Construction Materials: Vinyl Siding
Foundation Details: Poured

Levels: One
Other Structures: Sheds, Storage

Utilities

Sewer: Septic Tank
Utilities: Cable Available

Water Source: Well

Interior and Exterior Features

Interior Features

Appliances: Dishwasher, Electric Water Heater, Free Standing Range, Oven, Refrigerator
Basement: Full

Has Basement: Yes
Bathrooms Full: 2
Bathrooms Half: 0
Bathrooms Total Integer: 2
Bedrooms Total: 3
Cooling: Ceiling Fan(s)
Has Cooling: Yes
Fireplaces Total: 1
Has Fireplace: Yes
Flooring: Carpet, Hardwood, Tile, Varies, Vinyl
Heating: Propane, Forced Air
Has Heating: Yes
Interior Features: Ceiling Fans, Eat In Kitchen, Separate Formal Living Room, Kitchen Island, Other, See Remarks, Bedroom On Main Level
Laundry Features: Main Level
Main Level Bathrooms: 2
Main Level Bedrooms: 3
Rooms Total: 10
Window Features: Storm Windows, Thermal Windows, Wood Frames

Exterior Features

Exterior Features: Gravel Driveway, Propane Tank Leased
Patio And Porch Features: Open, Porch

Roof: Asphalt
Stories: 1
Stories Total: 1

Multi Family

Multi Family Information

Number Of Units Total: 0

Property History for 240 Brennan Road

Date	Event & Source	Price	Appreciation
Sep 21, 2026	Listed (Active) New York State Alliance of MLSs (Buffalo) #S1716626	$375,000	—
Sep 21, 2026	Listed (Active) Central New York Information Services #S1716626	$375,000	—
Sep 21, 2026	Listed (Active) WNYREIS #S1716626	$375,000	—
Aug 26, 2005	Sold (Public Record) Public Record #1307257056	$19,000	—

Date	Event & Source	Price
09/21/2026	Listed (Active) New York State Alliance of MLSs (Buffalo) #S1716626	$375,000
09/21/2026	Listed (Active) Central New York Information Services #S1716626	$375,000
09/21/2026	Listed (Active) WNYREIS #S1716626	$375,000
08/26/2005	Sold (Public Record) Public Record #1307257056	$19,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public records

240 Brennan Road

Beds

Baths

Total Finished SqFt

1,680 SqFt

Above Grade Finished SqFt

1,680 SqFt

Stories

Lot Size

431,244 SqFt

Schools near 240 Brennan Road

This home is within Mount Markham Central School District.


Rating	School	Type	Grades	Distance
5/10	Mount Markham Elementary School	Public - Serves this home	PK to 4	7.5 mi
3/10	Mount Markham Middle School	Public - Serves this home	5 to 8	7.7 mi
7/10	Mount Markham Senior High School	Public - Serves this home	9 to 12	7.6 mi


Rating	School	Distance
5/10	Mount Markham Elementary School PublicPK to 4 Serves this home	7.5 mi
3/10	Mount Markham Middle School Public5 to 8 Serves this home	7.7 mi
7/10	Mount Markham Senior High School Public9 to 12 Serves this home	7.6 mi

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Explore Nearby Homes

More information about 240 Brennan Road, Columbia, NY 13357

240 Brennan Road is a single family home for sale in Columbia, NY 13357. This property was listed for sale on September 21, 2026 by River Hills Properties LLC Lf, it's currently listed at $375,000. It has been on the market for a total of 19 days and was last sold on August 26, 2005. This listing's school district is Mount Markham Central School District. Nearby schools include Mount Markham Elementary School, Mount Markham Middle School and Mount Markham Senior High School. 240 Brennan Road is a 3-bed, 2-bath, 1,680 sqft single family home built in 2006.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of River Hills Properties LLC Lf

The data relating to real estate for sale on this website comes in part from the Internet Data exchange (IDX) program of the New York State Alliance MLS. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Real estate listings held by brokerage firms other than Compass and its related brokerages, are indicated by detailed information about them such as the name of the listing firms. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither the listing broker(s) nor Compass and its related brokerages shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. Copyright ©2026 New York State Alliance and participating MLS's - CNYIS, UNYREIS and WNYREIS. All Rights Reserved.

240 Brennan Rd, Columbia, NY 13357

Property Details

Building Information

Summary

Property

Interior and Exterior Features

Multi Family

Beds

Baths

Total Finished SqFt

Above Grade Finished SqFt

Stories

Lot Size

Explore Nearby Homes

Homes in Nearby Columbia Neighborhoods

Homes in Nearby Columbia Cities

Homes in Nearby Columbia Zip Codes

More information about 240 Brennan Road, Columbia, NY 13357