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.
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.
Property Details
Price:
$375,000
MLS #:
S1716626
Status:
Active
Beds:
3
Baths:
2
Type:
Single Family
Subtype:
SingleFamilyResidence
Neighborhood:
columbia212000
Listed Date:
Sep 21, 2026
Finished Sq Ft:
1,680
Total Sq Ft:
1,680
Lot Size:
431,244 sqft / 9.90 acres (approx)
Year Built:
2006
See this Listing
Schools
School District:
Mount Markham
Interior
Appliances
Dishwasher, Electric Water Heater, Free Standing Range, Oven, Refrigerator
Bathrooms
2 Full Bathrooms
Fireplaces Total
1
Flooring
Carpet, Hardwood, Tile, Varies, Vinyl
Heating
Propane, Forced Air
Interior Features
Ceiling Fans, Eat In Kitchen, Separate Formal Living Room, Kitchen Island, Other, See Remarks, Bedroom On Main Level
Laundry Features
Main Level
Levels
One
Main Level Bathrooms
2
Main Level Bedrooms
3
Exterior
Architectural Style
Ranch
Construction Materials
Vinyl Siding
Exterior Features
Gravel Driveway, Propane Tank Leased
Lot Features
Irregular Lot, Rural Lot
Other Structures
Sheds, Storage
Parking Features
No Garage
Patio And Porch Features
Open, Porch
Roof
Asphalt
Stories
1
Window Features
Storm Windows, Thermal Windows, Wood Frames
Financial
Taxes
$2,745
Map
Community
- Address240 Brennan Road Columbia NY
- CityColumbia
- CountyHerkimer
- Zip Code13357
Subdivisions in Columbia
Market Summary
Current real estate data for Single Family in Columbia as of Oct 11, 2026
7
Single Family Listed
61
Avg DOM
171
Avg $ / SqFt
$282,814
Avg List Price
Property Summary
- 240 Brennan Road Columbia NY is a Single Family for sale in Columbia, NY, 13357. It is listed for $375,000 and features 3 beds, 2 baths, and has approximately 1,680 square feet of living space, and was originally constructed in 2006. The current price per square foot is $223. The average price per square foot for Single Family listings in Columbia is $171. The average listing price for Single Family in Columbia is $282,814.
Similar Listings Nearby
Courtesy of River Hills Properties LLC Lf. Disclaimer: All data relating to real estate for sale on this page comes from the Broker Reciprocity (BR) of the New York State Alliance of MLSs. Detailed information about real estate listings held by brokerage firms other than Michael Paduano include the name of the listing broker. Neither the listing company nor Michael Paduano shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. The Broker providing this data believes it to be correct, but advises interested parties to confirm any item before relying on it in a purchase decision. Copyright 2026. New York State Alliance of MLSs. All rights reserved. 240 Brennan Road
Columbia, NY

