Description
Enjoy a lifestyle of luxury in this exquisite custom-built home nestled on 2+ acres of private serene landscape in prime Hopkinton location. A spectacular and welcoming presence, this home offers superb interior spaces, gourmet kitchen, 3-season porch, and grand covered terrace w/ beautiful gardens & heated pool ideal for indoor/outdoor entertaining. Primary bedroom has 2 separate dressing areas each w/ oversized closets and luxe bath. The separate expansive guest house (can be attached for access under one roof if desired) with kitchen and full bath offers flexible living space perfect for multigenerational use, office/studio, media room/bar or gym. Lower-level features workshop & climate-controlled garage bays for up to 14 vehicles ideal for car collector. Additional amenities include heated pool house, additional garage, automatic full property generator, irrigation system & Sonos sound system Expertly crafted and sophisticated, this residence is a testament to refined living.
Property Id: 125700
Price: $ 3,495,000
Property Size: 6,472 ft2
Property Lot Size: 2 ft2
Rooms: 13
Bedrooms: 6
Bathrooms: 6
AccessibilityFeatures: No
ArchitecturalStyle: Colonial
BathroomsTotalDecimal: 6
BuildingAreaSource: Owner
BuildingAreaUnits: Square Feet
Basement: Full,Interior Entry,Bulkhead,Unfinished
BathroomsFull: 5
BuyerAgencyCompensation: 2
BathroomsHalf: 2
CommunityFeatures: Public Transportation,Shopping,Walk/Jog Trails,Golf,Medical Facility,Highway Access,House of Worship,Public School
BuildingAreaTotal: 6472
Directions: West Main to W. Elm to Old Farm Road to Queen Anne
Disclosures: Family room fireplace is gas. Room sizes approximate,buyer/agent to verify. Well for irrigation only. Audio/Visual Surveillance at front/back doors/barn garages. FR small windows have hairline cracks. Septic is 4 bedroom system. Title V scheduled. See attached feature sheet.
ExpirationDate: 1900-01-01
FarmLandAreaUnits: Square Feet
IDXParticipationYN: 1
ListAgentMlsId: TM300600
ListOfficeMlsId: M95356
ListingAgreement: Exclusive Right To Sell
Cooling: Central Air
CoveredSpaces: 12
LotSizeUnits: Acres
DoorFeatures: French Doors
Electric: Generator Connection
ElementarySchool: Marath,Elmw,Hop
Exclusions: Cabinets In Basement, Wall Sconces In Sunroom & Patio, Safe In Barn. Large Mirror In Fr Is Included
MLSPIN_CERTIFICATE_NUMBER: 000000000955
Fencing: Fenced
MLSPIN_COLOR: White
FireplaceFeatures: Family Room,Living Room,Master Bedroom
FireplacesTotal: 3
MLSPIN_COMP_BASED_ON: Net Sale Price
Flooring: Tile,Hardwood,Flooring - Hardwood,Flooring - Stone/Ceramic Tile,Flooring - Wall to Wall Carpet
FoundationDetails: Concrete Perimeter
MLSPIN_COOLING_ZONES: 5
GarageSpaces: 12
MLSPIN_DISCLOSURE: Y
MLSPIN_DPR_Flag: No
MLSPIN_ENTERED_BY: BB921490
Heating: Baseboard,Radiant,Humidity Control,Natural Gas
HighSchool: Hop High
MLSPIN_HEAT_ZONES: 11
LaundryFeatures: Closet/Cabinets - Custom Built,Flooring - Hardwood,Electric Dryer Hookup,Washer Hookup,Lighting - Overhead,Sink,Second Floor
MLSPIN_LAUNDRY_DIMEN: 12X11
MLSPIN_LEAD_PAINT: None
MLSPIN_LISTING_ALERT: No
MLSPIN_LIST_PRICE_PER_SQFT: 540.02
MLSPIN_MAIN_LO: M59500
ListingContractDate: 2024-06-18
MLSPIN_MARKET_TIME: 136
ListingId: 73253928
MLSPIN_MARKET_TIME_BROKER: 136
MLSPIN_MARKET_TIME_PROPERTY: 136
LotFeatures: Easements
LotSizeArea: 2.03
LotSizeSquareFeet: 88440
MLSPIN_OFFLINE_LIST_NO: 3721053
MiddleOrJuniorSchool: Hop Middle
MLSPIN_PRICE_PER_SQFT: 540.02
OtherStructures: Barn/Stable,Guest House
ParcelNumber: M:0R22 B:0137 L:0,531845
MLSPIN_SQUARE_FEET_DISCLOSURES: Square footage includes living area in guest house (barn). Additional 2400 sq.ft. in heated shops.
ParkingFeatures: Attached,Detached,Garage Door Opener,Paved Drive,Off Street,Paved
MLSPIN_SQUARE_FEET_INCL_BASE: No
MLSPIN_SUB_AGENCY_OFFERED: No
PoolFeatures: Pool - Inground Heated
MLSPIN_TEAM_MEMBER: BB921490
MLSPIN_UFFI: Unknown
MLSPIN_VT_FLAG: 1
MLSPIN_YEAR_ROUND: Yes
MainLevelBathrooms: 1
Roof: Shingle,Rubber
MlsStatus: Canceled
OffMarketDate: 2024-11-01
OriginalListPrice: 3495000
OriginatingSystemID: mlspin
OriginatingSystemKey: mlspin
OriginatingSystemName: MLS Property Information Network
ParkingTotal: 30
PatioAndPorchFeatures: Porch,Porch - Enclosed,Patio,Covered
PhotosCount: 42
PrivateOfficeRemarks: Negotiable items in barn: 2 - 4 post car lifts, stationary wood-shop equipment, media blasting booth. Additional 2,400 square feet in heated garages and wood-shop. Additional 1,100 square feet of unfinished space on third floor in barn/guest house. Pool house has electric heat. Viessmann boilers and indirect water heaters in main house and barn. Main house has been renovated over the years. Barn was built in 2005.Pool cover and clear plastic terrace enclosure included. New pool heater 2024. New pool pump & filter 2023.Roof is Certainteed Grand Manor ‘Shangle’ With Lifetime Transferrable Warranty. See detailed feature sheet attached to MLS. Offers must included buyer signed sellers disclosure attached to MLS. All showings must be accompanied by listing agent. Please give 12 - 24 hours notice. Visit 10QueenAnneRoad.com for more photos, 3d walk through, video and floor plans.
RoadFrontageType: Public
RoomBathroom1Area: 56
RoomBathroom1Features: Bathroom - Half,Flooring - Stone/Ceramic Tile,Crown Molding
RoomBathroom1Length: 7
RoomBathroom1Level: Main,First
RoomBathroom1Width: 8
RoomBathroom2Area: 96
RoomBathroom2Features: Bathroom - Full,Bathroom - Tiled With Shower Stall,Flooring - Stone/Ceramic Tile,Pedestal Sink,Soaking Tub
RoomBathroom2Length: 8
RoomBathroom2Level: Second
RoomBathroom2Width: 12
RoomBathroom3Area: 108
RoomBathroom3Features: Bathroom - Full,Bathroom - Tiled With Tub & Shower,Flooring - Stone/Ceramic Tile,Countertops - Stone/Granite/Solid,Double Vanity,Recessed Lighting
RoomBathroom3Length: 9
RoomBathroom3Level: Second
RoomBathroom3Width: 12
RoomBedroom2Area: 224
RoomBedroom2Features: Closet,Closet/Cabinets - Custom Built,Flooring - Hardwood,Crown Molding
RoomBedroom2Length: 14
RoomBedroom2Level: Second
RoomBedroom2Width: 16
RoomBedroom3Area: 320
RoomBedroom3Features: Flooring - Hardwood,Closet - Double
RoomBedroom3Length: 16
RoomBedroom3Level: Second
RoomBedroom3Width: 20
RoomBedroom4Area: 238
RoomBedroom4Features: Vaulted Ceiling(s),Flooring - Hardwood,Attic Access,Recessed Lighting,Closet - Double
RoomBedroom4Length: 14
RoomBedroom4Level: Third
RoomBedroom4Width: 17
RoomBedroom5Area: 528
RoomBedroom5Features: Vaulted Ceiling(s),Flooring - Hardwood,Recessed Lighting,Closet - Double,Window Seat
RoomBedroom5Length: 24
RoomBedroom5Level: Third
RoomBedroom5Width: 22
RoomDiningRoomArea: 256
RoomDiningRoomFeatures: Flooring - Hardwood,Recessed Lighting,Wainscoting,Lighting - Overhead,Crown Molding
RoomDiningRoomLength: 16
RoomDiningRoomLevel: Main,First
RoomDiningRoomWidth: 16
RoomFamilyRoomArea: 304
RoomFamilyRoomFeatures: Skylight,Vaulted Ceiling(s),Flooring - Hardwood,French Doors,Exterior Access,Recessed Lighting,Lighting - Overhead
RoomFamilyRoomLength: 16
RoomFamilyRoomLevel: Main,First
RoomFamilyRoomWidth: 19
RoomKitchenArea: 546
RoomKitchenFeatures: Flooring - Hardwood,Dining Area,Pantry,Countertops - Stone/Granite/Solid,French Doors,Kitchen Island,Recessed Lighting,Stainless Steel Appliances,Pot Filler Faucet
RoomKitchenLength: 26
RoomKitchenLevel: Main,First
RoomKitchenWidth: 21
RoomLivingRoomArea: 320
RoomLivingRoomFeatures: Flooring - Hardwood,Recessed Lighting,Crown Molding
RoomLivingRoomLength: 16
RoomLivingRoomLevel: Main,First
RoomLivingRoomWidth: 20
RoomMasterBathroomFeatures: Yes
RoomMasterBedroomArea: 320
RoomMasterBedroomFeatures: Bathroom - Full,Closet - Linen,Walk-In Closet(s),Flooring - Hardwood,Dressing Room,Closet - Double
RoomMasterBedroomLength: 16
RoomMasterBedroomLevel: Second
RoomMasterBedroomWidth: 20
Sewer: Private Sewer
ShowingInstructions: Schedule with ShowingTime or Call 888-627-2775,Video Recording/Surveillance Device on Premises,Accompanied Showings.
StateOrProvince: MA
StreetName: Queen Anne Rd
StreetNumber: 10
StreetNumberNumeric: 10
TaxAnnualAmount: 20194
TaxAssessedValue: 1382200
TaxYear: 2024
TransactionBrokerCompensation: 1
Utilities: for Gas Range,for Electric Oven,for Electric Dryer,Washer Hookup,Generator Connection
WaterSource: Public,Private
WaterfrontFeatures: Beach Front,Lake/Pond,1 to 2 Mile To Beach,Beach Ownership(Public)
YearBuiltDetails: Renovated Since
YearBuiltSource: Public Records
Zoning: A
YearBuilt: 1987
Office Name: william raveis r.e. & home services
Member Name: the macchi group
Outdoor Details
Garage Attached
Other Features
Bathroom
Bathroom - Full
Bedroom
Ceiling Fan(s)
Countertops - Stone/Granite/Solid
Covered Patio/Deck
Crown Molding
Decorative Lighting
Den
Dishwasher
Dryer
Fenced Yard
Gas Water Heater
Guest House
Has Cooling System
Has Fireplace
Has Garage
Has Heating System
Has Pool
Lighting - Overhead
Microwave
Mud Room
Open Parking
Oven
Patio
Pedestal Sink
Pool - Inground Heated
Porch
Porch - Enclosed
Professional Landscaping
Range
Recessed Lighting
Refrigerator
Sprinkler System
Storage
Sun Room
Vacuum System - Rough-in
Wainscoting
Walk-up Attic
Washer
Water Heater
Window Seat
Wired for Sound
$ 17,919.56
per month
- Principal and Interest
- Property Tax
- HOA fee
$ 13,550.81
Similar Listings
$ 1,695,000
Residential
Active
4 Chadwick Way, Hopkinton MA 01748
Beds:
4Baths:
4.5Size:
5,200 ft2MLS #
73326979Listed by:
berkshire hathaway homeservices commonwealth real estate
Philippe Felix
$ 1,629,000
Residential
Active
6 Everett Circle, Hopkinton MA 01748
Beds:
4Baths:
3.5Size:
5,700 ft2MLS #
73359874Listed by:
berkshire hathaway homeservices commonwealth real estate
Philippe Felix
$ 399,900
Residential
Closed
38 E Main St, Hopkinton MA 01748
Beds:
3Baths:
1Size:
1,208 ft2MLS #
73329893Listed by:
re/max executive realty
Philippe Felix
$ 2,200,000
Land
Sold
24 Chestnut St, Hopkinton MA 01748,Hopkinton,Middlesex,Land
Baths:
0MLS #
73021997Listed by:
a. rutkowski realty, inc.
Philippe Felix