
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$1,739,000
Listing Price5beds
5baths
3,833sqft
134,644sqft lot
151 June Rd, Stamford, CT 06903
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Off Market
Home type
Price / sqft
Year built
Home Details
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, its 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 chefs 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 artists 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
Interior Details
3833
5
5
Has Heating:
Yes
Heating Type:
Hot Water
Has Cooling:
Yes
Cooling Type:
N/A
Has Fuel:
Yes
Fuel Type:
Oil
Has Basement:
No
Basement Type:
Partial
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
134644
No
No
Type:
Garage, Attached
Location:
N/A
Status:
N/A
Number of Spaces:
0
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Construction Details
Colonial
Wood Siding
N/A
Gable
Asphalt
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2020
$18,145
$369,540
$346,790
--%
$716,330
2019
$18,145
$369,540
$346,790
--%
$716,330
2018
$17,514
$369,540
$346,790
--%
$716,330
2017
$16,519
$321,350
$324,170
--%
$645,520
2016
$16,432
$321,350
$340,710
--%
$662,060
2014
$15,433
$321,350
$340,710
--%
$662,060
2013
$15,009
$321,350
$340,710
--%
$662,060
2011
$15,009
$321,350
$340,710
--%
$662,060
Average Home Price in 06903
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$1,854,502
$1,854,502
4 Beds
3.5 Baths
4,085 Sqft
87,120 Lot (sqft)
Sold 10/06/2026
$1,739,000
$1,739,000
5 Beds
5 Baths
3,833 Sqft
134,644 Lot (sqft)
Sold 09/29/2026



