Financial
Distress signals
Property profile

147 E Main St Columbus, OH 43215

FOR LEASE
Investment properties
Property ID
US66-6030782
14,604 SF 0.13 ac lot Built 1887
Last sale Oct 2003 · $900,000
Entity Owned Owner of record is a legal entity (LLC / corporation). 22-yr Hold Held for 22 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

This exceptional 1,620-square-foot retail space, located at 147 E Main Street in Columbus, Ohio (zip code 43215), presents a unique opportunity. Situated in the vibrant Red Brick District, this single-tenant property boasts a highly desirable location adjacent to The Walrus and Hawk Galleries. The building features attractive high ceilings, exposed brick walls, and hardwood floors, creating a character-rich ambiance ideal for a variety of businesses. The property is conveniently located near

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 · 2023

What does the county charge?
$26k
Tax billed · 2023
Assessed value$353k
Assessed land$79k
Assessed improvement$274k
Effective rate7.30%

Value estimate

· Sep 2026
$410k
$369k – $451k
Submarket $/SF estimate$1.41M
NOI build-up
Gross scheduled income$64k
Vacancy & credit loss−$14k
Operating expenses−$13k
NOI · 170,990.91% cap applied$38k

Realmo valuation models over county records.

Recently sold

What actually traded nearby?
$118/SF
ZIP average, outlier-cleaned · 21 recorded sales of this use type
Observed band · Q1–Q3$62 – $158

Cap rate analysis

How does the asset earn?
170,990.91%
$38k estimated NOI · market benchmarks for this use type

Price anchors at 6 / 6.5 / 7% — in the full report.

Zoning insight

No data for this section
What can be built here?

No zoning code is on file for this parcel. Coverage grows with every catalog release.

JurisdictionFRANKLIN

Location intelligence

Which uses thrive at this corner?
Best fit: Electrical Service
Demand heat for this use is drawn on the map · LocInt grid
Demand index
Electrical Service11.8
Laundry Service10.1
Grocery Store9.9

Location

147 E Main St Columbus, OH 43215
County assessor Recorded deeds · 6 transfers Qualifying comp sales · not on file Zoning catalog · not on file

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 · 15 properties nearby
Recent sales nearby
6 recorded sales in this ZIP, last 8 years
Address Sale price Sold Size
40 High, Columbus, OH 43215-3010 $350,000 Oct 2024 5,670 SF
40 Long, Columbus, OH 43215-2911 $2,500,000 Nov 2022 20,140 SF
161 4th, Columbus, OH 43215-3297 $2,075,000 Jun 2021 14,178 SF
82 Ml, Columbus, OH 43215 $900,000 Apr 2021 5,200 SF
122 Main, Columbus, OH 43215-5208 $430,000 Apr 2020 14,681 SF
118 Main, Columbus, OH 43215-5208 $235,000 Apr 2020 1,240 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?”
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