Julie Riccio Friedow
Licensed Associate Real Estate Broker
REALTOR®
Niskayuna, NY
social icon social icon social icon 
New
View Full Photo Gallery

Property Description

Tucked down a long private road in the heart of Milan sits an artist's imagined home, created in collaboration with a renowned architect and inspired by the mid century minds of Frank Lloyd Wright and his contemporaries. The Woodland Modern gives in ways both familiar and unexpected. Floor to ceiling custom windows frame a picture perfect view, creating the feeling of floating among the trees, while a sunken living room and wood burning stove bring warmth and intimacy to the space. Beyond the glass, six acres of forest unfold in every direction, reached by a private shared driveway that was graded and regraveled in 2024.Attention to detail is felt throughout. Each room flows naturally into the next within an open floor plan, with every space offering easy passage between indoors and out. The chef's kitchen sets the stage for meals best enjoyed on the three season screened porch, where comfortable seating, a dining area, and outdoor speakers make the transition from cooking to gathering feel effortless.Upstairs, a separate wing offers a full bathroom and a flexible room with a private balcony that can become an office, guest space, studio, or simply a quiet place to retreat. Down the long corridor, two additional bedrooms share a beautifully designed bathroom. The primary suite, reimagined in a full 2023 renovation, is a retreat unto itself, with a walk-in closet, custom millwork, and a window bench crafted by Rowan Woodwork, along with a new Cardoso bath and double wide vanity.That same renovation extended into the living room below, where all new millwork, rebuilt windows, and energy efficient UV filtered glass now frame the surrounding landscape without ever losing the warmth of the original home. Comfort runs quietly beneath it all, with radiant heating throughout and new mini split systems in every bedroom, the home office, and den. A new roof was installed in 2024. Modern living is seamlessly woven in as well, from the Crestron lighting automation system and in ceiling sound throughout the house to Ubiquiti high speed WiFi, with cable and future fiber connections ready to go.Just beyond the main house sits a standalone 1,000 square foot studio, kept comfortable year round with its own new mini split system. Once alive with an artist's creative work, the studio is ready to become whatever the next chapter calls for. Originally built in 1993 and designed by its first owner, a noted local artist, the home has since been thoughtfully reimagined for modern living, creating a rare balance between artistic

25 Willow Glen Road | MLS# 1052121

This single family home located at 25 Willow Glen Road , Red Hook, NY 12571 is currently listed for sale with an asking price of $1,625,000. This property was built in 1993 and has 4 bedrooms and 4 full baths with 3200 sq. ft. Willow Glen Road is located within the Red Hook school district. Search Red Hook real estate on julie-friedow.coldwellbankerprime.com today.

Upcoming Open Houses

Open House Saturday September 26th, 12:00pm - 3:00pm

Gallery

Property Features

Property Type: Residential - Single Family
Cooling: Ductless
Fireplaces: 1
Garage: 2
Heating: Propane, Radiant, Radiant Floor
Home Style: Contemporary, Modern
Lot Size: 6.40 Acres
Taxes: $20,632
Year Built: 1993

Amenities

Built-in Features
Chefs Kitchen
Granite Counters
High Ceilings
High Speed Internet
In-Law Floorplan
Kitchen Island
Natural Woodwork
Open Floorplan
Original Details

Feature Descriptions

Appliances: Dishwasher, Dryer, Oven, Range, Refrigerator, Stainless Steel Appliance(s), Washer, Water Purifier Owned, Water Softener Owned
Building Area Total: 4168
Days on Site: 6
Exterior: Cedar, Shake Siding, Wood Siding
Fireplace Features: Living Room
Fireplace Y/N: Yes
Flooring: Concrete, Hardwood
GarageY/N: Yes
Laundry: Laundry Room
Number Of Kitchens: 1
On Market Date: 2026-09-18
Other Structures: Workshop
Parcel Number: 133600-6573-00-208047-0000
Parking Features: Driveway, Garage
Patio And Porch: Porch, Screened
Rental Term: Monthly
Road Responsibility: Road Maintenance Agreement
Rooms Total: 12
Sewer: Septic Tank
Special View Info: Trees/Woods
Utilities: Electricity Connected
Water: Well
Window Features: Floor to Ceiling Windows, Oversized Windows

Local Schools

High School: Red Hook Senior High School
Middle School: Linden Avenue Middle School
Elementary School: Mill Road-Intermediate(grades 3-5)
School District: Red Hook

Estimate Your Payment

Estimated Payment

$ 5,809.84 per month $3,616.55 Principal & Interest $1,719.33 Property Tax $473.96 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Upstate Down
Agency Contact: 845-516-5123

Shown By

Agent Name: Julie Riccio Friedow
Agent Phone: (518) 229-7908 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 09/24/2026. The listing information on this page last changed on 09/24/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 09/24/2026 12:05:29 AM EST) or Global MLS (last updated Wed 09/23/2026 11:52:29 PM EST) or New York State Alliance MLS (last updated Thu 09/24/2026 12:03:15 AM EST) or Hudson Valley Catskill Region MLS (last updated Thu 09/24/2026 12:01:18 AM EST) or Berkshire MLS (last updated Wed 09/23/2026 8:13:19 PM EST) or OneKey MLS (last updated Thu 09/24/2026 12:00:26 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Listing data and photos distributed by MLSGRID
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.



C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell Banker®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

THANK YOU FOR
YOUR INTEREST!

Complete the fields below to receive additional details.

Add to Calendar

Reserve A Time

Cancel Your Appointment?

Registration Successful

You are now registered to view virtual open houses for the listings.