Price Reduced 37.47%

$1,250,000 ($229.19 per sqft)

Pending

Est. Mortgage $6,486/mo *

Quick Pre-Approval

Listing courtesy of Donald Goudreau, eXp Realty Cell: 603-370-0798


Price History

$1,999,000
3/24/2023

$1,795,000
5/18/2023

$1,500,000
10/24/2023

$1,400,000
12/6/2023

$1,250,000
12/28/2023


845 Upper Straw Road, Hopkinton, NH, 03229

845 Upper Straw Road, Hopkinton, NH, 03229

13 rooms

4 beds

4 Full / 1 Half baths

1982

Contemporary, Farmhouse

5,454 sqft

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.


Status:

Pending

Type:

Single-family residential

Zoning:

R-4

Frontage:

552

Garage:

5-car Garage, Attached, Auto Open

Heating:

Forced Air, Multi Zone, Radiant Floor, Stove - Wood, Mini Split

Cooling:

Central AC, Mini Split

Basement:

Full

Parking:

Driveway, Garage, Off Street, Parking Spaces 21+, RV Accessible

Acreage:

48.09

Est. Taxes:

$44,320

Lot Description:

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

Middle School:

Hopkinton Middle School

High School:

Hopkinton Middle High School

School District:

Hopkinton School District

MLS #:

4946584


Community Info

School Info

The Hopkinton Independent School

Enrollment: 91

Distance: 1.32 Miles

The Beech Hill School

Enrollment: 39

Distance: 1.35 Miles

Harold Martin School

Enrollment: 315

Distance: 2.3 Miles

Community Rating:

Parker Academy

Enrollment: 41

Distance: 2.84 Miles

Community Rating:

Mountain Shadows School

Enrollment: 68

Distance: 2.85 Miles

Community Rating:

Waterville Valley Academy

Enrollment: 18

Distance: 2.85 Miles

Community Rating:

Parker Academy

Enrollment: 44

Distance: 2.85 Miles

Newport Montessori School

Enrollment: 80

Distance: 2.85 Miles

Community Rating:

High Mowing School

Enrollment: 177

Distance: 2.85 Miles

Longview School

Enrollment: 19

Distance: 2.85 Miles

Community Rating:

North End Montessori School LLC

Enrollment: 186

Distance: 2.85 Miles

Unity Christian School

Enrollment: 18

Distance: 2.85 Miles

Trinity Christian School

Enrollment: 228

Distance: 2.85 Miles

Community Rating:

Greater Manchester Ymca Child Development Center

Enrollment: 61

Distance: 2.85 Miles

Community Rating:

Enriched Learning Center

Enrollment: 16

Distance: 2.85 Miles

The Montessori Children's School

Enrollment: 41

Distance: 2.85 Miles

Colorful Apples Learning Center

Enrollment: 12

Distance: 2.85 Miles

Robert B Jolicoer School

Enrollment: 88

Distance: 2.85 Miles

Community Rating:

Seacoast Learning Collaborative

Enrollment: 50

Distance: 2.85 Miles

Community Rating:

Dover Day Care Center

Enrollment: 54

Distance: 2.85 Miles

Community Rating:

New Morning School

Enrollment: 58

Distance: 2.85 Miles

Community Rating:

South Merrimack Christian Academy

Enrollment: 153

Distance: 2.85 Miles

Community Rating:

Estabrook Christian School

Enrollment: 4

Distance: 2.85 Miles

Rochester Learning Academy

Enrollment: 15

Distance: 2.85 Miles

St Paul's School

Enrollment: 545

Distance: 2.91 Miles

Community Rating:

The Contoocook School

Enrollment: 10

Distance: 3.39 Miles

Concord High School

Rating: 3/10

Enrollment: 1,594

Distance: 4.01 Miles

Community Rating:

Bishop Brady High School

Enrollment: 304

Distance: 4.04 Miles

Community Rating:

Woodside School

Enrollment: 79

Distance: 4.05 Miles

Community Rating:

Rundlett Middle School

Rating: 3/10

Enrollment: 953

Distance: 4.22 Miles

Community Rating:

Abbot-Downing School

Rating: 3/10

Enrollment: 383

Distance: 4.31 Miles

Community Rating:

Bow High School

Rating: 9/10

Enrollment: 654

Distance: 4.36 Miles

Community Rating:

Christa Mcauliffe School

Rating: 6/10

Enrollment: 406

Distance: 4.51 Miles

Community Rating:

Meeting House Montessori School

Enrollment: 48

Distance: 4.67 Miles

St John Regional School

Enrollment: 230

Distance: 4.81 Miles

Community Rating:

Bow Elementary School

Rating: 9/10

Enrollment: 529

Distance: 4.93 Miles

Community Rating:

Bow Memorial School

Rating: 5/10

Enrollment: 499

Distance: 4.96 Miles

Community Rating:

Maple Street Elementary School

Rating: 8/10

Enrollment: 212

Distance: 4.96 Miles

Community Rating:

Dunbarton Elementary School

Rating: 6/10

Enrollment: 242

Distance: 5.54 Miles

Community Rating:

Beaver Meadow School

Rating: 3/10

Enrollment: 350

Distance: 5.63 Miles

Community Rating:

Hopkinton High School

Rating: 10/10

Enrollment: 308

Distance: 5.76 Miles

Hopkinton Middle School

Rating: 6/10

Enrollment: 167

Distance: 5.76 Miles

Eastman School

Enrollment: 167

Distance: 6.04 Miles

Community Rating:

Penacook Elementary School

Rating: 4/10

Enrollment: 352

Distance: 6.49 Miles

Community Rating:

East Side Learning Center

Enrollment: 86

Distance: 6.51 Miles

Merrimack Valley High School

Rating: 4/10

Enrollment: 819

Distance: 6.63 Miles

Community Rating:

Concord Christian Academy

Enrollment: 255

Distance: 6.68 Miles

Community Rating:

Broken Ground School

Rating: 5/10

Enrollment: 345

Distance: 6.69 Miles

Community Rating:

Shaker Road School

Enrollment: 147

Distance: 6.7 Miles

Community Rating:

Merrimack Valley Middle School

Rating: 6/10

Enrollment: 545

Distance: 6.73 Miles

Community Rating:

Mill Brook School

Enrollment: 395

Distance: 6.75 Miles

Csi Charter School

Rating: 1/10

Enrollment: 38

Distance: 6.79 Miles

Teams Charter School

Enrollment: 21

Distance: 6.8 Miles

Pace Career Academy Charter School

Enrollment: 43

Distance: 7.24 Miles

Community Rating:

Strong Foundations Charter Sch

Rating: 5/10

Enrollment: 269

Distance: 7.26 Miles

Community Rating:

Capital City Public Charter School (H)

Enrollment: 0

Distance: 7.58 Miles

John Stark Regional High School

Rating: 6/10

Enrollment: 643

Distance: 7.66 Miles

Community Rating:

Capital City Public Charter School (E)

Enrollment: 33

Distance: 7.7 Miles

Center Woods School

Rating: 2/10

Enrollment: 636

Distance: 7.75 Miles

Community Rating:

Weare Middle School

Rating: 3/10

Enrollment: 339

Distance: 7.95 Miles

Community Rating:

School Information courtesy of GreatSchools

Walk Score

Yelp