Stately North Stamford Colonial w/Sweeping Curved Staircase. Completely reconstructed in 2024. New Electrical, Plumbing, Super High Efficiency Heat Pumps HVAC, New Walls, Ceilings, and Hdwd Fls. Stunning Custom Gourmet Kitchen w/Thermidor Appliances, 6ft wide Refrigerator/Freezer, Double Oven, and Cooktop. Butlers Pantry w/Wine Cooler, Large Island, Dining Area, French Doors opening to Large Patio. Formal Dining Room, Two Story Fam Rm w/ Stone FPL, Custom Cherry Paneled Library. Magnificent Primary Bedroom Suite w/ Tray Ceilings, Large Walk-in Dressing Closet. Lovely En-suit Bath w/separate Vanities,large Walk-In Shower and Soaking Tub with Separate Toilet Rm. 2 Large Bedrooms w/their own en-suite Bathrooms, 2 additional Bedrooms w/attached Jack & Jill en-suite Bathrooms and large Hallway with separate Study areas and build in Desks. Completely equipped Laundry Rm on 2nd Fl. Fully Finished and conditioned 3rd Floor plus additional Attic Storage. Full Basement (2500s/f) with High Ceilings. 3 Car Garage, Underground Sprinkler System, 2-80 Gallon Hot Water Heaters, Central Vac. and many other enhancements. MUST see to appreciate.
Accepting backups
$2,575,000
40 Hoyclo Road, Stamford, CT 06903
5beds
10,420sqft
Est.:
Single Family Residence
Built in 2024
1 Acres Lot
$-- Zestimate®
$247/sqft
$-- HOA
What's special
Separate toilet rmSoaking tubHigh ceilingsStone fplSweeping curved staircaseStunning custom gourmet kitchenUnderground sprinkler system
- 395 days |
- 1,483 |
- 44 |
Zillow last checked: 7 hours ago
Listing updated: February 28, 2026 at 09:40am
Listed by:
Lawrence Davidoff (203)554-2999,
Davidoff Realty Co. 203-327-2190
Source: Smart MLS,MLS#: 24074115
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Features: Vaulted Ceiling(s), Bedroom Suite, Dressing Room, Stall Shower, Steam/Sauna, Walk-In Closet(s)
- Level: Upper
- Area: 619.37 Square Feet
- Dimensions: 24.1 x 25.7
Bedroom
- Features: Full Bath, Walk-In Closet(s)
- Level: Upper
- Area: 228 Square Feet
- Dimensions: 15 x 15.2
Bedroom
- Features: Full Bath
- Level: Upper
- Area: 179.07 Square Feet
- Dimensions: 12.7 x 14.1
Bedroom
- Features: Jack & Jill Bath
- Level: Upper
- Area: 255.36 Square Feet
- Dimensions: 15.2 x 16.8
Bedroom
- Features: Jack & Jill Bath, Walk-In Closet(s)
- Level: Upper
- Area: 450 Square Feet
- Dimensions: 20 x 22.5
Dining room
- Features: Bay/Bow Window
- Level: Main
- Area: 332.88 Square Feet
- Dimensions: 15.2 x 21.9
Family room
- Features: 2 Story Window(s), Cathedral Ceiling(s), Balcony/Deck, Fireplace
- Level: Main
- Area: 436 Square Feet
- Dimensions: 20 x 21.8
Kitchen
- Features: High Ceilings, Quartz Counters, Eating Space, French Doors, Pantry, Patio/Terrace
- Level: Main
- Area: 680.6 Square Feet
- Dimensions: 20.5 x 33.2
Library
- Features: High Ceilings, Bookcases, Built-in Features, Wet Bar
- Level: Main
- Area: 234.96 Square Feet
- Dimensions: 13.2 x 17.8
Living room
- Features: High Ceilings, Fireplace
- Level: Main
- Area: 383.56 Square Feet
- Dimensions: 22.3 x 17.2
Rec play room
- Level: Third,Other
- Area: 1298.76 Square Feet
- Dimensions: 31.6 x 41.1
Study
- Features: High Ceilings
- Level: Main
- Area: 174.24 Square Feet
- Dimensions: 12.1 x 14.4
Heating
- Heat Pump, Forced Air, Electric
Cooling
- Heat Pump
Appliances
- Included: Gas Cooktop, Oven, Convection Oven, Microwave, Range Hood, Refrigerator, Ice Maker, Dishwasher, Disposal, Washer, Dryer, Wine Cooler, Water Heater
- Laundry: Upper Level
Features
- Basement: Full
- Attic: Storage,Finished,Walk-up
- Number of fireplaces: 2
Interior area
- Total structure area: 10,420
- Total interior livable area: 10,420 sqft
- Finished area above ground: 7,800
- Finished area below ground: 2,620
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached
- Attached garage spaces: 3
Lot
- Size: 1 Acres
- Features: Wooded, Level
Details
- Parcel number: 315283
- Zoning: RA1
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Clapboard
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- Torn Down & Rebuilt
- New construction: Yes
- Year built: 2024
Details
- Warranty included: Yes
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & HOA
Community
- Subdivision: North Stamford
HOA
- Has HOA: No
Location
- Region: Stamford
Financial & listing details
- Price per square foot: $247/sqft
- Tax assessed value: $1,469,500
- Annual tax amount: $34,195
- Date on market: 2/18/2025
Estimated market value
Not available
Estimated sales range
Not available
$8,314/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 12/15/2025 | Price change | $2,575,000-1.9%$247/sqft |
Source:  Smart MLS #24074115 Report a problem | ||
| 8/12/2025 | Price change | $2,625,000-3.7%$252/sqft |
Source: Smart MLS #24074115 Report a problem | ||
| 7/10/2025 | Price change | $2,725,000-3.5%$262/sqft |
Source: Smart MLS #24074115 Report a problem | ||
| 5/14/2025 | Price change | $2,825,000-0.9%$271/sqft |
Source: Smart MLS #24074115 Report a problem | ||
| 2/18/2025 | Listed for sale | $2,850,000+356%$274/sqft |
Source: Smart MLS #24074115 Report a problem | ||
| 12/15/2023 | Sold | $625,000-63.2%$60/sqft |
Source: Public Record Report a problem | ||
| 12/20/2020 | Listing removed | $1,699,000$163/sqft |
Source: Halstead Real Estate #170298813 Report a problem | ||
| 11/13/2020 | Price change | $1,699,000-5.6%$163/sqft |
Source: Halstead Real Estate #170298813 Report a problem | ||
| 7/23/2020 | Listed for sale | $1,799,000-12.2%$173/sqft |
Source: Halstead Real Estate #170298813 Report a problem | ||
| 3/1/2004 | Sold | $2,050,000+310%$197/sqft |
Source: Smart MLS #98172221 Report a problem | ||
| 8/29/2002 | Sold | $500,000$48/sqft |
Source: Public Record Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $34,328 +3.7% | $1,469,500 +1% |
| 2024 | $33,113 -6.9% | $1,454,880 |
| 2023 | $35,586 +14% | $1,454,880 +22.7% |
| 2022 | $31,217 +1.4% | $1,185,600 |
| 2021 | $30,790 +2.5% | $1,185,600 |
| 2020 | $30,031 | $1,185,600 |
| 2019 | $30,031 +3.6% | $1,185,600 |
| 2018 | $28,988 -15.4% | $1,185,600 -11.4% |
| 2017 | $34,252 +3.1% | $1,338,490 |
| 2016 | $33,221 | $1,338,490 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$16,905/mo
Principal & interest
$13279
Property taxes
$3626
More affordability tools
Climate risks
Neighborhood: North Stamford
Nearby schools
GreatSchools rating
- 5/10Northeast SchoolGrades: K-5Distance: 1.6 mi
- 3/10Turn Of River SchoolGrades: 6-8Distance: 3.3 mi
- 3/10Westhill High SchoolGrades: 9-12Distance: 3.9 mi
Schools provided by the listing agent
- Elementary: Northeast
- Middle: Turn of River
- High: Westhill
Source: Smart MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 06903
- Connecticut
- Fairfield County
- Stamford
- 06903
- North Stamford
- 40 Hoyclo Road
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Stamford Topics
