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.
Closed
Listed by: EXP Realty • Donald Goudreau
Bought with: Cameron Prestige, LLC
$1,100,000
845 Upper Straw Road, Hopkinton, NH 03229
4beds
5,454sqft
Single Family Residence
Built in 1982
48.09 Acres Lot
$-- Zestimate®
$202/sqft
$5,289 Estimated rent
Home value
Not available
Estimated sales range
Not available
$5,289/mo
Zestimate® history
Owner options
List your home for rent
$5,289/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,289/mo
Rent Zestimate®
Refinance and save
$6,181/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$6,181/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Green acresOpen farmlandHeated floorsWood stoveGorgeous farmOld world farmsCentral air
Zillow last checked:
Listing updated:
Listed by:
Donald Goudreau,
EXP Realty Cell:603-370-0798
Bought with:
Tami J Mallett
Cameron Prestige, LLC
Source: PrimeMLS,MLS#: 4946584
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Heating
- Propane, Oil, Wood, Forced Air, Zoned, Radiant Floor, Wood Stove, Mini Split
Cooling
- Central Air, Mini Split
Appliances
- Included: Gas Cooktop, ENERGY STAR Qualified Dishwasher, Microwave, Electric Range, ENERGY STAR Qualified Refrigerator, Propane Water Heater, Tank Water Heater, Stand Alone Ice Maker
- Laundry: 1st Floor Laundry
Features
- Central Vacuum, Cathedral Ceiling(s), Dining Area, Primary BR w/ BA, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
- Flooring: Ceramic Tile, Softwood
- Doors: ENERGY STAR Qualified Doors
- Windows: Blinds
- Basement: Full,Interior Entry
- Number of fireplaces: 2
- Fireplace features: Wood Burning, 2 Fireplaces, Wood Stove Hook-up
Interior area
- Total structure area: 7,086
- Total interior livable area: 5,454 sqft
- Finished area above ground: 5,166
- Finished area below ground: 288
Property
Parking
- Total spaces: 21
- Parking features: Crushed Stone, Gravel, Auto Open, Driveway, Garage, Off Street, Parking Spaces 21+, RV Access/Parking, Attached
- Garage spaces: 5
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: 1st Floor 1/2 Bathroom, 1st Floor Full Bathroom, 1st Floor Hrd Surfce Flr, Access to Common Areas, Access to Parking, Access to Restroom(s), Bathroom w/Tub, Grip-Accessible Features, 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
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Covered Porch, Enclosed Porch, Heated Porch
- Exterior features: Building, Deck, Garden, Shed
- Has view: Yes
- Frontage length: Road frontage: 552
Lot
- Size: 48.09 Acres
- Features: Agricultural, Country Setting, Farm, Dairy Farm, Horse/Animal Farm, Field/Pasture, Hilly, Landscaped, Major Road Frontage, Open Lot, Rolling Slope, Secluded, Timber, Trail/Near Trail, Views, Wooded, Near Shopping, Near Skiing, Near Snowmobile Trails, Near Hospital
Details
- Additional structures: Gazebo, Outbuilding
- Parcel number: HOPNM00265B000016L000000
- Zoning description: R-4
- Other equipment: Satellite, Satellite Dish
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Clapboard Exterior, Concrete Exterior
- Foundation: Concrete
- Roof: Metal,Standing Seam
Condition
- New construction: No
- Year built: 1982
Utilities & green energy
- Electric: 200+ Amp Service, Circuit Breakers, Generator Ready
- Sewer: 1500+ Gallon, Septic Tank
- Utilities for property: Phone, Satellite, Satellite Internet
Community & HOA
Community
- Security: Security System, Smoke Detector(s), HW/Batt Smoke Detector
Location
- Region: Hopkinton
Financial & listing details
- Price per square foot: $202/sqft
- Tax assessed value: $1,370,427
- Annual tax amount: $44,320
- Date on market: 3/25/2023
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 3/6/2024 | Sold | $1,100,000-12%$202/sqft |
Source:  PrimeMLS #4946584 Report a problem | ||
| 1/10/2024 | Contingent | $1,250,000$229/sqft |
Source: PrimeMLS #4946584 Report a problem | ||
| 12/28/2023 | Price change | $1,250,000-10.7%$229/sqft |
Source: PrimeMLS #4946584 Report a problem | ||
| 12/6/2023 | Price change | $1,400,000-6.7%$257/sqft |
Source: PrimeMLS #4946584 Report a problem | ||
| 10/24/2023 | Price change | $1,500,000-16.4%$275/sqft |
Source: PrimeMLS #4946584 Report a problem | ||
| 5/18/2023 | Price change | $1,795,000-10.2%$329/sqft |
Source: PrimeMLS #4946584 Report a problem | ||
| 3/25/2023 | Listed for sale | $1,999,000-2.5%$367/sqft |
Source: PrimeMLS #4946584 Report a problem | ||
| 1/1/2023 | Listing removed | -- |
Source: PrimeMLS #4905444 Report a problem | ||
| 11/2/2022 | Price change | $2,050,000-12.4%$376/sqft |
Source: PrimeMLS #4905444 Report a problem | ||
| 10/31/2022 | Listed for sale | $2,339,000$429/sqft |
Source: PrimeMLS #4905444 Report a problem | ||
| 9/20/2022 | Contingent | $2,339,000$429/sqft |
Source: PrimeMLS #4905444 Report a problem | ||
| 9/1/2022 | Listed for sale | $2,339,000$429/sqft |
Source: PrimeMLS #4905444 Report a problem | ||
| 7/18/2022 | Contingent | $2,339,000$429/sqft |
Source: PrimeMLS #4905444 Report a problem | ||
| 6/14/2022 | Price change | $2,339,000-8.3%$429/sqft |
Source: PrimeMLS #4905444 Report a problem | ||
| 4/17/2022 | Listed for sale | $2,550,000-8.9%$468/sqft |
Source: PrimeMLS #4905444 Report a problem | ||
| 11/20/2021 | Listing removed | -- |
Source: PrimeMLS #4857603 Report a problem | ||
| 6/2/2021 | Listed for sale | $2,799,900$513/sqft |
Source: PrimeMLS #4857603 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $29,999 -22.5% | $1,370,427 +23.9% |
| 2023 | $38,726 +8.4% | $1,105,818 -0.2% |
| 2022 | $35,722 +10% | $1,107,659 -0.3% |
| 2020 | $32,485 +0.4% | $1,110,605 |
| 2019 | $32,341 +44.5% | $1,110,605 +72.3% |
| 2018 | $22,388 +2% | $644,442 +0.6% |
| 2017 | $21,957 +2.2% | $640,343 |
| 2016 | $21,484 -0.2% | $640,343 0% |
| 2015 | $21,529 +3.2% | $640,349 -0.1% |
| 2014 | $20,861 +5.1% | $640,693 -7.2% |
| 2013 | $19,843 +2.1% | $690,440 +0.2% |
| 2012 | $19,426 +10.5% | $689,098 +5.2% |
| 2009 | $17,578 | $655,157 |
Find assessor info on the county website
Neighborhood: 03229
Nearby homes
- $362,900-- bd-- ba-- sqft775 Upper Straw Rd, Hopkinton, NH 03229Off Market
- $499,3006 bd3 ba3.4k sqft902 Upper Straw Rd, Hopkinton, NH 03229Off Market
- $544,6003 bd1 ba3.1k sqft811 Upper Straw Rd, Hopkinton, NH 03229Off Market
- $287,7003 bd1 ba1.1k sqft929 Upper Straw Rd, Hopkinton, NH 03229Off Market
- $644,6003 bd2 ba2.4k sqft930 Upper Straw Rd, Hopkinton, NH 03229Off Market
- $471,800-- bd-- ba-- sqftUppr Straw Rd, Hopkinton, NH 03229Off Market
- $6,900-- bd-- ba-- sqftUppr Straw Rd, Hopkinton, NH 03229Off Market
- $560,000-- bd-- ba-- sqftUppr Straw Rd, Hopkinton, NH 03229Off Market
Nearby schools
GreatSchools rating
- 5/10Harold Martin SchoolGrades: PK-3Distance: 2.3 mi
- 6/10Hopkinton Middle SchoolGrades: 7-8Distance: 5.8 mi
- 10/10Hopkinton High SchoolGrades: 9-12Distance: 5.8 mi
Schools provided by the listing agent
- Middle: Hopkinton Middle School
- High: Hopkinton Middle High School
- District: Hopkinton School District
Source: PrimeMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
- New Hampshire
- Merrimack County
- Hopkinton
- 03229
- 845 Upper Straw Road
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Hopkinton Topics
