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.
Sold for $2,625,000
$2,625,000
40 Hoyclo Road, Stamford, CT 06903
5beds
10,420sqft
Single Family Residence
Built in 2024
1 Acres Lot
$2,647,300 Zestimate®
$252/sqft
$8,314 Estimated rent
Home value
$2,647,300
$2.38M - $2.94M
$8,314/mo
Zestimate® history
Owner options
List your home for rent
$8,314/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$8,314/mo
Rent Zestimate®
Refinance and save
$14,794/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$14,794/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Separate toilet rmSoaking tubHigh ceilingsStone fplSweeping curved staircaseStunning custom gourmet kitchenUnderground sprinkler system
Zillow last checked:
Listing updated:
Listed by:
Lawrence Davidoff (203)554-2999,
Davidoff Realty Co. 203-327-2190
Bought with:
Marc Tessitore, RES.0802351
Coldwell Banker Realty
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
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 & neighborhood
Location
- Region: Stamford
- Subdivision: North Stamford
Price history
| Date | Event | Price |
|---|---|---|
| 4/3/2026 | Pending sale | $2,575,000-1.9%$247/sqft |
Source:  Smart MLS #24074115 Report a problem | ||
| 4/2/2026 | Sold | $2,625,000+1.9%$252/sqft |
Source: Smart MLS #24074115 Report a problem | ||
| 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
| 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
Neighborhood: North Stamford
Nearby schools
GreatSchools rating
- 5/10Northeast SchoolGrades: K-5Distance: 1.7 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.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$2,647,300
2% more
+$52,946
With Zillow Showcase(estimated)
$2,700,246
- Connecticut
- Fairfield County
- Stamford
- 06903
- North Stamford
- 40 Hoyclo Road
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Stamford Topics
