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.

HomePennsylvaniaLancaster CountyColumbia

Columbia, Pennsylvania: commercial real estate data.

Columbia 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 since FY2020.

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

Counted by borrower city: approvals to borrowers whose address is in Columbia, in any county, FY2020 to FY2026. Only 2 loans have reached a final outcome, fewer than the 30 a charge-off rate needs, so no rate is published.

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

Counted by borrower city: approvals to borrowers whose address is in Columbia, in any county, FY2010 to FY2026. Only 3 loans have reached a final outcome, fewer than the 30 a charge-off rate needs, so no rate is published.

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

Columbia

Flood risk in Columbia

  • NFIP communityBorough of Columbia
  • NFIP community number420543
  • Participating in the NFIPYes
  • Community Rating System classNone
  • Currently effective map date04/05/16

The Borough of Columbia participates in the National Flood Insurance Program as community 420543 and carries no Community Rating System class, so no CRS premium discount applies to it.

Federal Emergency Management Agency, NFIP Community Status Book (OpenFEMA), as of 2026-09-26.

Lancaster County, not Columbia

Lancaster County context, not Columbia figures

  • Establishments in Lancaster County13,776
  • Covered employment, Lancaster County252,045
  • Average annual pay, Lancaster County$59,966
  • Housing units permitted, Lancaster County1,184

Every figure in this section is published for Lancaster County as a whole and is not a measurement of Columbia.

All Lancaster County figures →

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.

Coverage

What this page does not hold.

Parcel detail, zoning and the flood zone at an address are not on this page; they resolve at the address in the platform. How this page was built →

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 totaling $1.9 m since FY2020, across 7 lenders, median approval $50,000, plus 5 504 approvals worth $1.7 m since FY2010. 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 loans have reached a final outcome, fewer than the 30 a charge-off rate needs, so no rate is published. The counts are shown instead.

Is Columbia in the National Flood Insurance Program?

Yes. Columbia appears in the FEMA Community Status Book as Columbia, borough of, 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 labeled 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?

No. Nothing on this page presents parcel level zoning.