Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

5 Queen Anne Rd, Hopkinton MA 01748

$1,749,000

Estimated $12,405/month Calculator

Single Family

4 Bedrooms

Baths

5540

Total Parking: 8 (2 Garage)

41,617 (0.96)

Built in 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.

This home has been viewed 4 times

Last Checked: September 17th, 2026 at 9:38am (Source: MLS PIN #73565351)

Garage Parking

Air Conditioning

Waterview

Lead Paint Free

General Information for 5 Queen Anne Rd, Hopkinton MA 01748

Listing ID73565351

Property TypeSingle Family / Detached

Price$1,749,000 ($315.7/SqFt)

StyleColonial

CityHopkinton

CountyMiddlesex

Neighborhood(s)

Garage Parking2

ZoningA

Year Built1987

Year Built SourcePublic Records

Year Built DetailsActual

Handicap Access / Features0

Interior Features for 5 Queen Anne Rd, Hopkinton MA 01748

Approximate Living Area Total5540

Living Area Includes BasementYes

Rooms11

Bedrooms4

Primary En Suite BathroomYes

BasementFull

Cooling1, Split

Fireplaces

AppliancesRange

FlooringTile

Electric

Exterior Features for 5 Queen Anne Rd, Hopkinton MA 01748

Approximate Lot Size (Acres)0.96

Approximate Lot Size (Square Feet)41617

Total Parking8 (2 Garage)

Garage Parking2

WaterPublic

SewerPrivate Sewer

Lot FeaturesGentle Sloping

Parking Features1

Exterior FeaturesPorch

Foundation Materials

Construction MaterialsFrame

Road Frontage Type

Patio & PorchCovered

Roof MaterialAsphalt/fiberglass Shingles

Utility Connections110 Volts

Water ViewsNo

Water Views Features

Waterfront0

Waterfront Features

Pool FeaturesAssociation

Horse Permitted0

Horse Amenities

Disclosures for 5 Queen Anne Rd, Hopkinton MA 01748

Lead PaintNone

UFFINo

Living Area Includes BasementYes

Living Area Disclosure

Building Area SourcePublic Records

Special Listing Conditions

ExclusionsWasher

Title 5A

Compensation Based On

Financial Information for 5 Queen Anne Rd, Hopkinton MA 01748

Association Fee

Association Fee Frequency

Association Fee Includes

Real Estate Tax19533

Tax Year2026

Assessed Value$1,374,000

Location Information for 5 Queen Anne Rd, Hopkinton MA 01748

Elementary SchoolMrthn/Elmw/Hopkins

Middle SchoolHopkinton Ms

High SchoolHopkinton Hs

Neighborhood(s)

Area AmenitiesWalk/jog Trails

Contact Information for 5 Queen Anne Rd, Hopkinton MA 01748

Agent

Name: The Macchi Group

Office

Name: William Raveis R.E. & Home Services

Phone: 781-235-5000

Team Members

Name: Nikki Howell

Payment Calculator

, Interest

Property Taxes 1627.75

Principal & Interest 10776.78

HOA Dues

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

William Raveis R.E. & Home Services

The Macchi Group

Agent Phone

Office Phone

(781) 235-5000

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 0.96 acres (41,617 SqFt)
    [add_date] => 2026-09-16 16:38:35
    [address] => Queen Anne Rd
    [agent] => Array
        (
            [address] => 
            [city] => 
            [id] => BB921490
            [name] => The Macchi Group
            [national_association] => 
            [office] => M95356
            [state] => 
            [zip] => 
        )

[apod_available] => Array
        (
        )

[appliances] => Array
        (
            [0] => Range
        )

[approx_living_area_total] => 5540
    [approx_lot_size_acres] => 0.96
    [approx_lot_size_sqft] => 41617
    [assessed_value] => $1,374,000
    [association] => 
    [association_fee] => Array
        (
        )

[association_fee_frequency] => Array
        (
        )

[association_fee_includes] => Array
        (
        )

[association_required] => Array
        (
        )

[available_date] => 
    [available_now] => 0
    [basement] => Array
        (
            [0] => Full
        )

[bathrooms] => 
    [bedrooms] => 4
    [building_amenities] => Array
        (
        )

[building_area_source] => Array
        (
            [0] => Public Records
        )

[building_management] => Array
        (
        )

[building_debug] => 
    [building_id] => 
    [building_parent] => 0
    [building_name] => 
    [building_name_from_address] => 
    [building_url] => 
    [buyer_agent_compensation] => 
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Detached
        )

[c_type] => Array
        (
            [0] => Single Family
        )

[cap_rate] => 
    [city] => Hopkinton
    [community_features] => Array
        (
            [0] => Walk/jog Trails
        )

[compensation_based_on] => Array
        (
        )

[complex_complete] => Array
        (
        )

[construction_materials] => Array
        (
            [0] => Frame
        )

[construction_status] => 
    [cooling] => Array
        (
            [0] => 1
            [1] => Split
        )

[cooperating_agent_commission] => Array
        (
        )

[county] => Middlesex
    [cultivation_acres] => 
    [date_available_note] => 
    [deposit_amount] => Array
        (
        )

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => 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.
    [disclosures] => 
    [documents_available] => Array
        (
        )

[electric] => Array
        (
        )

[electric_expense] => Array
        (
        )

[elementary_school] => Mrthn/Elmw/Hopkins
    [en_suite_bath] => Array
        (
            [0] => Yes
        )

[energy_features] => 
    [entry_level] => Array
        (
        )

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
            [0] => Washer
        )

[exterior_features] => Array
        (
            [0] => Porch
        )

[facilitator_compensation] => 
    [fee_paid_by_tennant] => 
    [financial_data_source] => Array
        (
        )

[fireplaces] => Array
        (
        )

[first_month_required] => Array
        (
        )

[floor_number] => 0
    [flooring] => Array
        (
            [0] => Tile
        )

[for_sale_by_owner] => 
    [foundation_area] => 
    [foundation_materials] => Array
        (
        )

[frontage_length] => 
    [full_baths] => 
    [garage_parking] => 2
    [gas] => Array
        (
        )

[gas_expense] => Array
        (
        )

[gross_income] => Array
        (
        )

[half_baths] => 
    [handicap_access] => 0
    [heating] => 
    [heating_expense] => Array
        (
        )

[high_school] => Hopkinton Hs
    [horse_features] => Array
        (
        )

[horse_permitted] => 0
    [hot_water] => Array
        (
        )

[id] => 
    [insurance_expense] => Array
        (
        )

[insurance_required] => Array
        (
        )

[interior_features] => Array
        (
            [0] => French Doors
        )

[last_month_required] => Array
        (
        )

[last_sync_date] => 2026-09-17 09:38:34
    [laundry_features] => Array
        (
            [0] => Archway
        )

[lead_paint] => Array
        (
            [0] => None
        )

[lease_term] => Array
        (
        )

[levels_in_unit] => 
    [living_area] => 
    [living_area_disclosure] => Array
        (
        )

[living_area_includes_basement] => Array
        (
            [0] => Yes
        )

[lot_features] => Array
        (
            [0] => Gentle Sloping
        )

[management_expense] => Array
        (
        )

[middle_school] => Hopkinton Ms
    [miscellaneuos_expense] => Array
        (
        )

[mls_area] => 
    [mls_id] => 73565351
    [neighborhoods] => 
    [net_income_calc] => -19533
    [net_operating_income] => Array
        (
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 
    [office] => Array
        (
            [id] => M95356
            [name] => William Raveis R.E. & Home Services
            [phone] => 781-235-5000
        )

[operating_expense] => Array
        (
        )

[optional_fee_includes] => Array
        (
        )

[optional_price] => 0
    [outdoor_space_available] => Array
        (
        )

[owner_occupancy_source] => 
    [parking_features] => Array
        (
            [0] => 1
        )

[pasture_area] => 
    [patio_and_porch] => Array
        (
            [0] => Covered
        )

[perc_test] => Array
        (
        )

[perc_test_date] => 
    [pet_policy] => Array
        (
            [0] => Allowed
        )

[phone] => 
    [pool_features] => Array
        (
            [0] => Association
        )

[price] => 1749000
    [price_per_sqft] => 315.7
    [price_per_unit] => 1749000
    [private_pool] => 
    [property_sub_type] => Array
        (
            [0] => Single Family Residence
        )

[real_estate_tax] => 19533
    [references_required] => Array
        (
        )

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
        )

[road_frontage_type] => Array
        (
        )

[roof_material] => Array
        (
            [0] => Asphalt/fiberglass Shingles
        )

[rooms] => 11
    [schools] => 
    [senior_community] => 
    [sewer] => Array
        (
            [0] => Private Sewer
        )

[sewer_expense] => Array
        (
        )

[short_sale] => Array
        (
        )

[special_listing_conditions] => Array
        (
        )

[state] => Massachusetts
    [state_code] => MA
    [status] => Array
        (
            [0] => Active
        )

[street_number] => 5
    [structure_type] => Array
        (
        )

[style] => Array
        (
            [0] => Colonial
        )

[subagent_compensation] => 
    [tag_accessible_features] => 
    [tag_air_conditioning] => 1
    [tag_association_pool] => 
    [tag_beach_access] => 
    [tag_beach_front] => 
    [tag_elevator] => 
    [tag_equestrian] => 
    [tag_garage_parking] => 1
    [tag_generator] => 
    [tag_green_features] => 
    [tag_laundry] => 1
    [tag_lead_paint_free] => 1
    [tag_loft] => 
    [tag_pet_friendly] => 
    [tag_pre_construction] => 
    [tag_private_outdoor_space] => 
    [tag_private_pool] => 
    [tag_professional_management] => 
    [tag_recently_renovated] => 
    [tag_senior_community] => 
    [tag_townhouse] => 
    [tag_waterfront] => 
    [tag_waterview] => 1
    [tax_year] => 2026
    [team] => CN244456,BB921490
    [team_agents] => Array
        (
            [CN244456] => Array
                (
                    [agent_mls_id] => CN244456
                    [full_name] => Nikki Howell
                    [address] => 22 Roosevelt Lane
                    [city] => Hopkinton
                    [state] => MA
                    [postal_code] => 01748
                    [national_association_id] => 
                    [office_mls_id] => M95356
                )

[BB921490] => Array
                (
                    [agent_mls_id] => BB921490
                    [full_name] => Trina Macchi
                    [address] => 12 Granite Street
                    [city] => Hopkinton
                    [state] => MA
                    [postal_code] => 01748
                    [national_association_id] => 449522540
                    [office_mls_id] => M95356
                )

)

[terms] => Array
        (
        )

[timber_acres] => 
    [title_5] => A
    [total_gross_expense] => 19533
    [total_gross_income] => 0
    [total_parking] => 8 (2 Garage)
    [trash_expense] => Array
        (
        )

[travel_routes] => 
    [uffi] => Array
        (
            [0] => No
        )

[unit_1_bathrooms] => 
    [unit_1_bedrooms] => 
    [unit_1_floor] => 
    [unit_1_lease] => Array
        (
        )

[unit_1_levels] => 
    [unit_1_rent] => Array
        (
        )

[unit_2_bathrooms] => 
    [unit_2_bedrooms] => 
    [unit_2_floor] => 
    [unit_2_lease] => Array
        (
        )

[unit_2_levels] => 
    [unit_2_rent] => Array
        (
        )

[unit_3_bathrooms] => 
    [unit_3_bedrooms] => 
    [unit_3_floor] => 
    [unit_3_lease] => Array
        (
        )

[unit_3_levels] => 
    [unit_3_rent] => Array
        (
        )

[unit_4_bathrooms] => 
    [unit_4_bedrooms] => 
    [unit_4_floor] => 
    [unit_4_lease] => Array
        (
        )

[unit_4_levels] => 
    [unit_4_rent] => Array
        (
        )

[unit_level] => 
    [unit_number] => 
    [units_owner_occupied] => 
    [unparsed] => 5 Queen Anne Rd, Hopkinton MA 01748
    [utilities] => Array
        (
            [0] => 110 Volts
        )

[view] => Array
        (
        )

[water] => Array
        (
            [0] => Public
        )

[water_expense] => Array
        (
        )

[water_views] => Array
        (
            [0] => No
        )

[water_views_features] => Array
        (
        )

[waterfront] => 0
    [waterfront_features] => Array
        (
        )

[raw] => 
)

EXIT

39 More Photos