New search
Property profile & analytics
OFF-MARKET
Estimated value
$575,000
Retail space
1748 Columbia Ave Lancaster, PA 17603-4364
Entity Owned
~
Est. High Equity
Property ID
US73-0335480
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
Implied cap rate, NOI & suggested price
Cap vs submarket · NOI estimate · 3 price anchors
Current use
Occupant on record · Public records
-
EverPresent Photo Restoration Service Video Editing Service
-
Signarama Lancaster, PA Marketing & Advertising Advertising Agency
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
$385k
CAP Approach
CAP
$465k
Comparable Approach
Comparable
$484k
Blend (final)
Blend
$575k
Owner & transaction history
Almaguer Enterprises LLC
Almaguer Enterprises LLC
since 2025
Last sale
$650,000
3 recorded transactions
Zoning & alternative use
GC · Lancaster, PA
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Top alternative use upside
Commercial (general)
$665,000
+19.0%
Medical building
$585,000
+4.5%
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 Lancaster submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Lancaster 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
$385,000
CAP Approach
CAP Return
Estimation
6%
$505,000
6.5%
$465,000
7%
$430,000
Alternative Use
Use
Estimation
RETAIL STORES
$560,000
Current use
COMMERCIAL (GENERAL)
$665,000
Change: +19% · Conversion: Easy
MEDICAL BUILDING
$585,000
Change: +5% · Conversion: Difficult
Blend value · Realmo final
$575k
Range $518k – $633k · ±10% · vs last sale $650k (Jul 30 2025)
Last sale anchor
$650k
Jul 30 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
$224 / 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 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
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
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, PA
Zoning GC · permitted uses
GC · Lancaster, PA
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Lancaster. Always verify with local authorities before improvements.
Alternative use value scenarios
Repositioning upside vs current use
RETAIL STORES Current
Est. value
$560,000
COMMERCIAL (GENERAL)
Est. value
$665,000
MEDICAL BUILDING
Est. value
$585,000
RETAIL STORES Current
COMMERCIAL (GENERAL)
MEDICAL BUILDING
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
1962
Construction
FRAME
Heating
FORCED AIR
Stories
2
Buildings
2
Rooms
9
Bathrooms
6
Lot
0.2 ac
Current owner
From public records · entity-resolved
Almaguer Enterprises LLC
Entity
Mailing address
1119 CENTRAL MNR RD, LANCASTER, PA 17603-8903
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
3 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Oct 30, 2025
$650,000
Almaguer Enterprises LLC
Stephen A Dickerman
Deed
$520,000 · Univest Bank & Trust Co
Jun 25, 2019
—
Stephen A Dickerman
Dickerman,stephen A & Jere L
Quit Claim Deed
related
—
Jun 5, 2001
$190,000
Stephen A Dickerman
Harman,donald M
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?”
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.
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.
