Off Market Oct 2024 for $1.5M

$1,399,299

Est. refi paymentEst. refi $5,359/mo

•

2,593

sq ft

587 Haviland Rd, Stamford, CT 06903

About this home

Character and charm fill this impeccably updated antique farmhouse. The beautifully landscaped, 1.51 level acres boasts a sparkling inground pool and expansive rear yard allowing for the ideal entertaining space, multiple play areas and idyllic unwinding space. The upper level of the home consists of an en-suite primary bedroom, two additional bedrooms with a shared hall bath. The main level flows perfectly and is appointed with a cozy living room/ library, light-filled family room/ dining area, updated kitchen, office equipped with pocket doors for privacy, and a flexible main level, en-suite bedroom with a separate entrance. A true North Stamford oasis yet still convenient to amenities and the Merritt Parkway. This is the home and setting which will help you create a lifetime of wonderful memories.

Single-familyProperty Type

1740Year Built

1.51 acresLot Size

$540Est. Price/Sq.Ft.

2 car garageParking

Listed by Lara Winters • Brown Harris Stevens

Bought with Cheryl McCormick • Brown Harris Stevens

Bought with Tricia Neylan • Brown Harris Stevens

Source:Smart MLS #24042067

Redfin Estimate

$1,399,299

$131K since sold in October 2024$167K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 39.2% higher than the average sale price ($1.01M) of 5 comparable homes.

SOLD MAY 7, 2026
$1,394,000
A
4 beds3 baths3,202 sq ft
202 Fox Ridge Rd, Stamford, CT 06903
SOLD AUG 28, 2026
$1,427,500
B
4 beds2.5 baths2,890 sq ft
1097 Sunset Rd, Stamford, CT 06903
SOLD MAR 25, 2026
$774,000
C
4 beds3 baths2,402 sq ft
27 Wellington Dr, Stamford, CT 06903
SOLD DEC 16, 2025
$845,000
D
4 beds3 baths1,957 sq ft
43 Mill Rd, Stamford, CT 06903
SOLD AUG 31, 2026
$585,000
E
4 beds3 baths1,603 sq ft
1566 Long Ridge Rd, Stamford, CT 06903

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$133,894

Est. take-home

List your home with Redfin and save $13,993

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$3,611/mo

Redfin rental estimate

List your home for rent

Market trends in 06903, CT

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

106.5%

1.2% MoM

Median sale price

$1.3M

$43K MoM

Avg. days on market

30d

4 days MoM

Recently sold homes

13 MoM

New listings for sale

NEW 12 HRS AGO
$1,595,000
3 beds4 baths3,942 sq ft
460 Cascade Rd, Stamford, CT 06903
COMING SOON
$619,000
3 beds1.5 baths1,125 sq ft
431 Scofieldtown Rd, Stamford, CT 06903
$919,000
3 beds2.5 baths2,536 sq ft
70 Arrow Head Dr, Stamford, CT 06903
COMING SOON
$1,175,000
4 beds2.5 baths3,317 sq ft
48 Chestnut Hill Ln, Stamford, CT 06903
$1,225,000
4 beds4 baths3,481 sq ft
231 Skymeadow Dr, Stamford, CT 06903
$1,795,000
3 beds3 baths3,312 sq ft
58 Skymeadow Dr, Stamford, CT 06903
$1,725,000
4 beds4 baths5,002 sq ft
79 Cross Country Trl, Stamford, CT 06903
$750,000
3 beds2.5 baths2,568 sq ft
981 Rock Rimmon Rd, Stamford, CT 06903
$725,000
3 beds2.5 baths2,161 sq ft
421 Chestnut Hill Rd, Stamford, CT 06903
$769,000
4 beds2.5 baths2,416 sq ft
568 Hunting Ridge Rd, Stamford, CT 06903
See all

Provided by Redfin

Sale history for 587 Haviland Rd

Date

Event

Price

Smart MLS #24042067

Oct 22, 2024

Sold

$1,530,000

$590/sq ft

Sep 19, 2024

Pending

—

Sep 12, 2024

Contingent

—

Sep 4, 2024

Listed

$995,000

$384/sq ft

Aug 28, 2024

Coming Soon

$995,000

$384/sq ft

Smart MLS #99051316

Apr 30, 2014

Sold

$800,000

$309/sq ft

Jan 20, 2014

Listed

$849,500

$328/sq ft

Country Colonial on 1.5 stunning level North Stamford acres. A rare blend of period details, modern updates and open flow. Light-filled family room opens to kitchen and playroom/dining room with a walk out slider to the enormous backyard. Spacious updated master bedroom with a deluxe new bathroom. Large first floor bedroom/bonus room has full bath with laundry. Antique living room with fireplace and original wide plank floor. Relax in privacy along state of the art 20 x 42 grey gunite swimming pool with built-in electric heat retaining safety cover. Detached two car garage with loft storage. A North Stamford gem.

Public Records

Mar 16, 1998

Sold

$352,500

$136/sq ft

Smart MLS #97026606

Sep 15, 1997

Listed

$349,000

$135/sq ft

Tax history for 587 Haviland Rd

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

1.51 Acres

Year renovated

—

Sq. Ft.

2,593

Year built

1740

Style

Single Family Residential

County

Fairfield County

APN

313947

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 12, 2023.

RA-1

Single Family Districts, Very Low Density

The purpose of these districts is to set aside and protect areas which have been or may be developed predominantly for single family dwellings on large Lots in a rural setting. Certain other uses are also permitted as-of-right or by Special Permit subject to adequate conditions and safeguards. It is intended that all uses permitted in these districts be compatible with single family Development and consistent with local Street characteristics, the use and protection of private water and sewer facilities (where public facilities are unavailable) and the level of other public services. it is hereby found and declared, further, that these regulations are necessary to the protection of these areas and that their protection is essential to the maintenance of a balanced community of sound residential area of diverse types.

Permitted uses

Include but are not limited to:

Housing-Single unit
Housing-Senior
Educational/school
Communications tower

Property details

Parking

Garage Information
Garage & Parking: Detached Garage
Garages Number: 2

Interior

Virtual Tour Information

Interior Information
Total Rooms: 8
Laundry Room Info: Main Level
In-Law Apartment: Possible
In-Law Access: First Floor
Fireplaces Total: 1
Cooling System: Central Air
Appliances Included: Electric Range, Microwave, Refrigerator, Dishwasher, Washer, Dryer

Bathroom Information
# of Baths (Full): 3

Bedroom Information
Beds Total: 4

Room Information
Basement Description: Partial
Has Attic
Attic Description: Pull-Down Stairs

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Wood

Lot Information
Lot Description: Level Lot, Professionally Landscaped

Pool Information
Swimming Pool
Pool Description: In Ground Pool

Building Information
Foundation Type: Block, Stone
Construction Description: Frame

Property Information
Waterfront Description: Beach Rights
Property Type: Single Family For Sale

Financial

Assessments Information
Assessed Value: $589,390

Utilities

Utility Information
Water Source: Private Well
Sewage System: Septic
Hot Water Description: Domestic
Heat Type: Hot Water
Heat Fuel Type: Electric

Location

School Information
High School: Westhill
Elementary School: Northeast

Location Information
State: Connecticut
Directions: Long Ridge to Hunting Ridge to Haviland
County: Fairfield

Public facts

Beds: 4
Baths: 3.0
Sq. Ft.: 2,593
Stories: 2.0
Lot Size: 1.51 acres
Style: Single Family Residential
Year Built: 1740
Year Renovated: —
County: Fairfield County
APN: 313947

Home facts updated by county records on Jul 12, 2023

Other

Documents & Disclosures
Supplement Count Public: 4

Around this home

Schools

Northeast School

Public K-5 • Assigned • 2.1mi

5/10

Turn Of River School

Public 6-8 • Assigned • 3.5mi

3/10

Westhill High School

Public 9-12 • Assigned • 3.4mi

3/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

4/10 Heat Factor

7 days above 100° expected this year, 15 days in 30 years

6/10 Wind Factor

27% chance of strong winds in next 30 years

4/10 Air Factor

5 unhealthy days expected this year, 7 days in 30 years

Provided by First Street

Historical weather

Stamford, CT • 06903

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 8.7 hours in June and 4.3 hours in December, placing it below the U.S. average for solar exposure.

8.7 hrs

4.3 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$1.33M – $1.61M

Reach more buyers when you sell with Redfin. Save up to $13,993 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

NEW CONSTRUCTION

$10,995,000

6 beds9 baths12,310 sq ft

67 Stag Ln, Greenwich, CT 06831

OPEN SAT, 11:30AM TO 1PM

$925,000

4 beds3 baths2,315 sq ft

26 Campbell Dr, Stamford, CT 06903

$1,995,000

6 beds4.5 baths6,986 sq ft

223 Jonathan Dr, Stamford, CT 06903

3D WALKTHROUGH

$8,250,000

6 beds7.5 baths9,440 sq ft

34 Carrington Dr, Greenwich, CT 06831

$965,000

4 beds2.5 baths2,708 sq ft

151 Sun Dance Rd, Stamford, CT 06905

NEW 12 HRS AGO

$1,595,000

3 beds4 baths3,942 sq ft

460 Cascade Rd, Stamford, CT 06903

New listings for sale in 06903

NEW 12 HRS AGO

$1,595,000

3 beds4 baths3,942 sq ft

460 Cascade Rd, Stamford, CT 06903

COMING SOON

$619,000

3 beds1.5 baths1,125 sq ft

431 Scofieldtown Rd, Stamford, CT 06903

$919,000

3 beds2.5 baths2,536 sq ft

70 Arrow Head Dr, Stamford, CT 06903

COMING SOON

$1,175,000

4 beds2.5 baths3,317 sq ft

48 Chestnut Hill Ln, Stamford, CT 06903

$1,225,000

4 beds4 baths3,481 sq ft

231 Skymeadow Dr, Stamford, CT 06903

$1,795,000

3 beds3 baths3,312 sq ft

58 Skymeadow Dr, Stamford, CT 06903

$1,725,000

4 beds4 baths5,002 sq ft

79 Cross Country Trl, Stamford, CT 06903

$750,000

3 beds2.5 baths2,568 sq ft

981 Rock Rimmon Rd, Stamford, CT 06903

$725,000

3 beds2.5 baths2,161 sq ft

421 Chestnut Hill Rd, Stamford, CT 06903

Home values near 587 Haviland Rd

Data from public records.

Address	Redfin Estimate
547 Haviland Rd, Stamford, CT 5 Beds \| 6.5 Baths \| 8129 Sq. Ft.	$2,674,830
555 Haviland Rd, Stamford, CT 4 Beds \| 3.5 Baths \| 3226 Sq. Ft.	$1,458,606

Address	Redfin Estimate
603 Haviland Rd, Stamford, CT 5 Beds \| 4 Baths \| 4882 Sq. Ft.	$1,727,093
592 Haviland Rd, Stamford, CT 4 Beds \| 4 Baths \| 3523 Sq. Ft.	$1,751,048

Address	Redfin Estimate
519 Haviland Rd, Stamford, CT 3 Beds \| 3.5 Baths \| 3161 Sq. Ft.	$1,681,571
119 Haviland Rd, Stamford, CT 5 Beds \| 4.5 Baths \| 6553 Sq. Ft.	$1,966,553

Property information provided by Smart MLS when last listed in 2024. This data may not match . Learn more.

More real estate resources

Neighborhoods
Zip Codes
Minor Civil Divisions
Cities
Popular Searches

North Stamford homes for sale

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

06820 homes for sale
06830 homes for sale
06902 homes for sale
06840 homes for sale
06906 homes for sale

Wilton homes for sale
Teaneck Township homes for sale
Weston homes for sale
Fairfield homes for sale
New Canaan homes for sale

Houses for rent in Stamford	Agents near me	Westport, CT homes for sale	Stamford Housing Market
Houses for sale near me	Greenwich, CT homes for sale	New Haven, CT homes for sale
Land for sale near me	Stamford, CT homes for sale	Milford, CT homes for sale
Open Houses near me	West Hartford, CT homes for sale	Stamford Property Records
Condos for sale near me	Norwalk, CT homes for sale	CT New Listings

Greenwich homes for sale
White Plains homes for sale
New York homes for sale