George Cress of Real Broker Email: george@cress.co (dot co) Call/Text: 212-203-5251
Stamford, CT / SOLD
0 Ingleside Drive, Unit LOT B2Stamford, CT 06904
The buyer could have saved $27,463 in brokerage fees*
When you buy with Cress, we give you back a portion of the brokerage commission we receive.
See how the commission rebate works ↗*Estimate assumes a 2.5% buyer-agent commission and a 50% rebate. Actual savings depend on final purchase price and commission received. Based on the recorded closed price; this is a hypothetical estimate, not a statement of actual commission or rebate paid.
Sale Price$2,197,000ClosedJanuary 19, 2022
Open house
Our Take
0 Ingleside Drive in North Stamford is a custom modern farmhouse with waterfront views, five bedrooms, five full baths and one half bath. The home includes a three-car garage, an open-concept layout, a two-story entry foyer, and a glass-walled second-floor bonus room. Its kitchen has Viking appliances, quartz counters, and a 9-by-5-foot island. Set on 2.09 acres, the property has a level lot with stone walls overlooking a pond and running brook, plus unfinished basement and attic space.
At a glance
Closed · MLS #170382698- Bedrooms
- 5
- BathroomsBaths
- 5 full / 1 half
- Square feet
- 7,200
- Year built
- 2021
- Acres
- 2.09
- Property taxes
- $6,131
July 2020-June 2021
What stands out
- Five-bedroom modern farmhouse with 5.5 baths
- Three-car garage
- Two-story foyer with floating staircase
- Kitchen with Viking appliances and quartz counters
- Primary suite with fireplace and tray ceiling
- Level lot overlooking a pond and running brook
- Separate exterior basement entrance
- Pre-wired for a generator
Read the full listing description
Rare opportunity to own custom new construction in North Stamford with serene waterfront views. This stunning modern farmhouse features 5-bedrooms, 5.5 baths, a 3 car garage and 5300 sqft of finished space. Just 7 miles from Stamford downtown; a 45-min train ride to NYC. Located next to a cul-de-sac on a picturesque setting as part of a new subdivision with a pond. This spectacular home provides an expansive open concept floor plan with unique glass panel walls, barn doors, two-story double entry foyer with floating staircase looking up to a glass walled 2nd floor bonus room with a 20' ceiling to the loft in the attic above, an abundance of Pella windows/sliders, gourmet kit with Viking appl/quartz counters/9’x5’ island, oversize primary bedroom/bath suite with a 10' tray ceiling, fireplace, 24’x12’ closet plus a lux. 24’x12’ glam space. 1st bedroom/office with a see through fireplace to the fam. rm & a full bath just steps away from a future pool site. An add. 3000 sqft of unfinished space in the basement & attic can be used to add a home theater, wine room or more living space. A level lot with stone walls overlooking beautiful bucolic pond & running brook. Home to be complete in Fall 2021, with enough time to customize. Details incl. separate exterior basement entrance, spray foam insulation, 9' ceilings on both 1st & 2nd floor, 10’ ceilings in the attic, 5'' Character White Oak floors & modern trim design throughout, metal accent exterior roofs, pre-wired for generator.
Schools
- Elementary
- Northeast
- Middle
- Turn of River
- High
- Westhill
Schools as reported by SmartMLS. Confirm attendance assignments with the district.
Price history
| Date | Event | Price |
|---|---|---|
| Closed price | $2,197,000 | |
| Original list price | $1,999,000 |
Intermediate price changes and previous listings may not be included.
Interested in a property like this?
Cress can help you understand the market and find currently available homes.
*Estimate: $2,197,000 closed price × assumed 2.5% buyer-agent commission × 50% rebate = $27,463. Actual savings depend on the final purchase price and commission Cress receives. The assumed commission is not a representation of this listing's offered or actual compensation. This is a hypothetical estimate, not a rebate paid on this sale.
Listed by Arena Real Estate Services LLC
Joseph Schinella
SmartMLS · Listing #170382698 · Closed
Listing data checked: Sep 26, 2026, 12:16 PM EDT.
Listing information is deemed reliable but not guaranteed. Cress commentary is separate from the MLS listing description. Contact Cress about a correction.
For personal, noncommercial use to identify properties you may be interested in purchasing.