• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • elliman global
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • Elliman Private Listings
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • estate, trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2026 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON JAN 08 2026 AT 3:53 PM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

SCAMMERS ARE IMPERSONATING REAL ESTATE AGENTS AND USING ACTIVE LISTINGS TO REQUEST FAKE DEPOSITS. SHOULD YOU HAVE A QUESTION ABOUT THE LEGITIMACY OF A DOUGLAS ELLIMAN AGENT OR LISTING, PLEASE CONTACT THE AGENT DIRECTLY VIA THE “AGENTS” LINK IN THE TOP MENU. DOUGLAS ELLIMAN WILL NEVER ASK FOR ANY PAYMENT TO RESERVE, HOLD, OR VIEW A PROPERTY. THESE CHARGES ARE PROHIBITED UNDER NEW YORK LAW. IF YOU RECEIVE A SUSPICIOUS REQUEST FOR MONEY, DO NOT SEND FUNDS. REPORT IT TO THE NYS DEPARTMENT OF STATE AND NOTIFY DOUGLAS ELLIMAN. YOU CAN READ THE NEW YORK STATE DEPARTMENT OF STATE'S CONSUMER ALERT HERE.

POWERED BY PURLIN.AI

122 Brook Run Ln

mid-ridges, stamford, CT 06905

$2,300,000

  • 6 BR
    6 BA, 1 HALF BA
    APPROX. 5,760 SF
  • sold

INTERESTED? LET'S CONNECT

Experience luxury living at its finest in this exquisite direct waterfront property that has been completely renovated by award winning builder. Convenience & sophisticated style is what you get with this ultra-chic 6 bedroom 6.5 bathroom one of a kind property that will take your breath away from the moment you walk through the front door. Built with the best finishes in mind, you'll enjoy 10ft+ ceilings, flexible open floor plan, private office, walls of large-pane oversized glass with breathtaking water views, and formal rooms that flow seamlessly from one to another. Entertaining is easy in the ultimate dream kitchen featuring two islands with 2"quartz countertops, chefs appliances, two dishwashers, wine fridge, custom walk-in pantry, wet bar, and dramatic windowed breakfast area that opens to the family room overlooking the fabulous deck with unobstructed views of the lake. Wide plank floors, custom staircase with glass railings, and cubie built-ins will show the attention to detail. Absolutely spectacular primary bedroom with sitting are, huge walk-in closet, private deck and spa like bathroom featuring heated floors, double sink vanity and beautiful shower w/ frameless glass door. (All bedrooms have en-suite bathrooms with heated floors). Head Downstairs to a beautifully finished walkout lower level with full kitchen, additional bedroom, full bath, media room, game room, Gym, and 2nd laundry. The perfect space for au-pair quarters or in-law suite.

Details

5,760 Sq Ft

0.7 Private Acres Lot Size

Other

Built in 1955

MLS/Listing ID 24136360

Amenities & Features

Access

Lake

Style - Cape Cod

Construction - Frame

Patio

Balcony

Open Floor Plan

Main Level

Parking - Paved

Parking - Driveway

Porch

Washer

Refrigerator

Range Hood

Microwave

Gas Cooktop

Freezer

Dryer

Dishwasher

Style - Colonial

SMART

Interested in 122 Brook Run Ln?