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. The luxurious primary suite with 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.
Sold for $1,730,000 on 06/20/25
$1,730,000
157 Harpsichord Tpke, Stamford, CT 06903
4beds
4,338sqft
Residential, Single Family Residence
Built in 2007
1.25 Acres Lot
$1,779,300 Zestimate®
$399/sqft
$8,086 Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: June 20, 2025 at 08:26am
Listed by:
Joy Metalios 917-620-9121,
Houlihan Lawrence
Bought with:
Arielle McGregor, RES.0818127
Houlihan Lawrence
Source: Greenwich MLS, Inc.,MLS#: 122176
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 4
Heating
- See Remarks, Forced Air, Propane
Cooling
- Central Air
Features
- Kitchen Island
- Basement: Exterior Entry
- Number of fireplaces: 2
Interior area
- Total structure area: 4,338
- Total interior livable area: 4,338 sqft
Property
Parking
- Total spaces: 3
- Parking features: Garage Door Opener
- Garage spaces: 3
Features
- Exterior features: Balcony
Lot
- Size: 1.25 Acres
- Features: Parklike
Details
- Additional structures: Shed(s)
- Parcel number: 135 001 8594
- Zoning: RA-1
- Other equipment: Generator
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Residential, Single Family Residence
Materials
- Roof: Other
Condition
- Year built: 2007
- Major remodel year: 2021
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Propane
Community & neighborhood
Security
- Security features: Security System
Location
- Region: Stamford
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$1,779,300
2% more+$35,586
With Zillow Showcase(estimated)$1,814,886