OFF MARKET

Listed by Donald Goudreau • EXP Realty (Cell: 603-370-0798). Bought with Cameron Prestige, LLC.

Off Market Mar 2024 for $1.1M

$1,552,674

•

5,454

sq ft

845 Upper Straw Rd, Hopkinton, NH 03229

About this home

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.

Single-familyProperty Type

1982Year Built

48.09 acresLot Size

$285Est. Price/Sq.Ft.

5 car garageParking

Listed by Donald Goudreau • EXP Realty

Contact: Cell: 603-370-0798

Bought with Tami Mallett • Cameron Prestige, LLC

Redfin checked: a few seconds ago

•Source:PrimeMLS #4946584

Redfin Estimate

$1,552,674

$453K since sold in March 2024$56K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 23.3% higher than the average sale price ($1.26M) of 6 comparable homes.

SOLD AUG 24, 2026
$1,350,000
A
4 beds3.5 baths4,969 sq ft
170 Fieldstone Rd, Hopkinton, NH 03229
SOLD JUN 3, 2026
$880,000
B
5 beds4 baths5,332 sq ft
211 Hedgerose Ln, Hopkinton, NH 03229
SOLD AUG 5, 2026
$1,200,000
C
3 beds3 baths2,649 sq ft
1526 South Rd, Hopkinton, NH 03229
SOLD JUN 26, 2026
$1,275,000
D
3 beds3 baths3,158 sq ft
10 Fiskill Farm Rd, Concord, NH 03301
SOLD APR 30, 2026
$2,180,000
E
5 beds5 baths6,083 sq ft
541 South Rd, Hopkinton, NH 03229
SOLD MAY 4, 2026
$670,000
F
4 beds3 baths2,796 sq ft
8 Spillway Ln, Concord, NH 03301

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$620,466

Est. take-home

List your home with Redfin and save $15,527

Market trends in 03229, NH

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

99.8%

+0.8% MoM

Median sale price

$505K

$5K MoM

Avg. days on market

47d

6 days MoM

Recently sold homes

1 MoM

New listings for sale

3D WALKTHROUGH
$649,000
4 beds2 baths3,055 sq ft
222 Bassett Mill Rd, Hopkinton, NH 03229
$649,000
3 beds2.5 baths1,900 sq ft
634 jewett Rd, Hopkinton, NH 03229
See all

Provided by Redfin

Sale history for 845 Upper Straw Rd

Tax history for 845 Upper Straw Rd

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Other

County

Merrimack County

APN

1155171

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Feb 23, 2024.

Property details

Parking

Parking & Garage
Garage Capacity: 5
Driveway, Garage, Off Street, Parking Spaces 21+, RV Accessible

Interior

Virtual Tour

Bathroom Information
# of Baths (full): 4
# of Baths (1/2): 1

Basement Information
Basement: Yes
Basement Access: Interior
Full

Other Interior Features
# of Rooms: 13
Level B: Laundry Room
Flooring: Ceramic Tile, Softwood
Central Vacuum, Blinds, Cathedral Ceiling, Dining Area, Fireplace - Wood, Fireplaces - 2, Master Bedroom With Bath, Vaulted Ceiling, Walk-in Closet, Wet Bar, Wood Stove Hook-up, Laundry - 1st Floor

Accessibility Information
1st Floor 1/2 Bathroom, 1st Floor Full Bathroom, 1st Floor Hrd Surfce Flor, 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

Equipment & Appliance Information
Cooktop - Gas, Dishwasher - Energy Star, Microwave, Range - Electric, Refrigerator-Energy Star, Ice Maker-Stand Alone
Satellite, Satellite Dish, Security System, Smoke Detector, Smoke Detectr-Hard Wired With Battery, Whole Building Ventilation, Stove-Wood

Room 1 Information
Mudroom
Mudroom
Level: 1

Room 2 Information
Other
Level: 1

Room 3 Information
Eat-In Kitchen
Level: 1

Room 4 Information
Dining Room
Level: 1

Room 5 Information
Bedroom
Level: 1

Room 6 Information
Full Bath
Full Bath
Level: 1

Room 7 Information
Great Room
Level: 1

Room 8 Information
1/2 Bath
Level: 1

Room 9 Information
Family Room
Level: 1

Room 10 Information
Den
Level: 1

Room 11 Information
Sunroom
Level: 1

Room 12 Information
Master Bedroom Suite
Level: 2

Room 13 Information
Bedroom
Level: 2

Room 14 Information
Bedroom
Level: 2

Room 15 Information
Full Bath
Level: 1

Room 16 Information
Full Bath
Level: 1

Room 17 Information
Laundry Room
Level: Basement

Exterior

Building Information
Construction Status: Existing
Approximate Sq. Ft. Total Finished: 5454
Approximate Sq. Ft. Total: 7086
Color: Green
Building, Deck, Doors - Energy Star, Garden Space, Gazebo, Outbuilding, Patio, Porch - Covered, Porch - Enclosed, Shed, Handicap Modified, Porch - Heated
Foundation: Concrete
Roof: Metal, Standing Seam

Driveway
Crushed Stone, Gravel

Lot, Zoning, & Easement Information
Lot: 0
Easements: Yes

Survey Information
Surveyed: Yes

Other Property & Lot Information
Year Built: 1982

Financial

Tax Information
Tax Year: 2022
Gross Amount Tax: 44320

Other Tax Information
Page Deed: 0043

Financing Information
Possible Options: Cash, Conventional, Other

Utilities

Heating & Cooling Information
Cooling: Central AC, Mini Split
Heat: Forced Air, Multi Zone, Radiant Floor, Stove - Wood, Mini Split
Heat Fuel: Gas - Liquid Propane Bottle, Oil, Wood

Sewer Information
1500+ Gallon, Leach Field - Existing, Septic

Electric Information
Electric Company: Eversource
200 Amp, Circuit Breaker(s), Generator Ready

Other Utilities Information
Cable Company: Dir TV/Hughes
Fuel Company: Irving
Phone Company: Avail
Phone, Satellite

Location

School Information
School District: Hopkinton School District
Middle/Jr School: Hopkinton Middle School
School - High: Hopkinton Middle High School

Neighborhood Information
Near Shopping, Near Skiing, Near Snowmobile Trails, Suburban, Near Hospital

Road Information
Road Frontage: Yes
Road Frontage Length: 552
Paved, Public

Other Location Information
Directions: Hopkinton Rd to Upper Straw, property is on the L side, the driveway is marked by a piece of red antique farming equipment.
Block: 16

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Other
Year Built: —
Year Renovated: —
County: Merrimack County
APN: 1155171

Home facts updated by county records on Feb 23, 2024

Other

Water Body Information
Flood Zone: Unknown

Documents & Disclosures
Documents Available: Deed, Lease Agreements, Plot Plan, Property Disclosure, Survey

Around this home

Schools

Harold Martin School

Public PreK-3 • Assigned • 2.3mi

5/10

Hopkinton Middle School

Public 7-8 • Assigned • 5.7mi

6/10

Hopkinton High School

Public 9-12 • Assigned • 5.7mi

10/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

3/10 Heat Factor

7 days above 94° expected this year, 17 days in 30 years

4/10 Wind Factor

15% chance of strong winds in next 30 years

1/10 Air Factor

0 unhealthy days expected this year, 0 days in 30 years

Provided by First Street

Historical weather

Hopkinton, NH • 03229

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

Try the sun simulator tool to see how light moves across the property at different times of day and year.

Provided by Shadowmap

Estimated sale price

$1.48M – $1.79M

Reach more buyers when you sell with Redfin. Save up to $15,527 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$275,000

Land— sq ft

455 (39-4) Maple St, Contoocook, NH 03229

$339,900

2 beds1 bath872 sq ft

545 N State St, Concord, NH 03301

$895,000

3 beds3.5 baths4,014 sq ft

8 W Gate Dr, Bow, NH 03304

OPEN SUN, 11AM TO 2PM

$1,100,000

5 beds5.5 baths4,587 sq ft

16 Gould Hill Rd, Hopkinton, NH 03229

$649,900

4 beds2.5 baths2,706 sq ft

244 Page Rd, Bow, NH 03304

$679,500

4 beds2 baths2,394 sq ft

975 Rollins Rd, Hopkinton, NH 03229

New listings for sale in 03229

3D WALKTHROUGH

$649,000

4 beds2 baths3,055 sq ft

222 Bassett Mill Rd, Hopkinton, NH 03229

$649,000

3 beds2.5 baths1,900 sq ft

634 jewett Rd, Hopkinton, NH 03229

Home values near 845 Upper Straw Rd

Data from public records.

Address	Redfin Estimate
1000 Upper Straw Road, Hopkinton, NH 4 Beds \| 3.5 Baths \| 3164 Sq. Ft.	$811,432
1075 Upper Straw Road, Hopkinton, NH 2 Beds \| 1 Baths \| 2121 Sq. Ft.	$516,658

Address	Redfin Estimate
741 Upper Straw Road, Hopkinton, NH 3 Beds \| 2.5 Baths \| 1848 Sq. Ft.	$675,022
758 Upper Straw Road, Hopkinton, NH 3 Beds \| 1.5 Baths \| 1785 Sq. Ft.	$552,876

Address	Redfin Estimate
902 Upper Straw Road, Hopkinton, NH 6 Beds \| 3.5 Baths \| 3435 Sq. Ft.	$644,329
929 Upper Straw Road, Hopkinton, NH 3 Beds \| 1 Baths \| 1151 Sq. Ft.	$364,850

Property information provided by PrimeMLS when last listed in 2023. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Bedford homes for sale
Gilford homes for sale
Bow homes for sale
Litchfield homes for sale
Merrimack homes for sale

Houses for sale near me	Nashua, NH homes for sale	Derry, NH homes for sale
Land for sale near me	Portsmouth, NH homes for sale	Hudson, NH homes for sale
Open Houses near me	Salem, NH homes for sale	Contoocook Property Records
Condos for sale near me	Manchester, NH homes for sale	NH New Listings
Agents near me	Londonderry, NH homes for sale	Contoocook Housing Market

Concord homes for sale
Hooksett homes for sale
Manchester homes for sale