Skip main navigation
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,719,000 Zestimate®
    $252/sqft
    $-- Estimated rent

    Home value

    $2,719,000

    $2.45M - $3.02M

    Not available

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more
    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.

    See today's rates

    $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 started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Separate toilet rmSoaking tubHigh ceilingsStone fplSweeping curved staircaseStunning custom gourmet kitchenUnderground sprinkler system
    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.

    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#: 24074115MLS Logo

    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 & HOA

    Community
    • Subdivision: North Stamford
    HOA
    • Has HOA: No
    Location
    • Region: Stamford

    Financial & listing details

    • Price per square foot: $252/sqft
    • Tax assessed value: $1,469,500
    • Annual tax amount: $34,195
    • Date on market: 2/18/2025

    Price history

    DateEventPrice
    4/3/2026Pending sale$2,575,000-1.9%$247/sqft
    Source: Smart MLS #24074115 Report a problem
    4/2/2026Sold$2,625,000+1.9%$252/sqft
    Source: Smart MLS #24074115 Report a problem
    12/15/2025Price change$2,575,000-1.9%$247/sqft
    Source: Smart MLS #24074115 Report a problem
    8/12/2025Price change$2,625,000-3.7%$252/sqft
    Source: Smart MLS #24074115 Report a problem
    7/10/2025Price change$2,725,000-3.5%$262/sqft
    Source: Smart MLS #24074115 Report a problem
    5/14/2025Price change$2,825,000-0.9%$271/sqft
    Source: Smart MLS #24074115 Report a problem
    2/18/2025Listed for sale$2,850,000+356%$274/sqft
    Source: Smart MLS #24074115 Report a problem
    12/15/2023Sold$625,000-63.2%$60/sqft
    Source: Public Record Report a problem
    12/20/2020Listing removed$1,699,000$163/sqft
    Source: Halstead Real Estate #170298813 Report a problem
    11/13/2020Price change$1,699,000-5.6%$163/sqft
    Source: Halstead Real Estate #170298813 Report a problem
    7/23/2020Listed for sale$1,799,000-12.2%$173/sqft
    Source: Halstead Real Estate #170298813 Report a problem
    3/1/2004Sold$2,050,000+310%$197/sqft
    Source: Smart MLS #98172221 Report a problem
    8/29/2002Sold$500,000$48/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax 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 homes

    Nearby schools

    GreatSchools rating
    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,719,000
    2% more
    +$54,380
    With Zillow Showcase(estimated)
    $2,773,380
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $2,719,000
    2% more
    +$54,380
    With Zillow Showcase(estimated)
    $2,773,380

    Nearby cities

    Nearby neighborhoods

    Nearby zip codes

    Other Stamford Topics

      Search
      Updates
      Favorites
      Plan
      Inbox