Bring your inner chef out! The Stansbury includes a gourmet kitchen that enhances your culinary talents. It boasts generous counter space, dual sinks, an expansive island with seating, a walk-in pantry, and an adjoining breakfast area with a centrally located desk and access to the rear staircase. This home is impressive from the moment you enter the two-story foyer, which is complemented by views of a handsome curved stair. On one side of the foyer, the formal living room is perfect for casual or formal gatherings. On the other side, the dining room includes a butler's pantry for easy and elegant entertaining. The expansive family room offers a fireplace for chilly nights. The master bedroom suite features two large walk-in closets and a luxurious bath with a Roman tub with decorative columns, a separate shower, dual vanities, and a private toilet area. Additional highlights include a playroom or optional fifth bedroom, and nine-foot ceilings throughout.
- CT
- South Windsor
- 06074
- 97 Longmeadow Drive
- MLS# 170090900
- Date Listed06/01/2018
- Bedrooms 5
- Bathrooms 5 Full baths, 1 Half baths
- Lot Size 0.5 acres (21,780 sq. ft)
- Sewer Public Sewer
- Property Type Single Family
- County Hartford
- Year Built 2018
- Water Public
- Square Feet 4,758 sq. ft
- Price Per Sq. Ft $189.15
Interior Features
- Appliances Dishwasher, Gas Cooktop, Microwave, Oven
- Cooling Central Air
- Heating Natural Gas, Zoned, Gravity
Exterior / Lot Features
- Roof Asphalt
- Lot Size Acres 0.50
- Lot Size SQFT 21,780.00
- Lot Features Cul- De- Sac
Directions
Graham Road - Signs for Subdivision
Financial Considerations
- HOA Fee $500 Annually
Nearby Schools
Source: School Digger
International Magnet School For Global Citizenship
Public • PK - 5 • Serves this home
3.9 mi
Distance
Public • 6 - 8 • Serves this home
2.48 mi
Distance
Public • 9 - 12 • Serves this home
1.33 mi
Distance
International Magnet School For Global Citizenship
Public • PK - 5 • Serves this home
3.9 mi
Distance
Public • PK - PK
4.44 mi
Distance
Public • PK - 4
4.9 mi
Distance
Public • PK - 5
5.75 mi
Distance
Public • PK - 6
5.85 mi
Distance
Public • PK - 4
5.98 mi
Distance
Public • PK - 5
6.33 mi
Distance
Public • PK - 5
6.42 mi
Distance
Public • PK - 2
8.39 mi
Distance
Public • 6 - 8 • Serves this home
2.48 mi
Distance
Public • 7 - 8
5.69 mi
Distance
Public • 5 - 6 • Serves this home
6.21 mi
Distance
Public • 6 - 8
6.35 mi
Distance
Public • 6 - 8
7.06 mi
Distance
Public • 6 - 8
7.57 mi
Distance
Public • 7 - 8
8.74 mi
Distance
Academy Of Aerospace And Engineering Middle And High School
Public • 6 - 12
9.61 mi
Distance
Public • 9 - 12 • Serves this home
1.33 mi
Distance
Public • 9 - 12
4.44 mi
Distance
Howell Cheney Technical High School
Public • 9 - 12
4.73 mi
Distance
Public • 9 - 12
5.31 mi
Distance
Public • 9 - 12
6.37 mi
Distance
Public • 9 - 12
7.57 mi
Distance
The Cornerstone Christian School
Private • PK - 12
4.44 mi
Distance
Private • 09 - 12
4.73 mi
Distance
Clinical Day School - Manchester Memorial Hospital
Private • 07 - 12
5.01 mi
Distance
Private • 09 - 12
6.9 mi
Distance
Private • PK - 12
7.19 mi
Distance
Praise Power & Prayer Christian School
Private • KG - 12
7.8 mi
Distance
Sales & Tax History
Source: Public Records
| Street Address | Beds | Baths | Sold Date | List Price |
|---|---|---|---|---|
| 561 Strong Road | 5 | 3 | Nov 08, 2025 | $709,900 |
| 165 Oakland Street | 3 | 2 | Nov 19, 2025 | $369,900 |
| 55 Homestead Street | 2 | 1 | Oct 15, 2025 | $249,900 |
| 88 Benedict Drive | 3 | 1 | Oct 15, 2025 | $269,900 |
| 6 Hamilton Drive | 4 | 3 | Nov 24, 2025 | $459,900 |
| 227 Hany Lane | 3 | 3 | Oct 15, 2025 | $425,000 |
| 281 Hilton Drive | 5 | 3 | Oct 15, 2025 | $525,000 |
| 62 Mather Street | 2 | 1 | Oct 15, 2025 | $269,900 |
| 119 Chambers Street | 4 | 2 | Oct 15, 2025 | $329,900 |
| 32 Whitney Road | 3 | 2 | Oct 15, 2025 | $229,900 |
Population & Environment
Source: Sperling's Best Places
| Zip | City | County | National | |
|---|---|---|---|---|
| Population | 26,869 | 26,890 | 913,900 | 335,858,263 |
| Population Density | 958 | 958 | 1,243 | 95 |
| People per Household | 2.6 | 2.6 | 2.5 | 2.6 |
| Median Age | 46.2 | 46.2 | 42 | 39.1 |
| Median Income | $109,784 | $109,750 | $77,593 | $66,222 |
| Average Income | $49,630 | $49,624 | $41,527 | $35,475 |
| Cost of Living Index | 114 | 114 | 103 | 100 |
| Zip | City | County | National | |
|---|---|---|---|---|
| January Avg. High Temp | 16.99°F | 16.99°F | 16.3°F | 22.6°F |
| July Avg. High Temp | 84.64°F | 84.64°F | 83.8°F | 86.2°F |
| Annual Precipitation | 45.72" | 45.72" | 56.93" | 38" |
33/100
Car-Dependent
Walk Score ®
27/100
Bikable
Bike Score ®
Overview
Most errands require a car. It is possible to get on a bus. Minimal bike infrastructure.Walkability averages in the surrounding area
The average walkability score in the surrounding area is Walk Score: 20/100, Transit Score: 0/100, Bike Score: 26/100.
Property Change History
View Changes
Previous Value:
Updated Value:
View Changes
Previous Value:
Updated Value:
Points of Interest near 97 Longmeadow Drive, South Windsor, CT 06074
264 ft
Distance
581 ft
Distance
950 ft
Distance
0.2 mi
Distance
Buckland Grill & Pizza, South Windsor, CT, USA
Food • Retail • Nightlife
0.25 mi
Distance
Sawadee Thai Cuisine, South Windsor, CT, USA
Food • Retail • Nightlife
0.25 mi
Distance
0.34 mi
Distance
950 ft
Distance
0.2 mi
Distance
Buckland Grill & Pizza, South Windsor, CT, USA
Food • Retail • Nightlife
0.25 mi
Distance
Sawadee Thai Cuisine, South Windsor, CT, USA
Food • Retail • Nightlife
0.25 mi
Distance
264 ft
Distance
528 ft
Distance
0.2 mi
Distance
0.2 mi
Distance
581 ft
Distance
634 ft
Distance
0.27 mi
Distance
0.35 mi
Distance
264 ft
Distance
528 ft
Distance
0.2 mi
Distance
0.2 mi
Distance
Buckland Grill & Pizza, South Windsor, CT, USA
Food • Retail • Nightlife
0.25 mi
Distance
Sawadee Thai Cuisine, South Windsor, CT, USA
Food • Retail • Nightlife
0.25 mi
Distance
264 ft
Distance
634 ft
Distance
634 ft
Distance
898 ft
Distance
264 ft
Distance
317 ft
Distance
898 ft
Distance
Nearby Properties
-
$959,900 Active Under Contract5 bds • 4 ba • 4,573 sqft
60 Saddle Ridge Road, Glastonbury, CT 06033
This spacious 5-bedroom, 3.5-bath Colonial with contemporary flair offers 4,573 square feet of beautifully updated living space on 3.1 acres of private, landscaped grounds just minutes from Glastonbury Center. The home's airy, open kitchen features a...Listing by: Steffen Reich - Coldwell Banker Realty -
$899,000 Active Under Contract3 bds • 3 ba • 4,330 sqft
76 Trymbulak Lane, Glastonbury, CT 06033
Tucked away at the end of a quiet cul-de-sac on a private road, 76 Triymbulak Lane feels like your own hidden retreat in Glastonbury. This 2,650 sq. ft. colonial welcomes you with timeless curb appeal and a layout designed for modern family living. I...Listing by: Lisa Daniele - William Raveis Real Estate -
$849,900 Active12 bds • 6 ba • 5,028 sqft
10 Warner Street, Hartford, CT 06114
Welcome to 10 Warner ST in Hartford CT. This 6 Unit property is ready for its next owners. Each apartment comes with 2 spacious and bright bedrooms as well as ample closet space, eat-in-kitchens and more. There is also a private driveway leading to a...Listing by: Ben Weinberg - Oxford Realty -
$830,000 Active9 bds • 9 ba • 4,560 sqft
27 Allen Place, Hartford, CT 06106
Welcome to this well managed asset on one of the most desired streets in the Hartford multifamily market. Property is fully Stabilized, with off street parking and a state of the art security system. All 9 units are occupied and yielding $9,300 per m...Listing by: Connor Wenchell - VC Property Group, LLC -
$799,900 Active Under Contract4 bds • 4 ba • 4,728 sqft
188 High Wood Drive, Glastonbury, CT 06073
***back on market, buyers financing fell through, nothing to do with the home*** THIS MAGNIFICENT HOME GRACED THE COVER OF HOME DESIGNS MAGAZINE WHEN IT WAS BUILT! What's unique about this SOUTH GLASTONBURY home? The Contemporary design, use of ceili...Listing by: Tracy Wagner - Rockoff Realty -
$799,900 Active4 bds • 3 ba • 4,074 sqft
Lot 106 South Street Extension, Coventry, CT 06238
Welcome to Coventry's NEWEST micro subdivision, where generous lot sizes provide the perfect blend of privacy and possibility. Tucked away on a quiet, non-thru road, you'll enjoy the peace of country living while still having plenty of space for gard...Listing by: Robyn Letourneau - Berkshire Hathaway NE Prop. -
$951,000 Active8 bds • 8 ba • 4,883 sqft
15 Sand Hill Road, Simsbury, CT 06089
Custom Soraghan Kitchen. Marble counter tops. 5-8 bedrooms.7.5 Baths. Majority of house built in 2004. Remarkably spacious with tons of closets. Private, level and huge yard. Majority newer construction. Perfect location to get in and out of town. Pr...Listing by: Derek Greene - Derek Greene -
$899,900 Active4 bds • 5 ba • 4,808 sqft
59 St. Germain Rd, Hampden, MA 01036
A TIMELESS CLASSIC is this stately property nestled on 10 tranquil acres offering modern updates and spacious living. The bright, airy living room showcases a stone fireplace, vaulted ceiling, ideal for both relaxing and entertaining. The kitchen fea...Listing by: -
$989,900 Active7 bds • 7 ba • 4,608 sqft
452 East Street, Plainville, CT 06062
Amazing 8 unit opportunity in the desirable Plainville market! 2 buildings on 1 lot - this property offers a versatile mix of spacious studios, 1-bedroom apartments, and one commercial tenant. The property has ample off-street parking, a partially fi...Listing by: Maddy Ceruti - Century 21 AllPoints Realty -
$849,900 Active5 bds • 4 ba • 4,530 sqft
54 Bulkeley Hill Road, Colchester, CT 06415
Stunning brick contemporary home with seasonal views of Colchester. Enter through a grand 14x14 marble foyer with soaring 18-foot ceilings. The impressive first-floor primary suite features double doors, 10-foot ceilings, two walk-in closets, a full...Listing by: Sherry Borgeson - Berkshire Hathaway NE Prop. -
$1,025,000 Active5 bds • 4 ba • 5,261 sqft
63 Taylor Road, Colchester, CT 06415
Set on 6.16 acres across two separate lots, A fully attached legal in-law/ADU with full sized kitchen, 2 bathrooms, oil heat, mini-split hookups, and separate entrance offers flexible living or income potential. This property delivers privacy, elegan...Listing by: Rafael Suarez - Yellowbrick Real Estate LLC -
$785,000 Active10 bds • 5 ba • 4,468 sqft
230 West Main Street, Meriden, CT 06451
Mixed use 3 large Apts, 2-4BRs, 1-2BR. Flower Shop with long term lease on the first floor. Off-street parking. All utils separate. Please take a look at the attachment for financials on the property. Must be sold with 236 West Main St based on share...Listing by: Mark Poole - Kazantzis Real Estate, LLC -
$879,000 Active Under Contract4 bds • 3 ba • 4,251 sqft
17 Hunters Ridge, Wolcott, CT 06716
Stunning Farmhouse Colonial with Pool & Solar in Desirable Wolcott Cul-de-Sac Welcome to your dream home! This meticulously maintained 4 bedroom, 4 full bath, 4,251 sq ft Farmhouse Colonial is nestled in one of Wolcott's most sought-after cul-de-sac...Listing by: Robert Disapio - Dave Jones Realty, LLC -
$995,000 Active Under Contract4 bds • 4 ba • 4,427 sqft
363 Winding Ridge, Southington, CT 06489
Luxurious Custom-Built Cape on 5+ Private Acres in Southington Nestled on one of the most desirable roads in Southington, this stunning 4,427 sq ft custom-built Cape offers over 5 acres of complete privacy surrounded by lush greenery and mature tree...Listing by: Dave Jones - Dave Jones Realty, LLC -
$925,000 Active5 bds • 4 ba • 4,681 sqft
20 Upson Road, Wolcott, CT 06716
Stunning property consisting of a contemporary 4,680 SF home with 18 rooms on 36+/- acres that are sub-dividable with 16+/- building lots in Wolcott, CT. Country living at its finest at this resort type property with surrounding private woods. Perfec...Listing by: Donald Orsini - Don Orsini Realty, LLC -
$879,000 Active5 bds • 3 ba • 4,271 sqft
126 Cooke Road, Wallingford, CT 06492
126 Cooke Road is more than a home - it's your private retreat. Tucked away on nearly 5 acres in Wallingford's peaceful countryside, this oversized Colonial offers the space, privacy, and lifestyle you've been searching for. The open, sun-filled main...Listing by: Kevin Rockoff - Rockoff Realty -
$899,000 Active6 bds • 3 ba • 4,184 sqft
163 Main Street, Deep River, CT 06417
The walkability and quintessential New England charm of downtown Deep River is a big draw for buyers seeking a trophy property or a dream location for their small business. Built in 1850, this mixed-use gem has much to offer including two commercial...Listing by: Connor Wenchell - VC Property Group, LLC -
$825,000 Active15 bds • 6 ba • 5,280 sqft
45 River St, Southbridge, MA 01550
PRICE IMPROVEMENT! Six-unit multifamily in Southbridge featuring three 2-bedroom apartments and three 3-bedroom apartments—15 bedrooms total. Four of the six units are currently occupied, with two units recently updated. A new rubber roof was install...Listing by: -
$775,000 Active8 bds • 4 ba • 4,099 sqft
87 Broad Street, Norwich, CT 06360
Welcome to one of the most beautifully finished multifamily properties on the market - located in one of Connecticut's most desirable multifamily neighborhoods. This fully remodeled 4-family property features high-end designer finishes across all fou...Listing by: Anthony Velez - VC Property Group, LLC -
$799,900 Active5 bds • 4 ba • 4,414 sqft
21 Hidden Pond Drive, Watertown, CT 06795
***PRICE IMPROVEMENT*** Welcome to this Majestic Colonial home, nestled on a picturesque 1.92-acre lot in one of Watertown's most coveted neighborhoods. With 4,414 square feet of meticulously maintained living space, this home offers the perfect blen...Listing by: Robert Disapio - Dave Jones Realty, LLC
Similar Priced Comparison
-
$750,000 Active3 bds • 3 ba • 2105 sqft
610 Clark Street
- Home smaller by 2,653 sqft
- Lot larger by 413,820 sqft
- Older by 45 years
Listing by: Thomas Boyle - Thomas P. Boyle -
$679,900 Active Under Contract3 bds • 3 ba • 2365 sqft
643 Burnham Street West
- Home smaller by 2,393 sqft
- Lot larger by 19,602 sqft
- Older by 23 years
Listing by: Linda Edelwich - William Raveis Real Estate -
$1,050,000 Active4 bds • 5 ba • 3452 sqft
40 Barber Hill Road
- Home smaller by 1,306 sqft
- Lot larger by 222,592 sqft
- Newer by 1 years
Listing by: Brittany O'hara - William Raveis Real Estate -
$899,900 Active5 bds • 3 ba • 6621 sqft
52 Burnside Avenue
- Home larger by 1,863 sqft
- Lot larger by 1,743 sqft
- Older by 118 years
Listing by: George Agnelli - Agnelli Real Estate
Nearby Locations
Communities
- Verplanck Homes For Sale
- Css Con Homes For Sale
- Northeast Homes For Sale
- South End & South Meadows Homes For Sale
- SoDo Homes For Sale
- Dutch Point Colony Homes For Sale
- Behind The Rocks Homes For Sale
- Wells Quarter Homes For Sale
- Southwest Homes For Sale
- Windsor Locks Homes For Sale
- Roland Heights Homes For Sale
- Rainbow Homes For Sale
- Thompsonville Homes For Sale
- Hungary Homes For Sale
- South Meriden Homes For Sale
- Tracy Homes For Sale
- Bucks Hill Homes For Sale
- Torringford Homes For Sale
- Greystone Homes For Sale
- Burrville Homes For Sale
Nearby Zips
- 06108 Homes For Sale
- 06074 Homes For Sale
- 06118 Homes For Sale
- 06042 Homes For Sale
- 06040 Homes For Sale
- 06114 Homes For Sale
- 06112 Homes For Sale
- 06095 Homes For Sale
- 06106 Homes For Sale
- 06033 Homes For Sale
- 06016 Homes For Sale
- 06109 Homes For Sale
- 06119 Homes For Sale
- 06096 Homes For Sale
- 06002 Homes For Sale
- 06066 Homes For Sale
- 06110 Homes For Sale
- 06067 Homes For Sale
- 06117 Homes For Sale
- 06107 Homes For Sale
Nearby Cities
- East Hartford, CT Homes for Sale
- South Windsor, CT Homes for Sale
- Manchester, CT Homes for Sale
- Hartford, CT Homes for Sale
- Windsor, CT Homes for Sale
- East Windsor, CT Homes for Sale
- Glastonbury, CT Homes for Sale
- Wethersfield, CT Homes for Sale
- Broad Brook, CT Homes for Sale
- South Glastonbury, CT Homes for Sale
- Windsor Locks, CT Homes for Sale
- Vernon, CT Homes for Sale
- Bloomfield, CT Homes for Sale
- Rocky Hill, CT Homes for Sale
- West Hartford, CT Homes for Sale
- Rockville, CT Homes for Sale
- Newington, CT Homes for Sale
- Enfield, CT Homes for Sale
- Ellington, CT Homes for Sale
- Thompsonville, CT Homes for Sale
Similar Searches
- South Windsor Land for Sale
- South Windsor New Homes for Sale
- South Windsor Single Story Homes for Sale
- South Windsor Homes with Pools for Sale
- South Windsor Cheap Homes for Sale
- South Windsor Luxury Homes for Sale
- South Windsor Condos for Sale
- South Windsor Town Homes for Sale
- South Windsor Commercial for Sale
- South Windsor Open Houses for Sale
- South Windsor Two Car Garage Homes for Sale
- South Windsor Large Lots for Sale
- National Listings
- National Home Values
- Properties in CT
- Home Values in CT
- Other properties in Hartford, CT
- Other properties in 06074, CT
- Home Values in South Windsor, CT
Frequently Asked Questions for 97 Longmeadow Drive
Source: Realty.com
97 Longmeadow Drive, South Windsor, CT 06074 is a Single Family 4,758 sq. ft. home listed for sale. Realty.com has 1 photos available of this 5 bed, 6 bath house, listed at $899,995. View sales and tax history, use our mortgage calculator and more on Realty.com
Our records indicate that 97 Longmeadow Drive was built in 2018.
The full address for this home is 97 Longmeadow Drive, South Windsor, CT 06074.
97 Longmeadow Drive has been listed on Realty.com since Fri June 01, 2018
Most errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 20/100, Transit Score: 0/100, Bike Score: 26/100.
There are 3 schools assigned to this home. Check out the schools near 97 Longmeadow Drive. International Magnet School For Global Citizenship (Grades: PK - 5), Timothy Edwards School (Grades: 6 - 8), South Windsor High School (Grades: 9 - 12)
Listing provided courtesy of:
Thomas Jacovino
(tel: 860-430-5400)
Listing agent:
Nicole Defrancesco
(tel: 860-430-5400)
(#DEFRANCN)
This content last refreshed on 2025-12-04 17:58:23. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Export listing data of 97 Longmeadow Drive, South Windsor, CT 06074 : MLS# 170090900