Off Market Oct 2025 for $465K

$538,720

•

1,534

sq ft

40 Lindstrom Rd #40, Stamford, CT 06902

About this home

Welcome to Harbor View Court at the gateway to Shippan Point in Stamford. This 2-bedroom 1.5 bath end unit home is a rare find in one of the most sought-after water front neighborhoods in Stamford. This tri level home has more than 1,500 square feet, including the lower level. As the result of being an end unit the living area is very bright, and features wonderful open living. Both bedrooms are on the second level, and both are large and has good closet space. The lower level has the family room and a separate room for the washer and dryer. This lovely complex is conveniently located adjacent to Cummings Park and West Beach - two of Stamford's premier beaches and parks. Enjoy the breeze off Long Island Sound from your secluded backyard patio. Moments from the vibrant Stamford downtown area featuring dining, entertainment and shops. Additionally, you are only 1.5 miles from the Metro North and Amtrak service at the Stamford train station and interstate 95. Low homeowners' association fees and 2 reserved parking sport, plus plenty of guest parking makes this a ideal residence for wonderful living.

CondoProperty Type

1971Year Built

$351Est. Price/Sq.Ft.

2 spacesParking

Listed by Howard Dubman • Century 21 AllPoints Realty

Contact: Agent Attribution Contact: (203) 981-7047 | Office Attribution Contact: (203) 327-0021

Bought with Monsie Baez-Falcon • Keller Williams Realty Prtnrs.

Source:Smart MLS #24089745

Redfin Estimate

$538,720

$74K since sold in October 2025$2,000 since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 9.5% lower than the average sale price ($595K) of 6 comparable homes.

SOLD APR 30, 2026
$540,009
A
2 beds1.5 baths1,534 sq ft
54 Lindstrom Rd #54, Stamford, CT 06902
SOLD JUL 16, 2026
$485,000
B
2 beds1.5 baths1,503 sq ft
77 Van Buskirk Ave #77, Stamford, CT 06902
SOLD MAY 14, 2026
$629,000
C
2 beds2 baths1,600 sq ft
105 Harbor Dr #120, Stamford, CT 06902
SOLD JUL 21, 2026
$794,000
D
2 beds2 baths1,406 sq ft
123 Harbor Dr #308, Stamford, CT 06902
SOLD MAR 10, 2026
$627,000
E
2 beds2 baths1,600 sq ft
105 Harbor Dr #117, Stamford, CT 06902
SOLD MAY 11, 2026
$495,000
F
2 beds1.5 baths1,394 sq ft
55 Woodland Pl Apt 1, Stamford, CT 06902

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

Earn from this home

Sell

$139,713

Est. take-home

List your home with Redfin and save $5,387

Rent

$3,790/mo

Redfin rental estimate

List your home for rent

Market trends in 06902, CT

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

103.9%

+0.9% MoM

Median sale price

$680K

$117K MoM

Avg. days on market

30d

4 days MoM

Recently sold homes

138

34 MoM

New listings for sale

COMING SOON
$732,000
3 beds2 baths2,081 sq ft
114 Webb Ave, Stamford, CT 06902
FOR SALE BY OWNER
$219,780
1 bed1 bath427 sq ft
60 Strawberry Hill Ave, Stamford, CT 06902
$549,999
3 beds1 bath1,186 sq ft
28 Houston Ter, Stamford, CT 06902
22 Revere Dr #3, Stamford, CT 06902
$290,000
2 beds1 bath775 sq ft
22 Revere Dr #3, Stamford, CT 06902
$998,000
6 beds4 baths3,437 sq ft
101 Webb Ave, Stamford, CT 06902
$699,000
3 beds2 baths2,254 sq ft
107 Clovelly Rd, Stamford, CT 06902
3D WALKTHROUGH
$522,000
2 beds1.5 baths1,848 sq ft
83 Van Buskirk Ave, Stamford, CT 06902
$1,075,000
3 beds3 baths2,183 sq ft
45 Hemlock Dr, Stamford, CT 06902
$712,985
5 beds3 baths2,358 sq ft
224 Seaside Ave, Stamford, CT 06902
3D WALKTHROUGH
$460,000
2 beds2.5 baths1,404 sq ft
50 Glenbrook Rd Unit 7D, Stamford, CT 06902
See all

Provided by Redfin

Sale history for 40 Lindstrom Rd #40

Public record

Public record
Zoning

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Condo/Co-op

County

Fairfield County

APN

333137

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 27, 2025.

R-6

One- and Two-Family Districts

The purpose of this district is to set aside and protect areas which have been or may be developed predominantly for one family or two family detached family Dwellings on separate Lots. It is the intent of these regulations to stabilize such neighborhoods and preserve the type of Dwelling Units and Density provided for. Certain other uses are also permitted as-of-right or by Special Permit subject to adequate conditions and safeguards. It is intended that new Development permitted in this district be harmonious and compatible with existing Dwellings. 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 areas of diverse types.

Permitted uses

Include but are not limited to:

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

Property details

Parking

Garage Information
Garage & Parking: Off Street Parking, Unassigned Parking

Parking Information
Parking Total Spaces: 2

Interior

Interior Information
Total Rooms: 5
Levels In Unit: 3
Laundry Room Location: Separate room in lower level
Laundry Room Info: Lower Level
In-Law Apartment: No
Cooling System: Wall Unit
Appliances Included: Electric Range, Oven/Range, Refrigerator, Freezer, Icemaker, Dishwasher, Washer, Electric Dryer

Bathroom Information
# of Baths (Full): 1
# of Baths (Half): 1

Bedroom Information
Beds Total: 2

Room Information
Basement Description: Full, Heated, Partially Finished, Liveable Space, Concrete Floor

Exterior

Exterior Features
Exterior Siding: Brick

Lot Information
Lot Description: Corner Lot, Level Lot, On Cul-De-Sac

Building Information
Construction Description: Brick
Complex: Harbor View Court
Color: Brown Brick

Property Information
Waterfront Description: Walk to Water
Property Type: Condo/Co-Op For Sale
Property Sub Type: Condominium
Living Area SQFT Per Public Record: 1023

Financial

Assessments Information
Assessed Value: $240,750

Rental Information
Property Management Type: Unit Owners Association
Pets Allowed: Yes
Pets Allowed Info: Dogs and cats

Utilities

Utility Information
Water Source: Public Water Connected
Sewer Assess Description: Sewer fees paid by association
Sewage System: Public Sewer Connected
Hot Water Description: Electric
Heat Type: Baseboard
Heat Fuel Type: Electric

Location

Multi-Unit Information
Total Number of Units: 20
End Unit

HOA Information
Has Home Owner's Assocation
HOA Fee Frequency: Monthly
HOA Fee Amount: $325
Association Fee Includes: Security Service, Grounds Maintenance, Trash Pickup, Snow Removal, Water, Sewer, Property Management, Pest Control, Insurance

School Information
Middle Jr High School: Rippowam
High School: Stamford
Elementary School: Toquam Magnet

Location Information
State: Connecticut
Nearby Amenities: Commuter Bus, Playground/Tot Lot, Public Rec Facilities, Public Transportation, Shopping/Mall, Walk to Bus Lines
Directions: Shippan Ave, right on Lindstrom - 40 is on the right side at the end of the first building
County: Fairfield

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Condo/Co-op
Year Built: —
Year Renovated: —
County: Fairfield County
APN: 333137

Home facts updated by county records on Aug 27, 2025

Other

Documents & Disclosures
Supplement Count Public: 2

Around this home

Schools

Rogers International School

Public K-8 • Assigned • 1.2mi

5/10

Stamford High School

Public 9-12 • Assigned • 1.6mi

2/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

6/10 Heat Factor

7 days above 98° expected this year, 16 days in 30 years

6/10 Wind Factor

69% chance of strong winds in next 30 years

5/10 Air Factor

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

Provided by First Street

Historical weather

Stamford, CT • 06902

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

$512,000 – $620,000

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

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

Nearby similar homes

$290,000

2 beds1 bath775 sq ft

22 Revere Dr #3, Stamford, CT 06902

$449,999

2 beds2 baths1,276 sq ft

50 Glenbrook Rd Unit 2B, Stamford, CT 06902

$1,195,000

3 beds3.5 baths2,756 sq ft

994 Shippan Ave Unit B, Stamford, CT 06902

$475,000

2 beds2 baths1,500 sq ft

101 Grove St #29, Stamford, CT 06901

$285,000

2 beds1 bath860 sq ft

290 W Main St #4, Stamford, CT 06902

$299,000

1 bed1 bath650 sq ft

1 Valley Rd #108, Stamford, CT 06902

New listings for sale in 06902

COMING SOON

$732,000

3 beds2 baths2,081 sq ft

114 Webb Ave, Stamford, CT 06902

FOR SALE BY OWNER

$219,780

1 bed1 bath427 sq ft

60 Strawberry Hill Ave, Stamford, CT 06902

$549,999

3 beds1 bath1,186 sq ft

28 Houston Ter, Stamford, CT 06902

$290,000

2 beds1 bath775 sq ft

22 Revere Dr #3, Stamford, CT 06902

$998,000

6 beds4 baths3,437 sq ft

101 Webb Ave, Stamford, CT 06902

$699,000

3 beds2 baths2,254 sq ft

107 Clovelly Rd, Stamford, CT 06902

3D WALKTHROUGH

$522,000

2 beds1.5 baths1,848 sq ft

83 Van Buskirk Ave, Stamford, CT 06902

$1,075,000

3 beds3 baths2,183 sq ft

45 Hemlock Dr, Stamford, CT 06902

$712,985

5 beds3 baths2,358 sq ft

224 Seaside Ave, Stamford, CT 06902

Home values near 40 Lindstrom Rd #40

Data from public records.

Address	Redfin Estimate
38 Lindstrom Rd, Stamford, CT 2 Beds \| 1.5 Baths \| 1023 Sq. Ft.	$424,886
16 Lindstrom Rd Apt 5, Stamford, CT 2 Beds \| 2 Baths \| 1400 Sq. Ft.	$549,952

Address	Redfin Estimate
30 Lindstrom Rd, Stamford, CT 2 Beds \| 1.5 Baths \| 1023 Sq. Ft.	$451,792
32 Lindstrom Rd Apt 000032, Stamford, CT 2 Beds \| 1.5 Baths \| 1023 Sq. Ft.	$434,761

Address	Redfin Estimate
34 Lindstrom Rd, Stamford, CT 2 Beds \| 1.5 Baths \| 1023 Sq. Ft.	$451,123
56 Lindstrom Rd, Stamford, CT 2 Beds \| 1.5 Baths \| 1023 Sq. Ft.	$429,837

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

More real estate resources

Zip Codes
Minor Civil Divisions
Cities
Neighborhoods
Popular Searches

06820 homes for sale
06830 homes for sale
06902 homes for sale
06840 homes for sale
06906 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.

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

Cove-East Side-Shippan homes for sale
Shippan Point homes for sale