Sold
Last Sold Price
4 beds5,454 sqft$202/sqft
845 Upper Straw Rd, Hopkinton, NH 03229
Single FamilyProperty Type
48.09 acresLot Size
1982Year Built
$202/sq ftPrice per sq ft
5 carsParking Spaces

Description

Huge Price Reduction! Gorgeous farm, 49 acres, home & 1 Cell Tower lease. Here's Your chance for your "Green Acres" lifestyle right by the Capitol City! Bring Your horses and livestock, Living "the good life". Unique offering consists of a 5,454 finished sq' custom built home or 6,176 sq' area in a farm setting. This unique offering also leased land with an active US Cellular Tower creating a substantial rental income of $23,626 plus $10,138 of the property taxes Billed directly to Tower Lessees,...Huge Price Reduction! Gorgeous farm, 49 acres, home & 1 Cell Tower lease. Here's Your chance for your "Green Acres" lifestyle right by the Capitol City! Bring Your horses and livestock, Living "the good life". Unique offering consists of a 5,454 finished sq' custom built home or 6,176 sq' area in a farm setting. This unique offering also leased land with an active US Cellular Tower creating a substantial rental income of $23,626 plus $10,138 of the property taxes Billed directly to Tower Lessees, equals net $0 taxes to Owner after income & taxes paid by Leases are paid! Setting has 48.09 acres that are mostly rolling and open. The home is beautiful and custom built and includes open farmland with several pole barns & several garages & other farm buildings. The farm was set up for over 100 beef critter though the years. The custom features include 3 heating systems plus wood stove, 4 wells, 8 heating zones, generator ready for the optional PTO portable generator, heated floors, central air and so much more. The cell tower is located at the North end of the acreage. Surprises in store when viewing this home and the pictures are just a tease of what you have in store for you. If you are looking for a horse farm, or for livestock or agricultural use this could be THE ONE. The setting has unobstructed Southern exposure. Old world farms like this don't become available too often and is move-in ready. Come see all that this dream located on the Concord town line has to offer you.

    Sold By Cameron Prestige, LLC

    • Listed by: Donald Goudreau • EXP Realty Cell: 603-370-0798
    Listing closed: 03/06/2024 12:00 AM • Source: New England Real Estate Network, MLS#: 4946584

    Recent comparable sales

    Median sold price

    $1,160,000

    Avg days on market

    40

    Sale-to-list ratio

    94.3%

    Hopkinton, NH

    9 comparable properties found

    $1,350,000 | 170 Fieldstone Road, Hopkinton, NH 03229
    1/61
    1

    $1,350,000

    Sold 08/24/26

    4
    Bedrooms
    4,969
    Square Feet
    3.6
    Acres
    $815,000 | 340 Main Street, Hopkinton, NH 03229
    1/49
    2

    $815,000

    Sold 04/11/25

    4
    Bedrooms
    5,500
    Square Feet
    0.53
    Acres
    $880,000 | 211 Hedgerose Lane, Hopkinton, NH 03229
    1/60
    3

    $880,000

    Sold 06/03/26

    5
    Bedrooms
    5,332
    Square Feet
    4.7
    Acres
    $1,150,000 | 36 Old Henniker Road, Hopkinton, NH 03229
    1/59
    4

    $1,150,000

    Sold 04/20/26

    4
    Bedrooms
    5,451
    Square Feet
    2.4
    Acres
    $1,414,000 | 19 Falcon Ridge Drive, Hopkinton, MA 01748
    1/43
    5

    $1,414,000

    Sold 08/29/25

    4
    Bedrooms
    5,034
    Square Feet
    1.40
    Acres
    a front view of a house with a garden
    1/43
    6

    $1,160,000

    Sold 09/26/25

    4
    Bedrooms
    4,750
    Square Feet
    0.96
    Acres
    $1,000,000 | 128 Patch Road, Hopkinton, NH 03229
    1/59
    7

    $1,000,000

    Sold 06/18/25

    5
    Bedrooms
    4,397
    Square Feet
    12.9
    Acres
    $2,180,000 | 541 S Road, Hopkinton, NH 03229
    1/56
    8

    $2,180,000

    Sold 04/30/26

    5
    Bedrooms
    6,083
    Square Feet
    25.3
    Acres
    $1,700,000 | 4 Chadwick Way, Hopkinton, MA 01748
    1/43
    9

    $1,700,000

    Sold 03/06/25

    4
    Bedrooms
    5,200
    Square Feet
    1.09
    Acres

    Location

    Add your commute

    Payment Calculator

    $9,378 per month

    30 year fixed, 6.71% Interest

    Principal and Interest

    $5,684

    Property Taxes

    $3,693

    HOA Dues

    $0

    The Payment Calculator is for illustrative purposes only.

    Know your buying power with a preapproval and custom rate in minutes

    Rocket Mortgage1

    Property Information for 845 Upper Straw Road

    Property Details
    • Taxes: $44,320 / year
    • MLS Type: Residential / Single Family
    • Parking: Auto Open, Driveway, Garage, Off Street, Parking Spaces 21+, RV Access/Parking, Attached
    • Structure Type: Stick Built Off-Site
    • Zoning: R-4
    Building Information
    • Stories: 2
    • Year Built: 1982
    • Lot Size: 48.09 AC / 2,094,800 SF
    Summary
    Location and General Information
    • Area Description: Near Shopping, Near Skiing, Near Snowmobile Trails, Suburban, Near Hospital
    • City: Hopkinton
    • County: NH-Merrimack
    • Directions: Hopkinton Rd to Upper Straw, property is on the L side, the driveway is marked by a piece of red antique farming equipment.
    • Latitude: 43.181836189089211
    • Longitude: -71.625902978881911
    • Road Frontage: Yes
    • Seasonal: No
    • State: NH
    • Street Designation: Road
    • Map: 265
    • Zip Code: 03229
    Taxes and HOA Information
    • Tax - Gross Amount: $44,320.00
    • Tax Year: 2022
    • Taxes TBD: No
    School Information
    • School - High: Hopkinton Middle High School
    • School - District: Hopkinton School District
    • School - Middle/Jr: Hopkinton Middle School
    Parking
    • Garage: Yes
    • Garage Capacity: 5.00
    • Driveway: Crushed Stone, Gravel
    Property
    Lot Information
    • Block: 16
    • Footprint: 36X85
    • Lot: 0
    • Lot - Sqft: 2094800.0
    • Lot Features: Agricultural, Country Setting, Farm, Farm - Dairy, Farm - Horse/Animal, Field/Pasture, Hilly, Landscaped, Major Road Frontage, Open, Rolling, Secluded, Timber, Trail/Near Trail, View, Wooded
    • Lot Size Acres: 48.09
    • Road Frontage Length: 552.0
    • Square Feet Apx Finished Above Grade: 5166.0
    • Square Feet Apx Finished AG Source: Assessor
    • Square Feet Apx Finished Below Grade: 288.0
    • Square Feet Apx Finished BG Source: Assessor
    • Square Feet Apx Total: 7086.0
    • Square Feet Apx Total Finished: 5454.0
    • Square Feet Apx Unfinished Above Grade: 0.0
    • Square Feet Apx Unfinished AG Source: Assessor
    • Square Feet Apx Unfinished Below Grade: 1632.0
    • Square Feet Apx Unfinished BG Source: Assessor
    Property and Assessments
    • Current Use: Yes
    • Property Class: Residential
    • Property Type: Single Family
    • Easements: Yes
    • Flood Zone: Unknown
    • Foundation: Concrete
    • PreConstruction: No
    • Surveyed: Yes
    • Year Built: 1982
    Utilities
    • Electric Company: Eversource
    • Cable Company: Dir TV/Hughes
    • Fuel Company: Irving
    • Electric: 200 Amp, Circuit Breaker(s), Generator Ready
    • Sewer: 1500+ Gallon, Leach Field - Existing, Septic
    • Water Source: Drilled Well, Dug Well
    • Utilities: Phone, Satellite
    • Internet: High Speed Intrnt -AtSite, Satellite Internet
    Interior and Exterior Features
    Exterior Features
    • Color: Green
    • Construction Materials: Clapboard Exterior, Concrete Exterior
    • Features - Accessibility: 1st Floor 1/2 Bathroom, 1st Floor Full Bathroom, 1st Floor Hrd Surfce Flr, Access Common Use Areas, Access Parking, Access Restrooms, Bathroom w/Tub, Easy Grip Door Hardware, Grab Bars in Bathroom, Handicap Modified, Hard Surface Flooring, Kitchen w/5 Ft. Diameter, Kitchenette w/5 Ft. Diam, No Stairs from Parking, 1st Floor Laundry
    • Features - Exterior: Building, Deck, Doors - Energy Star, Garden Space, Gazebo, Outbuilding, Patio, Porch - Covered, Porch - Enclosed, Shed, Handicap Modified, Porch - Heated
    • Roads: Paved, Public
    • Roof: Metal, Standing Seam
    Interior Features
    • Appliances: Cooktop - Gas, Dishwasher - Energy Star, Microwave, Range - Electric, Refrigerator-Energy Star, Water Heater-Gas-LP/Bttle, Water Heater - Tank, Ice Maker-Stand Alone
    • Basement: Yes
    • Basement Access Type: Interior
    • Basement Description: Full
    • Baths - Total: 5
    • Baths - Full: 4
    • Half Baths: 1
    • One Quarter Baths: 0
    • Three Quarter Bath: 0
    • Rooms - Total: 13
    • Rooms: Level 1: Level 1: Bedroom, Level 1: Bath - Full, Level 1: Bath - 1/2, Level 1: Den, Level 1: Dining Room, Level 1: Family Room, Level 1: Great Room, Level 1: Kitchen - Eat-in, Level 1: Mudroom, Level 1: Other, Level 1: Sunroom
    • Rooms: Level 2: Level 2: Bedroom, Level 2: Primary Bdm Ste
    • Rooms: Level B: Level B: Laundry Room
    • Bedrooms - Total: 4
    • Equipment: Satellite, Satellite Dish, Security System, Smoke Detector, Smoke Detectr-HrdWrdw/Bat, Whole BldgVentilation, Stove-Wood
    • Features - Interior: Central Vacuum, Blinds, Cathedral Ceiling, Dining Area, Fireplace - Wood, Fireplaces - 2, Primary BR w/ BA, Vaulted Ceiling, Walk-in Closet, Wet Bar, Wood Stove Hook-up, Laundry - 1st Floor
    • Flooring: Ceramic Tile, Softwood
    • Heat Fuel: Gas - LP/Bottle, Oil, Wood
    • Heating: Forced Air, Multi Zone, Radiant Floor, Stove - Wood, Mini Split
    • Cooling: Central AC, Mini Split
    • Total Stories: 2
    Room Information
    Room 1
    • Room Level: 1
    • Room Type: Mudroom
    Room 2
    • Room Level: 1
    • Room Type: Other
    Room 3
    • Room Level: 1
    • Room Type: Kitchen - Eat-in
    Room 4
    • Room Level: 1
    • Room Type: Dining Room
    Room 5
    • Room Level: 1
    • Room Type: Bedroom
    Room 6
    • Room Level: 1
    • Room Type: Bath - Full
    Room 7
    • Room Level: 1
    • Room Type: Great Room
    Room 8
    • Room Level: 1
    • Room Type: Bath - 1/2
    Room 9
    • Room Level: 1
    • Room Type: Family Room
    Room 10
    • Room Level: 1
    • Room Type: Den
    Room 11
    • Room Level: 1
    • Room Type: Sunroom
    Room 12
    • Room Level: 2
    • Room Type: Primary BR Suite
    Room 13
    • Room Level: 2
    • Room Type: Bedroom
    Room 14
    • Room Level: 2
    • Room Type: Bedroom
    Room 15
    • Room Level: 1
    • Room Type: Bath - Full
    Room 16
    • Room Level: 1
    • Room Type: Bath - Full
    Room 17
    • Room Level: Basement
    • Room Type: Laundry Room

    Property History for 845 Upper Straw Road

    DateEvent & SourcePriceAppreciation
    Mar 6, 2024

    Sold (Public Record)

    Public Record #1528377472

    $1,100,000
    Mar 6, 2024

    Sold

    New England Real Estate Network #4946584

    $1,100,000
    Jan 9, 2024

    Pending

    New England Real Estate Network #4946584

    DateEvent & SourcePrice
    03/06/2024

    Sold (Public Record)

    Public Record #1528377472

    $1,100,000
    03/06/2024

    Sold

    New England Real Estate Network #4946584

    $1,100,000
    01/09/2024

    Pending

    New England Real Estate Network #4946584

    For completeness, we often displays two records for one sale: the MLS record and the public record.

    Public Records for 845 Upper Straw Road

    Taxable ValueLand-Additions$437,800Total-
    Tax Record2025$10,223 ($852 / month)
    Home Facts
    Beds0StyleSingle Family ResidenceZoningR-4CountyMERRIMACKAPNHOPN M:00265 B:000016 L:000088

    Schools near 845 Upper Straw Road

    This home is within Hopkinton School District.
    Rating
    School
    Type
    Grades
    Distance
    Public - 4 to 6
    Public - 7 to 8
    Public - 9 to 12
    Public - PK to 3
    Rating
    School
    Distance
    Maple Street Elementary School
    Public4 to 6

    Hopkinton Middle School
    Public7 to 8

    Hopkinton High School
    Public9 to 12

    Harold Martin School
    PublicPK to 3

    School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

    Similar Homes

    New listings in 03229

    $119,000 | 25 Sunset Drive, Hopkinton, NH 03229
    1/24

    $119,000

    2
    Bedrooms
    1,152
    Square Feet
    Unavailable
    Acres
    $990,000 | 228 Maple Street, Hopkinton, NH 03229
    1/54

    $990,000

    5
    Bedrooms
    3,858
    Square Feet
    1.38
    Acres
    $499,900 | 525 North Shore Drive, Hopkinton, NH 03229
    1/41

    $499,900

    1
    Bedrooms
    972
    Square Feet
    0.46
    Acres
    $839,999 | 376 Main Street, Hopkinton, NH 03229
    1/11
    Active Under Contract

    $839,999

    4
    Bedrooms
    3,528
    Square Feet
    0.63
    Acres
    $1,100,000 | 16 Gould Hill Road, Hopkinton, NH 03229
    1/59
    Open: 9/13 11:00AM - 02:00PM

    $1,100,000

    5
    Bedrooms
    4,587
    Square Feet
    4.07
    Acres
    $2,750,000 | 385 Irish Hill Road, Hopkinton, NH 03229
    1/56

    $2,750,000

    4
    Bedrooms
    5,009
    Square Feet
    40.76
    Acres
    $789,000 | 594 Kearsarge Avenue, Hopkinton, NH 03229
    1/39

    $789,000

    3
    Bedrooms
    2,552
    Square Feet
    2.2
    Acres
    $899,900 | 41 Roberts Road, Hopkinton, NH 03229
    1/40
    Listed By Coldwell Banker Realty

    $899,900

    4
    Bedrooms
    2,997
    Square Feet
    1.2
    Acres
    $149,900 | 26 Deer Path Road, Hopkinton, NH 03229
    1/48

    $149,900

    2
    Bedrooms
    1,424
    Square Feet
    Unavailable
    Acres

    Nearby home values

    AddressSold priceBedsBathsSqftLot (Sqft)
    This home: 845 Upper Straw Road, Hopkinton, NH 03229
    $1,100,000
    4
    5,454
    2,094,800
    $254,500
    3
    3,216
    729,194
    3
    2
    2,428
    382,544
    3
    2.5
    4,019
    242,629
    $477,500
    4
    4,255
    524,462
    $890,000
    4
    4,587
    130,680

    No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

    Listing Courtesy of EXP Realty

    Copyright 2026 PrimeMLS, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of PrimeMLS. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated 09/11/2026 10:52 PM