1742 Main Street, South Windsor, CT 06074 - Photo 1

1/1

$1,150,000

Sold
Closed
Single Family
6 Beds
6 Full Baths
2 Partial Baths
6,828 Sq. Ft.
3 Car Garage

1/1

Property Description

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.

Full Property Details

Full Property Details for 1742 Main St

General

Sold For: $1,150,000
Taxes: (July 2026-June 2027)
Status: Closed
Type: Single Family
Source: SMARTMLS
MLS ID: 24183232
Added to Site: 105 day(s) ago

Interior

Number of Rooms: 12
Interior Features: Auto Garage Door Opener, Cable - Available, Open Floor Plan
Fireplace: Yes
Number of Fireplaces: 3
Appliances: Oven/Range, Wall Oven, Refrigerator, Dishwasher, Disposal, Compactor, Washer, Dryer

Rooms

Bathrooms

Total Bathrooms: 8
Full Bathrooms: 6
Half Bathrooms: 2
Partial Bath: Hardwood Floor, Main

Bedrooms

Total Bedrooms: 6
Primary Bedroom: Primary Bedroom - Bedroom Suite, Full Bath, Stall Shower, Walk-In Closet, Wall/Wall Carpet, Upper
Primary Suite: Ceiling Fan, Full Bath, Stall Shower, Whirlpool Tub, W, Main
Bedroom 1: Bedroom - Bedroom Suite, Full Bath, Walk-In Closet, Wall/Wall Carpet, Stall Shower, Upper
Bedroom 2: Bedroom - Bedroom Suite, Full Bath, Walk-In Closet, Wall/Wall Carpet, Tub w/Shower, Upper
Bedroom 3: Bedroom - Bedroom Suite, Full Bath, Wall/Wall Carpet, Stall Shower, Upper
Bedroom 4: Bedroom - Bedroom Suite, Full Bath, Walk-In Closet, Wall/Wall Carpet, Upper

Other Rooms

Living Room: Living Room - Fireplace, Hardwood Floor, Main
Family Room: Family Room - Palladian Window(s), 9 ft+ Ceilings, Ceiling Fan, Fireplace, Hardwood Floor, Main
Eat In Kitchen: Eat-In Kitchen - Breakfast Nook, Granite Counters, Dining Area, Island, Hardwoo, Main
Dining Room: Dining Room - Hardwood Floor, Main
Office: Office - Book Shelves, Built-Ins, Fireplace, French Doors, Hardwood Floor, Main
Den: Den - Wall/Wall Carpet, On 3rd Floor, Upper
Laundry: Main Level, Upper Level
Other Room 1: Other - Built-Ins, Laundry Hookup, Tile Floor, Upper
Other Room 2: Other - Wall/Wall Carpet, Upper

Exterior

Exterior Features: Underground Utilities, Shed, Gutters, Stone Wall, Patio

Parking

Garage: Yes
Attached garage: Yes
Garage Spaces: 3
Parking: Attached Garage

Location

County: Hartford
Driving Directions: Please use GPS.

School Information

Elementary School: Eli Terry
Middle School: Edwards
Intermediate School: Per Board of Ed
High School: South Windsor

Heating & Cooling

Cooling Type: Ceiling Fans, Central Air
Heating Type: Hot Air, Oil, Propane
Heating Fuel: Oil, Propane
Water Heater: Oil, Domestic

Utilities

Sewer: Public Sewer Connected
Water: Public Water Connected

Structural Information

Architectural Style: Colonial
Construction Status: No/Resale
Exterior Const.: Brick
Basement Desc.: Full
Roof: Asphalt Shingle
Attic: Yes
Square Feet: 6,828
Above Ground: 6,828 Sq. Ft.
Year Built: 1995

Lot Features

Lot Size (Acres): 3.79
Zoning: A40
Lot Description: Secluded, Rear Lot, Treed, Level Lot, Professionally Landscaped

Financial Considerations

Assessment Amount: $716,700
Tax Year: July 2026-June 2027

Disclosures and Reports

Exclusions: Please see the inclusion exclusions form.
Property ID: 715620

Listed and Sold by Redfin Corporation, Anthony Cervoni

What's Your Home Worth?

* Indicates a required field

For a complimentary comparative market analysis, please contact us so we can discuss your home's value.

Your Property Information

Address optional

City *State *

Zip Code optional

Your Contact Information

First Name *Last Name *

Email Address *

Phone Number *

Location of interest

Comment *

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Submit, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

Listing agent

— 1742 Main St —

Anthony Cervoni

Redfin Corporation

Agent Contact: (954) 395-6344 Office Contact: (203) 349-8711

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 1742 Main St

School District:South Windsor School District

Name	Grades	Distance
Pleasant Valley School, South Windsor, CT 591 Ellington Road, South Windsor, CT 06074	K-5	3 mi
Timothy Edwards School 100 Arnold Way, South Windsor, CT 06074	6-8	4.4 mi
South Windsor High School 161 Nevers Road, South Windsor, CT 06074	9-12	2.7 mi

Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 1742 Main St

Date

Details

Price

Change

Source

9/04/2026

Sold

$1,150,000

15.01%

MLS

7/29/2026

Price Reduced

$999,900

-13.05%

MLS

6/26/2026

Listed

$1,150,000

—

MLS

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

26 Merriman Rd, Windsor, CT 06095 - Photo 1

Just Listed

$525,000

26 Merriman Rd Windsor, CT 06095

Single Family
Active
Updated 5 days ago

3
Beds
3
Total Baths
2,782
Sq. Ft.

Listed by Shawna Woodberry (646) 708-4253

42 Marble Faun Ln, Windsor, CT 06095 - Photo 1

Just Listed

$459,000

Open House

42 Marble Faun Ln #42 Windsor, CT 06095

Duplex
Active
Updated 5 days ago

3
Beds
3
Total Baths
1,912
Sq. Ft.

Listed by William Raveis/First Town RE

37 Clover St, Windsor, CT 06095 - Photo 1

Just Listed

$339,900

Open House

37 Clover St Windsor, CT 06095

Single Family
Active
Updated 1 day ago

3
Beds
2
Total Baths
2,130
Sq. Ft.

Listed by William Raveis Real Estate

77-81 Pierson Ln, Windsor, CT 06095 - Photo 1

Just Listed

$1,100,000

77-81 Pierson Ln Windsor, CT 06095

Commercial
Active

Listed by Berkshire Hathaway NE Prop.

23 Coach Cir, Windsor, CT 06095 - Photo 1

Price Reduced

-$10,000 (-1.91%)

$514,900

23 Coach Cir Windsor, CT 06095

Single Family
Active
Updated 1 day ago

4
Beds
3
Total Baths
2,450
Sq. Ft.

Listed by Steven Inghilterra (860) 707-5634

342 Mountain Rd, Windsor, CT 06095 - Photo 1

Price Reduced

-$14,000 (-4.93%)

$270,000

342 Mountain Rd Windsor, CT 06095

Single Family
Active
Updated 6 days ago

2
Beds
1
Total Bath
1,343
Sq. Ft.

Listed by Brian Gallagher (917) 202-4145

839 Marshall Phelps Rd, Windsor, CT 06095 - Photo 1

Price Reduced

-$10,000 (-2.67%)

$365,000

839 Marshall Phelps Rd #STE 1 Windsor, CT 06095

Commercial
Active

Listed by The Wilson Company of CT

204 Willowcrest Dr, Windsor, CT 06095 - Photo 1

Price Reduced

-$22,700 (-5.41%)

$397,000

204 Willowcrest Dr Windsor, CT 06095

Single Family
Active
Updated 2 days ago

3
Beds
3
Total Baths
1,700
Sq. Ft.

Listed by Beycome of Connecticut

57 Longmeadow Dr, South Windsor, CT 06074 - Photo 1

Sold

$1,240,000

57 Longmeadow Dr South Windsor, CT 06074

Single Family
Closed

5
Beds
3
Total Baths
4,368
Sq. Ft.

Listed by Nikki Defrancesco
Sold by James Knurek

110 Joseph Ln, South Windsor, CT 06074 - Photo 1

Sold

$1,075,000

110 Joseph Ln South Windsor, CT 06074

Single Family
Closed

5
Beds
4
Total Baths
3,595
Sq. Ft.

Listed by Coldwell Banker Realty
Sold by Tea Leaf Realty

[Address not provided], South Windsor, CT 06074 - Photo 1

Sold

$1,059,000

[Address not provided] South Windsor, CT 06074

Single Family
Closed

5
Beds
4
Total Baths
3,260
Sq. Ft.

Listed by James Knurek
Sold by RE/MAX Right Choice

40 Barber Hill Rd, East Windsor, CT 06016 - Photo 1

Sold

$1,050,000

40 Barber Hill Rd East Windsor, CT 06016

Single Family
Closed

4
Beds
5
Total Baths
3,452
Sq. Ft.

Listed by William Raveis Real Estate
Sold by William Raveis Real Estate

1742 Main Street, South Windsor, CT 06074 (MLS# 24183232) is a Single Family property that was sold at $1,150,000 on September 04, 2026. Want to learn more about 1742 Main Street? Do you have questions about finding other Single Family real estate for sale in South Windsor? You can browse all South Windsor real estate or contact a Coldwell Banker agent to request more information.

1742 Main St South Windsor, CT 06074