app.mmcganalytics.com/workspace?place=4215384
Live

Live workspace · free

Enter a Columbia address. Eight answers in seconds.

Parcel, building, flood, wetland, traffic, demographic and lending layers resolve at the address without leaving this page.

Full screen stage. Launch is one click until the anonymous view and the frame-ancestors header land on the app route; then set AUTO_MOUNT true and it loads on arrival.

HomePennsylvaniaLancaster CountyColumbia borough

Columbia borough, Pennsylvania: commercial real estate data.

Columbia borough is a Census borough of 10,278 people across 2.41 square miles of land, in Lancaster County. Median household income is $54,437, 52.8 percent of occupied homes are owned, and the SBA record carries 12 7(a) approvals to borrowers here worth $1.9 m.

80 sourced place values · tier FULL · 9 sections · underlined figures are computed by MMCG Analytics, not published by the agency

Columbia

What Columbia is

  • Census place typeborough
  • Land area2.41 sq mi
  • Water area0.01 sq mi
  • Population per square mile of land4,258
  • County holding the largest share of its areaLancaster County, 100.0 percent

US Census Bureau, cartographic boundary file, places, 2024 vintage. US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

How many people live in Columbia

  • Population10,278
  • Median age41.8
  • Population under 181,794
  • Share under 1817.5 percent
  • Population 65 and over2,326
  • Share 65 and over22.6 percent
  • Households4,568
  • Family households2,439
  • Share of households that are families53.4 percent

US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

Income and work in Columbia

  • Median household income$54,437
  • Per capita income$33,896
  • Civilian labor force5,269
  • Employed5,103
  • Unemployed166 plus or minus 87
  • Unemployment rate3.2 percent plus or minus 1.6
  • Adults 25 and over7,639
  • Adults 25 and over with a high school diploma or higher82.4 percent
  • Adults 25 and over with a bachelor degree or higher17.4 percent
  • Adults 25 and over with a graduate degree5.4 percent plus or minus 1.8

US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

Housing in Columbia

  • Housing units4,936
  • Occupied units4,568
  • Vacant units368 plus or minus 141
  • Vacancy rate7.5 percent plus or minus 2.8
  • Owner occupied2,411
  • Renter occupied2,157
  • Ownership rate52.8 percent
  • Median owner-occupied home value$196,500
  • Median gross rent, monthly$1,075
  • Annual rent as a share of median income23.7 percent
  • Single family units3,003
  • Share single family60.8 percent
  • Units in buildings of two or more1,885 plus or minus 400
  • Share in buildings of two or more38.2 percent plus or minus 7.6
  • Mobile homes14 plus or minus 21
  • Median year structure built1938

US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

How Columbia gets to work

  • Workers 16 and over who commute4,783
  • Commuting under 15 minutes1,167 plus or minus 282
  • Share commuting under 15 minutes24.4 percent plus or minus 5.4
  • Commuting 30 minutes or more1,389 plus or minus 354
  • Share commuting 30 minutes or more29.0 percent plus or minus 6.9
  • Drove alone73.7 percent
  • Carpooled11.2 percent plus or minus 6.6
  • Public transport0.6 percent plus or minus 0.5
  • Walked6.5 percent plus or minus 2.9
  • Worked from home5.9 percent plus or minus 2.2

US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

Columbia

SBA loans in Columbia (7(a))

  • Approvals12
  • Gross approval$1,945,500
  • Average approval$162,125
  • Median approval$50,000
  • Ninetieth percentile approval$620,000
  • Largest approval$630,000
  • Jobs supported43
  • Jobs per approval3.6
  • Loans with a final outcome2
  • Paid in full2
  • Charged off0
  • Median term120 months
  • Share on real estate terms of 20 years or more16.7 percent
  • Share to franchises8.3 percent
  • Distinct lenders7
  • Distinct industries by NAICS9

A charge-off rate is not published here. only 2 resolved loans, too few to publish a rate, and a rate over that few outcomes would move several points on one loan.

US Small Business Administration, 7(a) FOIA release, FY2020 to FY2026 year to date, as of 2026-06-30.

Columbia

SBA loans in Columbia (504)

  • Approvals5
  • Gross approval$1,687,000
  • Average approval$337,400
  • Median approval$363,000
  • Largest approval$550,000
  • Jobs supported39
  • Loans with a final outcome3
  • Charged off0
  • Median term240 months
  • Distinct CDCs2

US Small Business Administration, 504 FOIA release, FY2010 to FY2026 year to date, as of 2026-06-30.

Columbia

Flood risk in Columbia

  • Listed NFIP communities2
  • Of those, participating2
  • NFIP community number420543
  • Currently effective map date04/05/16

This community carries no Community Rating System class, so no CRS premium discount applies to it.

FEMA, National Flood Insurance Program Community Status Book, Community Status Book, as retrieved.

Lancaster County, not Columbia

Lancaster County context, not Columbia figures

These are Lancaster County figures. There is no place level equivalent published for any of them, so they are shown as the county backdrop and never as Columbia measurements.

  • Establishments in Lancaster County13,776
  • Employment at those establishments, Lancaster County249,379
  • Covered employment, Lancaster County252,045
  • Average annual pay, Lancaster County$59,966
  • Average weekly wage, Lancaster County$1,153
  • Housing units permitted, Lancaster County1,184
  • Of those, single family, Lancaster County755
  • County product, 2024, Lancaster County$39,951,127,000
  • County product change over the prior year, Lancaster County5.1 percent
  • Average income of an arriving household, Lancaster County$71,303

Every figure in this section is published for Lancaster County as a whole and is not a measurement of Columbia. It is here because a county backdrop is what a credit committee reads a place against, and it is labelled so that it can never be quoted as the place's own.

US Census Bureau, County Business Patterns, 2023. US Bureau of Labor Statistics, Quarterly Census of Employment and Wages, 2024 annual averages. US Census Bureau, Building Permits Survey, 2024 annual. US Bureau of Economic Analysis, Regional, table CAGDP2, CAGDP2, through 2024. US Internal Revenue Service, Statistics of Income county migration flows, 2021 to 2022 filing years.

Coverage

What this page does not hold.

Every item below could be filled with a plausible figure. None of them is. On a page a lender may read, a number that cannot be traced is worse than an absence, so the absences are named.

  • Parcel level detail, zoning and flood zone at an address are resolved in the platform, not on this page.

SBA figures count approvals to borrowers whose address is in the place. They are not approvals for projects inside the place boundary: the tape records a borrower city and a project county, and those can differ.

Common questions

Columbia questions, answered from the record.

How many people live in Columbia, Pennsylvania?

10,278, in 4,568 households. Columbia borough covers 2.41 square miles of land, which is 4,258 people per square mile. Source: US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

What county is Columbia in?

Lancaster County, which holds 100.0 percent of the place by area. Source: US Census Bureau, cartographic boundary file, places, 2024 vintage.

What is the median household income in Columbia?

$54,437. The median owner-occupied home is valued at $196,500. Median gross rent is $1,075 per month. Source: US Census Bureau, American Community Survey 5-Year Estimates, place level, 2020-2024 5-year.

How much SBA lending goes to Columbia businesses?

12 7(a) approvals totalling $1.9 m, across 7 lenders, median approval $50,000, plus 5 504 approvals worth $1.7 m. These count approvals to borrowers whose address is in Columbia, not projects sited inside the place boundary, and they are approvals recorded in the release rather than loans disbursed.

Do SBA loans to Columbia borrowers get paid back?

No rate is published for Columbia. only 2 resolved loans, too few to publish a rate, and a percentage over that few outcomes would move several points on a single loan. The counts are shown instead.

Is Columbia in the National Flood Insurance Program?

Yes. Columbia appears in the FEMA Community Status Book as community 420543, with no Community Rating System class, so no CRS discount applies. Whether a specific parcel sits in a mapped special flood hazard area is an address level question the platform answers.

Are the county figures on this page Columbia figures?

No, and they are labelled so. County Business Patterns, QCEW, the Building Permits Survey, BEA product and IRS migration are published for Lancaster County as a whole and there is no place level equivalent. They appear in one clearly marked section as context and are never presented as measurements of Columbia.

Is zoning published for Columbia?

Not yet. The zoning layer is in build. Nothing on this page presents parcel level zoning.