OFF MARKET

Off Market Jul 2019 for $190K

$334,652

•

1 ba

•

1,425

sq ft

4240 Fairview Rd, Columbia, PA 17512

About this home

Imagine being able to sit outside in the back, on the patio after a long day of work, and enjoy a cool drink while gazing out over the peaceful farmland behind you. That~s what you can do and so much more with this 3 bed/1 plus bathroom Brick Rancher that sits on just over 1 acre of land. With some updates and TLC this home will be worth the sweat equity! Keeping the updates/TLC in mind, this property has been priced below the recent private appraisal that was done. In the past, this property had been a flower garden/tree farm which is why there is the ~plus~ bathroom along with the laundry area, located in the garage. The kitchen has so much potential to be made into a cooks dream. There are hardwoods in the Living Room/hallway and it is suspected that there may be hardwood under the carpeted areas as well. The basement has a wood burning fireplace along with 2 separate rooms ~ one was a workshop and the other was storage for the items made. There is an oversized shed that also has electricity. This is an Estate and being sold ~As-Is, Executor/Estate will not do any repairs. Seller is providing a 1 year America~s Choice Home Warranty.

Single-familyProperty Type

1961Year Built

1.03 acresLot Size

$235Est. Price/Sq.Ft.

4 spacesParking

Listed by Claire Chivington • RE/MAX Patriots

•717-517-9222 (broker)

•remaxpatriots@comcast.net (broker)

Bought with Karen Williams • Berkshire Hathaway HomeServices Homesale Realty

•717-560-9100 (broker)

•leadcenter@homesale.com (broker)

Redfin checked: 2 minutes ago

•Source:BRIGHT MLS #PALA134832

Redfin Estimate

$334,652

$145K since sold in July 2019$5,000 since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 6.7% lower than the average sale price ($359K) of 6 comparable homes.

SOLD JUL 8, 2026
$325,000
A
3 beds1 bath1,296 sq ft
485 Summit Dr, Columbia, PA 17512
SOLD JUN 26, 2026
$305,000
B
2 beds1 bath1,025 sq ft
4066 Marietta Ave, Mount Joy, PA 17552
SOLD JUN 26, 2026
$389,900
C
3 beds2 baths1,440 sq ft
2637 Hemlock Dr, Columbia, PA 17512
SOLD JUL 31, 2026
$435,000
D
3 beds2 baths1,575 sq ft
319 Druid Hill Rd, Lancaster, PA 17601
SOLD MAY 29, 2026
$355,000
E
3 beds2 baths1,308 sq ft
715 Hempfield Hl, Columbia, PA 17512
SOLD MAR 30, 2026
$343,000
F
2 beds1 bath1,728 sq ft
4260 Fairview Rd, Columbia, PA 17512

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Rent

$1,377/mo

Redfin rental estimate

List your home for rent

Market trends in 17512, PA

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

101.9%

0.0% MoM

Median sale price

$305K

$20K MoM

Avg. days on market

0 days MoM

Recently sold homes

6 MoM

New listings for sale

NEW 12 HRS AGO
$239,900
3 beds2 baths1,227 sq ft
1045 Prospect Rd, Columbia, PA 17512
(717) 291-6400
$799,000
4 beds1 bath4,000 sq ft
525 Franklin St, Columbia, PA 17512
(717) 735-8400
$169,995
4 beds1 bath1,728 sq ft
321 N 2nd St, Columbia, PA 17512
(717) 755-5599
COMING SOON
$149,900
3 beds1 bath1,681 sq ft
755 Locust St, Columbia, PA 17512
(717) 569-1700
$425,000
3 beds2 baths2,661 sq ft
332 Indian Head Rd, Columbia, PA 17512
(717) 808-1942
$379,000
4 beds1.5 baths1,480 sq ft
1189 Ridge Ave, Columbia, PA 17512
(717) 291-9101
OPEN SUN, 11AM TO 1PM
$245,000
4 beds1 bath1,775 sq ft
753 Locust St, Columbia, PA 17512
(717) 208-4444
3D WALKTHROUGH
$174,999
3 beds1.5 baths1,051 sq ft
292 S 5th St, Columbia, PA 17512
(443) 499-3839
See all

Provided by Redfin

Sale history for 4240 Fairview Rd

Year

Property tax

Land + Additions

Assessment*

2026

$4,333 (+2.4%)

$54,400 + $124,300

$178,700

2025

$4,233 (+2.7%)

$58,400 + $124,300

$182,700

2024

$4,120 (+2.0%)

$58,400 + $124,300

$182,700

2023

$4,041 (+2.7%)

$58,400 + $124,300

$182,700

2022

$3,935 (+2.0%)

$58,400 + $124,300

$182,700

2021

$3,857

$58,400 + $124,300

$182,700

2020

$3,857 (+1.7%)

$58,400 + $124,300

$182,700

2019

$3,794 (−15.9%)

$58,400 + $124,300

$182,700

2018

$4,510 (+17.4%)

$58,400 + $124,300

$182,700

2017

$3,841 (+9.8%)

$45,500 + $103,900

$149,400

2014

$3,498

$45,500 + $103,900

$149,400

Tax history for 4240 Fairview Rd

Year

Property tax

Land + Additions

Assessment*

2026

$4,333 (+2.4%)

$54,400 + $124,300

$178,700

2025

$4,233 (+2.7%)

$58,400 + $124,300

$182,700

2024

$4,120 (+2.0%)

$58,400 + $124,300

$182,700

2023

$4,041 (+2.7%)

$58,400 + $124,300

$182,700

2022

$3,935 (+2.0%)

$58,400 + $124,300

$182,700

2021

$3,857

$58,400 + $124,300

$182,700

2020

$3,857 (+1.7%)

$58,400 + $124,300

$182,700

2019

$3,794 (−15.9%)

$58,400 + $124,300

$182,700

2018

$4,510 (+17.4%)

$58,400 + $124,300

$182,700

2017

$3,841 (+9.8%)

$45,500 + $103,900

$149,400

2014

$3,498

$45,500 + $103,900

$149,400

*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

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

0.57 Acres

Year renovated

—

Sq. Ft.

1,425

Year built

1961

Style

Single Family Residential

County

Lancaster County

APN

3005317700000

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 11, 2026.

Property details

Parking

Parking Information
# of Attached Garage Spaces: 2
Garage Features: Additional Storage Area, Garage - Front Entry, Garage - Rear Entry, Inside Access
# of Total Garage and Parking Spaces: 4
Has Garage
# of Garage Spaces: 2
Asphalt Driveway
# of Open Parking Spaces: 2
Attached Garage, Off Street, On Street, Other

Interior

Bedroom Information
# of Bedrooms On Main Level: 3

Bathroom Information
# of Bathrooms (Full) On Main Level: 1
# of Bathrooms (Full): 1

Interior Information
Appliances: Dishwasher, Dryer - Electric, Microwave, Oven - Single, Oven/Range - Electric, Refrigerator, Washer
Flooring Type: Hardwood, Vinyl, Carpet
Interior Features: Breakfast Area, Floor Plan - Traditional, Kitchen - Eat-In, Kitchen - Table Space, Stall Shower, Other, Attic/House Fan
Living Area Sq.Ft. Source: Assessor

Room Information
Living Room, Bedroom 2, Bedroom 3, Kitchen, Basement, Bedroom 1, Bathroom 1, Bathroom 2
Laundry Type: Main Floor, Shared, Has Laundry

Fireplace Information
Has Fireplace
# of Fireplaces: 1
Brick, Wood

Basement Information
Basement: Yes
Full, Unfinished, Windows, Workshop

Exterior

Property Information
Not Federal Flood Zone
Total Below Grade Sq. Ft.: 0
Accessibility Features: 2+ Access Exits
Irrigation Water Rights
Improvement Assessed Value: $124,300
Ownership Interest: Fee Simple
Property Condition: Fixer
Year Built Source: Assessor

Building Information
Construction Materials: Brick, Masonry
Other Structures: Above Grade, Below Grade
Outdoor Living Structures: Patio(s), Porch(es)
Roof: Shingle
Structure Type: Detached

Exterior Information
Outbuilding(s)

Lot Information
Lot Features: Additional Lot(s), Backs - Open Common Area, Cleared, Front Yard, Landscaping, Level, Rear Yard, Rural, SideYard(s)
Lot Size Dimensions: 0.00 x 0.00
Tidal Water: No

Land Information
Land Assessed Value: $58,400

Above Grade Information
Finished Sq.Ft.: 1,425
Finished Sq.Ft. Source: Assessor

Below Grade Information
Unfinished Sq.Ft. Source: Assessor
Finished Sq.Ft. Source: Assessor

Financial

Tax Information
City/Town Tax: $338
County Tax: $532
School Tax: $2,987
Tax Assessed Value: $182,700
Tax Year: 2020
Tax Annual Amount: $3,857

Assessments Information
Year Assessed: 2020

Lease Information
Lease Considered: No

Utilities

Utilities Information
100 Amp Service
Baseboard - Electric
Heating Fuel: Electric
Hot Water: Electric
Sewer Septic: On Site Septic
Cable TV, Electric Available, Phone Available
Water Source: Well, Public

Location

School Information
Elementary School: FARMDALE
Middle Or Junior School: LANDISVILLE
High School: HEMPFIELD
School District Name: HEMPFIELD
Elementary School Source: 3rd Party
Middle School Source: 3rd Party
High School Source: 3rd Party
School District Source: 3rd Party

Location Information
Directions: From Lancaster: Route 30 W to Prospect Rd. , sharp L onto Fairview Rd. (Tavern on Curve of Fairview/ Prospect Rds). Home on left.
Location Type: Rural
Municipality: WEST HEMPFIELD TWP

Public facts

Beds: 3
Baths: 1.0
Sq. Ft.: 1,425
Stories: 1.0
Lot Size: 0.57 acres
Style: Single Family Residential
Year Built: 1961
Year Renovated: —
County: Lancaster County
APN: 3005317700000

Home facts updated by county records on Jul 10, 2026

Around this home

Schools

Farmdale El School

Public K-6 • Assigned • 0.6mi

8/10

Landisville Middle School

Public 7-8 • Assigned • 3.1mi

7/10

Hempfield Senior High School

Public 9-12 • Assigned • 3.3mi

9/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

5/10 Heat Factor

7 days above 100° expected this year, 14 days in 30 years

4/10 Wind Factor

16% chance of strong winds in next 30 years

4/10 Air Factor

3 unhealthy days expected this year, 6 days in 30 years

Provided by First Street

Historical weather

Columbia, PA • 17512

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

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.

9.3 hrs

4.1 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$318,000 – $385,000

Sell confidently with a local market expert in Columbia. 3 minutes to get started.

Nearby similar homes

$60,000

2 beds1.5 baths980 sq ft

409-26 E Main St, Mountville, PA 17554

(717) 840-1355

3D WALKTHROUGH

$775,000

5 beds5.5 baths6,754 sq ft

501 Bald Eagle Ct, Lancaster, PA 17601

(717) 285-7009

NEW CONSTRUCTION3D WALKTHROUGH

$567,990

4 beds2.5 baths— sq ft

251 Lindsey Dr, Columbia, PA 17512

(878) 322-0400

NEW CONSTRUCTION3D WALKTHROUGH

$464,990

3 beds2 baths— sq ft

205 Lindsey Dr, Columbia, PA 17512

(878) 322-0400

3D WALKTHROUGH

$290,000

3 beds2 baths2,058 sq ft

318 Linden St, Columbia, PA 17512

(717) 553-2500

NEW CONSTRUCTION

$497,990

4 beds2.5 baths— sq ft

215 Lindsey Dr, Columbia, PA 17512

(878) 322-0400

New listings for sale in 17512

NEW 12 HRS AGO

$239,900

3 beds2 baths1,227 sq ft

1045 Prospect Rd, Columbia, PA 17512

(717) 291-6400

$799,000

4 beds1 bath4,000 sq ft

525 Franklin St, Columbia, PA 17512

(717) 735-8400

$169,995

4 beds1 bath1,728 sq ft

321 N 2nd St, Columbia, PA 17512

(717) 755-5599

COMING SOON

$149,900

3 beds1 bath1,681 sq ft

755 Locust St, Columbia, PA 17512

(717) 569-1700

$425,000

3 beds2 baths2,661 sq ft

332 Indian Head Rd, Columbia, PA 17512

(717) 808-1942

$379,000

4 beds1.5 baths1,480 sq ft

1189 Ridge Ave, Columbia, PA 17512

(717) 291-9101

OPEN SUN, 11AM TO 1PM

$245,000

4 beds1 bath1,775 sq ft

753 Locust St, Columbia, PA 17512

(717) 208-4444

3D WALKTHROUGH

$174,999

3 beds1.5 baths1,051 sq ft

292 S 5th St, Columbia, PA 17512

(443) 499-3839

Home values near 4240 Fairview Rd

Data from public records.

Address	Redfin Estimate
4251 Fairview Rd, Columbia, PA 3 Beds \| 1 Baths \| 2250 Sq. Ft.	$345,645
4260 Fairview Rd, Columbia, PA 2 Beds \| 1 Baths \| 1728 Sq. Ft.	$361,854

Address	Redfin Estimate
4283 Fairview Rd, Columbia, PA 4 Beds \| 1.5 Baths \| 2324 Sq. Ft.	$432,820
4273 Fairview Rd, Columbia, PA 3 Beds \| 1.5 Baths \| 1292 Sq. Ft.	$348,478

Address	Redfin Estimate
4270 Fairview Rd, Columbia, PA 3 Beds \| 1 Baths \| 1128 Sq. Ft.	$260,150
4220 Fairview Rd, Columbia, PA - Beds \| - Baths \| 3250 Sq. Ft.	$470,012

Property information provided by BRIGHT MLS when last listed in 2019. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

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.

GreatSchools Ratings provided by GreatSchools.org.

Houses for sale near me	Philadelphia, PA homes for sale	Allentown, PA homes for sale
Land for sale near me	Pittsburgh, PA homes for sale	Media, PA homes for sale
Open Houses near me	West Chester, PA homes for sale	Columbia Property Records
Condos for sale near me	Lancaster, PA homes for sale	PA New Listings
Agents near me	Bethlehem, PA homes for sale	Columbia Housing Market

Lititz homes for sale
York homes for sale
Lancaster homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 17512, PA

Sale history for 4240 Fairview Rd

Tax history for 4240 Fairview Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 17512

Home values near 4240 Fairview Rd

More real estate resources