151 June RoadStamford, CT 06903
Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.




This stunning property seamlessly blends modern farmhouse charm with a touch of Museum of Modern Art sophistication. Situated on 3 picturesque acres with a tranquil pond, Mianus River frontage, and expansive fields perfect for outdoor entertaining or a potential pool, it's a truly exceptional estate. The interior showcases soaring ceilings, a dramatic two-story fireplace, and floor-to-ceiling windows that frame breathtaking views of the pond and barn-creating an artful, open-concept living space. The recently renovated chef's kitchen features quartz countertops, top-tier Wolf and Sub-Zero appliances, a large island, and smart design details that elevate everyday living. An elegant dining area, cozy TV lounge, and stylish home office complete the first floor. With five bedrooms-including one on the main level-and 4.5 bathrooms, the layout is ideal for family, guests, or entertaining. The property includes an historic post-and-beam barn, rebuilt in 2008, offering endless potential: It includes horse stalls, an artist's studio, and a rustic gathering space with a wood-burning stove. The fenced garden invites vegetable and flower gardening, while direct access to 30 miles of riding trails through the Greenwich Riding & Trails Association makes it a haven for equestrians and outdoor enthusiasts alike. This property masterfully combines contemporary farmhouse warmth with artistic, museum-quality architectural details-offering a one-of-a-kind lifestyle in a serene, country setting
| 3 weeks ago | Listing updated with changes from the MLS® | |
| 4 weeks ago | Status changed to Pending | |
| 2 months ago | Listing first seen on site |
The data relating to real estate for sale on this website appears in part through the SMARTMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SMARTMLS through a licensing agreement. Listing information is from various brokers who participate in the SMARTMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2025 SmartMLS, Inc.
Last checked: 2025-10-28 09:10 PM UTC.
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.