Back to Search
Property profile & analytics
OFF-MARKET
Estimated value
$18,880,000
Showrooms
15551 Greenway Hayden Loop Scottsdale, AZ 85260-1210
Entity Owned
5-yr Hold
~
Est. High Equity
Property ID
US07-0536362
Property profile
Verified
Property type
Showrooms
Use group
SHOW ROOM, WAREHOUSE
Year built
2007
Construction
CONCRETE
Total area
69,190 SF
Lot
8.66 ac (377,055 SF)
Zoning code
I-1
APN
215-44-001L
UPID
US07-0536362
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
-
PHX Interior Design - Scottsdale Interior Design Home Decor Store
-
Style Source Interior Design Home Decor Store
-
Baker Furniture - Showroom Furniture & Home Goods Home Decor Store
-
Imagine Backyard Living (Bike/Boat/Book/etc) Store Kitchen & Bath Showroom
-
Golf Course Homes Real Estate Agency
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
by Request
CAP Approach
CAP
$15.01M
Comparable Approach
Comparable
$19.76M
Blend (final)
Blend
$18.88M
Owner & transaction history
K2h District At The Airpark LLC · 5 yrs held
K2h District At The Airpark LLC
since 2021
Last sale
$21.1M
7 recorded transactions
Zoning & alternative use
I-1 · Scottsdale, AZ
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Zoning description
nd rear yards, and a minimum six-foot high masonry wall or approved landscape screen on the side and rear property lines abutting any Residential District or an alley adjacent to a Residential District. Industrial Park (I-1) • Minimum 30-foot landscape buffer in the side and rear yards, and a minimum six-foot high masonry block wall or approved landscape scr…
Zone name
Industrial Park
General category
INDUSTRIAL
Zone area
1,365.54 ac
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 Scottsdale submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Scottsdale 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
$17,445,000
ML approach
by Request
CAP Approach
CAP Return
Estimation
6%
$16,260,000
6.5%
$15,010,000
7%
$13,935,000
Alternative Use
Use
Estimation
AUTO REPAIR, GARAGE
$28,510,000
Change: -16% · Conversion: Difficult
Blend value · Realmo final
$18.88M
Range $16.99M – $20.77M · ±10% · vs last sale $21.09M (Mar 4 2021)
Last sale anchor
$21.09M
Mar 4 2021
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
$273 / 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 2023Property tax & assessments
Tax year 2023
Tax billed
$266,336
Tax year 2023
Assessed value
$4,336,382
Assessed 2024
Previous assessed
$3,751,730
+15.6% YoY
Effective rate
6.14%
On assessed value
Land market value
$10,717,100
Improvement market value
$15,564,002
Total market value
$26,281,102
Applied tax rate
691,400.0000
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
Showrooms
Use group
SHOW ROOM, WAREHOUSE
Status
Off-Market
Year built
2007
Construction
CONCRETE
Heating
PACKAGE
Cooling
YES
Buildings
3
Stories
1
Units
3
Total area
69,190 SF
Lot
8.66 ac (377,055 SF)
Zoning code
I-1
APN
215-44-001L
UPID
US07-0536362
Jurisdiction
MARICOPA
Zoning & alternative use
I-1 · Scottsdale, AZZoning I-1 · permitted uses
I-1 · Scottsdale, AZ
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Zoning description
nd rear yards, and a minimum six-foot high masonry wall or approved landscape screen on the side and rear property lines abutting any Residential District or an alley adjacent to a Residential District. Industrial Park (I-1) • Minimum 30-foot landscape buffer in the side and rear yards, and a minimum six-foot high masonry block wall or approved landscape screen on the side and rear property lines abutting any Residential District. Light Em
Zone name
Industrial Park
General category
INDUSTRIAL
Zone area
1,365.54 ac
Alternative use value scenarios
Repositioning upside vs current use
AUTO REPAIR, GARAGE
Est. value
$28.5M
AUTO REPAIR, GARAGE
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
2007
Construction
CONCRETE
Heating
PACKAGE
Cooling
Yes
Stories
1
Buildings
3
Units
3
Lot
8.66 ac
Current owner
From public records · entity-resolved
K2h District At The Airpark LLC
Entity
Mailing address
1314 E MYRNA LN, TEMPE, AZ 85284-3342
Ownership since
2021
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
9 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Mar 4, 2021
—
K2h District At The Airpark LLC
K2h Airpark Design LLC
Intrafamily Transfer
related
$25,400,000 · Morgan Stanley Bank NA
Mar 28, 2018
—
K2h Airpark Design LLC
—
Deed
related
$19,000,000 · Bank Of America NA
Sep 5, 2014
$21,091,000
K2h Airpark Design LLC
Loop 76 LLC
Special Warranty Deed
$14,000,000 · Western Alliance Bank
Feb 2, 2006
—
Loop 76 LLC
Crown City Properties LLC
Warranty Deed
$21,500,000 · Wells Fargo Bank NA
May 10, 2004
$7,255,960
Crown City Properties LLC
Scottsdale Place LLC
Grant Deed
$5,400,000 · Home National Bank
Apr 8, 1998
$9,740,000
Scottsdale Place LLC
Palo Verde Associates
Grant Deed
—
Dec 31, 1997
$3,900,000
L L C Fithian
Scottsdale & T B L L C
Grant Deed
—
Jan 10, 1997
$1,492,106
Esa 0942 INC
Scottsdale 22 L L C
Trustees Deed
—
Jan 10, 1997
$1,225,000
Scottsdale 22 L L C
Palo Verde Associates
Trustees Deed
—
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?”
You own 15551 Greenway Hayden Loop?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
List this address →
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.
