BMN Boston

Get our mobile app!

Download on the App Store

10 Queen Anne Rd, Hopkinton MA 01748

Hopkinton, MA 01748
$2,895,000
Est. $16,535/month
6
Beds
6
Baths
6,472
Sq Ft
$447
Price/Sq Ft
2.03
Acres
1987
Year Built
96
Days on Market
Pending Listed Feb 26, 2026 • MLS# 73480298 Copied!

About this home

Where your car collection lives as well as YOU DO! Rare collector's compound w/ purpose-built 2,400 SF heated garage & workshop featuring lift infrastructure, 14' ceilings, radiant heated concrete floors, commercial overhead doors, hard-piped air compressor lines & 200 amp electrical engineered for 12 vehicles. Above, 1,800 SF of finished Vermont pine liv space w/ multiple flex rms, full bath & kitchenette. Use as guest suite, home office, recreation space, multigenerational living or all of the above, completely separate from main home. 40kW standby generator. Main residence 4,672 SF w/ chef's kitchen featuring Wolf range, Sub-Zero appliances & oversized island opening to covered terrace. Cathedral family rm w/ skylights, gas fireplace & French doors to pool. Wet bar w/ Sub-Zero wine fridge. Primary suite w/ fireplace. 3 fireplaces. Private guest suite w/ separate stair access. Heated gunite pool, 40x16 brick terrace & parking for 30+ vehicles. Quiet cul-de-sac minutes to major rtes.

View in the App

Save this property, schedule tours instantly, and get alerts when the price drops

Scan to download BMN Boston app Scan with phone
Get the full experience in the BMN Boston app

Public Records

Current Owner

Owner BERGMANN, J. DEREK
Mailing Address 10 QUEEN ANNE RD, HOPKINTON, MA, 01748

Land Use

Use Code 101
Description Single Family
Zoning A
Style COLONIAL

Tax Information

Assessed Value $1,435,800

Assessment History

Year Land Building Total Change
FY2025 $489,500 $809,900 $1,435,800

Sale History

Date Price Book/Page
Feb 21, 2005 $100 44800/439

Building Permit History

Permit history not yet available for this municipality.

Municipal Context: HOPKINTON

Property Data Comparison

Discrepancies found between MLS and assessor records.

Field Assessor MLS Match
Sqft 9,897 6,472
Year built 1,987 1,987
Match: geocode_proximity (87.4% confidence) · Data as of Jun 1, 2026

Property Overview

Property Type
Single Family Residence
Listing Type
For Sale
Year Built
1987
Bedrooms
6
Full Bathrooms
5
Half Bathrooms
2
Living Area
6,472 sq ft
Total Rooms
16

Facts & Features

12 Car Garage
Central AC

Home Facts

Type Residential
Style Single Family Residence
Year Built 1987
Living Area 6,472 sq ft
Lot Size 2.03 acres
Bedrooms 6
Full Baths 5
Half Baths 2
Total Rooms 16

Interior

Heating Baseboard, Radiant, Natural Gas
Cooling Central Air
Flooring Tile, Carpet, Hardwood, Flooring - Hardwood, Flooring - Stone/ceramic Tile
Appliances Gas Water Heater, Range, Oven, Dishwasher, Microwave, Refrigerator, Washer, Dryer, Vacuum System, Vacuum System - Rough-in
Fireplace Family Room, Living Room, Master Bedroom
Fireplaces 3
Basement Full, Interior Entry, Bulkhead, Unfinished
Laundry Closet/cabinets - Custom Built, Flooring - Hardwood, Electric Dryer Hookup, Washer Hookup, Lighting - Overhead, Sink, Second Floor
Features Vaulted Ceiling(s), Recessed Lighting, Closet - Double, Window Seat, Ceiling Fan(s), Wainscoting, Lighting - Overhead, Wet Bar, Crown Molding, Bathroom - Full, Bathroom - With Shower Stall, Pedestal Sink, Bathroom - Tiled With Tub & Shower, Countertops - Stone/granite/solid, Bedroom, Sun Room, Mud Room, Sitting Room, Bathroom, Wet Bar, Walk-up Attic, Wired For Sound

Exterior

Construction Frame
Architecture Colonial, Carriage House
Roof Shingle
Features Porch, Porch - Enclosed, Covered Patio/deck, Pool - Inground, Rain Gutters, Storage, Barn/stable, Professional Landscaping, Sprinkler System, Decorative Lighting, Fenced Yard, Guest House
Pool In Ground
Spa None
Fencing Fenced
Patio/Porch Porch, Porch - Enclosed, Covered

Parking

Garage Spaces 12
Has Garage Yes
Features Attached, Detached, Garage Door Opener, Heated Garage, Paved Drive, Paved
Total Spaces 42

Utilities

Electric Generator, Generator Connection
Water Public, Private
Sewer Private Sewer
Gas None
Other For Gas Range, For Gas Oven, For Electric Oven, For Electric Dryer, Washer Hookup, Generator Connection

Financial

Annual Tax $20,360
Assessed Value $1,435,800

Interior Features

Flooring: Tile, Carpet, Hardwood, Flooring - Hardwood, Flooring - Stone/Ceramic Tile
Appliances: Gas Water Heater, Range, Oven, Dishwasher, Microwave, Refrigerator, Washer, Dryer, Vacuum System, Vacuum System - Rough-in
Interior Features: Vaulted Ceiling(s), Recessed Lighting, Closet - Double, Window Seat, Ceiling Fan(s), Wainscoting, Lighting - Overhead, Wet bar, Crown Molding, Bathroom - Full, Bathroom - With Shower Stall, Pedestal Sink, Bathroom - Tiled With Tub & Shower, Countertops - Stone/Granite/Solid, Bedroom, Sun Room, Mud Room, Sitting Room, Bathroom, Wet Bar, Walk-up Attic, Wired for Sound
Windows: Insulated Windows, Storm Window(s)
Basement: Full, Interior Entry, Bulkhead, Unfinished
Laundry: Closet/Cabinets - Custom Built, Flooring - Hardwood, Electric Dryer Hookup, Washer Hookup, Lighting - Overhead, Sink, Second Floor
Security:

Construction & Materials

Style: Colonial, Carriage House
Year Built: 1987
Structure Type:
Exterior Materials: Frame
Roof: Shingle
Foundation: Concrete Perimeter

Heating, Cooling & Utilities

Heating: Baseboard, Radiant, Natural Gas
Heating Zones: 11
Cooling: Central Air
Cooling Zones: 5
Hot Water:
Water Source: Public, Private
Sewer: Private Sewer
Energy Features: Thermostat

Exterior & Lot

Exterior Features: Porch, Porch - Enclosed, Covered Patio/Deck, Pool - Inground, Rain Gutters, Storage, Barn/Stable, Professional Landscaping, Sprinkler System, Decorative Lighting, Fenced Yard, Guest House
Patio & Porch: Porch, Porch - Enclosed, Covered
Fencing: Fenced
Other Structures: Barn/Stable, Guest House
Lot Features: Easements
Road Surface:

Parking & Garage

Garage Spaces: 12
Garage Type: Attached
Total Parking Spaces: 42
Parking Features: Attached, Detached, Garage Door Opener, Heated Garage, Paved Drive, Paved

Special Features

Fireplaces: 3
Fireplace Type: Family Room, Living Room, Master Bedroom
Pool: Private Pool
Pool Features: In Ground
Community Amenities: Public Transportation, Shopping, Walk/Jog Trails, Golf, Medical Facility, Highway Access, House of Worship, Public School

Location

Loading map...

Neighborhood

10 Queen Anne Rd, Hopkinton MA 01748

Hopkinton, MA 01748

Walkability

Loading Walk Score...

Nearby Schools

School information not available for this location.

Monthly Payment Calculator

Monthly Payment
$0
Principal, interest, taxes & insurance
Loan Amount
$0
After down payment
Total Interest
$0
Over life of loan
Total Cost
$0
Including down payment
%
Down: $0
%

Monthly Payment Breakdown

Principal & Interest $0
Property Tax $1,697
Homeowners Insurance $200
PMI (if <20% down) $0

Loan Summary

Total of 360 payments $0
Total principal paid $0
Total interest paid $0

Rate Impact

-0.5% Rate
$0/mo
Save $0/mo
Current Rate
$0/mo
+0.5% Rate
$0/mo
Cost $0/mo

Payment Over Time

Interest
Principal
Year 1
95% Interest
Year 15
50/50
Year 30
95% Principal
* Estimates only. Actual payments may vary. Consult with a lender for accurate figures.

Property History

Market Insights

Property Timeline

📋
Status: Active under contract
May 22, 2026
Active → Active Under Contract
Pending Sale
May 21, 2026
Offer accepted, sale pending
👁️
Showing Instructions Updated
Apr 7, 2026
New showing requirements
🏠
Listed for Sale
Feb 26, 2026
$2,895,000
Original listing
Agent: Lisa Aron Williams Office: Coldwell Banker Realty - Sudbury

Price & Status History

Date Event Price Change
May 22, 2026 Status: Active under contract $0
Feb 26, 2026 New Listing Added $2,895,000

Market Statistics

Days on Market
96 days
Price per Sq Ft
$447

Tax History

Year Taxes Assessment
2025 $20,360 $1,435,800

Financial Details

Annual Property Tax
$20,360
Tax Year 2025
Assessed Value
$1,435,800

Listing Information

Listing Agent Lisa Aron Williams
Listing Office Coldwell Banker Realty - Sudbury
Agent MLS ID BB800454
Office MLS ID AN6236
Listing Data Updated Jun 3, 2026 1:11 PM EDT
Listing information is deemed reliable but not guaranteed. Data provided by MLS Property Information Network, Inc. All information should be independently verified.

Comparable Properties

Customize Comparable Search

Finding comparable properties...

Market Analytics for Hopkinton, MA

Real-time market trends and pricing data for this area

10 Queen Anne Rd, Hopkinton MA 01748 - Photo 1 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 2 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 3 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 4 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 5 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 6 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 7 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 8 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 9 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 10 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 11 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 12 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 13 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 14 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 15 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 16 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 17 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 18 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 19 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 20 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 21 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 22 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 23 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 24 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 25 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 26 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 27 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 28 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 29 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 30 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 31 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 32 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 33 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 34 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 35 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 36 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 37 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 38 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 39 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 40 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 41 10 Queen Anne Rd, Hopkinton MA 01748 - Photo 42
BMN Boston Real Estate

BMN Boston Real Estate

Douglas Elliman

Your message will be sent to BMN Boston Real Estate.

Schedule a Tour