Last Sold Price
4 beds5,454 sqft$202/sqft
845 Upper Straw Rd, Hopkinton, NH 03229

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.
LISTING CLOSED: 03/06/2024 12:00 AM

  1. Listed by Donald Goudreau • EXP Realty • Cell: 603-370-0798

Sold By Cameron Prestige, LLC

Property Details for 845 Upper Straw Road

Status
MLS #
4946584
Days on Market
291
Taxes
$44,320 / year
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family
Year Built
1982
Lot Size
48.09 AC / 2,094,800 SF
Parking
Auto Open, Driveway, Garage, Off Street, Parking Spaces 21+, RV Access/Parking, Attached
Structure Type
Stick Built Off-Site
Zoning
R-4

Recent comparable sales

Median sold price

$1,160,000

Avg days on market

37

Sale-to-list ratio

96.1%

Hopkinton, NH

9 comparable properties found

$815,000 | 340 Main Street, Hopkinton, NH 03229
1/49
1

$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
2

$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
3

$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
4

$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
5

$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
6

$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
7

$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
8

$1,700,000

Sold 03/06/25

4
Bedrooms
5,200
Square Feet
1.09
Acres
$1,925,000 | 36 Connelly Hill Road, Hopkinton, MA 01748
1/42
9

$1,925,000

Sold 07/07/25

4
Bedrooms
4,995
Square Feet
1.06
Acres

Location

Add your commute

Building Information for 845 Upper Straw Road

Stories2Year Built1982Building Size-Lot Size48.09 AC / 2,094,800 SF

Payment Calculator

$9,285 per month

30 year fixed, 6.55% Interest

Principal and Interest

$5,591

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

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
$1,195,000 | 455 Maple Street, Hopkinton, NH 03229
1/18
Virtual Tour

$1,195,000

3
Bedrooms
2,598
Square Feet
24.75
Acres
$990,000 | 228 Maple Street, Hopkinton, NH 03229
1/54

$990,000

5
Bedrooms
3,858
Square Feet
1.38
Acres
$150,000 | 50 Sunset Drive, Hopkinton, NH 03229
1/31
Active Under Contract

$150,000

2
Bedrooms
1,232
Square Feet
Unavailable
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/57
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

$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
$450,000 | 35 Tyler Road, Hopkinton, NH 03229
1/37
Active Under Contract

$450,000

3
Bedrooms
1,208
Square Feet
1
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 08/20/2026 07:06 PM