Search
Retail Building with Apartments
For Sale
$900,000

401 Linden Street, Columbia, PA 17512

Solid masonry retail storefront with an active antique shop, plus two upper apartments and a full basement.

Property Size4,725 SF
Lot Size0.30 Acres
Price / SF$190.48
Days on Market328

Property Features for 401 Linden Street

General Information

Standard status Active
Size 4,725 SF
Lot size 0.30 Acres
Property subtype Commercial
Lease Term []

Additional Details

Business Included Yes
Highway Access Yes
Multifamily Units 2

Building Details

Year Built 1969
Listing Agency: High Associates Ltd.
Listed By: Althea Ramsay Carrigan · License #RS211857L
Source: Deepcreeklake
Added: Dec 4, 2025 Changed: Oct 27 Last Checked: Oct 26 at 4:26PM

Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of High Associates Ltd.

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

Investment Insights

Based on property information with market context.

The property is a solid masonry retail building with an active antique shop on the main level and two apartments above. A full basement is included, though its square footage is not calculated into the stated building size. The layout supports mixed-use occupancy, with storefront operations on the lower level and residential units overhead, along with additional lower-level space for storage or other uses consistent with tenant/operator needs.

The building sits on two combined parcels totaling 0.30+/- acres, providing private parking and access. It is located on US Route 30 as you enter Lancaster County from York, Pennsylvania, with visibility from US 30. The property is immediately beside the Turkey Hill Experience, and the retail site benefits from its established positioning along this corridor.

For buyers or operators looking for a multi-use configuration, this setup offers an income-and-operations blend by pairing an operating storefront with two upper apartments in a single, masonry structure. The antique store is actively operating, and tours are by appointment with an agent present. Please do not visit without an appointment unless shopping.

Key Highlights

  • 4,725 SF solid masonry retail building on US Route 30
  • Active antique shop on the main level with two apartments above
  • Two combined parcels totaling 0.30+/- acres with ample private parking and access

Financial Insights

Estimated NOI and Cap Rate

NOI / Yr
$55,606
Cap Rate
6.18%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$1,112,120 $1.1M
Cap Rate 7%
$794,371 $794.4K
Cap Rate 9%
$617,844 $617.8K
Market Conditions
NOI Build-Up for 4,725 SF
Gross rent
$85.1K $18.00/SF
− Vacancy
−$5.6K −$1.19/SF
EGI
$79.4K $16.81/SF
− OpEx
−$23.8K −$5.04/SF
NOI
$55.6K $11.77/SF
Area
Lancaster County, PA
Vacancy
6.60%
Lease Rate
$18.00 /SF/Yr
Expense Ratio
30.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap Rate 5%
$1,112,120
Cap Rate 7%
$794,371
Cap Rate 9%
$617,844

Alternative Uses

Best Use
Retail
$794.4K
$695.1K – $926.8K (±1% cap)
NOI $55,606 @ 7.0% cap · market cap 6.18%
Second Best
Multifamily LT 5
$754.0K
$659.7K – $879.6K (±1% cap)
NOI $52,778 @ 7.0% cap · market cap 5.86%
Theoretical Best
Office A
$1.58M
$1.39M – $1.85M (±1% cap)
NOI $110,836 @ 7.0% cap · market cap 12.32%
Zoning and permitted uses should be independently verified with authorities. How Realmo checks its estimates

Property Analytics

Who owns this building? See the owner, sales and loan history
Open Analytics

Current Use

Storefront properties

Suggested Use

Top Pick Real Estate Agency Dental Office Building Supply Restaurant Big Box & Wholesale Store Auto Parts Store

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

2
Residential units
Turnkey business
Opportunity
Yes
Highway access

Location Intelligence

Trade Area within ½ mile

626
Businesses Nearby
Under-served
Demand for This Use

Demographics for 17512, PA

18,267
Population
8,255
Households
2.2
Avg Household Size
42
Median Age
23%
College-Educated
86%
High-School Grad
16.0 sq mi
ZIP Area
1,142
Density / Sq Mi
$61,130
Median Household Income
$42,702
Median Earnings
$1,067
Median Rent
$221,100
Median Home Value
Check the figures for this property Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics

Market

Vacancy Rate% for Multifamily in Northeast region

4% 2022
4.6% 2023
5.3% 2024
5.6% 2025

Similar Off Market Nearby

  • Flowers by Us — 449 Locust St, Columbia, PA 17512
  • Branch and Blossom Farm — S 6th St, Columbia, PA 17512

Frequently Asked Questions

What type of property is this?
Storefront property - Solid masonry retail storefront with an active antique shop, plus two upper apartments and a full basement.
Where is this storefront property located?
The property is located at 401 Linden Street Columbia, PA.
What is the asking price?
The asking price for this property is $900,000.
What are key features of this property?
This property features: 4,725 SF solid masonry retail building on US Route 30; Active antique shop on the main level with two apartments above; Two combined parcels totaling 0.30+/- acres with ample private parking and access
Research This Page with AI

Rey answers here. ChatGPT, Grok and Claude get the same data packet.

Includes: Price & PSF · Cap rate · Location · Zoning

Ask Rey → ChatGPT Grok Claude
Preferred Make Realmo a preferred source.

Our comps and market reports get this label in your Google results.

Add as a preferred source on Google One click on Google
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
Why this one?
Saved