Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 2 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 3 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 4 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 5 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 6 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 7 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 8 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 9 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 10 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 11 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 12 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 13 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 14 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 15 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 16 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 17 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 18 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 19 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 20 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 21 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 22 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 23 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 24 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 25 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 26 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 27 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 28 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 29 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 30 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 31 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 32 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 33 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 34 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 35 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 36 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 37 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 38 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 39 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 40 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 41 of 42
Single Family Residence at 5 Queen Anne Rd, Hopkinton MA 01748, Hopkinton, photo 42 of 42
42 photos

$1,749,000

5 Queen Anne Rd, Hopkinton MA 01748
Hopkinton, MA 01748
Listed by The Macchi Group
Bedrooms
4
Bathrooms
4.5
Living area
5,540 sqft
Year built
1987

About this home

Custom built by one of Hopkinton's most respected luxury builders, this extraordinary Victorian-inspired Colonial is a rare offering where exceptional craftsmanship, timeless architecture, and meticulous care come together. Purchased directly from the builder by the current original owners, the home has been lovingly maintained and thoughtfully updated while preserving its character and quality. Recent improvements include a freshly painted exterior (2025), new heat pumps (2024), all-new Marvin windows and doors (2021), new kitchen appliances (2021), and a lifetime metal roof (2019). At the heart of the home is a beautifully renovated chef's kitchen featuring premium Sub-Zero double refrigerator/freezers, luxury Miele appliances, custom cabinetry, and views of the backyard oasis. Step outside to an expansive patio overlooking a spectacular Pebbl-Tec in-ground pool with waterfall, beautifully landscaped grounds, and a generous level lawn for play and entertaining. The first floor offers elegant yet comfortable living spaces, including a dramatic living room with soaring ceilings, formal dining room, private wood paneled study w/ private porch, inviting family room with stone fireplace, butler's pantry, laundry, and a bright kitchen designed for gathering. The finished lower level offers a home theater, full bath, sauna, home gym, and abundant recreation space. Upstairs, the luxurious primary suite is a private retreat with a spa-inspired bath, oversized walk-in closet, cedar closet and sitting room. Two additional bedrooms share a beautifully appointed bath, while the third-floor suite features a bedroom, sleeping loft, and full bath, ideal for guests, multigenerational living, or an au pair. Ideally located minutes from I-495, shopping, dining, Trader Joe's, HomeGoods, TJ Maxx, Lowe's, and everyday conveniences, this remarkable property enjoys all that Hopkinton is known for, including highly acclaimed schools, a vibrant community, and an outstanding commuter location. More than a beautiful home, this is a truly special property built to an exceptional standard and designed to be treasured for generations.

Highlights

Private poolFireplace

Property details

MLS #
73565351
Property type
Single Family Residence
Subdivision
Circa 1700
Status
Active
Days on market
37
On market date
August 19, 2026
Stories
N/A
Total bathrooms
4.5
Garage spaces
2
Parking spaces
6
Lot size
0.96 acres
Loading map…

Nearby schools

Within 10 miles · public school directory data (NCES)

Elementary
Elmwood
1.46 mi away · Grades 2-3
Nearest school -- attendance-zone data not available here
4.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
622
Student:teacher ratio
14.5:1
District
Hopkinton
Middle
Hopkinton Middle School
2.19 mi away · Grades 6-8
Nearest school -- attendance-zone data not available here
4.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
923
Student:teacher ratio
13.6:1
District
Hopkinton
High
Hopkinton High
2.17 mi away · Grades 9-12
Nearest school -- attendance-zone data not available here
4.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
1,212
Student:teacher ratio
14.4:1
District
Hopkinton

Walkability

Blended score for Hopkinton's center: EPA's National Walkability Index (street network, transit, land-use mix) combined with nearby-amenity density. 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).

21
Car-dependent
out of 100
EPA National Walkability Index
6.3 / 20 -- Below average walkable
Nearby-amenity density
5 / 100
Restaurants & cafes0
Grocery stores0
Parks1
Schools0
Transit stops0
Pharmacies0

Mortgage calculator

Estimate only - actual rate and payment depend on your lender, credit, and loan program.

$
%
%
Adjust tax / insurance estimates
% / yr
$
/mo
Est. monthly payment
$10,683/mo
$349,800 down
$1,399,200 loan
Principal & interest$9,075
Property tax (est.)$1,458
Home insurance (est.)$150

Similar homes you might like

Data source: Listing information provided by MLS Property Information Network via Trestle/CoreLogic. Last updated 9 days ago.

Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.