$10,000 Closing Credit¹
#24048343, Elaine Voss, Listing Office: Coldwell Banker Realty
#24071559·
Listing Office: Houlihan Lawrence·
Listing Agent: Joy Kim Metalios·
Listing Office Phone: (203) 869-0700
$1,650,000 List price
157 Harpsichord Tpke Stamford, CT 06903
$10,000
Closing credit¹
4 beds
4 full
4,338 sqft
1.3 acres
$380 / sqft
House
Property details
About 157 Harpsichord Tpke
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.
Highlights
Home typeOther
HeatingForced Air
StatusActive
CoolingCentral Air, Zoned
Size4,338 sqft
Lot size1.25 Acres
Year built2007
ParkingAttached Garage
MLS #24071559
Attached garage3 spaces
WaterfrontRiver, Waterfront
ViewWater
Summary
- MLS Number: 24071559
- Office Name: Houlihan Lawrence
- Office Phone: (203) 869-0700
- Office Email: joygreenwichbroker@gmail.com
- Listing Agent: Joy Kim Metalios
Copyright © 2025 Smart MLS. 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.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 3/11/2025, 3:20:52 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$1,650,000
157 Harpsichord Tpke
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Aug 27, 2020 | Home Sold | $1,175,000 |
| Jun 24, 2015 | Home Sold | $1,225,000 |
| Nov 28, 2006 | Home Sold | $672,500 |
| Mar 12, 1996 | Home Sold | $375,000 |
| Nov 18, 1993 | Home Sold | $315,000 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $937,800 | $21,344 |
| 2023 | $940,300 | $23,000 |
| 2022 | $772,090 | $20,329 |
| 2021 | $772,090 | $20,051 |
| 2020 | $772,090 | $19,557 |
| 2019 | $772,090 | $19,557 |
History based on county public records data.
Nearby schools
4
Northeast School
Public District KG-5
2.6 mi
•82 Scofieldtown Rd
9
Parkway School
Public District KG-5
3.5 mi
•141 Lower Cross Rd
9
West School
Public District PK-4
3.5 mi
•769 Ponus Rdg
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $228,393. Typical income of Stamford, CT residents is $200k+ annually. The most common type of family is married, no kids. Residents of this area typically have high school diploma education.
How much money do the neighbors make?
2%
<35k
15%
35k-100k
16%
100k-200k
67%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
20%
Single, No Kids
4%
Single, with Kids
44%
Married, No Kids
32%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
15%
<11 yrs old
10%
12-17 yrs old
8%
18-34 yrs old
49%
35-64 yrs old
18%
65+ yrs old
What do the neighbors do for fun?
Skiing/snowboarding
PGA/LPGA
Figure Skating
Where do the neighbors shop?
BJs Wholesale Club
Stein Mart
Kmart
Where do the neighbors go to eat?
Panera
Cracker Barrel
Bob Evans
What do the neighbors drive?
Infiniti
Lexus
Lincoln
What do the neighbors listen to?
Adult Hits
Oldies
News/Talk/Information
All data provided by Home Junction and Claritas
Similar homes for sale
$10,000 Closing Credit¹
#24074736, Anthony Ardino, Listing Office: William Raveis Real Estate
$10,000 Closing Credit¹
#24022816, Barbara Elste, Listing Office: BE Real Estate
New - 5 days on Rocket
$10,000 Closing Credit¹
#24078171, Michael Feldman, Listing Office: Century 21 AllPoints Realty
$8,728 Closing Credit¹
#24063586, Newton Davis, Listing Office: Preferred Choice Realty Group
Frequently asked questions
About 157 Harpsichord Tpke
This home is located at 157 Harpsichord Tpke in Stamford, CT and zip code 06903 in the North Stamford neighborhood. This 4,338 square foot home, which was built in 2007, sits on a 1.25 acre lot. Features: 4 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since March 5, 2025 and is currently priced at $1,650,000.
In February 2025, from all listings sold in Stamford, CT there were more than 38 sold above asking price, over 19 sold below and more than 12 were sold right at the asked price. Between January and February 2025, Stamford, CT real estate market has seen increase in the number of listings by 10.7%.
From Rocket Homes Real Estate and based on county public records data.