Homes

Save
Ask
Tour
Hide
Share
$1,650,000
9 Days On Site

157 Harpsichord Turnpike
Stamford, CT 06903

For Sale|Single Family Residence|Active
4
Beds
4
Full Baths
0
Partial Baths
4,338
SqFt
$380
/SqFt
2007
Built
County:
Fairfield
Listing courtesy of Joy Kim Metalios of Houlihan Lawrence
Call Now: 860.406.4060
Is this the home for you? We can help make it yours.
860.406.4060
157 Harpsichord Turnpike157 Harpsichord Turnpike157 Harpsichord Turnpike157 Harpsichord Turnpike
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$7,528
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

Previously featured on HGTV Property Brothers: Dream Home, this newly renovated masterpiece showcases unparalleled craftsmanship and design. A soaring two-story foyer with a stone fireplace sets the tone for elegance. The chef's kitchen boasts stunning quartz countertops, a professional range, and custom cabinetry. The dramatic living and dining areas feature coffered ceilings, a stone fireplace, and oversized windows that bring in natural light. The luxurious primary suite offers a tray ceiling, dressing room, custom walk-in closet, and spa-like bath with a private deck. Two ensuite bedrooms, an office/fourth bedroom, and an oversized family room complete the home. Multiple patios and an outdoor fireplace overlook 1.25 acres with serene Mianus River frontage. BEST AND FINAL OFFERS DUE TUESDAY 3/11 AT NOON.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,650,000
Days On Site 
9 Days
Bedrooms 
4
Inside Area (SqFt) 
4,338 sqft
Total Baths 
4
Full Baths 
4
Partial Baths 
N/A
Lot Size 
1.25 Acres
Year Built 
2007
MLS® Number 
24071559
Status 
Active
Property Tax 
$21,344
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
4 days agoListing updated with changes from the MLS®
a week agoStatus changed to Active
a week agoListing first seen on site
General Features
Acres 
1.25
Attached Garage 
Yes
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
3
Parking 
Attached
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
SqFt Total 
4338
Style 
Colonial
Water Source 
Well
Zoning 
RA1
Interior Features
Appliances 
DryerRangeOvenRefrigeratorWasher
Basement 
None
Cooling 
Central AirZoned
Fireplace 
Yes
Fireplaces 
2
Heating 
PropaneForced Air
Interior 
Entrance Foyer
Full Bath 
Level - Upper
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
ConcreteFrameOtherShake Siding
Lot Features 
Waterfront
View 
Water
Waterfront 
Yes
Waterfront Features 
River Front
Waterview 
Water
Schools
School District
Unknown
Elementary School
Roxbury
Middle School
Cloonan
High School
Westhill
Listing courtesy of Joy Kim Metalios of Houlihan Lawrence



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.

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share