Back to Search
Property profile & analytics
FOR SALE
Investment properties
151 Smead Hill Rd Greenfield Greenfield, MA 01301
Entity Owned
8-yr Hold
~
Est. High Equity
Property ID
US38-0203178
For Sale
1 / 12
$699,000
151 Smead Hill Rd,Unit Greenfield, Greenfield, MA 01301
View Listing →
Property profile
Verified
Property type
Investment properties
Use group
OFFICE/RESIDENTIAL (MIXED USE)
Year built
1994
Construction
FRAME
Total area
4,811 SF
Lot
5.44 ac (236,836 SF)
Zoning code
RC
APN
GREE M:0R33 B:0019 L:0
UPID
US38-0203178
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors
Implied cap rate, NOI & suggested price
Cap vs submarket · NOI estimate · 3 price anchors
Current use
Occupant on record · Public records
-
The Mountain Rose Inn Hotel & Motel Resort
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
$355k
CAP Approach
CAP
by Request
Comparable Approach
Comparable
$441k
Blend (final)
Blend
$515k
Owner & transaction history
Moonlight Rose INC · 8 yrs held
Moonlight Rose INC
since 2018
7 recorded transactions
Zoning & alternative use
RC · Greenfield, MA
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Zoning description
The purpose of the Rural Residential District is to provide areas for low density residential development and for agricultural uses.
Zone name
Rural Residential
General category
RESIDENTIAL
Zone area
7,854.49 ac
Source
Realmo
Top alternative use upside
Office building
$655,000
+98.8%
Auto repair, garage
$545,000
+65.8%
Retail stores
$500,000
+52.0%
Cap rate
Implied · in-place · derived from last sale + estimated NOI
Implied Cap rate
#1
Implied · in-place · NOI ÷ last sale
In-place · derived from last sale + estimated NOI
Cap rate, NOI & submarket benchmark
Implied cap rate vs Greenfield submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Greenfield submarket · NOI estimate · typical band, median & reading
Refine your cap rate
8-question underwriting flow
1.
Property current status — Going-In vs Stabilized
2.
Price for denominator — asking / offer / market
3.
Leasing status & lease structure (NNN / Gross)
4.
Tenant risk profile & vacancy assumption
5.
Upload T12 / rent roll / OM (optional)
Refine in 60 seconds, get exact suggested price
T12 upload · Submarket benchmarks · Sensitivity grid
Suggested price · 3 cap rate anchors
Income approach @ 5% / 7% / 9% — aggressive / typical / conservative
Suggested price at 5% / 7% / 9% cap
Aggressive / typical / conservative · Implied $/SF per anchor · Sensitivity grid
Suggested price at 5% / 7% / 9% cap
Aggressive / typical / conservative · implied $/SF · sensitivity
Value
AI, CAP & Alternative Use estimations · Realmo proprietary blendValue Estimations
Based on Realmo’s proprietary methodology
AI Approach
Method
Estimation
Statistic approach
by Request
ML approach
$355,000
CAP Approach
CAP Return
Estimation
6%
by Request
6.5%
by Request
7%
by Request
Alternative Use
Use
Estimation
COMMERCIAL (GENERAL)
$330,000
Current use
OFFICE BUILDING
$655,000
Change: +99% · Conversion: Easy
AUTO REPAIR, GARAGE
$545,000
Change: +66% · Conversion: Difficult
RETAIL STORES
$500,000
Change: +52% · Conversion: Easy
Blend value · Realmo final
$515k
Range $464k – $567k · ±10%
Realmo estimate · informational only.
These numbers are calculated by our models from public records and may not reflect actual market value.
Not an appraisal.
Verify with a licensed appraiser before transacting. Realmo accepts no liability for divergence from real-world outcomes.
View the full estimation — every method, every assumption
Confidence drivers & risk notes · Custom comparable set · Free for first 3 / day
Full estimation methodology
Every method · every assumption · confidence drivers
Price per SF
Sale + rent benchmarks
Subject property
$107 / SF
Submarket sale & rent benchmarks
Median sale $/SF · Asking & closed rent · Submarket vacancy
Submarket sale & rent benchmarks
Median sale $/SF · asking & closed rent · submarket vacancy
Property tax & assessments
Tax year 2024Property tax & assessments
Tax year 2024
Tax billed
$17,939
Tax year 2024
Assessed value
$879,800
Assessed 2024
Previous assessed
$895,500
-1.8% YoY
Effective rate
2.04%
On assessed value
Assessed land
$79,200
Assessed improvement
$800,600
Comparables
6 recent transactions · within 1.5 miComparable in this city
6 recent transactions
Comparable in this City
Similar Nearby for Sale
Similar Nearby for Lease
Recent comparable sales
Sale price & price/SF · Sale date & distance · Adjustments & confidence
Recent comparable sales
Sale price & $/SF · sale date & distance · adjustments
Property description
Physical attributes from public recordsBuilding & lot
Public records
Property type
Investment properties
Use group
OFFICE/RESIDENTIAL (MIXED USE)
Status
For Sale
Year built
1994
Construction
FRAME
Heating
HOT WATER
Cooling
YES
Buildings
1
Stories
2
Units
1
Rooms
14
Bathrooms
10
Total area
4,811 SF
Lot
5.44 ac (236,836 SF)
Zoning code
RC
APN
GREE M:0R33 B:0019 L:0
UPID
US38-0203178
Jurisdiction
GREENFIELD
Zoning & alternative use
RC · Greenfield, MAZoning RC · permitted uses
RC · Greenfield, MA
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Zoning description
The purpose of the Rural Residential District is to provide areas for low density residential development and for agricultural uses.
Zone name
Rural Residential
General category
RESIDENTIAL
Zone area
7,854.49 ac
Source
Realmo
Alternative use value scenarios
Repositioning upside vs current use
COMMERCIAL (GENERAL) Current
Est. value
$330,000
OFFICE BUILDING
Est. value
$655,000
AUTO REPAIR, GARAGE
Est. value
$545,000
RETAIL STORES
Est. value
$500,000
COMMERCIAL (GENERAL) Current
OFFICE BUILDING
AUTO REPAIR, GARAGE
RETAIL STORES
Alternative use deep dive — conversion cost, permits, timeline
Conversion cost estimate · Permit path & risks · Stabilized NOI per option
Alternative use deep dive
Conversion cost · permit path · stabilized NOI per option
Building & site characteristics
From public records
Year built
1994
Construction
FRAME
Heating
HOT WATER
Cooling
Yes
Stories
2
Buildings
1
Units
1
Rooms
14
Bathrooms
10
Lot
5.44 ac
Current owner
From public records · entity-resolved
Moonlight Rose INC
Entity
Mailing address
151 SMEAD HL RD, GREENFIELD, MA 01301-9706
Mailing matches property
Yes
Owner-occupied
Yes
Ownership since
2018
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
13 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
May 30, 2018
$750,000
Moonlight Rose INC
Waskewicz,michael A & Sandra
Quit Claim Deed
—
Oct 5, 2012
—
Sandra L Waskewicz
—
Deed Of Trust
related
$400,000 · Greenfield Capital Bank
Aug 12, 2010
$1
Michael A Waskewicz
Richardson,sandra
Grant Deed
—
Aug 19, 2004
—
Richardson,sandra L
—
Grant Deed
related
$35,000 · Greenfield Capital Bank
Mar 11, 2003
—
Sandra L Richardson
—
Deed Of Trust
related
$625,000 · Greenfield Capital Bank
Oct 15, 2002
—
Sandra L Richardson
—
Deed Of Trust
related
$50,000 · Greenfield Capital Bank
Oct 12, 2001
—
Sandra L Richardson
—
Deed Of Trust
related
$527,700 · Greenfield Capital Bank
Dec 9, 1999
—
Timothy E Richardson
—
Deed Of Trust
related
$30,000 · Greenfield Savings Bank
Feb 19, 1998
—
Timothy E Richardson
—
Deed Of Trust
related
$40,000 · United Bank
Aug 31, 1995
—
Timothy E Richardson
—
Deed Of Trust
related
$180,000 · United Bank
Mar 6, 1995
—
Timothy E Richardson
—
Deed Of Trust
related
$20,000 · United Bank
Sep 30, 1994
—
Timothy E Richardson
—
Deed Of Trust
related
$125,000 · United Bank
Jun 24, 1994
$2,800
Timothy E Richardson
Almstead,raymond W JR
Grant Deed
related
—
Coming soon
Costs & Benchmarks
Operating expenses, capex projections, utility benchmarks, and submarket comparables — all in one view.
Coming soon
Risks
Flood, climate, environmental, title, and tenant-concentration risk — surfaced with mitigations and source citations.
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?”
Full reports are paid
Unlock the full Property Analytics report
Start free for 7 days — no card required. Full owner contacts, all 4 valuations with methodology, refine flow, comparable adjustments, foot-traffic deep dive, export to PDF / CSV.
