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:
Donald Goudreau,
EXP Realty Cell:603-370-0798
Bought with: Cameron Prestige, LLC
$1,100,000
845 Upper Straw Road, Hopkinton, NH 03229
4beds
5,454sqft
Farm
Built in 1982
48.09 Acres Lot
$-- Zestimate®
$202/sqft
$5,510 Estimated rent
Home value
Not available
Estimated sales range
Not available
$5,510/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: March 06, 2024 at 09:50am
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: Farm
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 & neighborhood
Security
- Security features: Security System, Smoke Detector(s), HW/Batt Smoke Detector
Location
- Region: Hopkinton
Other
Other facts
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 3/6/2024 | Sold | $1,100,000-12%$202/sqft |
Source:  PrimeMLS #4946584 | ||
| 1/10/2024 | Contingent | $1,250,000$229/sqft |
Source: PrimeMLS #4946584 | ||
| 12/28/2023 | Price change | $1,250,000-10.7%$229/sqft |
Source: PrimeMLS #4946584 | ||
| 12/6/2023 | Price change | $1,400,000-6.7%$257/sqft |
Source: PrimeMLS #4946584 | ||
| 10/24/2023 | Price change | $1,500,000-16.4%$275/sqft |
Source: PrimeMLS #4946584 | ||
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% |
Find assessor info on the county website
Neighborhood: 03229
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.