#S1622166, Brandon Mosher, Listing office: River Hills Properties LLC Lf
395 Brennan Rd Columbia, NY 13357
Property details
About 395 Brennan Rd
Tucked away on 7.8 gently rolling acres, 395 Brennan Road offers a rare combination of privacy, functionality, and character. This 1,120-square-foot home features 2 bedrooms and 1.5 bathrooms, providing a comfortable and manageable layout ideal for year-round living or a peaceful country getaway. Step inside to discover bright, welcoming spaces anchored by a dramatic spiral staircase that leads to the second level, creating a unique architectural centerpiece. The main floor includes a spacious kitchen with plenty of cabinetry and workspace, flowing into the dining and living areas—perfect for everyday living and entertaining. Large windows bring in natural light and views of the surrounding acreage. The two bedrooms are thoughtfully separated for privacy, and the one full bathroom and one half bathroom offer convenience for family and guests. Whether you need space for a home office, hobby room, or guest accommodations, this home provides flexibility to suit your needs. A standout feature is the oversized three-stall garage, offering abundant storage for vehicles, tools, outdoor gear, or workshop space. The acreage itself is a canvas for your imagination—plant a garden, add a patio or fire pit, raise animals, or simply enjoy the open space and serenity. Located just minutes from Ilion village, you’ll have easy access to shopping, dining, schools, and major routes while still enjoying a peaceful, country setting. Whether you’re seeking a place to slow down and savor the outdoors or a property with room to expand and create, 395 Brennan Road delivers the opportunity to live the lifestyle you’ve been dreaming of.
Highlights
(Pending)
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 1
- Appliances: Electric Water Heater, Microwave, Refrigerator
- Flooring Type: Carpet, Varies, Vinyl
- Interior: Eat-in Kitchen, Separate/Formal Living Room, Bedroom on Main Level
- Total Bedroom Count: 2
- Garage Space: 3 spaces
- Attached Garage: No
- Parking: Detached, Garage
- Exterior: Deck, Gravel Driveway
- Architectural Style: Two Story
- Heating: Electric, Baseboard, Hot Water
- List Price: $175,000
- Price/SqFt: $156
- Lot: Irregular Lot, Rural Area
- Directions: Spohn Road to Brennan Road
- Year Built: 1976
- Living Area: 1,120 SqFt
- Lot Size: 7.8 Acres
- MLS Number: S1622176
- MLS Name: NYS
- Office Name: River Hills Properties LLC Lf
- Office Phone: (315) 502-5268
- Office Email: realestatebyrobin@gmail.com
- Listing Agent: Brandon Mosher
The data relating to real estate on this website comes in part from the Internet Data Exchange (IDX) Program of NYSAMLS’s. Real estate listings held by other firms are marked with theListing Broker’s Firm Name. Data provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties that consumers may be interested in purchasing. 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 this firm shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally
harmless.
© 2025 CNYIS, UNYREIS, WNYREIS. All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 7/24/2025, 10:45:30 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
4
Barringer Road Elementary School
Public District 2-4
3.6 mi
•326 Barringer Rd
4
Frankfort-Schuyler Elementary School
Public District PK-5
4.9 mi
•610 Reese Rd
4
Herkimer Elementary School
Public District PK-5
7.2 mi
•255 Gros Blvd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $68,167. Residents of Columbia, NY typically earn between $35k-100k each year. The most common type of family is married, no kids. The majority of residents in this area have high school diploma education.
Similar homes for sale
Frequently asked questions
About 395 Brennan Rd
The listing price of 395 Brennan Rd property is $175,000.
The property 395 Brennan Rd is a house located in Columbia, New York, 13357.
Sale Pending: 395 Brennan Rd is Sale Pending (Pending), which means that the seller has accepted an offer but the sale is not finalized.
The nearby schools for 395 Brennan Rd are: Barringer Road Elementary School (GreatSchools Rating 4/10), Frankfort-Schuyler Elementary School (GreatSchools Rating 4/10), Herkimer Elementary School (GreatSchools Rating 4/10), Gregory B Jarvis Middle School (GreatSchools Rating 4/10), Frankfort-Schuyler Middle School (GreatSchools Rating 4/10), Mount Markham Middle School (GreatSchools Rating 3/10), Central Valley Academy (GreatSchools Rating 5/10), Frankfort-Schuyler Central High School (GreatSchools Rating 6/10), Herkimer High School (GreatSchools Rating 4/10).
The property at 395 Brennan Rd has 2 bedrooms and 1 full and 1 half bathrooms.
The property 395 Brennan Rd is 1,120 SqFt (source: MLS/tax record).
The year of construction for 395 Brennan Rd is 1976.
This home is located at 395 Brennan Rd in Columbia, NY and zip code 13357. This 1,120 square foot home, which was built in 1976, sits on a 7.80 acre lot. Features: 2 bedrooms, 2 bathrooms. It has been listed on Rocket Homes since July 13, 2025 and is currently priced at $175,000.