Barns & Farms Realty LLC

Columbia County Real Estate

Homes Land Farms Estates Commercial

We list and sell Columbia County real estate, homes, land, commercial in Columbia and adjoining counties.
Visit the most visible Columbia County Real Estate Broker, Barns & Farms Realty LLC with four offices. Click below

Hudson(518)822-0226, the center for Hudson Valley Real Estate
Chatham(518)392-6400, the center for Northern Columbia County Real Estate Brokers
Ancram-Taghkanic(518)851-7727 for Southern Columbia County and Dutchess County
Hillsdale(518)325-3111, the gateway to the Berkshires.

We list and sell Columbia County Real Estate through 3 specialized divisions. Luxury Homes and Estates (including Farms & Waterfront Properties). Hudson Valley Commercial Real Estate (including multifamily properties). and Hudson Valley Land Experts. We sell more land than any other broker in the Hudson Valley.

Barns & Farms Realty LLC is part of the Hudson Valley Real Estate Network, the Hudson Valley’s largest grouping of independent brokers. It participates in HVREAL.COM the Hudson Valley’s only specialized real estate website with links to 8 Multiple List Systems. We have affiliates in Dutchess, Ulster, Berkshire, Albany, Rennselaer and Schoharie Counties.

Like us on Facebook Like us on Facebook

OUR FEATURED COLUMBIA COUNTY REAL ESTATE LISTINGS: FIND BELOW OR CALL (800)398-8802

FOR INFORMATION ABOUT PURCHASING AND SELLING COLUMBIA COUNTY REAL ESTATE CLICK BELOW

IF YOU PREFER TO SEARCH THE MULTIPLE LIST SYSTEMS IN THE HUDSON VALLEY DIRECTLY, CLICK BELOW

 

Columbia-Greene-Northern Dutchess MLS
Ulster County MLS
Mid Hudson(Dutchess) MLS

Delaware, Otsego, Chanango MLS

Greater Hudson Valley MLS
(Westchester, Rockland, Orange)

Berkshire County MLS

Greater Capital Region MLS
(Albany, Rensselaer, Saratoga, Schoharie)

Sullivan County MLS

 

LUXURY HOMES & ESTATES & FARMS
Click Here to Go Directly to Commercial/Multifamily or Vacant Land

 

Columbia County Real Estate, Historic Colonial Mansion, 8 Turner Mews, Wappingers, NY 12590

Historic Colonial Mansion
8 Turner Mews
Wappingers, NY 12590

Historic Colonial Mansion, 8 Turner Mews, Wappingers, NY 12590
$1,750,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Dutchess Historic Colonial is a 1700s pre-revolutionary mansion which has undergone several major renovations. It is a true Center Hall Colonial with a marble floor and 9 foot high ceilings on 16+ acres.. It has six fireplaces, 5 or 6 bedrooms with maid’s quarters above the kitchen. The living room has a working fireplace with wide planked floors, lighted bay windows, covered beams and plaster walls. The 2230 den has wide plank floors, a large fireplace and an unusual sunket 10 foot wet bar. It also has exposed brick walls exposed beam and hand hewn pillars. The dining room is 1915 with plaster walls, crown moldings, a fireplace, hardwood floors and pocket doors. The kitchen is 3030 with a marble floor and radiant heat. It has a large fireplace with a Dutch oven. It has brick walls, hand hewn beams, a south wall of windows, cherry cabinets. It has a wooden ceiling with hand hewn beams, in wall oven, central isle and corrian counters.
Click HERE to view more details.

Agent Name: David Birch, Brokerage: Ancram, Cell Number: (518)928-7239

Columbia County Real Estate Ancram 3500sf Retreat Secluded Glass, 2400 Doodletown Road, Ancram, NY 12502

Ancram 3500sf Retreat Secluded Glass
2400 Doodletown Road
Ancram, NY 12502

Ancram 3500sf Retreat Secluded Glass, 2400 Doodletown Road, Ancram, NY 12502

$1,495,000

Ancram 3500sf Retreat Secluded Glass. This spectacular home with views from every room has 4 or 5 BR with spacious master suite on 1st floor, overlooks stone walls, specimen trees, English gardens and 1 acre spring fed swimming pond for fishing and ice skating, open kitchen/living/dining room with shared fireplace, conservatory and screened in porch with great views, 20 x 40 gunite heated pool, 6 person hot tub and croquet court on 53 acres.
Click HERE to view more details.
Agent Name: David Birch, Brokerage: Ancram, Cell Number: (518)928-7239

 

Columbia County Real Estate, Jewel of Hudson 522 Warren St, Hudson, NY 12534

Jewel of Hudson
522 Warren St
Hudson, NY 12534

Jewel of Hudson 522 Warren St, Hudson 12534
$1,300,000

This jewel of Hudson is on the best block right net door to City Hall. Designer quality updates with the finest materials and appliances. Great light and views from all three levels. Pass through the ultra modern kitchen to a covered outdoor dining area overlooking a manicured ivy walled garden complete with a waterfall and fountain, as well as a heated carriage house with and upper level iron balcony, imported from France. The main structure third level is accessed by a spiral staircase to vaulted, sky-lighted gallery and media room, also to the master suite. Each level has its own meter, gas heat, and air conditioning units. upgrades throughout, as well as tilt in thermo windows, and recent new roof.
Click HERE to view more details.

Agent Name: Bob Kavanaugh, Brokerage: Hudson, Cell Number: (518)821-1512

 

Columbia County Real Estate, Scenic Catskill Views, 132 Lockwood Livingston, NY 12534

Scenic Catskill Views
132 Lockwood Livingston
NY 12534

Scenic Catskill Views, 132 Lockwood Livingston, NY 12534
$1.102,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Livingston NY Farm, a 147 acre parcel with full Catskill views open and wooded. Ideal for estate. Consists of 3 subdivided parcels each with its own access; 80 acres, 38 acres and 27 acres. There are some delineated wetlands.Ideal for family compound or small development. Lots may be purchased separately. Multiple access points.
Click HERE to view more details.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

 

Columbia County luxury homes Cozy Slice of Americana 271 Shaker Ridge Drive, Canaan, NY 12029

Cozy Slice of Americana
271 Shaker Ridge Dr, Canaan, NY 12029

Americana Includes Museum Quality Collection 4000sq ft, 271 Shaker Ridge Drive, Canaan 12029
$750,000

Columbia County Luxury Homes, Canaan Americana Museum Quality. First time on the market this 3 story 4000SF 5 BR 5 BA home is chock full of original Americana collected from all over the United States over a 50 year period. A 40 x 20 living room, a dining room with bar, 20 x 20 kitchen, 20x 12 porch, 5 large bedrooms, chair lift for handicap accessibility on 6 acres in upscale development.

Click HERE to view more details
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

Columbia County Luxury Homes 3 Living Spaces 439 Shaker Ridge Dr, Canaan, NY 12029

3 Living Spaces
439 Shaker Ridge Dr, Canaan, NY 12029

3 Living Spaces 439 Shaker Ridge Dr, Canaan, NY 12029
$589,000

Columbia County Luxury Homes, Canaan 4400 SF Upscale Development. This 6 bedroom 2 bath contemporary has a large master bedroom + 2 other bedrooms with a kitchen and dining room on main level. 4 bedrooms downstairs with family room, play room and bar lots of entertaining space all on 5.8 Acres.

Click HERE to view more details
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

 

Columbia County real estate, 23 Acre Farmland, 1205 County Rte 8, Clermont, NY 12571

23 Acre Farmland
1205 County Rte 8
Clermont, NY 12571

23 Acre Farmland, 1205 County Rte 8, Clermont, NY 12571
$399,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Clermont Farm, 2 houses, 2 barns on 23 acres, open and wooded, good farmland, current rent roll is $2695/month.
Click HERE to view more details.
Agent Name: David Birch, Brokerage: Ancram, Cell Number: (518)928-7239

Columbia County Real Estate Cairo NY Colonial Mountain View, 215 Germans Hill Road, Freehold, NY 12431

Cairo NY Colonial Mountain View
215 Germans Hill Road
Freehold, NY 12431

Cairo NY Colonial Mountain View, 215 Germans Hill Road, Freehold, NY 12431

$385,000

Cairo NY Colonial Catskill Mountain View, secluded 3400 sf home with 5 BR, huge master suite, 2 car garage, decks, entertaining kitchen, great room with stone fireplace, 3 season enclosed porch on 6 + acres, pond, pool.
Click HERE to view more details.

Agent Name: David Birch, Brokerage: Ancram, Cell Number: (518)928-7239

 

Dramatic Lakefront Views - Columbia County Real Estate Broker

Dramatic Lakefront Views
1264 Lakeview Rd
Copake, NY 12516

Dramatic Lakefront Views, 1264 Lakeview Rd, Copake, NY 12516
$375,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Taconic Shores Lakefront Home. This 3 bedroom 2 bath home on a private lake has a deck overlooking the water. In addition there is a screened in porch and private dock for boating and swimming.
Click HERE to view more details.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

 

Columbia County Affordable Homes

Secluded Ranch, 57 Cottontail Rd Ancram, NY 12502
$249,000

Secluded ranch in wooded rural setting on shared private road, 2BR2BA plus attached garage, convenient to Pine Plains.
Click HERE to view more details.
Agent Name: David Birch, Brokerage: Ancram, Cell Number: (518)928-7239

 

 

Columbia County Affordable Homes Ranch on 2 Acres, 295 Tunnel Hill Rd Canaan, NY 12029

Ranch on 2 Acres
295 Tunnel Hill Rd
Canaan NY 12029

Ranch on 2 Acres, 295 Tunnel Hill Rd Canaan, NY 12029
$184,000

Canaan NY Ranch 2 Acres. This Ranch Style 2BR home with 2baths and a possible 3rd bedroom on lower level, workshop. Lovely covered porch, a field for horse or large garden.
Click HERE to view more details.
Agent Name: David Birch, Brokerage: Ancram, Cell Number: (518)928-7239

Click on the Links Below to View More Properties From Each Category:

Luxury Homes
Estates
Farms
Affordable Homes

(Under $300,000)

 

Commercial/Multifamily

Adaptable Opportunity, 343 Rte 295 Chatham, NY 12037

Adaptable Opportunity, 343 Rte 295 Chatham, NY 12037

Adaptable Opportunity, 343 Rte 295 Chatham, NY 12037
$2,900,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Stonykill Creek Property, an unbelievable combined industrial, commercial and residential opportunity. With 200+ acres and 120,00 SF multiple buildings, warehouse, industrial and office space. It also has a railroad siding and is 5 minutes from I-90, NYS Thruway and Mass Turnpike. Owner is willing to divide property.
Click HERE to view more details.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

 

Columbia County commercial properties

Solar Neutral on 3 Acres
344 Route 295
Chatham, NY 12037

Solar Neutral on 3 Acres, 344 Route 295, Chatham, NY 12037
$900,000

Columbia County commercial properties, Chatham 20,000Sf Solar Neutral on 3 Acres. Large warehouse/office building currently occupied, part of a 200+ acre parcel with frontage on Route 295 and access to a freight rail siding, also access to Stony Kill Creek. Route 295 connects with I-90 and provides access to the NYS Thruway to Albany And NYC and the Mass. Turnpike to the Berkshires, Springfield and Boston.

Click HERE to view more details.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

Columbia County commercial properties

Restaurant with Equipment
4401 Route 23
Hudson, NY 12534

Restaurant with Equipment, 4401 Route 23, Hudson, NY 12534
$525,000

Columbia County commercial properties, Currently turn key Restaurant w/ equipment. Handicap access> Many other Commercial uses possible. Refer to Startupny @esd.ny.gov for possible qualification for tax breaks and incentives. Fully equipped, walk-in cooler, office, dry storage, ansul system, etc. Hi visibility State Road across from Columbia Greene Community College. Minutes to Hudson, Amtrack, RR Station, Thruway, Parkway, Skiing Olana etc.

Click HERE for more details.
Agent Name: Bob Kavanaugh, Brokerage: Hudson, Cell Number: (518)821-1512

 

Active Inn on 50 Acres, 14213 State Rte 22 New Lebanon 12125
$449,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Operating Inn with 2 structures. Includes 3BR 3BA 1790 colonial farmhouse and renovated creamery with 4 bedrooms and 4 1/2 baths and dining for 25, serving Jiminy Peak and Tanglewood; also could serve as retreat center or family compound or farm on 50 acres.
Click HERE for more details.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

 

Former Manufacturing Site, 2195 route 145, Durham, NY 12423
$375,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Former Manufacturing site in great structural condition on 10 acre main structure + several additional structures of varying length, has potability issue. Accessible to New York State Thruway through Saugerties, Catskill and Coxsackie located in town of Durham.
Click HERE for more details.
Agent Name: David Birch, Brokerage: Hudson, Cell Number: (518)928-7239

 

Commercial Air BNB, 34 S. Front St Hudson, NY 12037
$275,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Hudson NY Air B&B 2200SF Clapboard, 4 units, + expandable large attic. 2 Blocks to Amtrak, needs finishing, great opportunity.
Click HERE for more details.
Agent Name: David Birch, Brokerage: Hudson, Cell Number: (518)928-7239

 

Commercial Use Building, 4 Main St New Lebanon, NY 12125
$244,000

Columbia County Real Estate Broker, Barns & Farms Realty presents New Lebanon Commercial Use Building. This turn of the century brick building has a 20 x 45 retail space to use along with apartments with rent roll of $40,000 located on Route 22 and Main Street.
Click HERE for more details.
Agent Name: David Birch, Brokerage: Hudson, Cell Number: (518)928-7239

 

Huge Business Opportunity, 9754-9760 Rte 9W, Athens, NY 12015
$199,000

Athens Commercial Complex: 40 x 50 garage with all the toys, 45 x 20 newer garage, 35 x 35 warehouse. Also available with 1940s Decorative Stone house(could be professional offices), see separate listing in Affordable homes. On hi traffic 9W intersection with municipal water.

Click HERE for more details.
Agent Name: David Birch, Brokerage: Hudson, Cell Number: (518)928-7239

 

Columbia County commercial properties

Former Tavern with Possibility
3927 US Rte 9
Livingston, NY 12534

Former Tavern with Possibility, 3927 US Rte 9 Livingston, NY 12534
$183,000

Columbia County commercial properties, what was Formerly Steve’s Tavern in a commercial zone on Route 9 in the Town of Livingston, between Red Hook and Hudson, 1 mile from Hannaford’s new supermarket. Structure is currently rented, but needs rehab. Also small garage included. Ideal for retail operation.

Click HERE for more details.
Agent Name: David Birch, Brokerage: Hudson, Cell Number: (
518)928-7239

 

Catskill Commercial Residential, 37 W Bridge Street, Catskill, NY 12414
$114,900

Columbia County Real Estate Broker, Barns & Farms Realty presents Catskill Commercial Residential which is a totally renovated property. You can walk to Catskill Creek. Upper level apartment has new improvements, while the lower level could be an artist studio, delivered empty if desired.
Click HERE for more details.
Agent Name: David Birch, Brokerage: Hudson, Cell Number: (518)928-7239

Click on the Links Below to View More Properties From Each Category:

Multifamily Properties
Commercial Properties

 

VACANT LAND

Great Location and Potential, 221-228 Tanner’s Lane Hudson NY 12534
$3,500,000

Columbia County Real Estate Broker, Barns & Farms Realty Presents a unique property, Railroad Frontage, In the River revitalization Area. Appx. 1,800 feet from the Hudson River. Zoned Industrial/Commercial/Warehousing. Walk to Hudson Train Station, Hudson River, Riverfront Park, Boat Club, and State Boat Launch Site. Currently under review for rezoning to allow for High rise condo’s. Unlimited possibilities. Please call listing agent for details and to view property, no trespassing please.

Agent Name: Bob Kavanaugh, Brokerage: Hudson, Cell Number: (518)821-1512

185 Acres For Residential Development, Highland Rd Chatham, NY 12037
$995,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Chatham 185 Acres for Estate or Residential Development near Chatham Village, public water available. Access via quiet residential street or Route 295, which provides access to the Taconic State Parkway and I-90 for Albany and Pittsfield, MA commutes. Also provides interconnections with the Mass. Turnpike to Boston and the NY S Thruway to New York City.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

Hudson Riverfront 10 Acres Natural Harbor Liberal Zoning, 140 Staats island Rd, Schodack, NY 12033

Hudson Riverfront 10 Acres Natural Harbor Liberal Zoning, 140 Staats island Rd, Schodack, NY 12033

$399,000

Columbia County Real Estate Broker, Barns & Farms Realty presents Spectacular 10 acres on the Hudson River. Building sites on the River and on hill overlooking with river. Property includes a protected harbor. Neighbor on one side is conservation and on the other side an Historic Home. Mixed zoning permits multifamily and commercial uses. Broker owned.

Agent Name: David Birch , Brokerage: Barns & Farms Chatham, Cell Number: 518-928-7239

 

Tannersville 56+ Acres with Frontage

56+ Acres with Frontage, Elka Park Rd, Tannersville, NY 12427
$379,000

Columbia County Real Estate Broker, Barns & Farms Realty presents a large parcel in proximity of Ski Hunter and Ski Windham, great for subdivision or estate, long frontage.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

Lake and Pond on 40 Acres, 315 Pond Rd, Rhinebeck, NY 12572
$280,000

Rhinebeck Lake/Pond 40 Acres Unusual Find: lake and pond on 40 acres, lots of road frontage, easy subdivision for 3-8 lots, extreme privacy on dirt road, 6 miles to Rhinebeck Village or Taconic Parkway
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

38 Acres Overlooking Creek, 85 Merwin Rd, Chatham, NY 12037
$169,000

Overlooking Kinderhook Creek. 38 acres of privacy and views overlooking the creek and adjoining hills, long shale driveway in amidst a grove of pine trees, BOHA, and great creekfront soils for agriculture owner taking loss.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

 

Beautiful Lakefront Property, 33-J Appalachian Dr, Coxsackie, NY 12015
$99,000

Sleepy Hollow Lake Front Property Beautiful lakefront lot in area of fine homes with easy access from main entrance on quiet road. Inlet to main portion of lake, dock in and mowed lawn to lake. there are several building spots, common water & septic, homeowners association.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

Great 33 Acre Property, Maple Avenue Ext, Westerlo, NY 12193
$45,000

Westerlo land 33 Acres Great property with long frontage on Maple Avenue extension close to Greenville, has some wetland areas.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

Roadside Wooded Lot, M. Simmons Rd, Cairo, NY 12413
$15,000

Great deal on level residential or commercial lot, on two roads. Runs between Rt 32 and M. Simmons Road.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

Small Parcel, Great Location! 47-G Sleepy Hollow Rd, Athens, NY 12015
$5,000

Sleepy Hollow Lake Community, great lot with community water and sewer and all the amenities, beach, boating, swimming pool, tennis. Convenient to entrance.
Agent Name: David Birch, Brokerage: Chatham, Cell Number: (518)928-7239

Click HERE to view more Vacant Land listings

Disclaimer: Barns & Farms Realty LLC reserves the right to select the specific properties displayed on this website.
Information presented is deemed reliable, although not warranted. Barns & Farms Realty LLC and its affiliates and/or
suppliers do not guarantee the accuracy of any information displayed. It is suggested that before visiting a property,
the listing agent be contacted to verify any information.


There are properties displayed on this website that are not currently listed for sale, but are displayed as
examples of properties that have been on the market or may become available at a future date.


Copyright © 2017 All material published on this site is copyrighted by Barns & Farms Realty LLC with all rights reserved.
No reproduction, distribution, or transmission of the copyrighted materials at this site are permitted without
written permission of Barns & Farms Realty, LLC.