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.
For sale
$1,749,000
5 Queen Anne Rd, Hopkinton, MA 01748
4beds
5,540sqft
Single Family Residence
Built in 1987
0.96 Acres Lot
$1,700,900 Zestimate®
$316/sqft
$-- HOA
What's special
Expansive patioFormal dining roomHome gymAbundant recreation spaceOversized walk-in closetSpa-inspired bathBeautifully landscaped grounds
- 32 days
- 1,736
- 90
Zillow last checked:
Listing updated:
Listed by:
The Macchi Group 508-509-4236,
William Raveis R.E. & Home Services 781-235-5000
Source: MLS PIN,MLS#: 73565351
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bathroom - Full, Walk-In Closet(s), Flooring - Wall to Wall Carpet
- Level: Second
Bedroom 2
- Features: Walk-In Closet(s), Flooring - Wall to Wall Carpet
- Level: Second
Bedroom 3
- Features: Flooring - Wall to Wall Carpet, Closet - Double
- Level: Second
Bedroom 4
- Features: Skylight, Flooring - Wall to Wall Carpet, Closet - Double
- Level: Third
Primary bathroom
- Features: Yes
Bathroom 1
- Features: Bathroom - Half, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid
- Level: First
Bathroom 2
- Features: Bathroom - Full, Bathroom - Tiled With Shower Stall, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Bidet, Double Vanity, Recessed Lighting, Soaking Tub
- Level: Second
Bathroom 3
- Features: Bathroom - Full, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Recessed Lighting
- Level: Second
Dining room
- Features: Flooring - Hardwood, Recessed Lighting, Wainscoting, Lighting - Overhead, Crown Molding
- Level: First
Family room
- Features: Flooring - Hardwood, Wet Bar
- Level: First
Kitchen
- Features: Flooring - Hardwood, Countertops - Stone/Granite/Solid, Kitchen Island, Recessed Lighting, Lighting - Overhead, Crown Molding
- Level: First
Living room
- Features: Flooring - Hardwood
- Level: First
Heating
- Forced Air, Heat Pump, Natural Gas
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, Tankless Water Heater, Range, Oven, Dishwasher, Microwave, Refrigerator, Freezer, Washer, Dryer, Water Treatment, Vacuum System, Range Hood
- Laundry: Electric Dryer Hookup, Washer Hookup, First Floor
Features
- Bathroom - Full, Bathroom - With Shower Stall, Countertops - Stone/Granite/Solid, Bidet, Closet, Study, Bonus Room, Bathroom, Exercise Room, Central Vacuum
- Flooring: Tile, Carpet, Hardwood, Flooring - Hardwood, Flooring - Wall to Wall Carpet, Flooring - Vinyl, Flooring - Stone/Ceramic Tile
- Doors: French Doors
- Windows: Skylight, Insulated Windows
- Basement: Full,Finished,Interior Entry,Radon Remediation System,Concrete
- Number of fireplaces: 2
- Fireplace features: Family Room, Living Room
Interior area
- Total structure area: 5,540
- Total interior livable area: 5,540 sqft
- Finished area above ground: 4,671
- Finished area below ground: 869
Video & virtual tour
Property
Parking
- Total spaces: 6
- Parking features: Attached, Garage Door Opener, Paved Drive, Off Street, Paved
- Attached garage spaces: 2
- Uncovered spaces: 4
Accessibility
- Accessibility features: No
Features
- Patio & porch: Patio
- Exterior features: Patio, Pool - Inground Heated, Rain Gutters, Storage, Sprinkler System
- Has private pool: Yes
- Pool features: Pool - Inground Heated
Lot
- Size: 0.96 Acres
- Features: Wooded
Details
- Parcel number: M:0R22 B:0141 L:0,531849
- Zoning: A
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Frame
- Foundation: Concrete Perimeter
- Roof: Metal
Condition
- Year built: 1987
Utilities & green energy
- Sewer: Private Sewer
- Water: Public
- Utilities for property: for Electric Range, for Electric Oven, for Electric Dryer, Washer Hookup
Community & HOA
Community
- Features: Public Transportation, Shopping, Walk/Jog Trails, Golf, Medical Facility, Highway Access, House of Worship
- Security: Security System
- Subdivision: Circa 1700
HOA
- Has HOA: No
Location
- Region: Hopkinton
Financial & listing details
- Price per square foot: $316/sqft
- Tax assessed value: $1,374,000
- Annual tax amount: $19,533
- Date on market: 8/19/2026
- Exclusions: Family Room And Basement Exercise Room Wall Mounted Tvs, Family Room Sound-Bar And Safe.
Estimated market value
$1,700,900
$1.62M - $1.79M
$7,013/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/19/2026 | Listed for sale | $1,749,000$316/sqft |
Source: MLS PIN #73565351 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $17,522 +1.3% | $1,235,700 +4.4% |
| 2024 | $17,298 +5.1% | $1,184,000 +13.8% |
| 2023 | $16,452 +1.9% | $1,040,600 +9.8% |
| 2022 | $16,139 +2.8% | $947,700 +3.1% |
| 2021 | $15,698 +4.4% | $919,100 +2.8% |
| 2020 | $15,032 +2.2% | $893,700 +4.3% |
| 2019 | $14,711 +4.3% | $856,800 +2.7% |
| 2018 | $14,103 +3.3% | $834,500 +2.7% |
| 2017 | $13,655 +1.3% | $812,800 +2.6% |
| 2016 | $13,486 +0.1% | $791,900 +5.5% |
| 2015 | $13,477 +1.9% | $750,400 |
| 2014 | $13,230 +1.5% | $750,400 -1.8% |
| 2012 | $13,035 +1.9% | $764,500 |
| 2011 | $12,790 +2.7% | $764,500 -3.2% |
| 2010 | $12,452 +2.8% | $790,100 -1.9% |
| 2009 | $12,108 +8.6% | $805,600 +2.2% |
| 2008 | $11,154 +4.5% | $788,300 -5.2% |
| 2007 | $10,671 +5.3% | $831,700 +2.3% |
| 2006 | $10,134 +6.2% | $812,700 +4.9% |
| 2005 | $9,543 +7.4% | $774,600 +12.5% |
| 2004 | $8,884 +5.6% | $688,700 +13.2% |
| 2003 | $8,409 +3.7% | $608,500 +10% |
| 2002 | $8,111 +15.8% | $553,300 +15.2% |
| 1999 | $7,005 +7.9% | $480,100 +6.2% |
| 1998 | $6,494 | $451,900 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 01748
Nearby schools
Schools provided by the listing agent
- Elementary: Mrthn/Elmw/Hopkins
- Middle: Hopkinton Ms
- High: Hopkinton Hs
Source: MLS PIN. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Similar homes
- $1,545,0006 bd4 ba5k sqft23 Falcon Ridge Dr, Hopkinton, MA 01748For Sale
MLS ID #73544112, The Macchi Group, William Raveis R.E. & Home Services. MLS PIN - $2,000,0005 bd5 ba4k sqft60 Chamberlain St, Hopkinton, MA 01748For Sale
MLS ID #73517327, Kim Foemmel, Foemmel Fine Homes. MLS PIN - $1,747,0004 bd4 ba5k sqft2 Watkins Ln, Southborough, MA 01772For Sale
MLS ID #73531936, Susan Gillis, William Raveis R.E. & Homes Services. MLS PIN - $945,0004 bd3 ba2.9k sqft12 Rocky Woods Rd, Hopkinton, MA 01748For Sale
MLS ID #73568375, The Macchi Group, William Raveis R.E. & Home Services. MLS PIN
