Welcome or Register
Back to Saved Search
Listing 1 out of 482
Sold for $475,000 Sold

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


Sold for $475,000 on May 23, 2019


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.


  • Property Type: Single Family Home
  • Sub Type: Residential
  • Listing Status: Sold
  • Listing Price: $495,000
  • 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
  • Sold Price: 475000.00
  • Sold Date: 2019-05-23
Courtesy of Berkshire Hathaway Homeservices Blake, Realtors, Mary Stapleton


Register Now
Already registered? Login

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*

We are looking forward to serving your real estate needs


Davala Real Estate, LLC

"Let us help you make your next move!"

Davala Real Estate, LLC
119 Main Street, Philmont, NY 12565
Contact Us


L to R: Heather Davala, Real Estate Saleperson, Melody Gardner, Real Estate Salesperson, Karen Davala, Real Estate Broker, Wendy Rowe, Office Admin, Brittany Gills, Real Estate Salesperson

Quick Search

view all



No Min.

No Max.

house realtor mls

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu