Active
24 Days on market
5 Queen Anne Rd Hopkinton — Photo 1 of 42

5 Queen Anne Rd Hopkinton — Photo 1 of 42

$1,749,000

Investment Analysis — 5 Queen Anne Rd

Hopkinton, MA 01748 — Circa 1700

Based on HUD Small Area Fair Market Rent for Boston-Cambridge-Quincy, MA-NH HUD Metro FMR Area, a 4-bedroom in 01748 carries an estimated $4,260/mo in gross rent — about a 1.10% cap rate and $19,318/yr in estimated NOI at the $1,749,000 list price. Adjust every assumption in the calculator below.

View Standard Listing

Beds

4

Baths

4.5

SqFt

5,540

Style

Single Family

Built

1987

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.

ADU Potential

Massachusetts allows one accessory dwelling unit by right in single-family zoning districts statewide (M.G.L. c. 40A §3; 760 CMR 71.00, effective Feb 2025). Estimated maximum ADU size for this property: 900 sq ft (the lesser of 900 sq ft or half the 5,540 sq ft principal dwelling). Lot size: 41,617 sq ft.

Based on listing data, which indicates the property type — not the zoning district. Local dimensional, septic (Title 5), and historic-district requirements still apply. Not legal advice — verify with the municipality.

Estimates — not financial advice

These figures are illustrative estimates for informational purposes only — not an appraisal, valuation, or guarantee of rent, income, or returns, and not financial, tax, or investment advice. Rent is either the figure reported on the MLS listing — in-place rent that may differ from market and is not verified against the actual leases — or, where the listing reports none, an estimate from HUD Small Area Fair Market Rents, a government benchmark that may differ from actual market rent. Each figure is labelled with its source. Cap rate, NOI, and returns depend on the assumptions shown, which you can change. MLS and other third-party data may be inaccurate or out of date. Verify all figures independently and consult your own financial, tax, and legal advisors before making any investment decision.

Property Details

Financials

Original Price$1,749,000
Annual Taxes$19,533

Parking

Garage2
Off-Street6

Interior Specifications

Total Rooms11
Fireplaces2
FlooringTile, Carpet, Hardwood, Flooring - Hardwood, Flooring - Wall to Wall Carpet, Flooring - Vinyl, Flooring - Stone/Ceramic Tile
BasementFull, Finished, Interior Entry, Radon Remediation System, Concrete

Climate & Utilities

HeatingForced Air, Heat Pump, Natural Gas
CoolingCentral Air
WaterPublic
SewerPrivate Sewer

Building & Exterior

ConstructionFrame
RoofMetal
FoundationConcrete Perimeter
ZoningA

Property & Lot

Acres0.96
SqFt Lot41,617
Lot FeaturesWooded

Amenities & Appliances

Gas Water Heater • Tankless Water Heater • Range • Oven • Dishwasher • Microwave • Refrigerator • Freezer • Washer • Dryer • Water Treatment • Vacuum System • Range Hood

Neighborhood

Public Transportation • Shopping • Walk/Jog Trails • Golf • Medical Facility • Highway Access

Geography

Floorplan Breakdown

Structural Layout

Third
Bedroom 4
Second
Master BedroomBedroom 2Bedroom 3Bathroom 2Bathroom 3
First
Living RoomDining RoomKitchenFamily RoomBathroom 1
Living Room
Lvl First

Flooring - Hardwood

Dining Room
Lvl First

Flooring - Hardwood, Recessed Lighting, Wainscoting, Lighting - Overhead, Crown Molding

Kitchen
Lvl First

Flooring - Hardwood, Countertops - Stone/Granite/Solid, Kitchen Island, Recessed Lighting, Lighting - Overhead, Crown Molding

Family Room
Lvl First

Flooring - Hardwood, Wet Bar

Master Bedroom
Lvl Second

Bathroom - Full, Walk-In Closet(s), Flooring - Wall to Wall Carpet

Bedroom 2
Lvl Second
Bedroom 3
Lvl Second

Flooring - Wall to Wall Carpet, Closet - Double

Bedroom 4
Lvl Third

Skylight, Flooring - Wall to Wall Carpet, Closet - Double

Bathroom 1
Lvl First

Bathroom - Half, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid

Bathroom 2
Lvl Second

Bathroom - Full, Bathroom - Tiled With Shower Stall, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Bidet, Double Vanity, Recessed Lighting, Soaking Tub

Bathroom 3
Lvl Second

Bathroom - Full, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Recessed Lighting

Listing Provided By

Listing Agent: The Macchi Group

Listing Office: William Raveis R.E. & Home Services

MLS® Number: 73565351