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.
New construction
Price cut: $25K (5/14)
$2,825,000
40 Hoyclo Road, Stamford, CT 06903
5beds
10,420sqft
Est.:
Single Family Residence
Built in 2024
1 Acres Lot
$2,757,900 Zestimate®
$271/sqft
$-- HOA
What's special
Separate toilet rmSoaking tubHigh ceilingsStone fplSweeping curved staircaseStunning custom gourmet kitchenUnderground sprinkler system
- 122 days
- on Zillow |
- 1,657 |
- 67 |
Zillow last checked: 7 hours ago
Listing updated: June 01, 2025 at 05:40pm
Listed by:
Lawrence Davidoff,
Davidoff Realty Co.
Source: Smart MLS,MLS#: 24074115

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
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: $271/sqft
- Tax assessed value: $1,454,880
- Annual tax amount: $35,586
- Date on market: 2/18/2025
- Loading
- Loading