www.constantinerealestate.com/homes/151493696
244
Overbrook Rd
Longmeadow,
MA
01106
Elementary School:
Center
Spectacular Glen Arden estate nestled upon park like grounds in an exquisite neighborhood abutting the Longmeadow Country Club. Step inside this elegantly appointed and distinctively updated European Country Manor to the welcoming foyer and beautiful staircase leading you to the upper and lower levels. The main level features a spacious living room w/ vaulted and beamed ceilings, fireplace, balcony, and 4 season sunroom. The large primary suite is sure to impress with custom closets, marble tiled bath, high-end finishes, a private balcony, and luxurious suite with fireplaced sitting room and large sleeping quarters. The 2nd floor offers 5-6 additional bedrooms, study, 3 full baths, 2nd laundry and separate guest suite or Nanny's quarters. The lower entertaining level offers a professional kitchen w/Viking appliances, large fireplaced dining room, rec room, gym, and wine cellar. Professionally manicured grounds, extensive landscaping and a luxurious pool area simply breathtaking.
Architectural Style
CapeTudor
Attached Garage YN
Yes
Carport YN
No
Color
Cream
Construction Materials
FrameBrickStoneConventional (2x4-2x6)
Covered Spaces
2
Exterior Features
PorchDeckDeck - CompositePatioBalconyPool - IngroundPool - Inground HeatedRain GuttersHot Tub/SpaStorageProfessional LandscapingSprinkler SystemDecorative LightingScreensFenced YardInvisible FenceStone Wall
Fencing
Fenced/EnclosedFencedInvisible
Garage YN
Yes
Lot Features
WoodedEasementsClearedLevelSloped
Open Parking YN
Yes
Parking Features
AttachedGarage Door OpenerStorageWorkshop in GarageGarage Faces SideOff StreetDriveway
Parking Total
8
Patio And Porch Features
PorchDeckDeck - CompositePatio
Pool Features
In GroundPool - Inground Heated
Pool Private YN
Yes
Property Attached YN
No
Road Frontage Type
Public
Road Responsibility
Public Maintained Road
Road Surface Type
Paved
Roof
TileOther
Spa Features
Private
Spa YN
Yes
Waterfront Features
Stream
Waterfront YN
No
Appliances
Gas Water HeaterWater HeaterRangeDishwasherDisposalMicrowaveRefrigeratorFreezerWasherDryerWater TreatmentWine RefrigeratorENERGY STAR Qualified DryerENERGY STAR Qualified DishwasherRange HoodStainless Steel Appliance(s)Gas CooktopPlumbed For Ice Maker
Basement
FullPartially FinishedWalk-Out AccessInterior EntryConcrete
Bedroom2 Features
Bathroom - FullClosetFlooring - HardwoodFlooring - Wall to Wall CarpetLighting - Pendant
Bedroom2 Level
Second
Bedroom3 Features
Ceiling Fan(s)ClosetFlooring - HardwoodFlooring - Wall to Wall CarpetLighting - PendantCloset - Double
Bedroom3 Level
Second
Bedroom4 Features
Ceiling Fan(s)Walk-In Closet(s)Flooring - HardwoodFlooring - Wall to Wall CarpetLighting - Pendant
Bedroom4 Level
Second
Bedroom5 Features
Ceiling Fan(s)ClosetFlooring - HardwoodFlooring - Wall to Wall Carpet
Bedroom5 Level
Second
Building Area Total
7308
Cooling
Central AirDuctless
Cooling YN
Yes
Cooling Zones
6
Dining Room Features
Beamed CeilingsFlooring - Stone/Ceramic TileFrench DoorsExterior AccessRecessed LightingWine ChillerLighting - SconceLighting - PendantLighting - OverheadCrown Molding
Dining Room Level
Basement
Door Features
Pocket DoorInsulated DoorsStorm Door(s)French Doors
Family Room Features
Walk-In Closet(s)Flooring - Stone/Ceramic TileWindow(s) - Bay/Bow/BoxFrench DoorsCable HookupExterior AccessHigh Speed Internet HookupRecessed LightingStorage
Family Room Level
Basement
Fireplace Features
Dining RoomFamily RoomLiving RoomMaster Bedroom
Fireplace YN
Yes
Fireplaces Total
4
Flooring
WoodTileCarpetConcreteMarbleHardwoodStone / SlateFlooring - HardwoodFlooring - Wall to Wall CarpetFlooring - Stone/Ceramic Tile
Foundation Details
Concrete PerimeterOther
Heat Zones
10
Heating
CentralForced AirBaseboardRadiantNatural GasDuctless
Heating YN
Yes
Interior Features
Ceiling Fan(s)ClosetRecessed LightingCathedral Ceiling(s)Vaulted Ceiling(s)Walk-In Closet(s)Balcony - InteriorLighting - PendantLighting - OverheadCeiling - Half-VaultedDecorative MoldingBathroom - HalfCloset/Cabinets - Custom BuiltPantryCountertops - Stone/Granite/SolidKitchen IslandLighting - SconceCrown MoldingBathroom - 3/4Bathroom - Tiled With Shower StallEnclosed Shower - FiberglassBedroomExercise RoomWine CellarFoyerKitchenBathroomCentral VacuumWalk-up Attic
Kitchen Features
Beamed CeilingsFlooring - HardwoodDining AreaCountertops - Stone/Granite/SolidKitchen IslandCabinets - UpgradedRecessed LightingStainless Steel AppliancesGas StoveLighting - PendantLighting - Overhead
Kitchen Level
MainFirst
Laundry Features
Dryer Hookup - ElectricLaundry ClosetCloset/Cabinets - Custom BuiltFlooring - HardwoodCountertops - Stone/Granite/SolidFrench DoorsMain LevelGas Dryer HookupRecessed LightingRemodeledWasher HookupLighting - SconceBeadboardCrown MoldingCloset - DoubleSinkFirst FloorElectric Dryer Hookup
Lead Paint
Unknown
Living Room Features
Cathedral Ceiling(s)Ceiling Fan(s)Beamed CeilingsVaulted Ceiling(s)Flooring - HardwoodBalcony / DeckBalcony - ExteriorFrench DoorsCable HookupRecessed LightingLighting - SconceLighting - Overhead
Living Room Level
MainFirst
Main Level Bathrooms
1
Main Level Bedrooms
1
Master Bathroom Features
Yes
Master Bedroom Features
Bathroom - FullBathroom - Double Vanity/SinkCeiling Fan(s)Closet - LinenWalk-In Closet(s)ClosetCloset/Cabinets - Custom BuiltFlooring - HardwoodWindow(s) - Bay/Bow/BoxBalcony / DeckBalcony - ExteriorFrench DoorsCable HookupDouble VanityDressing RoomRecessed LightingRemodeledLighting - SconceLighting - PendantLighting - OverheadArchway
Master Bedroom Level
MainFirst
Rooms Total
18
Window Features
Insulated WindowsStorm Window(s)Screens
Association Fee
325
Association Fee Frequency
Annually
Association YN
Yes
Community Features
Public TransportationShoppingPoolTennis Court(s)ParkWalk/Jog TrailsGolfMedical FacilityHighway AccessPublic SchoolUniversityOther
Contingency
Financing
Current Financing
Conv. Fixed
Disclosures
Upper Foyer Wall Mirror to Remain. Fireplace in foyer decorative only. Some windows inoperable. Small portion of lower turnaround off boundary. Some seepage in garage by garage door in heavy rains. Appliances to remain for Buyer's enjoyment. Agent is Owner.
Electric
GeneratorCircuit BreakersGenerator Connection
Exclusions
Secondary LaundryPlay SetMounted Speakers/TvsDogwatch EquipmentGarden ArchwayHot Tub
Green Energy Efficient
Thermostat
Home Warranty YN
No
Listing Terms
Contract
Owners Association Required
No
Property Sub Type
Single Family Residence
Security Features
Security System
Senior Community YN
No
Sewer
Public Sewer
Tax Annual Amount
23385
Tax Year
2024
Utilities
for Gas Rangefor Gas Ovenfor Electric Ovenfor Gas Dryerfor Electric DryerWasher HookupIcemaker ConnectionGenerator Connection
Water Source
Public
Year Built Details
ActualRenovated Since
Year Round
Yes
Zoning
RA1
Listing information © 2024 MLS Property Information Network. All information is deemed reliable but should be independently verified.
Listing provided courtesy of Peter Gelinas of Valley Real Estate Company: 413-584-7253.
The property listing data and information set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc. The property listing data and information are for the personal, non commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and may not be used for any purpose other than to identify prospective properties which such consumers may have a good faith interest in purchasing or leasing. MLS Property Information Network, Inc. and its subscribers disclaim any and all representations and warranties as to the accuracy of the property listing data and information set forth herein. Data last updated 2024-10-06T19:04:01.097.