Brown Harris Stevens

Search
Ingleside Drive
Stamford, Connecticut
$2,495,000 Price
6 Bedrooms  
CloseClose Video
Photo 1 of Ingleside Drive, Stamford, Connecticut, $2,495,000, Web #: 24096732Previous PhotoNext Photo1 of 40

Stunning 2020 Custom New Construction home w/sparkling waterfront views. Set back far from the road, sited on 2.20 level acres in a serene new subdivision w/a pond, this fabulous modern farmhouse features 6 bedrooms, 6.5 baths, 3 car garage & custom elevator accessing 3 levels of finished living space....

Stunning 2020 Custom New Construction home w/sparkling waterfront views. Set back far from the road, sited on 2.20 level acres in a serene new subdivision w/a pond, this fabulous modern farmhouse features 6 bedrooms, 6.5 baths, 3 car garage & custom elevator accessing 3 levels of finished living space. Boasting 6,219 sq ft (2,239sf unfinished space in the lower-level w/walkout+plumbed for a bath), propane gas heat, city water, a full house generator & fenced in yard, this home is incomparable. A designer showcase gem, this home has an expansive open concept floor plan with unique glass panel walls, barn doors, white-oak hardwood flooring throughout, high ceilings, surround sound speakers, motorized shades, two-story double entry foyer with floating staircase looking up to a glass walled 2nd fl media room with a 20' ceiling to the Finished 3rd floor above. The gourmet kitchen, w/Viking appliances/quartz counters w/9' x 5' center island & 10ft long beverage counter, w/custom cabinetry, 2 wine fridges & bar sink adjoins the breakfast area, a large family room w/fireplace, walls of windows & 8-glass door panels allowing abundant sunshine indoors & views to the fenced yard & pond. Step outside to the flagstone patio w/built-in grill & stone walls, the perfect venue for outdoor entertaining. There's a proper dining room area, spacious living room & 1st floor bedroom/office w/fireplace, full bath & glass doors to flagstone patio.

Listing courtesy of Bhhs Darien/New Canaan

Calculate your Payments

Asking Price:

Percent Down:

Loan Amount:

Interest Rate:

Loan Term (years):

Estimated Mortgage Payment:

Monthly Real Estate Tax:

Total Monthly Payment:

* All information furnished regarding property for sale, rental, financing or estimated mortgage rates is from sources deemed reliable but no warranty or representation is made as to the accuracy thereof. For further financing information, please contact a Brown Harris Stevens agent.

Listing Details

New Listing
Stamford, Connecticut
Type: House
Price: $2,495,000
Re Tax: $30,125
Date Listed: 5/16/2025
Last Updated: 5/19/2025
Approx. sqft: 6,219 sf
Web ID: 24096732

Info & Amenities

Type: Single Family
Rooms: 14.0
Bedrooms: 6
Bathrooms: 7.0
Built: 2020
Woodburning fireplaces: 3

Get to Know Stamford

Stamford is a welcoming, growing city defined by its mix of urban and suburban atmospheres. Though it was once a suburb of New York City, today it’s a thriving city—the second-largest in Connecticut—on the coast of the Long Island Sound. Diverse and boasting a strong sense of community, Stamford is also home to several Fortune 500 companies and many corporate headquarters.

More About Stamford

Neighborhood Guide to Stamford

All information is from sources deemed reliable but is subject to errors, omissions, changes in price, prior sale or withdrawal without notice. No representation is made as to the accuracy of any description. All measurements and square footages are approximate and all descriptive information should be confirmed by customer. All rights to content, photographs and graphics are reserved to Brown Harris Stevens. Customer should consult with its counsel regarding all closing and tax costs. Broker represents the seller/owner on Broker's own exclusives, except if another agent of Broker represents the buyer/tenant, in which case Broker will be a dual agent, in Connecticut, or , in New York State and New Jersey, a dual agent with designated or disclosed agents representing seller/owner and buyer/tenant. Broker represents the buyer/tenant when showing the exclusives of other real estate firms. In Florida, Broker acts as a Transaction Broker with all sellers and buyers, unless a different form of agency has been established in writing. If you are looking to purchase or rent housing, are using a screen reader, and are having problems using this website, please call 1-212-712-1163 for assistance. All phone charges will be reimbursed by Brown Harris Stevens. Broker actively supports Fair Housing and Equal Housing Opportunities. BHS has adopted the attached policy statement - Prior to showing a homebuyer a property or providing services: (1) BHS does not require identification from a prospective homebuyer, (2) BHS may require a written agreement from a homebuyer before showing properties; and (3) BHS does not require a pre-approval for a mortgage loan in order to show a homebuyer properties. However, based upon the requirements of the seller, the building in which the properties is located, or others, some or all of the foregoing items may be required. Listing information for certain New York City properties provided courtesy of the Real Estate Board of New York's Residential Listing Service (the "RLS"). The information contained in this listing has not been verified by the RLS and should be verified by the consumer. The listing information provided here is for the consumer's personal, non-commercial use. Retransmission, redistribution or copying of this listing information is strictly prohibited except in connection with a consumer's consideration of the purchase and/or sale of an individual property. This listing information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. 2025 The Real Estate Board of New York, Inc., all rights reserved. RLS Data display by Brown Harris Stevens. Powered by Terra Holdings.