See Home Value
Stamford 06903 North Stamford
157 Harpsichord Turnpike
$1,609,441*
House - Off Market

157 Harpsichord Turnpike

Stamford, CT 06903
bedrooms
3 Beds
bathrooms
4 Baths
square feet
4338 Sqft
$1,058,000 - $1,292,000
Reference Base Price*
36.97%
Since Sep 1, 2020
National-US
Primary Model
Sold Aug 27, 2020
$1,175,000
$822,500 by Hsbc Bank Usa
Mortgage
Sold Jun 24, 2015
$1,225,000
$980,000 by Webster Bank
Mortgage Due Jun 24, 2023

About This Property

Featured on HGTV Property Brothers DREAM HOME. Masterfully crafted to the highest specifications, this elegant home, maintained to perfection is a true showplace. Enter the soaring 2 story foyer with custom chandelier & stone fireplace, this home was built with the finest materials, extraordinary millwork & trim and unique architectural accents. Beautifully appointed kitchen has granite counters, professional style range, breakfast bar, custom cabinetry & radiant heated floors. Great layout for living/entertaining. Gleaming hardwood floors in dramatic living room with coffered ceilings, stone fireplace, and dining area surrounded by walls of windows has elaborate brazilian walnut inlay. Oversized family room with large windows  and coffered ceilings fill the home with light. Additional office/potential 4th bedroom on first floor. Upstairs, spectacular master bedroom suite boasts tray ceiling, dressing room/office, built-ins, custom walk-in closet & sumptuous bathroom/marble topped vanity, jetted tub and enormous shower. Maintenance free deck overlooks park-like backyard. 2 bedrooms, each with gorgeous, sparkling baths & walk-in closets complete the second floor. Magnificent professionally landscaped plantings & circular driveway embrace this handsome home plus 3 car garage. Outdoor fireplace and patio add to the exterior perfection on picturesque 1.25 private acres with peaceful frontage on Mianus river. This home will exceed your expectations.

The manager has listed the unit size as 4338 square feet.
Unit Size
4,338Ft²
Days on Market
-
Land Size
1.25 acres
Price per sqft
$271
Property Type
House
Property Taxes
$19,557
HOA Dues
-
Year Built
2007

Price History

Date / Event Date Event Price
Aug 27, 2020 Sold to Anthony Champion $1,175,000
Sold to Anthony Champion
Aug 14, 2020 No longer available -
No longer available
Jun 4, 2020 Listed $1,175,000
Listed

Property Highlights

Fireplace
Air Conditioning
Garage

Building Info

Overview

    General

  • Year Built: 2007
  • Effective Year Built: 2007
  • Building Count: 1
  • Total Rooms: 8
  • Bedroom Count: 3
  • Bathroom Count: 4
  • Full Bathrooms: 3
  • Partial Bathrooms: 4
  • Building Condition: Good
  • Building Style: Colonial
  • Exterior Walls Type: Rock and stone
  • Roof Shape Type: Gable
  • Roof Cover Type: Tile
  • Floor Count: 2
  • Living Units: 1
  • Basement Type: Partial basement
  • Basement Area: 0
  • Garage Type: Attached
  • Parking Space Count: 0
  • Pool Type: Spa or hot tub (only)

    Dimensions

  • Lot Size Square Feet: 54,450
  • Total Building Area: 4,338
  • Gross Building Area: 8,775
  • Building Area: 4,338
  • Building Area Measurement: Living Area

    Heating and Cooling

  • Fireplace Count: 1
  • Air Conditioning: Yes
  • Heating: Forced air unit
  • Heated Square Feet: 4,338
  • Heating Fuel Type: Gas

    Utilities

  • Sewer System: unknown
  • Water Service: unknown

Building

  • Property Class: Residential
  • Land Acres: 1.25
  • Standard Land Use Code: Single family residential

Ownership

  • Current Owner : CHAMPION ANTHONY
  • Previous Owner : KEITH GEORGE
  • Previous Owner 2: KEITH CATHERINE B
  • Owner Before Previous Owner: WANDZEL URSZULA
  • Owner Before Previous Owner 2: WANDZEL ANDREZEJ S
  • Is Owner Occupied: Owner-occupied property

Neighborhood

  • School District Name: Stamford School District
  • School Tax School District: STAMFORD SD
  • Census Tract: 020200

Zoning

  • Zoning: RA1

Geography

  • Account Number: 1-8594
  • Parcel: STAM M:001 B:8594
  • Block: 8594
  • Municipality: STAMFORD
  • Latitude: 41.1361
  • Longitude: -73.5938

    Address

  • Full Address: 157 Harpsichord Tpke
  • Address - House Number: 157
  • Address - Street Name: Harpsichord
  • Address - Suffix Type: Tpke
  • State: CT
  • City Name: Stamford
  • Carrier Code: C046
  • 4-Digit Zip Code: 2031
  • Zip Code: 06903

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $23,000

    Appraisal Valuation

  • Standard Deviation: 0.2059
  • Valuation Date: Aug 23, 2023
  • Confidence Score: 72
  • Final Value: 1,464,159
  • High Value: 1,765,765
  • Low Value: 1,162,553

    Open Liens

  • Total Open Liens: 1
  • Total Open Liens Amount: $822,500
  • First Open Lien Mortgage Lender: HSBC BANK USA
  • First Open Lien Mortgage Recording Date: Aug 27, 2020
  • First Open Lien Mortgage Loan Amount: $822,500
  • First Open Lien Mortgage Term: 360
  • First Open Lien Mortgage Position: 1
  • First Open Lien Mortgage Loan Type: Purchase Money Mortgage

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $940,300
  • Assessed Land Value: $256,630
  • Assessed Improvements Value: $683,670

    Sales

  • Current Sale Contract Date: Aug 19, 2020
  • Current Sale Recording Date: Aug 27, 2020
  • Current Sale Transaction ID: 11785008727
  • Current Sale Price: $1,175,000
  • Current Sale Document Type: Warranty Deed
  • Current Sale Input Document Number: 2020012790
  • Previous Sale Recording Date: Jun 24, 2015
  • Previous Sale Amount: $1,225,000
  • Previous Sale Document Type: Warranty Deed

    Last Sale Mortgage

  • First Mortgage Lender: HSBC BANK USA
  • First Mortgage Transaction Date: Aug 27, 2020
  • First Mortgage Loan Amount: $822,500
  • First Mortgage Terms: 360
  • First Mortgage Loan Type: Purchase Money Mortgage

    Previous Mortgages

  • Previous Mortgage Lender: WEBSTER BANK
  • Previous Mortgage Transaction Date: Jun 24, 2015
  • Previous Mortgage Loan Amount: $980,000
  • Previous Mortgage Term: 95
  • Previous Mortgage Loan Due Date: Jun 24, 2023



Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes
House
4 Beds
5 Baths
3,674 ft²
$286/ft²
$1,050,000 Aug 11, 2023
$1,050,000 Oct 11, 2023
$1,384/mo
House
5 Beds
4 Baths
2,879 ft²
$425/ft²
$1,225,000 Feb 14, 2024
$1,225,000 Mar 27, 2024
$1,233/mo
House
5 Beds
4 Baths
3,388 ft²
$289/ft²
$980,000 Jul 19, 2023
$980,000 Oct 2, 2023
$1,239/mo
House
5 Beds
3 Baths
3,428 ft²
$284/ft²
$975,000 Jul 25, 2023
$975,000 Sep 15, 2023
$1,059/mo
House
3 Beds
4 Baths
4,411 ft²
$215/ft²
$949,900 Feb 13, 2024
-
$1,235/mo
House
3 Beds
4 Baths
4,933 ft²
$193/ft²
$950,000 Feb 28, 2024
-
$1,096/mo
House
5 Beds
4 Baths
4,333 ft²
$242/ft²
$1,050,000 Mar 14, 2024
-
$1,325/mo
House
5 Beds
3 Baths
2,966 ft²
$335/ft²
$995,000 Apr 5, 2024
-
$1,059/mo

About North Stamford


Similar Homes for Sale

Unit for sale at 20 Heather Drive, Stamford, Connecticut 06903

$995,000

  • 5 Beds
  • 3 Baths
  • 2,966 ft²
20 Heather Drive, Stamford, Connecticut 06903 Listing by Rachel Levi
Unit for sale at 191 Sawmill Road, Stamford, Connecticut 06903

$950,000

  • 3 Beds
  • 4 Baths
  • 4,933 ft²
191 Sawmill Road, Stamford, Connecticut 06903 Listing by John Horan

Nearby Rentals

Unit for rent at 254 West Haviland Lane, Stamford, CT, 06903

$8,500 /mo

  • 5 Beds
  • 3.5 Baths
  • 3,983 ft²
254 West Haviland Lane, Stamford, CT, 06903 Listing by Aaron Ramkalawan
Unit for rent at 840 Rock Rimmon Road, Stamford, CT, 06903

$1,750 /mo

  • 1 Bed
  • 1 Bath
  • 514 ft²
840 Rock Rimmon Road, Stamford, CT, 06903 Listing by Pete Rosato
Unit for rent at 2850 Long Ridge Rd, Stamford, CT, 06903

$4,500 /mo

  • 3 Beds
  • 3 Baths
  • 2,800 ft²
2850 Long Ridge Rd, Stamford, CT, 06903 Listing by Manager


Frequently Asked Questions

When was property at 157 Harpsichord Turnpike built and last sold?
The property at 157 Harpsichord Turnpike was built in 2007 and last sold on Aug 19, 2020 for $1,175,000.
How much is this home worth?
The estimated value of the home located at 157 Harpsichord Turnpike is $1,212,739.
What are some comparable homes to 157 Harpsichord Turnpike?
There are currently no comparable homes to 157 Harpsichord Turnpike.

Quantcast