Financial
Distress signals
Property profile

87 School St Hatfield, MA 01038

OFF-MARKET
Other investment properties
Property ID
US38-0244768
6,276 SF 0.97 ac lot Built 1880
Last sale Jan 2021 · $987,000
Entity Owned Owner of record is a legal entity (LLC / corporation). 5-yr Hold Held for 5 years. ~ Est. High Equity Modeled equity is high. Estimate, not a fact.
Saved · see the list in your Dashboard
Market Trends Soon

Property summary

AI-generated overview

The property is a three-floor historic building totaling approximately 9,000 square feet of combined living and event space, with views overlooking a waterfall along the Mill River. Its existing layout includes bed-and-breakfast accommodations, four income-producing apartments, a professional kitchen, a separate warming kitchen, expansive outdoor areas, and parking for 35 vehicles. The building is served by a sprinkler system on all floors and has updated building systems, including

Ownership intelligence

Who controls the opportunity?

Owner of record from public deeds, plus portfolio, hold profile and investor signals where the data supports them. In the full report.

Owner contacts

Can we reach the decision maker?

Skip-traced phones and e-mails of the owner. Included with the full report.

Mortgages

What is owed, to whom, and when it comes due

Recorded lenders, amounts and estimated maturities of the owner's loan book — in the full report.

Property tax · 2024

What does the county charge?
$13k
Tax billed · 2024
Assessed value$871k
Assessed land$133k
Assessed improvement$738k
Effective rate1.53%

Value estimate

· Sep 2026
$1.18M
$1.06M – $1.29M
AI approach$1.07M
CAP approach$925k
Submarket $/SF estimate$1.38M

Realmo valuation models over county records and 16 qualifying comparable sales.

Recently sold

What actually traded nearby?
$144/SF
County average, outlier-cleaned · 142 recorded sales of this use type
Observed band · Q1–Q3$91 – $240
Qualifying comparables16

Cap rate analysis

How does the asset earn?

No income signal is modeled for this parcel yet — the Cap Rates tab runs the workflow.

Zoning insight

What can be built here?
TC
JurisdictionHATFIELD

Location intelligence

Which uses thrive at this corner?
Best fit: Realty agency
Demand heat for this use is drawn on the map · LocInt grid
Demand index
Realty agency10.6
Wholesale Shop10.5
Restaurant10.0

Location

87 School St Hatfield, MA 01038-9732
County assessor Recorded deeds · 8 transfers 16 qualifying comp sales Zoning catalog

Every figure names its source: public record, benchmark, or modeled. Coverage varies by property — thin data is stated as missing, never invented.

Comparables

6 recorded sales · 6 properties nearby
Recent sales nearby
6 recorded sales in this ZIP, last 8 years
Address Sale price Sold Size
57 Elm, Hatfield, MA 01038-9717 $405,500 Nov 2025 5,250 SF
19 King, Hatfield, MA 01038-9774 $639,000 Sep 2024 3,527 SF
131 Main, Hatfield, MA 01038-9786 $1,275,000 Jan 2022 9,817 SF
103 Elm, Hatfield, MA 01038-9715 $25,000 Aug 2021 5,145 SF
23 Chestnut, Hatfield, MA 01038-9767 $250,000 Dec 2020 4,569 SF
125 Elm, Hatfield, MA 01038-9798 $430,000 Jan 2019 5,911 SF
Sale prices and dates as our records hold them, one row per building. A deed can cover more of a building than the size shown, so read the price against the size rather than dividing one by the other.
Comparable nearby
6 properties of the same type nearby
Try Rey
Ask anything about this address in plain English.
“Is 15.6% cap rate sustainable?” · “Best tenant mix for BU1?” · “What’s the redev upside?”
You own 87 School St?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message