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
$1,150,000
1742 Main Street, South Windsor, CT 06074
6beds
6,828sqft
Single Family Residence
Built in 1995
3.79 Acres Lot
$1,108,800 Zestimate®
$168/sqft
$-- HOA
What's special
Stunning fireplaceArchitectural detailSoaring ceilingsCrown moldingTwo primary suitesPrivate officeDramatic marble foyer
- 9 days |
- 1,710 |
- 61 |
Zillow last checked:
Listing updated:
Listed by:
Anthony G. Cervoni (954)395-6344,
Redfin Corporation 203-349-8711
Source: Smart MLS,MLS#: 24183232
Loading...
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: $168/sqft
- Tax assessed value: $716,700
- Annual tax amount: $25,522
- Date on market: 6/26/2026
- Exclusions: Please see the inclusion exclusions form.
Estimated market value
$1,108,800
$1.05M - $1.16M
$4,185/mo
Price history
| Date | Event | Price |
|---|---|---|
| 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
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
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.
A local agent can set up tours, give advice and negotiate with sellers.
- Connecticut
- Hartford County
- South Windsor
- 06074
- 1742 Main Street
Nearby cities
Nearby zip codes
Other South Windsor Topics
