Welcome or Register
Back to Saved Search
Listing 23 out of 547
$2,375,000 For Sale

57 Frese Road
Greenport, NY 12534

4 beds, 2 full, 1 partial baths | Single Family Home
3,300 sq ft; lot: 5.8 acres - MLS# 124975
Property Photo
1/52

Description

Modern farmhouse with spectacular Hudson River views resting atop 6 acres of Mt Merino's hillside. This open-air layout includes floor to ceiling windows and doors giving you a panoramic view you can enjoy from all angels. The first floor houses a chef's kitchen including granite counter tops a Viking stove & baking oven two dishwashers and a butler's pantry. Oakwood flooring is installed throughout main level which include a wood burning fireplace, dining room, grand entryway, and powder room. The first floor also contains a large mudroom off the back entrance and converted garage bay, which can act as an artist's studio or extra living space. Upstairs you will find a spacious river facing master suite with walk-in closets, large custom shower and stand-alone tub. Two guest rooms with large windows are fully finished with built in closets as well as a beautiful guest bath. A bonus room above the garage can serve as another b/r or media room. Basement provides more finished space.

Features

  • Property Type: Single Family Home
  • Sub Type: Residential
  • Listing Status: Active
  • County/Area: Columbia County
  • Zip Code: 12534
  • Year Built: 1998
  • School District: Hudson
  • Sq.Ft.: 3,300 sq ft
  • Style: Contemporary
  • Total Rooms: 10
  • Bedrooms: 4
  • Full Baths: 2
  • Half Baths: 1
  • Basement: Finished, Full
  • Garage: Attached 2-Car
  • Fireplace: 1 Living Room
  • Lot Size: 5.8 acres
  • Baths: 3
  • Pool or Spa: Yes
  • View: See View Details
  • Zoning: Residenital
  • 1st Floor: 1504
  • 2nd Floor: 1408
  • Appliances Included: Clothes Dryer, Clothes Washer, Dishwasher, Wall Oven, Refrigerator, Stove
  • Basement SqFt: 1000
  • Central Air: Yes
  • Color: White
  • Construction: Frame
  • Electric: 200 Amps
  • First Floor: Bath, Living Room, Dining Room, Kitchen, Other Room
  • Floors: Carpet, Oak, Wood, Other
  • Foundation: Poured Concrete
  • Heat Type: Radiant, Hot Air
  • Lot Measurement: Acres
  • Lot Square Footage: 252648.00
  • Other Floor: Family Room, Other Room
  • Roof: Asphalt, Shingle
  • Secluded: Semi
  • Second Floor: Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bath, Other Room
  • Sewer: Septic Tank
  • Siding: Wood
  • View Details: Catskills, Far Reaching, Hilltop, Hudson River, Mountain, Neighborhood, Panoramic, Parklike, Water
  • Walls: Sheetrock, Wood
  • Water: Well
  • Water Heater: Electric
  • Windows: Double Hung, Low Energy
Courtesy of Keller Williams Realty Hudson Valley United, Marie Wolpert

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*

We are looking forward to serving your real estate needs

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: 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


Any

Any

No Min.

No Max.

house realtor mls

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu