You will be amazed the minute you enter this custom-built home, built by the builder for his own family. Located on a cul-de-sac street close to the Glastonbury line, Manchester Country Club, schools, hwys, shops and restaurants. Enter this spectacular ranch and step into the foyer with marble flooring that leads to the center of the home and is open to the sunken living room, formal dining room, family room with fireplace and sliders that lead to a large deck. The spacious eat-in kitchen with new granite counter tops & stainless steel appliances overlooks the nature’s lovers private backyard & flows beautifully into the family room which is great for entertaining. Lots of large windows provide both ample natural light and views of the tranquil landscape from every window of the house. This impressive home offers loads of space, great flow, bright spacious open layout, beautifully sized rooms, detailed molding, updated bathrooms, new natural gas boiler, new tankless on demand HW heater, new windows, central vac, new shed, new driveway, new roof, large mud room, lovely spacious master suite with walk-in closet and steam shower. This home is filled with peacefulness, light & tons of amenities for every day living and entertaining and is ready for you to move in and create lasting memories.
Single-familyProperty Type
1987Year Built
0.73 acresLot Size
$266Est. Price/Sq.Ft.
2 car garageParking
Listed by Carole King• Keller Williams Realty
Bought with Lisa Trombly• Sentry Real Estate
Source:Smart MLS #170221389
Redfin Estimate
$616,753
$222K since sold in October 2019$5,000 since July
Recently sold homes
Estimate history
Homes for sale
This home's estimate is 21.3% higher than the average sale price ($508K) of 6 comparable homes.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Permits
Beds
3
Baths
2.5
Stories
1
Lot width
—
Lot depth
—
Lot size
0.73 Acres
Year renovated
—
Sq. Ft.
2,321
Year built
1987
Style
Single Family Residential
County
Hartford County
APN
627148
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 10, 2026.
May 12, 2025 • Final
Residential mechanical gas piping permit application
Install natural gas piping for a whole house generator.
Gas
Generator
May 12, 2025 • Final
Residential fixed generator w/ automatic transfer switch electrical permit application
Install and wire a standby generator and a transfer switch to power the entire home. The heating and air conditioning system will be load managed.
Electrical
Generator
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Garage Information
Garage & Parking: Attached Garage
Garages Number: 2
Interior
Interior Information
Total Rooms: 7
Laundry Room Location: Large 8x7 on the Main LEvel
Laundry Room Info: Main Level
Interior Features: Auto Garage Door Opener, Central Vacuum, Open Floor Plan
Fireplaces Total: 1
Cooling System: Central Air
Appliances Included: Oven/Range, Microwave, Range Hood, Refrigerator, Icemaker, Disposal
Bathroom Information
# of Baths (Full): 2
# of Baths (Half): 1
Bedroom Information
Beds Total: 3
Room Information
Rooms Additional: Laundry Room
Room Count: 7
Basement Description: Full With Hatchway, Unfinished
Has Attic
Attic Description: Pull-Down Stairs
Exterior
Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Brick
Exterior Features: Deck, Shed
Lot Information
Lot Description: Corner Lot, Level Lot, Lightly Wooded, Professionally Landscaped
Building Information
Foundation Type: Concrete
Construction Description: Frame
Property Information
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 2320
Driveway Type: Paved
Financial
Assessments Information
Assessed Value: $262,600
Utilities
Utility Information
Water Source: Public Water Connected
Sewage System: Public Sewer Connected
Hot Water Description: Natural Gas, Tankless Hotwater
Heat Type: Hot Air
Heat Fuel Type: Natural Gas
Energy Features: Thermopane Windows
Location
School Information
High School: Manchester
Elementary School: Per Board of Ed
Location Information
State: Connecticut
Nearby Amenities: Golf Course, Health Club, Medical Facilities, Public Pool, Public Rec Facilities, Putting Green, Shopping/Mall
Directions: FERN TO GARDNER TO HAYSTACK
County: Hartford
Public facts
Beds: 3
Baths: 2.5
Sq. Ft.: 2,321
Stories: 1.0
Lot Size: 0.73 acres
Style: Single Family Residential
Year Built: 1987
Year Renovated: —
County: Hartford County
APN: 627148
Home facts updated by county records on Jul 10, 2026
Other
Documents & Disclosures
Supplement Count Public: 1
Around this home
Schools
Martin School
Public PreK-4 • Assigned • 0.8mi
4/10
Illing Middle School
Public 7-8 • Assigned • 2.3mi
4/10
Manchester High School
Public 9-12 • Assigned • 2.2mi
4/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
8 days above 93° expected this year, 18 days in 30 years
6/10 Wind Factor
27% chance of strong winds in next 30 years
3/10 Air Factor
3 unhealthy days expected this year, 4 days in 30 years
Provided by First Street
Historical weather
Manchester, CT • 06040
Average low and high temperatures (°F)
33
19
36
20
53
32
62
41
69
50
81
60
85
67
80
60
75
55
64
45
52
35
38
23
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.9 hours in
June and 4.4 hours in December, placing it below the
U.S. average for solar exposure.
8.9 hrs
4.4 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$586,000 – $710,000
Reach more buyers when you sell with Redfin. Save up to $6,168 in fees.3 minutes to get started.
Get a free, detailed breakdown of how we calculated your estimate.