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

















































195 Franklin Rd, Columbia, PA 17512
About this home
Here's your opportunity to own more than 21 acres in Hempfield School District! Come see for yourself: gleaming hardwood floors, an open kitchen layout with loads of cabinetry, a large great room with cathedral ceilings and a stone fireplace, 6 bathrooms, a possible in-law quarters with a full kitchen and walk-out in the lower level. The lower level adds over 900 additional finished square footage. Not to mention the 3-car garage, detached large insulated shop with heat, plumbing including half bath and electric. Enjoy your own private sanctuary just minutes from Rt. 30!
Redfin Estimate
Earn from this home
List your home for rent
Market trends in 17512, PA
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
0 days MoM
- OPEN SUN, 4PM TO 6PM
- OPEN OCT 3, 10AM TO 12PM
- OPEN SUN, 1PM TO 3PM
See all
Provided by Redfin
Sale history for 195 Franklin Rd
$146/sq ft
$161/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
- Public record
- Zoning
R
Rural Agricultural District
Identify those areas within the Township where agricultural activities should be encouraged and or preserved; and Provide for the controlled expansion of low-density residential development in those areas most likely to remain dependent upon on-site sewer and water facilities.Include but are not limited to:
- Agriculture
- Greenhouse / nursery
- Livestock production
- Housing-Single unit
- Infrastructure
- Public service
- Fire house
- Communications tower
Property details
Parking
- Parking Information
- # of Attached Garage Spaces: 3
- Garage Features: Additional Storage Area, Garage - Side Entry, Garage Door Opener, Oversized
- # of Total Garage and Parking Spaces: 6
- Has Garage
- # of Garage Spaces: 3
- Asphalt Driveway, Lighted Parking, Paved Parking, Private, Paved Driveway
- # of Open Parking Spaces: 3
- Attached Garage, Driveway, Off Street
Interior
- Bedroom Information
- # of Bedrooms On Main Level: 3
- Bathroom Information
- # of Bathrooms (Half) On Main Level: 4
- # of Bathrooms (Full) On Main Level: 1
- # of Bathrooms (Full) On 1st Lower Level: 1
- # of Bathrooms (Full) On All Lower Levels: 1
- # of Bathrooms (Half): 4
- # of Bathrooms (Full): 2
- Interior Information
- Appliances: Built-In Microwave, Central Vacuum, Cooktop, Dryer, Dryer - Electric, Oven - Wall, Oven/Range - Electric, Refrigerator, Surface Unit, Washer, Water Conditioner - Owned, Water Heater
- Door Features: French, Insulated
- Flooring Type: Carpet, Hardwood, Laminated, Vinyl
- Interior Features: 2nd Kitchen, Attic, Breakfast Area, Carpet, Central Vacuum, Chair Railings, Combination Kitchen/Dining, Family Room Off Kitchen, Kitchen - Eat-In, Kitchen - Island, Recessed Lighting, Stain/Lead Glass, Store/Office, Wood Floors
- Living Area Sq.Ft. Source: Estimated
- Wall & Ceiling Types: Cathedral Ceilings, Dry Wall
- Room Information
- Living Room, Bedroom 2, Bedroom 3, Kitchen, Bedroom 1, Exercise Room, Great Room, In-Law/auPair/Suite, Laundry, Storage Room, Utility Room, Full Bath, Half Bath
- Laundry Type: Main Floor
- Fireplace Information
- Has Fireplace
- # of Fireplaces: 1
- Stone
- Basement Information
- Basement: Yes
- Daylight, Full, Sump Pump
Exterior
- Property Information
- Not Federal Flood Zone
- Total Below Grade Sq. Ft.: 970
- Accessibility Features: 2+ Access Exits, Doors - Lever Handle(s)
- Improvement Assessed Value: $218,000
- Ownership Interest: Fee Simple
- Property Condition: Very Good
- Year Built Source: Estimated
- Building Information
- Construction Materials: Frame, Vinyl Siding, Stick Built, Stone
- Other Structures: Above Grade, Below Grade
- Outdoor Living Structures: Patio(s), Roof
- Roof: Shingle
- Structure Type: Detached
- Window Features: Double Pane, Insulated
- Other Structures: 2nd Garage, Wood/Metal Shed
- Exterior Information
- Exterior Lighting, Play Area, Play Equipment, Secure Storage, Stone Retaining Walls
- Lot Information
- Tidal Water: No
- Land Information
- Land Assessed Value: $246,000
- Above Grade Information
- Finished Sq.Ft.: 2,448
- Finished Sq.Ft. Source: Assessor
- Below Grade Information
- Unfinished Sq.Ft. Source: Assessor
- Finished Sq.Ft.: 970
- Finished Sq.Ft. Source: Estimated
Financial
- Tax Information
- City/Town Tax: $673
- County Tax: $1,351
- School Tax: $7,426
- Tax Assessed Value: $464,000
- Tax Year: 2018
- Tax Annual Amount: $9,449
Utilities
- Utilities Information
- Central Air
- Cooling Type: Central A/C
- Cooling Fuel: Electric
- 200+ Amp Service
- Forced Air, Oil
- Heating Fuel: Oil
- Hot Water: 60+ Gallon Tank
- Sewer Septic: Holding Tank, Pressure Dose
- Cable TV Available, Electric Available, Phone
- Water Source: Well
Location
- School Information
- School District Name: HEMPFIELD
- School District Source: Listing Agent
- Location Information
- Directions: From Rt 30 W, take Prospect Rd exit and turn left, R on Columbia Ave, L on Oswego Dr, L on Franklin Rd, home is on left
- Location Type: Rural
- Municipality: WEST HEMPFIELD TWP
Public facts
- Beds: —
- Baths: —
- Sq. Ft.: —
- Stories: —
- Lot Size: —
- Style: Single Family Residential
- Year Built: —
- Year Renovated: —
- County: Lancaster County
- APN: 300-90134-0-0000
Around this home
Schools
Public K-6 • Assigned • 2.8mi
Public 7-8 • Assigned • 5.0mi
Public 9-12 • Assigned • 5.4mi
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 101° expected this year, 14 days in 30 years
13% 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 195 Franklin Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 1 Baths | 1260 Sq. Ft. | $310,792 |
2 Beds | 1 Baths | 1354 Sq. Ft. | $259,971 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2.5 Baths | 2020 Sq. Ft. | $458,435 |
3 Beds | 1.5 Baths | 1561 Sq. Ft. | $327,290 |
| Address | Redfin Estimate |
|---|---|
2 Beds | 1 Baths | 1920 Sq. Ft. | $431,125 |
4 Beds | 2.5 Baths | 3288 Sq. Ft. | $654,005 |
More real estate resources
- Zip Codes
- Cities
- Popular Searches
| 17368 homes for sale | |||
| 17512 homes for sale |
| Lititz 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