OFF MARKET

Off market sep 2025 for $429K

$461,447

Studio

•

— ba

•

3,250

sq ft

4220 Fairview Rd, Columbia, PA 17512

About this home

20 mile view of western Lancaster County. Formerly a bar and restaurant with 3-4 bedroom apartment on second floor and a dry, clean basement. Much of the building has been renovated and updated. Parking for 15 cars. See attached zoning information document. These restrictions: No marijuana or liquor sales. POSSIBLE RENTS SHOWN ARE PROJECTED. The basement floor is 25 yards of fibered concrete. The floors and rafters are heavy duty 2 x 12's. MUST SEE INSIDE TO APPRECIATE. R-3 ZONING. ADJACENT LOT AVAILABLE 55'x100'. Est. daily traffic count: 7,500 (PennDOT Traffic Information Repository)

Multi-familyProperty Type

1941Year Built

7,405 sq ftLot Size

$142Est. Price/Sq.Ft.

15 spacesParking

Listed by Spencer Speros • A' La Carte Realty Services LLC

•717-808-1942 (broker)

•ssperos@comcast.net (broker)

Bought with Spencer Speros • Farm Folk

•717-629-6658 (broker)

•farmfolk1@gmail.com (broker)

Redfin checked: 2 minutes ago

•Source:BRIGHT MLS #PALA2020300

Redfin Estimate

$461,447

$32K since sold in September 2025$5,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 31.9% higher than the average sale price ($350K) of 6 comparable homes.

SOLD SEP 17, 2026
$305,000
A
3 beds1.5 baths1,660 sq ft
4533 Miller Dr, Mount Joy, PA 17552
SOLD JUL 21, 2026
$305,000
B
3 beds1 bath1,620 sq ft
1220 Ironville Pike, Columbia, PA 17512
SOLD AUG 28, 2026
$380,000
C
2 beds2.5 baths2,868 sq ft
3932 Laurel Run, Columbia, PA 17512
SOLD FEB 12, 2026
$373,500
D
3 beds1.5 baths2,066 sq ft
2640 Hemlock Dr, Columbia, PA 17512
SOLD JUN 26, 2026
$345,000
E
3 beds2 baths1,618 sq ft
4309 Marietta Ave, Columbia, PA 17512
SOLD JUN 26, 2026
$389,900
F
3 beds2 baths1,440 sq ft
2637 Hemlock Dr, Columbia, PA 17512

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

Market trends in 17512, PA

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

101.1%

0.0% MoM

Median sale price

$300K

$20K MoM

Avg. days on market

13d

6 days MoM

Recently sold homes

13 MoM

New listings for sale

NEW 16 HRS AGO
$125,000
3 beds1.5 baths1,550 sq ft
841 Houston St, Columbia, PA 17512
(717) 393-0100
$298,000
3 beds2 baths1,577 sq ft
555 Maple St, Columbia, PA 17512
(717) 560-9100
$265,000
4 beds2.5 baths2,658 sq ft
240 N 3rd St, Columbia, PA 17512
(717) 757-7811
$334,901
3 beds2 baths2,752 sq ft
439 N 5th St, Columbia, PA 17512
(610) 484-8663
$162,500
3 beds1 bath1,785 sq ft
447 3rd St, Columbia, PA 17512
(717) 740-2221
$162,500
3 beds1 bath1,905 sq ft
445 3rd St, Columbia, PA 17512
(717) 740-2221
$289,900
4 beds2.5 baths1,857 sq ft
122 N 8th St, Columbia, PA 17512
(717) 553-2500
$169,900
2 beds1 bath1,000 sq ft
290 S 5th St, Columbia, PA 17512
(877) 366-2213
See all

Provided by Redfin

Sale history for 4220 Fairview Rd

Public record

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Multi-Family (2-4 Unit)

County

Lancaster County

APN

300-65897-0-0000

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jun 8, 2023.

Property details

Parking

Parking Information
# of Total Garage and Parking Spaces: 15
Parking Lot - # of Spaces: 15
Lighted Parking, Private
Parking Lot

Interior

Virtual Tour

Interior Information
Appliances: Air Cleaner, Built-In Microwave, Built-In Range, Commercial Range, Dishwasher, Dryer - Electric, Refrigerator, Range Hood, Stainless Steel Appliances, Stove, Washer
Flooring Type: Carpet, Concrete, Vinyl
Interior Features: 2nd Kitchen, Air Filter System, Bar, Carpet, CeilngFan(s), Store/Office, Kitchenette, Kitchen - Eat-In
Living Area Sq.Ft. Source: Estimated

Basement Information
Basement: Yes
Connecting Stairway, Daylight, Full, Drain, Garage Access, Improved, Interior Access, Outside Entrance, Side Entrance, Shelving, Sump Pump, Unfinished, Walkout Level, Windows, Workshop

Multi Unit Information
# of Single Room Units: 2
# of Vacant Units: 2
Gross Income: $52,715
Gross Scheduled Income: $52,715
Income Includes: Apartment Rentals, Shop Rentals

Exterior

Property Information
Total Below Grade Sq. Ft.: 1600
Accessibility Features: >84" Garage Door, 2+ Access Exits, 32"+ wide Doors, 36"+ wide Halls, Level Entry - Main
Improvement Assessed Value: $167,900
Ownership Interest: Fee Simple
Property Condition: Very Good
Year Built Source: Assessor
Year Major Reno/Remodel: 2021

Building Information
# of Levels (Total): 3
# of Units (Total): 2
Construction Materials: Copper Plumbing, Vinyl Siding, Block
Foundation Details: Block
Other Structures: Above Grade, Below Grade
Roof: Rubber
Structure Type: Detached
Window Features: Double Pane, Insulated

Exterior Information
Exterior Lighting, Fire Escape

Lot Information
Lot Features: Corner, Level, Road Frontage
Lot Size Dimensions: 60x141
Lot Dimensions Source: Estimated
Tidal Water: No

Land Information
Land Assessed Value: $52,300

Above Grade Information
Finished Sq.Ft.: 3,250
Finished Sq.Ft. Source: Estimated

Below Grade Information
Unfinished Sq.Ft.: 1,600
Unfinished Sq.Ft. Source: Estimated
Finished Sq.Ft. Source: Assessor

Financial

Tax Information
City/Town Tax: $429
County Tax: $641
School Tax: $3,895
Tax Assessed Value: $220,200
Tax Year: 2023
Tax Annual Amount: $4,965

Assessments Information
Year Assessed: 2023

Lease Information
Existing Lease Type: None

Rental Information
Total Actual Rent: $52,715

Utilities

Utilities Information
Central Air
Cooling Type: Ceiling Fan(s), Central A/C
Cooling Fuel: Electric
110 Volts, 220 Volts, 200+ Amp Service
Baseboard - Electric, Forced Air, Central
Heating Fuel: Electric, Propane - Owned
Hot Water: Propane
Sewer Septic: Public Sewer
Cable TV, Electric Available, Propane, Sewer Available, Water Available
Water Source: Public

Location

School Information
School District Name: HEMPFIELD
School District Source: Listing Agent

Location Information
Cross Street: prospect
Directions: Approximately 1.5 miles from 283 Bypass & Route 30. From Route 30, head north on Prospect Road. Property will be approximately 1.5 miles on the left at the corner of Fairview Road and Prospect Road 4.5 miles from 283 bypass.
Location Type: Corner Lot/Unit
Municipality: WEST HEMPFIELD TWP
Road Frontage Length: 141
Road Surface Type: Black Top

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Multi-Family (2-4 Unit)
Year Built: —
Year Renovated: —
County: Lancaster County
APN: 300-65897-0-0000

Home facts updated by county records on Jun 8, 2023

Around this home

Schools

Farmdale Elementary 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

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

$439,000 – $531,000

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

Nearby similar homes

NEW 13 HRS AGO

$499,900

5 beds2.5 baths2,909 sq ft

5820 Main St, East Petersburg, PA 17520

(877) 366-2213

$287,900

4 beds2 baths1,997 sq ft

236 N Franklin St, Lancaster, PA 17602

(717) 354-6416

$309,900

2 beds— baths1,518 sq ft

347 N Reservoir St, Lancaster, PA 17602

(717) 553-2500

$274,900

4 beds1 bath1,615 sq ft

134 W Walnut St, Marietta, PA 17547

(717) 757-2717

$245,000

3 beds1 bath1,518 sq ft

17 W Cottage Ave, Millersville, PA 17551

(717) 735-8400

$775,000

5 beds4 baths4,792 sq ft

701-703 N Duke St, Lancaster, PA 17602

(717) 392-0200

New listings for sale in 17512

NEW 16 HRS AGO

$125,000

3 beds1.5 baths1,550 sq ft

841 Houston St, Columbia, PA 17512

(717) 393-0100

$298,000

3 beds2 baths1,577 sq ft

555 Maple St, Columbia, PA 17512

(717) 560-9100

$265,000

4 beds2.5 baths2,658 sq ft

240 N 3rd St, Columbia, PA 17512

(717) 757-7811

$334,901

3 beds2 baths2,752 sq ft

439 N 5th St, Columbia, PA 17512

(610) 484-8663

$162,500

3 beds1 bath1,785 sq ft

447 3rd St, Columbia, PA 17512

(717) 740-2221

$162,500

3 beds1 bath1,905 sq ft

445 3rd St, Columbia, PA 17512

(717) 740-2221

$289,900

4 beds2.5 baths1,857 sq ft

122 N 8th St, Columbia, PA 17512

(717) 553-2500

$169,900

2 beds1 bath1,000 sq ft

290 S 5th St, Columbia, PA 17512

(877) 366-2213

Home values near 4220 Fairview Rd

Data from public records.

Address	Redfin Estimate
4251 Fairview Rd, Columbia, PA 3 Beds \| 1 Baths \| 2250 Sq. Ft.	$340,446
4240 Fairview Rd, Columbia, PA 3 Beds \| 1 Baths \| 1425 Sq. Ft.	$330,853

Address	Redfin Estimate
4270 Fairview Rd, Columbia, PA 3 Beds \| 1 Baths \| 1128 Sq. Ft.	$264,150
4273 Fairview Rd, Columbia, PA 3 Beds \| 1.5 Baths \| 1292 Sq. Ft.	$335,058

Address	Redfin Estimate
4260 Fairview Rd, Columbia, PA 2 Beds \| 1 Baths \| 1728 Sq. Ft.	$361,733
729 Ferndale Rd, Mount Joy, PA 3 Beds \| 1.5 Baths \| 1392 Sq. Ft.	$301,059

Property information provided by BRIGHT MLS when last listed in 2022. 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 rent in Columbia	Agents near me	Bethlehem, PA homes for sale	Columbia Housing Market
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

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