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

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.

0 Ingleside Drive, Unit LOT B2 — exterior photo
Open Google Maps ↗

Estimated buyer rebate

The buyer could have saved $27,463 on 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.

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

DateEventPrice
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.

Talk with Cress →

*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.