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.
For sale
Price cut: $150.1K (7/29)
$999,900
1742 Main Street, South Windsor, CT 06074
6beds
6,828sqft
Single Family Residence
Built in 1995
3.79 Acres Lot
$950,000 Zestimate®
$146/sqft
$-- HOA
What's special
Stunning fireplaceArchitectural detailSoaring ceilingsCrown moldingTwo primary suitesPrivate officeDramatic marble foyer
- 54 days |
- 2,420 |
- 120 |
Zillow last checked:
Listing updated:
Listed by:
Anthony G. Cervoni (954)395-6344,
Redfin Corporation 203-349-8711
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
Video & virtual tour
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: $146/sqft
- Tax assessed value: $716,700
- Annual tax amount: $26,525
- Date on market: 6/26/2026
- Exclusions: Please see the inclusion exclusions form.
Estimated market value
Zestimate®
$950,000
Estimated sales range
$903,000 - $998,000
Rent Zestimate®
$3,400/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/29/2026 | Price change | $999,900-13.1%$146/sqft |
Source: | ||
| 6/26/2026 | Listed for sale | $1,150,000$168/sqft |
Source: | ||
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
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 06074
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.
- $429,400-- bd-- ba-- sqft1732 Main St, South Windsor, CT 06074Off Market
Save - $529,7003 bd2 ba1.9k sqft1766 Main St, South Windsor, CT 06074Off Market
Save - $399,5003 bd2 ba1.3k sqft1693 John Fitch Blvd, South Windsor, CT 06074Off Market
Save 
- $644,9003 bd2 ba3k sqft1764 Main St, South Windsor, CT 06074Off Market
Save - $763,6005 bd3 ba4.2k sqft1752 Main St, South Windsor, CT 06074Off Market
Save - $--1.46 acres1669 John Fitch Blvd, South Windsor, CT 06074Off Market
Save - $378,0002 bd1 ba1.4k sqft1760 Main St, South Windsor, CT 06074Sold
Save - $514,0004 bd2 ba2.5k sqft1772 Main St, South Windsor, CT 06074Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.




