Welcome or Register
Back to Saved Search
Listing 1 out of 482
$535,000 New For Sale

457 Orchard Rd
Livingston, NY 11201

4 beds, 3 baths | Single Family Home
3,037 sq ft; lot: 2.05 acres - MLS# 125030
Property Photo
1/23

Description

1840 Fabulous Farmhouse overlooking forever endless open fields and long range views. Renovated to perfection offering 4 bedrooms, 3 bathrooms, with the best 21st century design makes this a magical place to live with light pouring into every room. Generous proportioned formal and informal living, dining, lounging areas, screened in porches with expansive deck. The kitchen and baths are so cool and hip but resonate with the traditional farmhouse. 2 two story barns one finished as a sweet guest house with new bath and kitchen (or airbnb it). Plus small barns. Just under 2 hrs from NYC & 10 minutes from Hudson. Come chill.

Features

  • Property Type: Single Family Home
  • Sub Type: Residential
  • Listing Status: Active
  • County/Area: Columbia County
  • Zip Code: 11201
  • Year Built: 1840
  • School District: Hudson
  • Sq.Ft.: 3,037 sq ft
  • Style: Center Hall, Colonial, Farm House, Greek Revival
  • Total Rooms: 10
  • Bedrooms: 4
  • Full Baths: 3
  • Basement: Partial, Unfinished
  • Garage: Attached
  • Fireplace: Living Room
  • Lot Size: 2.05 acres
  • Baths: 3
  • View: Far Reaching, Farmland, Pastoral
  • Appliances Included: Clothes Dryer, Clothes Washer, Dishwasher, Refrigerator, Stove
  • Construction: Frame, Post & Beam
  • Electric: 200 Amps
  • First Floor: Bath, Family Room, Living Room, Dining Room, Kitchen, Other Room
  • Floors: Pine, Stone, Wideboard
  • Foundation: Stone
  • Heat Type: Hot Water, Steam
  • Lot Measurement: Acres
  • Lot Square Footage: 89298.00
  • Paved Street: Yes
  • Roof: Asphalt, Shingle
  • Second Floor: Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bath, Other Room
  • Sewer: Septic Tank
  • Siding: Clapboard, Vinyl, Wood
  • Walls: Plaster, Sheetrock
  • Water: Well
  • Water Heater: Electric
  • Windows: Double Hung
Courtesy of Berkshire Hathaway Homeservices, Blake Realtors, Mary Stapleton

DON'T MISS A NEW LISTING AGAIN!

Register Now
Already registered? Login

FREE AUTOMATED EMAIL UPDATES
Sign in to take advantage of all this site has to offer. Save your favorite listings and searches – also receive email updates when listings you like come on the market for free!
*Contact Information is NOT Shared*

CONGRATULATIONS TO HEATHER DAVALA

COLUMBIA GREENE BOARD OF REALTOR'S

ROOKIE OF THE YEAR, 2017

SEE "ABOUT US" FOR MORE INFORMATION

Davala Real Estate, LLC

"Let us help you make your next move!"

Davala Real Estate, LLC
119 Main Street, Philmont, NY 12565
518-755-2385
Contact Us

 

L to R: Melody Gardner, Karen Davala, Heather Davala, Brittany Gillis

Quick Search


view all


Any

Any

No Min.

No Max.

house realtor mls

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu