Back to Search
Property profile & analytics
FOR SALE
Retail space
3507 W Main St Erin, TN 37061
Individually Owned
1-yr Hold
~
Est. High Equity
Property ID
US80-1214758
For Sale
1 / 35
$650,000
3507 W Main St, Erin, TN 37061
View Listing →
Property summary
AI-generated overview
This exceptional mixed-use property at 3507 W Main St, Erin, TN, presents a rare opportunity to acquire a thriving, fully operational restaurant and ice cream shop. The 4,000 square foot building sits on a 0.43-acre lot and is offered at $650,000. Recent extensive renovations have resulted in a pristine, modern space ready for immediate operation. Upgrades include a brand-new HVAC system, updated ductwork, a tankless water heater, a new kitchen hood, and all top-of-the-line kitchen equipment, all included in the sale. The current owner's significant investment ensures the property is in excellent condition. The business remains open during the sale, allowing for a seamless transition and immediate revenue generation. This turnkey operation is ideal for experienced restaurateurs or those seeking entry into the industry, offering the chance to build upon an established customer base and successful business model in a desirable location. The sale includes all existing kitchen equipment. Don't miss this chance to own a well-established business with significant upside potential.
Property profile
Verified
Property type
Retail space
Use group
RETAIL STORES (PERSONAL SERVICES)
Year built
1971
Total area
4,400 SF
Lot
0.45 ac (19,684 SF)
Zoning code
8
APN
042019M G 00901
UPID
US80-1214758
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
-
Sophia Ice Cream Shop Grocery & Convenience Store Specialty Food Shop
-
Houston County Community Hospital Rehab Center Hospital
-
The Ranch Bar and Grill And Sophia Ice Cream Shop Restaurant
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
$510k
CAP Approach
CAP
by Request
Comparable Approach
Comparable
$445k
Blend (final)
Blend
$520k
Owner & transaction history
Alfredo Cajero · 1 yrs held
Alfredo Cajero
since 2025
Last sale
$600,000
6 recorded transactions
Zoning & alternative use
8 · Erin, TN
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Source
Erin, TN
Top alternative use upside
Commercial (general)
$740,000
+90.8%
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 Erin submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Erin 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
$440,000
ML approach
$510,000
CAP Approach
CAP Return
Estimation
6%
by Request
6.5%
by Request
7%
by Request
Alternative Use
Use
Estimation
RETAIL STORES
$385,000
Current use
COMMERCIAL (GENERAL)
$740,000
Change: +91% · Conversion: Easy
Blend value · Realmo final
$520k
Range $468k – $572k · ±10% · vs last sale $600k (Mar 13 2025)
Last sale anchor
$600k
Mar 13 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
$118 / 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
Property tax & assessments
Assessed value
$79,640
Assessed 2023
Previous assessed
$64,920
+22.7% YoY
Assessed land
$16,080
Assessed improvement
$63,560
Land market value
$40,200
Improvement market value
$158,900
Total market value
$199,100
Applied tax rate
42.0000
Comparables
6 recent transactions · within 1.5 miComparable in this city
6 recent transactions
Comparable in this City
Similar Nearby for Sale
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
For Sale
Year built
1971
Heating
YES
Cooling
AC.PACKAGE
Stories
1
Units
1
Bathrooms
1
Total area
4,400 SF
Lot
0.45 ac (19,684 SF)
Zoning code
8
APN
042019M G 00901
UPID
US80-1214758
Jurisdiction
HOUSTON
Zoning & alternative use
8 · Erin, TNZoning 8 · permitted uses
8 · Erin, TN
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Source
Erin, TN
Alternative use value scenarios
Repositioning upside vs current use
RETAIL STORES Current
Est. value
$385,000
COMMERCIAL (GENERAL)
Est. value
$740,000
RETAIL STORES Current
COMMERCIAL (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
1971
Heating
YES
Cooling
Yes
Stories
1
Units
1
Bathrooms
1
Lot
0.45 ac
Current owner
From public records · entity-resolved
Alfredo Cajero
Individual
Mailing address
3507 W MAIN ST, ERIN, TN 37061-4148
Mailing matches property
Yes
Owner-occupied
Yes
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
6 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Mar 13, 2025
$600,000
Alfredo Cajero
Sarai Carcamo Rodas
Warranty Deed
$250,000 · Tristar Bank
Feb 26, 2024
—
Sofia Beatriz Rodas
Sofia Beatriz Rodas
Intrafamily Transfer
related
—
Jan 19, 2024
$320,000
Sofia Beatriz Rodas
Ray Bradley
Warranty Deed
$160,000 · Ray Bradley Etal
Jun 1, 2012
$128,427
Ray Bradley
Joseph W Tutt
Warranty Deed
—
Jun 5, 1990
$44,400
Patricia G Nichols
Unknown
Grant Deed
—
Jun 4, 1990
$44,400
Patricia G Nichols
Unknown,
Grant 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?”
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.
