Home / Recently Sold / Stamford
Closed · For Sale
$1,730,000
Asked $1,650,000 · Sold 2025-06-20

157 Harpsichord Turnpike, Stamford, Connecticut 06903

4 beds 4 baths 4,338 sq ft Single Family For Sale Built 2007

About this home

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.

Status
Closed
Type
Single Family For Sale
Price
$1,730,000
Beds
4
Baths
4
Interior
4,338 sq ft
Lot
1.25 ac
Year Built
2007
MLS #
24071559
ZIP
06903
Days on Market
10
Heat
Propane · Hot Air
Cooling
Central Air, Zoned
Water
Private Well
Sewer
Septic
Parking
Attached Garage (3-car)
Laundry
Upper Level

Flood risk: check the FEMA flood map for this address.

Schools

Elementary
Roxbury
Middle / Jr High
Cloonan
High School
Westhill

Taxes

Property tax
$21,344 (July 2024-June 2025)
Assessed value
$937,800

Interior

Appliances
Oven/Range, Refrigerator, Washer, Dryer
Attic
Pull-Down Stairs
Fireplaces
2
Total rooms
8

Building & Exterior

Style
Colonial
Roof
Other
Siding
Shake, Other
Foundation
Concrete
New construction
No/Resale

Lot & Land

Zoning
RA1
Lot
Water View
Waterfront
River, Walk to Water
Direct waterfront
Yes

What's nearby

Grocery
Acme3.07 mi away
Also nearby
Trader Joe's3.15 mi away
Pharmacy
CVS Pharmacy4.81 mi away
Train
New Canaan Station5.12 mi awayMetro-North Railroad
Elementary
Roxbury
Middle
Cloonan
High school
Westhill
~4.3 miAcme — 3.07 miTrader Joe's — 3.15 miCVS Pharmacy — 4.81 miNew Canaan — 5.12 mi
This homeGroceryPharmacyTrain

Real streets from OpenStreetMap; distances are straight-line from the property, not driving routes.

Distances are straight-line from the property, not driving or walking routes. Places data © OpenStreetMap contributors.

Listing & sale history

Every time this exact home has come to market in the MLS data this site tracks. Where a sale closed, the recorded sale price is shown; "asking" marks a price the home was listed at rather than what it sold for.

2025-06-20Sold — $1,730,000 asked $1,650,000 (this listing)MLS 24071559

Public record

From the Stamford assessor's public property record. These figures describe the property as the town has it on file and can differ from the listing — a finished basement or an addition may not be reflected in the assessor's living area.

Year built2007
Living area4,338 sq ft
Total rooms8
Lot size1.25 acres
Stories2
HeatForced Air-Duc
ExteriorStone
Assessed value$937,800
Town appraisal$1,339,700
Last recorded sale2020 — $1,175,000

Recorded sales

Deed transfers on file with the Stamford land records, newest first. These are recordings rather than MLS sales, so they include transfers that were never listed. Nominal and $0 transfers (estate, trust and family conveyances) are excluded.

Listing courtesy of Houlihan Lawrence — Joy Kim Metalios · (203) 869-0700

More homes in Stamford

Closest in price to this one.

← Back to all Stamford listings