UNDER CONSTRUCTION. READY FOR EARLY FALL OCCUPANCY is this ASPEN model. PRICE INCLUDES UPGRADES OF - Gourmet Kitchen w/glass cabinet door, slide out shelves, under cabinet lights & tiled backsplash, Shadow Boxes (foyer to great room) and Frameless Shower Door in primary bath. Located in the NEW Stonebridge Commons; a 55+ Planned Unit Development it offers a convenient relaxing setting with 4300 feet of walking trails, in Enfield, CT. This beautiful free-standing home, features unparalleled quality and pride of workmanship throughout. Entering the home, you are greeted by the bright warm open concept. The Kitchen offers an island, granite counter tops, loads of cabinets, a pantry and a generous appliance allowance. The vaulted Great Room, featuring hardwood floors, is bright and cheerful. There are 3 Bedrooms and 2 Full Bathrooms, (one Bedroom can be used as an Office with French Doors). This community offers the ease of condo living with the privacy of a single family home. This carefr
For sale
Price increase: $20K (6/1)
$649,900
242 Brainard Rd Lot 38, Enfield, CT 06082
3beds
1,900sqft
Single Family Residence
Built in 2026
-- sqft lot
$-- Zestimate®
$342/sqft
$300/mo HOA
What's special
- 353 days |
- 34 |
- 0 |
Zillow last checked:
Listing updated:
Listed by:
Wheway Group 413-478-1166,
Coldwell Banker Realty - Western MA 413-567-8931,
Patricia D. Wheway 413-478-1166
Source: MLS PIN,MLS#: 73393201
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
- Main level bedrooms: 1
Primary bedroom
- Features: Bathroom - Full, Walk-In Closet(s), Flooring - Wall to Wall Carpet, Lighting - Overhead
- Level: Main,First
Bedroom 2
- Features: Flooring - Hardwood, French Doors, Lighting - Overhead
- Level: First
Bedroom 3
- Features: Flooring - Wall to Wall Carpet, Lighting - Overhead
- Level: First
Primary bathroom
- Features: Yes
Bathroom 1
- Features: Bathroom - Full, Bathroom - With Shower Stall, Closet - Linen, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid
- Level: First
Bathroom 2
- Features: Bathroom - Full, Bathroom - With Tub & Shower, Closet - Linen, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid
- Level: First
Dining room
- Features: Flooring - Hardwood
- Level: First
Kitchen
- Features: Flooring - Hardwood, Pantry, Kitchen Island, Open Floorplan, Recessed Lighting
- Level: Main,First
Living room
- Features: Vaulted Ceiling(s), Flooring - Hardwood, Deck - Exterior, Open Floorplan
- Level: Main,First
Heating
- Central, Forced Air, Propane
Cooling
- Central Air
Appliances
- Included: Electric Water Heater, Tankless Water Heater
- Laundry: Flooring - Stone/Ceramic Tile, Electric Dryer Hookup, Washer Hookup, First Floor
Features
- Internet Available - Satellite
- Flooring: Carpet, Hardwood
- Doors: Insulated Doors, French Doors
- Windows: Insulated Windows
- Basement: Full
- Number of fireplaces: 1
Interior area
- Total structure area: 1,900
- Total interior livable area: 1,900 sqft
- Finished area above ground: 1,900
Property
Parking
- Total spaces: 4
- Parking features: Attached, Garage Door Opener, Off Street
- Attached garage spaces: 2
- Uncovered spaces: 2
Features
- Patio & porch: Deck - Composite
- Exterior features: Deck - Composite, Rain Gutters, Professional Landscaping, Sprinkler System
Lot
- Features: Cleared
Details
- Zoning: R-1
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Frame
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- Year built: 2026
Details
- Warranty included: Yes
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Public
- Utilities for property: for Electric Range, for Electric Dryer, Washer Hookup
Green energy
- Energy efficient items: Thermostat
Community & HOA
Community
- Features: Shopping, Golf, Medical Facility, Highway Access, House of Worship
- Senior community: Yes
HOA
- Has HOA: Yes
- HOA fee: $300 monthly
Location
- Region: Enfield
Financial & listing details
- Price per square foot: $342/sqft
- Date on market: 6/18/2025
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/1/2026 | Price change | $649,900+3.2%$342/sqft |
Source: MLS PIN #73393201 Report a problem | ||
| 3/30/2026 | Price change | $629,900-0.8%$332/sqft |
Source: MLS PIN #73393201 Report a problem | ||
| 2/7/2026 | Price change | $634,900-1.6%$334/sqft |
Source: MLS PIN #73393201 Report a problem | ||
| 9/1/2025 | Price change | $644,900+0.8%$339/sqft |
Source: MLS PIN #73393201 Report a problem | ||
| 6/18/2025 | Listed for sale | $639,900$337/sqft |
Source: MLS PIN #73393201 Report a problem | ||
Public tax history
Tax history is unavailable.
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: Sherwood Manor
Nearby schools
GreatSchools rating
- 6/10Prudence Crandall SchoolGrades: 3-5Distance: 0.7 mi
- 5/10John F. Kennedy Middle SchoolGrades: 6-8Distance: 4.6 mi
- 5/10Enfield High SchoolGrades: 9-12Distance: 3.6 mi
A local agent can set up tours, give advice and negotiate with sellers.
- Connecticut
- Hartford County
- Enfield
- 06082
- Sherwood Manor
- 242 Brainard Rd Lot 38
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Enfield Topics
