Back to Search
Property profile & analytics
OFF-MARKET
Estimated value
$880,000
Retail space
297 Main St Crestview, FL 32536-3543
Trust Owned
Free & Clear
Property ID
US18-5375919
Property summary
AI-generated overview
This exceptional 8,881-square-foot retail warehouse space is available for lease in Crestview, Florida. Located at 297 Main St, at the corner of N Main St & W Oakdale Ave, this single-tenant property offers unparalleled visibility and exposure. Built in 1947 and renovated in 1967, the building sits on a 0.29-acre lot and benefits from a mixed-use zoning designation. The property features one story and boasts excellent access to power. No elevators are present. This prime location enjoys high traffic counts exceeding 38,500 vehicles daily, placing it adjacent to S Ferdon Blvd and surrounded by established businesses including Wells Fargo, First National Land Title, Ronnys Car Wash, Fatboys, and CVS. The property's strategic placement ensures significant foot and vehicle traffic, creating a lucrative retail environment. The property's APN is 17-3N-23-2490-0004-009A and the zip code is 32536. This is an ideal opportunity for businesses seeking a high-visibility location in a thriving commercial area. The entire 8,881 square feet is currently vacant.
Property profile
Verified
Property type
Retail space
Use group
RETAIL STORES (PERSONAL SERVICES)
Year built
1947
Construction
MASONRY/CONCRETE MASONRY UNITS (CMUS)
Total area
8,881 SF
Lot
0.11 ac (4,675 SF)
APN
17-3N-23-2490-0004-009A
UPID
US18-5375919
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
-
Crestview Plumbing & Hardware Building Supply Hardware & Home Improvement
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
by Request
CAP Approach
CAP
by Request
Comparable Approach
Comparable
$613k
Blend (final)
Blend
$880k
Owner & transaction history
Shauney Irrevocable Trust
Shauney Irrevocable Trust
since 2025
Last sale
$990,000
2 recorded transactions
Zoning & alternative use
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Top alternative use upside
Neighborhood: shopping center
$1.4M
+23.9%
Auto repair, garage
$1.4M
+22.1%
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 Crestview submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Crestview 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
by Request
CAP Approach
CAP Return
Estimation
6%
by Request
6.5%
by Request
7%
by Request
Alternative Use
Use
Estimation
RETAIL STORES
$1,120,000
Current use
NEIGHBORHOOD: SHOPPING CENTER
$1,390,000
Change: +24% · Conversion: Moderate
AUTO REPAIR, GARAGE
$1,370,000
Change: +22% · Conversion: Difficult
WAREHOUSE, STORAGE
$1,010,000
Change: -10% · Conversion: Difficult
INDUSTRIAL (GENERAL)
$915,000
Change: -18% · Conversion: Difficult
Blend value · Realmo final
$880k
Range $792k – $968k · ±10% · vs last sale $990k (May 20 2025)
Last sale anchor
$990k
May 20 2025
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
$99 / 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
$3,818
Tax year 2023
Assessed value
$258,257
Assessed 2023
Previous assessed
$204,224
+26.5% YoY
Effective rate
1.48%
On assessed value
Assessed land
$100,099
Assessed improvement
$158,158
Land market value
$100,099
Improvement market value
$158,158
Total market value
$258,257
Applied tax rate
3.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
Retail space
Use group
RETAIL STORES (PERSONAL SERVICES)
Status
Off-Market
Year built
1947
Construction
MASONRY/CONCRETE MASONRY UNITS (CMUS)
Heating
FORCED AIR
Cooling
CENTRAL
Stories
1
Rooms
4
Total area
8,881 SF
Lot
0.11 ac (4,675 SF)
APN
17-3N-23-2490-0004-009A
UPID
US18-5375919
Jurisdiction
OKALOOSA
Zoning & alternative use
Zoning · permitted uses
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Alternative use value scenarios
Repositioning upside vs current use
RETAIL STORES Current
Est. value
$1.1M
NEIGHBORHOOD: SHOPPING CENTER
Est. value
$1.4M
AUTO REPAIR, GARAGE
Est. value
$1.4M
WAREHOUSE, STORAGE
Est. value
$1.0M
INDUSTRIAL (GENERAL)
Est. value
$915,000
RETAIL STORES Current
NEIGHBORHOOD: SHOPPING CENTER
AUTO REPAIR, GARAGE
WAREHOUSE, STORAGE
INDUSTRIAL (GENERAL)
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
1947
Construction
MASONRY/CONCRETE MASONRY UNITS (CMUS)
Heating
FORCED AIR
Cooling
Yes
Stories
1
Rooms
4
Lot
0.11 ac
Current owner
From public records · entity-resolved
Shauney Irrevocable Trust
Trust
Free & Clear · 0 yrs held
Mailing address
1249 GEORGIA AVE, BAKER, FL 32531-2505
Ownership since
2025
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
2 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Aug 20, 2025
$990,000
Shauney Irrevocable Trust
Brenda L Ellis
Warranty Deed
—
Mar 9, 2001
$160,000
Gary L Ellis
Steele,peter J
Grant Deed
$270,000 · First National Bank Crestview
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 297 Main 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.
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.
