240 Brennan Road
Columbia, NY, 13357 $ 375,000
Bedrooms3 Baths2.0 Sq 1,680 Monthly Estimate*
$ 2,368
for $375,000 with 3 bedrooms and 2 full baths. This 1,680 square foot home was built in 2006 on a lot size of 9.9.
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.
See more
FeaturesInteriorInterior Amenities CeilingFans EatInKitchen SeparateFormalLivingRoom KitchenIsland Other SeeRemarks BedroomOnMainLevel
Basement Full
Flooring Carpet Hardwood Tile Varies Vinyl
Total Fireplaces 1
Total Stories 1
Basement (Y/N) Yes
Heating Y/N Yes
Window Features StormWindows ThermalWindows WoodFrames
Fireplace Y/N Yes
Half Baths 0
Laundry Features MainLevel
Total Bedrooms 3
Main Level Bedrooms 3
Main Level Bathrooms 2
Total Baths 2
See more
GeneralSewer SepticTank
Heating Propane ForcedAir
Utilities CableAvailable
Possession Closing
Roof Asphalt
Appliances Dishwasher ElectricWaterHeater FreeStandingRange Oven Refrigerator
Garage Spaces 0.0
Patio/Porch Features Open Porch
Architectural Style Ranch
Construction Materials VinylSiding
School District Mount Markham
Year Built 2006
Stories Count 1
Township Not Applicable
Levels One
Property Subtype SingleFamilyResidence
County Herkimer
Property Type Residential
Garage Y/N No
Other Structures Sheds Storage
Total Rooms 10
Full Baths 2
Status Active
Directions Brewer Road to Sphon Road to Brennan Road
City Columbia
Senior Community Y/N No
High School District Mount Markham
Number Of Units Total 0
MLS Area Columbia-212000
Lot Size Units Acres
Lot Size Square Feet 431244.0
Year Built Details Existing
Tax Annual Amount 2745.0
Property Condition Resale
Virtual Tour https://www.propertypanorama.com/instaview/syr/S1716626
Standard Status Active
Middle/Junior School District Mount Markham
Elementary School District Mount Markham
Tax Assessed Value 110000
TaxOtherAnnualAssessmentAmount 0.0
Tax Lot 53
See more
ExteriorExterior Amenities GravelDriveway PropaneTankLeased
Parking Features NoGarage
Lot Features IrregularLot RuralLot
Water Source Well
Lot Size Area 9.9
Foundation Details Poured
Building Area Total 1680.0
Lot Size Acres 9.9
Waterfront Y/N No
See more
* Excluded FeaturesList ByRiver Hills Properties Llc LfBroker
Affordability Calculator
- Monthly Principal & Interest
- $2,368
- Monthly Property Taxes
- $229
- Monthly Home Insurance
- --
Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save NearbySingle family listings in Columbia, NY
Average List Price $282,814
Percent of Sale Price 25%
About Columbia, NY 1,559 Population
-4% Since 2002
$ 56,364 Median Income
46.45 Median Age
24% Households with Children
Trends Information provided by ATTOM Data Solutions.
3040956 Elementary School
3040889 Middle School
Unknown High School High School
Pricing History| Date | Price | Price Change | Description |
|---|
| 9/22/2026 | $375,000 | | Listed Price |