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 Market173

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: Feb 19 Changed: Aug 11 Last Checked: Aug 11 at 10:37AM

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.

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 = area × lease_rate × (100 − vacancy) / 100 × (1 − expense_ratio). Net Operating Income — what the owner takes home each year before mortgage payments and income tax. Effective rent (asking rent minus vacancy losses) minus operating costs (taxes, insurance, maintenance, management).
NOI / Yr
$55,606
Cap rate = NOI / list price × 100. Capitalization rate — annual return on a fully cash purchase, before financing. NOI divided by price. Higher means more income per dollar invested, but usually also more risk or older condition. 5–8% is typical for stabilized commercial property; double digits often signal distressed deals.
Cap Rate
6.18%
Suggested Prices Based on Cap Rates Cap rates vary significantly by property type, market, and asset quality. Typical U.S. stable-market ranges: Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+) Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand) Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically) Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher) Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk) Self-Storage — 5.5% to 7.5% Medical Office — 6.0% to 7.5% Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term Rules of thumb: Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%). Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C. Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI. Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
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 Vacancy — income lost from leasable area expected to sit empty during the year, subtracted from gross rent. EGI (Effective Gross Income) — gross rent minus vacancy losses, the realistic income before paying operating costs. OpEx (Operating Expenses) — recurring costs to operate the property (property tax, insurance, utilities, maintenance, management); excludes financing and capital improvements. NOI (Net Operating Income) — income a property generates after operating costs but before financing and taxes.
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 rates vary significantly by property type, market, and asset quality. Typical U.S. stable-market ranges: Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+) Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand) Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically) Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher) Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk) Self-Storage — 5.5% to 7.5% Medical Office — 6.0% to 7.5% Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term Rules of thumb: Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%). Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C. Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI. Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
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.

Property Analytics

Current Use

Storefront properties

Suggested Use

Top Pick Real Estate Agency Dental Office Parking Lot & Garage Accounting Firm Computer & Electronic Repair HVAC Service

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

Market

Vacancy Rate% for Multifamily in Northeast region

4% 2022
4.6% 2023
5.3% 2024
5.6% 2025
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

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