This home's estimate is 54.3% higher than the average sale price ($280K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate

















164 Franklin Rd, Columbia, PA 17512
About this home
http://www. LancasterOpenHouses.com/Zoned Commercial in West Hempfield
Redfin Estimate
Earn from this home
Get cash now or lower your monthly rate
List your home for rent
Market trends in 17512, PA
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
0.0% MoM
See all
Provided by Redfin
Sale history for 164 Franklin Rd
$128/sq ft
$143/sq ft
$118/sq ft
Tax history for 164 Franklin Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
- Public record
- Zoning
C-2
Commercial District
It is the purpose of the C-2 Commercial District to provide for highway-oriented commercial activities in areas best suited for such purpose.Include but are not limited to:
- Bank
- General retail
- Restaurant
- Infrastructure
- Hotel / motel
- Office
- Medical office
- Public service
- Post office
- Death related/funeral home
Property details
Parking
- Parking Information
- # of Total Garage and Parking Spaces: 2
- Has Garage
- # of Parking Spaces (Total): 2
Interior
- Bathroom Information
- # of Bathrooms (Full): 1
- Interior Information
- Interior Features: Kitchen - Country
- Living Area Sq.Ft. Source: Assessor
- Room Information
- Living Room, Bedroom 2, Kitchen, Bedroom 1, Bathroom 2
- Fireplace Information
- Has Fireplace
- # of Fireplaces: 1
- Basement Information
- Basement: Yes
- Full, Outside Entrance, Partially Finished
Exterior
- Property Information
- Total Below Grade Sq. Ft.: 960
- Ownership Interest: Other
- Property Condition: Good
- Year Built Source: Estimated
- Building Information
- Construction Not Completed
- Construction Materials: Vinyl Siding, Stick Built
- Other Structures: Above Grade, Below Grade
- Outdoor Living Structures: Deck(s)
- Roof: Shingle, Composite
- Structure Type: Detached
- Lot Information
- Lot Size Description: 4 Acres < 10 Acres
- Tidal Water: No
- Land Information
- Tillable Acres: 4.00
- Above Grade Information
- Finished Sq.Ft.: 960
- Below Grade Information
- Finished Sq.Ft.: 960
Financial
- Tax Information
- City/Town Tax: $273.80
- County Tax: $552.78
- School Tax: $2,978.44
- Tax Assessed Value: $148,000
- Tax Annual Amount: $3,805.02
Utilities
- Utilities Information
- 200+ Amp Service
- Other, Forced Air
- Heating Fuel: Oil
- Hot Water: Electric
- Sewer Septic: Public Sewer
- Water Source: Public
Location
- School Information
- Middle Or Junior School: LANDISVILLE
- High School: HEMPFIELD
- School District Name: HEMPFIELD
- Location Information
- In City Limits
- Directions: 462 W. L on Oswego Drive to L on Franklin
- Municipality: WEST HEMPFIELD TWP
Public facts
- Beds: 2
- Baths: 1.0
- Sq. Ft.: 960
- Stories: 1.0
- Lot Size: 4.9 acres
- Style: Single Family Residential
- Year Built: 1952
- Year Renovated: —
- County: Lancaster County
- APN: 3009024800000
Around this home
Schools
- K - 12
- Preschool & daycare
Public K-6 • Assigned • 2.8mi
Public 7-8 • Assigned • 4.9mi
Public 9-12 • Assigned • 5.3mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 100° expected this year, 15 days in 30 years
12% chance of strong winds in next 30 years
2 unhealthy days expected this year, 5 days in 30 years
Sun exposure
In this area, properties receive around 9.3 hours in June and 4.1 hours in December, placing it below the U.S. average for solar exposure.
Sell confidently with a local market expert in Columbia. 3 minutes to get started.
Nearby similar homes
New listings for sale in 17512
Home values near 164 Franklin Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 1591 Sq. Ft. | $369,713 |
2 Beds | 1 Baths | 1354 Sq. Ft. | $256,431 |
3 Beds | 1.5 Baths | 1320 Sq. Ft. | $208,902 |
3 Beds | 1.5 Baths | 1320 Sq. Ft. | $242,158 |
2 Beds | 1 Baths | 1310 Sq. Ft. | $213,947 |
3 Beds | 1.5 Baths | 1320 Sq. Ft. | $236,527 |
3 Beds | 1.5 Baths | 1280 Sq. Ft. | $246,161 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 2570 Sq. Ft. | $612,945 |
2 Beds | 1.5 Baths | 960 Sq. Ft. | $207,548 |
3 Beds | 1.5 Baths | 1320 Sq. Ft. | $233,640 |
4 Beds | 2 Baths | 1040 Sq. Ft. | $275,784 |
3 Beds | 1.5 Baths | 1300 Sq. Ft. | $240,779 |
3 Beds | 1.5 Baths | 1640 Sq. Ft. | $230,012 |
2 Beds | 1 Baths | 960 Sq. Ft. | $183,513 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2.5 Baths | 2020 Sq. Ft. | $454,862 |
3 Beds | 1.5 Baths | 1561 Sq. Ft. | $321,955 |
4 Beds | 2.5 Baths | 2834 Sq. Ft. | $399,204 |
2 Beds | 1 Baths | 1274 Sq. Ft. | $202,941 |
3 Beds | 1.5 Baths | 1320 Sq. Ft. | $225,996 |
3 Beds | 1.5 Baths | 1320 Sq. Ft. | $233,623 |
3 Beds | 1.5 Baths | 1320 Sq. Ft. | $235,945 |
More real estate resources
- Zip Codes
- Cities
- Popular Searches
| 17368 homes for sale | |||
| 17512 homes for sale |
| Hershey homes for sale | |||
| York homes for sale | |||
| Lancaster homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.







































United States
Canada