Entity Owned Property summary
AI-generated overview
This Lancaster County property at 1748 Columbia Ave offers 5,900 square feet of versatile commercial space, ideal for retail and/or warehouse use. The building, situated on a 0.2-acre lot with 55 feet of frontage on Columbia Avenue in the Lancaster, PA submarket, features two suites totaling 5,900 square feet. Currently, 3,703 square feet are vacant and available for lease or sale. The minimum leasable space is 1,519 square feet, with a maximum contiguous space of 3,703 square feet. The property includes two drive-in bays and 15 total parking spaces. The building is two stories and is zoned for General Commercial use. The vacant space comprises approximately 3,700 square feet of storefront retail space along Columbia Avenue, plus an additional 1,520 square feet in the rear suitable for various uses. The space can be leased separately or together. The sale of the property also includes two residential units
Property profile
Verified
Property type
Retail space
Use group
RETAIL STORES (PERSONAL SERVICES)
Year built
1962
Construction
FRAME
Total area
2,568 SF
Lot
0.2 ac (8,712 SF)
Zoning code
GC
APN
410-04792-0-0000
UPID
US73-0335480
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors
Current use
Occupant on record · Public records
-
Video Duplication Service Photo Lab
-
Marketing & Advertising Advertising Agency
Location
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
$385k
CAP Approach
CAP
$465k
Comparable Approach
Comparable
$484k
Blend (final)
Blend
$310k
Owner & transaction history
since 2025
Last sale
$650,000
3 recorded transactions
Zoning & alternative use
GC · Lancaster, PA
Top alternative use upside
Commercial (general)
$665,000
+19.0%
Medical building
$585,000
+4.5%
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
Value estimation
Instant AI valuation built from comps, income signals, and proprietary benchmarks. A defensible range, not a single guess.
Unlock the complete Valuation workflow
Full NOI reconstruction, selected comps, alternative-use scenarios, data audit and PDF export.
All 5 comparables with addresses
3 alternative uses screened
Sensitivity value band
Source audit · 6 inputs
PDF export
Professional Plan · 30 reports
from $99/month
from $99/month
Summary
1
Valuation conclusion
Included free
Estimated market value
$310k
Value range
$279k – $341k
±10% around blend
Estimated value / SF
$121 / SF
Confidence
High
5 county-verified comps
Property data
100
Market benchmarks
100
Comparable evidence
50
$279k
blend $310k
$341k
Market-derived valuation under stabilized market assumptions. Desktop analysis. No physical inspection performed.
2
Subject property
Included free
GBA
2,568 SF
Lot area
0.2 ac
Year built
1962
Stories
2
APN
410-04792-0-0000
Zoning
GC
Assessed value
$275,300
Annual tax
$6,012
3
Income approach: direct capitalization
Partial preview
Income approach indication
$465k
Direct capitalization · @ 6.5% CAP return
@ 6% CAP return
$505k
@ 6.5% CAP return
$465k
@ 7% CAP return
$430k
4
Sales comparison
Partial preview
Sales approach indication
$435k
Weighted, 5 comps · high confidence
Evidence
5 found · 5 selected
County-verified recorded sales
Comparable
Sale dateSale price$ / SF
8.5 mi away · 3,112 SF
8.9 mi away · 2,266 SF
8.9 mi away · 2,392 SF
9.4 mi away · 3,122 SF
5
Sensitivity & risk
Partial preview
Downside
−10%
Base
$310k
Upside
+10%
Bounds of the ±10% band vs the blend — never simulated scenarios.
6
Current market position
Included free
Benchmark
Observed band ($/SF)AverageSubject delta
ZIP 54 sales
$218
-45%
Submarket 90 sales
$203
-41%
County 277 sales
$161
-25%
Band = middle half (Q1–Q3) of recorded sale $/SF for this use type per geography; the diamond marks the subject at $121/SF. Delta below average reads as headroom. Source: Realmo CRE sales derivatives (county records).
7
Alternative use screening
Partial preview
Top alternative use
Commercial (general)
Gross theoretical uplift
+19%
vs current-use indication
Medical Building
Retail Stores · current use
Values shown before conversion costs, entitlement costs, capital expenditures and stabilization risk.
8
Data & methodology
Included free
Building area
County record
Property tax
County record
Assessed value
County record
Zoning designation
County record
Operating expenses
Modeled
Market rent
Not available
Not analyzed due to unavailable source data: actual rent roll, tenant leases, physical condition and capital
requirements are outside a desktop analysis.
Cost Approach excluded: income and sales evidence cover the value conclusion.
Automated valuation analysis, not a licensed appraisal. Figures are derived from public
records and proprietary models. Desktop analysis: no physical inspection, tenant leases or reported
property income. Verify with a licensed appraiser before transacting.
Cap rate
Cap rate calculated from real income and expense signals, benchmarked against sales of similar assets nearby.
Unlock the complete Cap Rate workflow
Full market tables, editable assumptions, comparable evidence, saved work and exports.
9-scenario matrix
Comparable evidence · 5 sales
Market rates by use type
PDF export
Professional Plan · 30 reports
from $99/month
from $99/month
Overview
Implied cap rate
7.90%
Implied, in-place cap rate for this retail space
Estimated NOI ÷ last recorded sale. Refine with your own numbers in the full report.
Lower yield / higher price
Higher yield / lower price
5.0%
This property · 7.90%
9.0%
NOI (est.)
$46k *
Last sale · Jul 2025
$650k
* derived from a real price signal at a 7% cap
Price sensitivity
The rate is the decision lever; valuation is the consequence.
Test a cap rate
Implied value$576k
Move the market yield to see immediate price impact.
Value / SF
$224
Vs. selected
Base
Derivation
NOI ÷ cap
Arithmetic over the derived NOI * — not market scenario modeling.
NOI × cap matrix
Preview
Preview of 9 modeled outcomes.
NOI
7.40%7.90%8.40%
$41k
$553k
$518k
$487k
$46k
$615k
$576k
$542k
$50k
$676k
$634k
$596k
NOI sensitivity ±10% across the selected-rate band (±0.5 pp) — derivation of the NOI above.
Comparable evidence
Partial preview
Recorded sales nearby
5 found
High confidence · county-verified
Closest comparable
$495k
2.1 mi · Feb 2026 · $204/SF
Property tax & assessments
Tax year 2024Property tax & assessments
Tax year 2024
Tax billed
$6,012
Tax year 2024
Assessed value
$275,300
Assessed 2024
Previous assessed
$275,300
+0.0% YoY
Effective rate
2.18%
On assessed value
Assessed land
$144,200
Assessed improvement
$131,100
Land market value
$144,200
Improvement market value
$131,100
Total market value
$275,300
Applied tax rate
410.0000
Automated cap rate analysis. Based on public records, market benchmarks and proprietary
models. Verify with a licensed professional before transacting.
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
1962
Construction
FRAME
Heating
FORCED AIR
Buildings
2
Stories
2
Rooms
9
Bathrooms
6
Total area
2,568 SF
Lot
0.2 ac (8,712 SF)
Zoning code
GC
APN
410-04792-0-0000
UPID
US73-0335480
Jurisdiction
LANCASTER
Zoning & alternative use
GC · Lancaster, PAZoning GC · permitted uses
GC · Lancaster, PA
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Alternative use value scenarios
Repositioning upside vs current use
Alternative use deep dive — conversion cost, permits, timeline
Conversion cost estimate · Permit path & risks · Stabilized NOI per option
Building & site characteristics
From public records
Year built
1962
Construction
FRAME
Heating
FORCED AIR
Stories
2
Buildings
2
Rooms
9
Bathrooms
6
Lot
0.2 ac
Zoning
The recorded zoning designation, what the district officially allows, and the municipal source it comes from.
Zoning designation
County-recorded code
GC
Jurisdiction
Lancaster, PA
Recorded code
GC
Zoning Insight
What can be built and operated here — officially.
The district profile from the municipal source: what is on file for GC in Lancaster, PA.
What opens after registration
Zoning profile
3 official documentsVerified municipal sources with file download
Match provenanceAssignment basis, match tier and confidence
Private report access
See the official zoning profile for this address.
Registration is required before the official district profile is shown.
One complete report on every paid plan · 30 · 300 reports per month.
Ownership Intelligence
Find the owner behind the property.
Unlock the evidence behind ownership: portfolio, transactions, debt and signals that help you decide who to contact next.
What opens after registration
Ownership report
Owner identityResolved entity and name variants
Portfolio holdingsLinked properties and estimated value
Deal signalsSell-side activity worth following
Debt & historyRecorded loans and transaction history
Private report access
See the ownership record for this address.
Registration is required before any owner information is shown.
One complete report on every paid plan · 30 · 300 reports per month.
Owner of record and activity signals are derived from public records and modeled classifications.
They do not confirm beneficial ownership or intent to transact.
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 1748 Columbia Ave?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
Get access to Data & Analytics
Choose membership plan that suits your needs
Unlock Full Report
$9
one-time
Single Property Report
Full report includes
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Ownership
- Location Insight
- Alternative use
- Local Zoning Insight
MOST POPULAR
Professional Plan
$99
/mo
30 property reports a month.
Cancel anytime.
Cancel anytime.
Your membership includes
- 30 reports a month
- Location Analytics
- Market Trends
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Ownership
- Location Insight
- Alternative use
- Local Zoning Insight
Enterprise Plan
$299
/mo
300 property reports a month.
Cancel anytime.
Cancel anytime.
Your membership includes
- 300 reports a month
- Location Analytics
- Market Trends
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Ownership
- Location Insight
- Alternative use
- Local Zoning Insight
Unlock Light Report
Free
Confirm your email
and get 1 Light Report
and get 1 Light Report
Light report includes
- Property Information
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Potential
- Location Insight
- Alternative use
- Local Zoning Insight
Confirm your e-mail to get the report
