240 Brennan Road Columbia, NY $ 375,000
240 Brennan Road
$ 375,000
Recently Listed
Share Save

240 Brennan Road

Columbia, NY, 13357
$ 375,000
Bedrooms3 Baths2.0 Sq 1,680

Monthly Estimate*

$ 2,368

240 Brennan Road, Columbia, NY 13357 - Image 1
240 Brennan Road, Columbia, NY 13357 - Image 2
240 Brennan Road, Columbia, NY 13357 - Image 3
240 Brennan Road, Columbia, NY 13357 - Image 4
240 Brennan Road, Columbia, NY 13357 - Image 5
240 Brennan Road, Columbia, NY 13357 - Image 6
240 Brennan Road, Columbia, NY 13357 - Image 7
240 Brennan Road, Columbia, NY 13357 - Image 8
240 Brennan Road, Columbia, NY 13357 - Image 9
240 Brennan Road, Columbia, NY 13357 - Image 10
240 Brennan Road, Columbia, NY 13357 - Image 11
240 Brennan Road, Columbia, NY 13357 - Image 12
240 Brennan Road, Columbia, NY 13357 - Image 13
240 Brennan Road, Columbia, NY 13357 - Image 14
240 Brennan Road, Columbia, NY 13357 - Image 15
240 Brennan Road, Columbia, NY 13357 - Image 16
240 Brennan Road, Columbia, NY 13357 - Image 17
240 Brennan Road, Columbia, NY 13357 - Image 18
240 Brennan Road, Columbia, NY 13357 - Image 19
240 Brennan Road, Columbia, NY 13357 - Image 20
240 Brennan Road, Columbia, NY 13357 - Image 21
240 Brennan Road, Columbia, NY 13357 - Image 22
240 Brennan Road, Columbia, NY 13357 - Image 23
240 Brennan Road, Columbia, NY 13357 - Image 24
240 Brennan Road, Columbia, NY 13357 - Image 25
240 Brennan Road, Columbia, NY 13357 - Image 26
240 Brennan Road, Columbia, NY 13357 - Image 27
240 Brennan Road, Columbia, NY 13357 - Image 28
240 Brennan Road, Columbia, NY 13357 - Image 29
240 Brennan Road, Columbia, NY 13357 - Image 30
240 Brennan Road, Columbia, NY 13357 - Image 31
240 Brennan Road, Columbia, NY 13357 - Image 32
240 Brennan Road, Columbia, NY 13357 - Image 33
240 Brennan Road, Columbia, NY 13357 - Image 34
240 Brennan Road, Columbia, NY 13357 - Image 35
240 Brennan Road, Columbia, NY 13357 - Image 36
240 Brennan Road, Columbia, NY 13357 - Image 37
240 Brennan Road, Columbia, NY 13357 - Image 38
240 Brennan Road, Columbia, NY 13357 - Image 39
240 Brennan Road, Columbia, NY 13357 - Image 40
240 Brennan Road, Columbia, NY 13357 - Image 41
240 Brennan Road, Columbia, NY 13357 - Image 42
240 Brennan Road, Columbia, NY 13357 - Image 43
240 Brennan Road, Columbia, NY 13357 - Image 44
240 Brennan Road, Columbia, NY 13357 - Image 45
240 Brennan Road, Columbia, NY 13357 - Image 46
240 Brennan Road, Columbia, NY 13357 - Image 47
240 Brennan Road, Columbia, NY 13357 - Image 48
240 Brennan Road, Columbia, NY 13357 - Image 49
240 Brennan Road, Columbia, NY 13357 - Image 50
View a Virtual Tour

Single Family Home for sale in Columbia, NY

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

Single Family Active

Price

$ 375,000

Bedrooms

3

Full Bath

2

Property Type

Single Family

Taxes

$ 2,745

Style

Ranch

Lot Size

9.9

Year Built

2006

Town/City

Columbia

County/Region

Herkimer

MLS | Web ID

S1716626

Features
Interior
Interior 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
General
Sewer 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
Exterior
Exterior 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
Internal Only
Street Number 1 240
See more
* Excluded Features
List By
River Hills Properties Llc Lf

Broker

(315) 868-4596

Phone

Affordability Calculator

$2,597
Per Month
91%
9%
0%
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

Discover how much house you can afford

Your dream home may be within reach.

Learn More about how to save

The time to sell is now
THE TIME TO SELL IS NOW! What's my home worth?
Nearby
3040956 Elementary School
3040889 Middle School
Unknown High School High School
Pricing History
DatePricePrice ChangeDescription
9/22/2026$375,000 Listed Price

Map


See all

240 Brennan Road, Columbia, NY, 13357 is a Single Family Home for sale at $375,000 with 1,680 sqft and a lot size of 9.9. 240 Brennan Road has 3 bedrooms, 2.0 baths, and was built in 2006. The property's zip code is 13357 which is in Columbia, NY