NOT LISTED FOR SALE

845 Upper Straw Rd Hopkinton, NH 03229

4 Beds
4.5 Baths
5,166 Sq Ft
48.09 Acres

Last Sold March 06, 2024

Last sale price $1,100,000 $213 Per Sq Ft

291 Days on Market

Highlights

  • 48.09 Acre Lot
  • Deck
  • Contemporary Architecture
  • Hopkinton Middle School Rated A-
  • Wood Burning Stove
  • Hilly Lot

About This Home

As of March 2024

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.

Last Agent to Sell the Property

Don Goudreau

EXP Realty Brokerage Phone: 603-370-0798 License #056852 Listed on: 03/24/2023

EXP Realty

Last Buyer's Agent

Tami Mallett

Cameron Prestige, LLC License #066830

Cameron Prestige, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $44,320

Year Built

  • Built in 1982

Lot Details

  • 48.09 Acre Lot
  • Secluded Lot
  • Open Lot
  • Lot Sloped Up
  • Hilly Lot
  • Wooded Lot
  • Garden
  • Property is zoned R-4

Parking

  • 5 Car Garage
  • Stone Driveway
  • Gravel Driveway
  • Off-Street Parking

Home Design

  • Contemporary Architecture
  • Farmhouse Style Home
  • Concrete Foundation
  • Metal Roof
  • Clapboard

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Cathedral Ceiling
  • Multiple Fireplaces
  • Wood Burning Stove
  • Wood Burning Fireplace
  • Blinds
  • ENERGY STAR Qualified Doors
  • Dining Area
  • Heated Enclosed Porch
  • Laundry on main level
  • Property Views

Kitchen

  • Gas Cooktop
  • Microwave
  • Ice Maker
  • ENERGY STAR Qualified Dishwasher

Flooring

  • Softwood
  • Radiant Floor
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Bathroom on Main Level
  • Bathtub

Basement

  • Basement Fills Entire Space Under The House
  • Interior Basement Entry

Home Security

  • Home Security System
  • Fire and Smoke Detector

Accessible Home Design

  • Visitor Bathroom
  • Grab Bar In Bathroom
  • Accessible Common Area
  • Kitchen has a 60 inch turning radius
  • Handicap Modified
  • Doors with lever handles
  • Hard or Low Nap Flooring
  • Accessible Parking
  • Ramped or Level from Garage

Eco-Friendly Details

  • Whole House Exhaust Ventilation

Outdoor Features

  • Deck
  • Patio
  • Gazebo
  • Shed
  • Outbuilding

Schools

  • Hopkinton Middle School
  • Hopkinton Middle High School

Farming

  • Farm
  • Timber
  • Agricultural
  • Pasture
  • Horse Farm

Utilities

  • Mini Split Air Conditioners
  • Forced Air Zoned Heating System
  • Mini Split Heat Pump
  • Heating System Uses Gas
  • Heating System Uses Oil
  • Heating System Uses Wood
  • Generator Hookup
  • 200+ Amp Service
  • Drilled Well
  • Dug Well
  • Septic Tank
  • Leach Field
  • High Speed Internet
  • Internet Available
  • Phone Available
  • Satellite Dish

Community Details

  • Trails

Listing and Financial Details

  • Tax Block 16

Home Details

Home Type

Single Family

Est. Annual Taxes

$44,320

Year Built

Built in 1982

Lot Details

0

Parking

5

Listing Details

  • Status Detail: Closed
  • Directions: Hopkinton Rd to Upper Straw, property is on the L side, the driveway is marked by a piece of red antique farming equipment.
  • Flood Zone: Unknown
  • Footprint: 36X85
  • Suitable Use: Agriculture, Farm, Farm - Dairy, Farm - Horse/Animal, Field/Pasture, Residential, Tillable, Timber
  • Construction: Existing
  • Total Stories: 2
  • Price Per Sq Ft: 212.93
  • Property Class: Residential
  • Property Type: Single Family
  • Year Built: 1982
  • List Agent: 6453
  • Display On Internet: High Speed Intrnt -AtSite, Satellite Internet
  • Architectural Style: Contemporary, Farmhouse
  • ResoLotFeatures: 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
  • Reso Structure Type: Stick Built Off-Site
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

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
  • Equipment: Satellite, Satellite Dish, Security System, Smoke Detector, Smoke Detectr-HrdWrdw/Bat, Whole BldgVentilation, Stove-Wood
  • 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 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
  • Total Bedrooms: 4
  • Flooring: Ceramic Tile, Softwood
  • Total Bathrooms: 5
  • Half Bathrooms: 1
  • Full Bathrooms: 4
  • Basement: Yes
  • Basement Access Type: Interior
  • Basement Description: Full
  • 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
  • Level 2: Level 2: Bedroom, Level 2: Primary Bdm Ste
  • Basement Level Rooms: Level B: Laundry Room
  • Room 1: Mudroom, On Level: 1
  • Room 2: Other, On Level: 1
  • Room 3: Kitchen - Eat-in, On Level: 1
  • Room 4: Dining Room, On Level: 1
  • Room 5: 1
  • Room 6: Bath - Full, On Level: 1
  • Room 7: Great Room, On Level: 1
  • Room 8: Bath - 1/2, On Level: 1
  • Room 9: Family Room, On Level: 1
  • Room 10: 1
  • Room 11: Sunroom, On Level: 1
  • Room 12: Primary BR Suite, On Level: 2
  • Room 13: Bedroom, On Level: 2
  • Room 14: Bedroom, On Level: 2
  • Room 15: Bath - Full, On Level: 1
  • Room 16: Bath - Full, On Level: 1
  • Room 17: Laundry Room, On Level: Basement
  • Sq Ft - Apx Finished AG: 5166
  • Sq Ft - Apx Finished BG: 288
  • Sq Ft - Apx Total: 7086
  • Sq Ft - Apx Total Finished: 5454
  • Sq Ft - Apx Unfinished BG: 1632

Exterior Features

  • Driveway: Crushed Stone, Gravel
  • Foundation: Concrete
  • Road Frontage: Yes
  • Roads: Paved, Public
  • Roof: Metal, Standing Seam
  • Easements: Yes
  • Features Exterior: Building, Deck, Doors - Energy Star, Garden Space, Gazebo, Outbuilding, Patio, Porch - Covered, Porch - Enclosed, Shed, Handicap Modified, Porch - Heated
  • Construction Type: Clapboard Exterior, Concrete Exterior

Garage/Parking

  • Garage Capacity: 5
  • Parking: Auto Open, Driveway, Garage, Off Street, Parking Spaces 21+, RV Access/Parking, Attached
  • Garage: Yes

Utilities

  • Cable Company: Dir TV/Hughes
  • Electric: 200 Amp, Circuit Breaker(s), Generator Ready
  • Fuel Company: Irving
  • Sewer: 1500+ Gallon, Leach Field - Existing, Septic
  • Heating Fuel: Gas - LP/Bottle, Oil, Wood
  • Heating: Forced Air, Multi Zone, Radiant Floor, Stove - Wood, Mini Split
  • Cooling: Central AC, Mini Split
  • Electric Company: Eversource
  • Phone Company: Avail
  • Utilities: Phone, Satellite
  • Water Source: Drilled Well, Dug Well

Schools

  • High School: Hopkinton Middle High School

Lot Info

  • Map: 265
  • Lot Sq Ft: 2094800
  • Current Use: Yes
  • Lot Acres: 48.09
  • Surveyed: Yes
  • Surveyed By: Lamarine Technical
  • Zoning: R-4
  • Deed Book: 3258
  • Deed Page: 0043
  • Deed Recorded Type: Warranty

Tax Info

  • Tax Gross Amount: 44320
  • Tax Year: 2022

MLS Schools

  • School District: Hopkinton School District
  • School Middle Jr: Hopkinton Middle School

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/06/2024 03/06/24 Sold $1,100,000 -12.0% $213 / Sq Ft
01/09/2024 01/09/24 Pending -- -- --
12/28/2023 12/28/23 Price Changed $1,250,000 -10.7% $242 / Sq Ft
12/06/2023 12/06/23 Price Changed $1,400,000 -6.7% $271 / Sq Ft
10/24/2023 10/24/23 Price Changed $1,500,000 -16.4% $290 / Sq Ft
05/18/2023 05/18/23 Price Changed $1,795,000 -10.2% $347 / Sq Ft
03/24/2023 03/24/23 For Sale $1,999,000 -- $387 / Sq Ft
Source: PrimeMLS

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: PrimeMLS

MLS Number: 4946584

PrimeMLS