Nestled privately off Main Street, this exceptional custom Colonial offers over-the-top craftsmanship, timeless elegance, and remarkable versatility with 6-7 bedrooms, 6 full baths, and 2 half baths. Designed for both grand entertaining and comfortable everyday living, the home features two primary suites, creating excellent potential as an in-law suite or multigenerational living. A dramatic marble foyer welcomes you into an interior rich with architectural detail, including stately columns, graceful archways, crown molding, and gleaming hardwood floors. The formal living room and private office each feature a fireplace, while the elegant dining room provides the perfect setting for special gatherings. At the heart of the home, the impressive family room boasts soaring ceilings, floor-to-ceiling windows, and a stunning fireplace that fills the space with natural light and warmth. The spacious eat-in kitchen is appointed with custom cabinetry, granite countertops, and abundant workspace for cooking and entertaining. Step outside to a beautiful patio framed by a stone wall and overlooking the expansive grounds, offering a peaceful retreat with room to relax, play, or entertain. Additional highlights include a 3-car attached garage, multiple living areas, and a highly convenient location close to shopping, dining, schools and parks. A rare opportunity to own a truly distinguished residence that combines luxury, functionality, and privacy.
Sold for $1,150,000
$1,150,000
1742 Main Street, South Windsor, CT 06074
6beds
6,828sqft
Single Family Residence
Built in 1995
3.79 Acres Lot
$945,900 Zestimate®
$168/sqft
$6,191 Estimated rent
Home value
$945,900
$899,000 - $993,000
$6,191/mo
Zestimate® history
Owner options
List your home for rent
$6,191/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$6,191/mo
Rent Zestimate®
Refinance and save
$9,103/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$9,103/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
Stunning fireplaceArchitectural detailSoaring ceilingsCrown moldingTwo primary suitesPrivate officeDramatic marble foyer
Zillow last checked:
Listing updated:
Listed by:
Anthony G. Cervoni (954)395-6344,
Redfin Corporation 203-349-8711
Bought with:
Anthony G. Cervoni, REB.0795616
Redfin Corporation
Source: Smart MLS,MLS#: 24183232
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 8
- Full bathrooms: 6
- 1/2 bathrooms: 2
Primary bedroom
- Features: Ceiling Fan(s), Full Bath, Stall Shower, Whirlpool Tub, Walk-In Closet(s), Hardwood Floor
- Level: Main
Primary bedroom
- Features: Bedroom Suite, Full Bath, Stall Shower, Walk-In Closet(s), Wall/Wall Carpet
- Level: Upper
Bedroom
- Features: Bedroom Suite, Full Bath, Walk-In Closet(s), Wall/Wall Carpet, Tub w/Shower
- Level: Upper
Bedroom
- Features: Bedroom Suite, Full Bath, Wall/Wall Carpet, Stall Shower
- Level: Upper
Bedroom
- Features: Bedroom Suite, Full Bath, Walk-In Closet(s), Wall/Wall Carpet
- Level: Upper
Bedroom
- Features: Bedroom Suite, Full Bath, Walk-In Closet(s), Wall/Wall Carpet, Stall Shower
- Level: Upper
Bathroom
- Features: Hardwood Floor
- Level: Main
Bathroom
- Features: Hardwood Floor
- Level: Main
Den
- Features: Wall/Wall Carpet
- Level: Third,Upper
Dining room
- Features: Hardwood Floor
- Level: Main
Family room
- Features: Palladian Window(s), High Ceilings, Ceiling Fan(s), Fireplace, Hardwood Floor
- Level: Main
Kitchen
- Features: Breakfast Nook, Granite Counters, Dining Area, Kitchen Island, Hardwood Floor
- Level: Main
Living room
- Features: Fireplace, Hardwood Floor
- Level: Main
Office
- Features: Bookcases, Built-in Features, Fireplace, French Doors, Hardwood Floor
- Level: Main
Other
- Features: Wall/Wall Carpet
- Level: Upper
Other
- Features: Built-in Features, Laundry Hookup, Tile Floor
- Level: Upper
Heating
- Forced Air, Oil, Propane
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Oven/Range, Oven, Refrigerator, Dishwasher, Disposal, Trash Compactor, Washer, Dryer, Water Heater
- Laundry: Main Level, Upper Level
Features
- Open Floorplan
- Basement: Full
- Attic: Finished,Walk-up
- Number of fireplaces: 3
Interior area
- Total structure area: 6,828
- Total interior livable area: 6,828 sqft
- Finished area above ground: 6,828
Property
Parking
- Total spaces: 3
- Parking features: Attached, Garage Door Opener
- Attached garage spaces: 3
Features
- Patio & porch: Patio
- Exterior features: Rain Gutters, Stone Wall
Lot
- Size: 3.79 Acres
- Features: Secluded, Rear Lot, Wooded, Level, Landscaped
Details
- Additional structures: Shed(s)
- Parcel number: 715620
- Zoning: A40
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1995
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Underground Utilities, Cable Available
Community & HOA
Community
- Features: Golf, Health Club, Library, Medical Facilities, Park, Playground, Public Rec Facilities, Shopping/Mall
HOA
- Has HOA: No
Location
- Region: South Windsor
Financial & listing details
- Price per square foot: $168/sqft
- Tax assessed value: $716,700
- Annual tax amount: $26,525
- Date on market: 6/26/2026
- Exclusions: Please see the inclusion exclusions form.
Price history
| Date | Event | Price |
|---|---|---|
| 9/4/2026 | Sold | $1,150,000+15%$168/sqft |
Source:  Smart MLS #24183232 Report a problem | ||
| 8/21/2026 | Pending sale | $999,900$146/sqft |
Source: Smart MLS #24183232 Report a problem | ||
| 7/29/2026 | Price change | $999,900-13.1%$146/sqft |
Source: Smart MLS #24183232 Report a problem | ||
| 6/26/2026 | Listed for sale | $1,150,000$168/sqft |
Source: Smart MLS #24183232 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $25,522 +3.3% | $716,700 |
| 2024 | $24,697 +4% | $716,700 |
| 2023 | $23,751 +13.7% | $716,700 +33% |
| 2022 | $20,893 +2.4% | $538,900 |
| 2021 | $20,403 -0.1% | $538,900 |
| 2020 | $20,414 -1.6% | $538,900 |
| 2019 | $20,748 +2.2% | $538,900 |
| 2018 | $20,300 +3.1% | $538,900 +4.2% |
| 2017 | $19,687 +2% | $517,000 |
| 2016 | $19,305 | $517,000 |
Find assessor info on the county website
Neighborhood: 06074
Nearby homes
- $438,600-- bd-- ba-- sqft1732 Main St, South Windsor, CT 06074Off Market
- $526,4003 bd2 ba1.9k sqft1766 Main St, South Windsor, CT 06074Off Market
- $384,3003 bd2 ba1.3k sqft1693 John Fitch Blvd, South Windsor, CT 06074Off Market
- $643,6003 bd2 ba3k sqft1764 Main St, South Windsor, CT 06074Off Market
- $739,3005 bd3 ba4.2k sqft1752 Main St, South Windsor, CT 06074Off Market
- $--1.46 acres1669 John Fitch Blvd, South Windsor, CT 06074Off Market
- $378,0002 bd1 ba1.4k sqft1760 Main St, South Windsor, CT 06074Sold
- $508,5004 bd2 ba2.5k sqft1772 Main St, South Windsor, CT 06074Off Market
Nearby schools
GreatSchools rating
- 9/10Pleasant Valley SchoolGrades: PK-5Distance: 3 mi
- 8/10Timothy Edwards SchoolGrades: 6-8Distance: 4.4 mi
- 10/10South Windsor High SchoolGrades: 9-12Distance: 2.7 mi
Schools provided by the listing agent
- Elementary: Eli Terry
- High: South Windsor
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 .
$945,900
2% more
+$18,918
With Zillow Showcase(estimated)
$964,818
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$945,900
2% more
+$18,918
With Zillow Showcase(estimated)
$964,818
- Connecticut
- Hartford County
- South Windsor
- 06074
- 1742 Main Street
