Features & Amenities

Interior

  • Total Bedrooms

    3

  • Bathrooms

    1

  • Above Grade Finished Area

    1217.0

  • Basement YN

    YES

  • Cooling YN

    NO

  • Cooling

    None

  • Fireplace YN

    NO

  • Heating YN

    YES

  • Heating

    Natural Gas, Forced Air

  • Pet friendly

    N/A

Exterior

  • Garage

    No

  • Construction Materials

    Brick

  • Parking

    On Street

  • Pool

    Yes

  • Pool Features

    None

  • Waterfront YN

    NO

Area & Lot

  • Lot Size(acres)

    0.03

  • Property Type

    Residential

  • Property Sub Type

    Duplex

  • Architectural Style

    Traditional

Price

  • Sales Price

    $185,000

  • Tax Amount

    1968.0

  • Sq. Footage

    1, 217

  • Price/SqFt

    $152

HOA

  • Association

    NO

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    N/A

Property Features

  • Foundation Details

    Stone

  • Senior Community YN

    NO

  • Sewer

    Public Sewer

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

LANCASTER

Elementary School

Middle School

High School

Listing Courtesy of Parker Wolfe , Prime Home Real Estate, LLC

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent TheresaKehler

Owner, President, Investment Property Advisor

TheresaKehler

Call Theresa today to schedule a private showing.


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
Welcome to 638 Fairview Ave! This traditional 3 bed 1 bath blends affordability with high-end finishes. Notice the painted gray exterior as you walk into the living room. Immediately you will notice the refinished hardwood floors, fresh paint, and new ceiling fan. The living room flows into the dining room which is spacious and has a coat closet. The kitchen has new vinyl floors, countertops, Shakir cabinets, and appliances. The mudroom off the kitchen leads to the backyard. Upstairs you have 3 true bedrooms which boast lots of utility including a bedroom, kids playroom, or office. The bathroom has new flooring and a tub shower. The bones are great also with vinyl windows, forced air heat, natural gas fuel, and a 2025 roof. This is your opportunity to own a 1,217 sq ft remodeled gem at an affordable price point! Don't miss the chance to make this your home and schedule a showing today!

638 FAIRVIEW AVENUE

Message successfully sent.

What would you like to know?

Related Properties

Beautiful country lot with very convenient location and many opportunities. This would be an excellent opportunity to remove the mobile home and potentially receive good credit towards stormwater for impervious surface. Also a great rental opportunity as the mobile home is in great condition.*Please note that it is not likely anyone can get a normal conventional mortgage on this property due to the age of the mobile home although it is in excellent condition
#PALA2075698

COLUMBIA

3806 LOCUST GROVE ROAD

2 Beds

1 Baths

672 Sq.Ft.

$149,900

MLS#: PALA2075698

Discover the perfect blend of charm and convenience in this 3-bedroom home located in the heart of Columbia. Step inside to find wide plank floors that add warmth and character throughout, tons of natural daylight from tall windows ,  a spacious formal dining room ideal for gatherings. The 2nd floor is home to 2 bedrooms including the primary bedroom w/ walk in closet and a large bathroom designed for comfort. A detached garage provides excellent storage space, perfect for tools, hobbies, or seasonal items. Situated in a vibrant town along the Susquehanna River, this home offers easy access to everything Columbia has to offer—unique shops, dining, local art and culture, and exciting water activities. Whether you’re strolling downtown, kayaking on the river, or exploring the area’s rich history, you’ll love calling this community home.
#PALA2075650

COLUMBIA

282 S 4TH STREET

3 Beds

1 Baths

1,542 Sq.Ft.

$199,000

MLS#: PALA2075650

Welcome to 139 Bethel Street! This clean and updated 3 bedroom twin on a quiet one-way street presents an affordable entry point in a desirable location in Columbia borough. This could could be a great rental property or personal residence. Schedule your tour before this opportunity is gone!
#PALA2074678

COLUMBIA

139 BETHEL STREET

3 Beds

1 Baths

1,187 Sq.Ft.

$164,900

MLS#: PALA2074678

Charming 4 Bedroom Home in Peaceful Columbia, PA – A Must See!
Welcome to your dream home in the heart of Columbia, Pennsylvania! This delightful 4-bedroom, 2-bathroom residence offers an abundance of space, comfort, and potential, perfect for growing families or anyone seeking a serene lifestyle.
Key Features:
- Spacious Living:With four generously sized bedrooms, there’s ample room for everyone to spread out. Each room is designed to be comfortable and inviting, ideal for rest and relaxation.
  
- Modern Amenities: Enjoy two full bathrooms that provide convenience and privacy for your family and guests. The layout is designed for modern living while retaining a cozy feel.
- Large Yard: Step outside to your expansive yard, perfect for outdoor activities, gardening, or hosting gatherings. This outdoor space is a rare find and offers endless possibilities for creating your own private oasis.
- Potential Parking:The property includes a potential area for parking in the back, providing easy access and convenience for vehicles or recreational toys.
- Bonus Storage: A fully enclosed spare room serves as extra storage space or could be transformed into a workshop or hobby area, catering to your unique needs.
- Friendly Neighborhood: Nestled in a quiet, friendly community, this home is surrounded by amenities including parks, shopping, dining, and more. Enjoy the peace of suburban living while being just a short drive away from modern conveniences.
Location:Conveniently situated in Columbia, this property offers easy access to major roadways, making commutes to nearby cities a breeze.
Whether you’re entertaining friends or enjoying a quiet evening in your private garden, this home offers the perfect blend of comfort and functionality. Don’t miss out on this incredible opportunity to own a piece of Columbia – schedule your viewing today!
#PALA2063938

COLUMBIA

913 SPRUCE STREET

4 Beds

2 Baths

1,358 Sq.Ft.

$195,900

MLS#: PALA2063938

Welcome to this beautifully updated end-of-row home, complete with a picture-perfect white picket fenced yard. Originally built in 1890 and fully renovated in 2025, this charming residence offers the perfect blend of historic character and modern convenience.

Inside, you'll find 816 square feet of intelligently designed living space—cozy, stylish, and incredibly functional. The inviting covered front porch is ideal for relaxing summer evenings. Step into the warm and welcoming living area, featuring exposed brick, refinished hardwood floors, and a cozy fireplace that anchors the space.

The open-concept living and dining area flows effortlessly into the brand-new white kitchen, outfitted with quartz countertops, a sleek tile backsplash, and all-new appliances—perfect for entertaining or enjoying everyday living.

This home offers two beautifully appointed full bathrooms, including a luxurious first-floor walk-in shower. A convenient first-floor bedroom and laundry area make for easy single-level living if desired.

Flooded with natural light and full of charm, this home is a rare find. Don’t miss your chance to own this nugget-sized treasure—
#PALA2074220

COLUMBIA

365 S 3RD STREET

3 Beds

2 Baths

816 Sq.Ft.

$212,000

MLS#: PALA2074220

 - property

Send a message

Message successfully sent.

Your message

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to receive some additional information on this specific property or similar properties?

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here