$625,000
About this home
A RARE MELROSE HEIGHTS GEM WITH AN EXTRAORDINARY BONUS. 1201 Fairview Road is one of those rare finds that offers character, lifestyle, and an opportunity you almost never see in Melrose Heights. Set along one of Columbia’s most beloved in-town neighborhoods, this beautifully maintained brick bungalow with a welcoming front porch offers the timeless appeal of classic architecture paired with an exceptionally versatile layout. Step outside your front door and into the walkable lifestyle that makes Melrose Heights so coveted—with Melrose Market, Crave, neighborhood coffee shops, fitness studios, and more all nearby. Zoned for Brennen Elementary, Crayton Middle, and AC Flora. Inside, the main residence is filled with warmth and character, featuring gleaming hardwood floors, generously proportioned rooms, and beautiful natural flow. The main level offers two spacious bedrooms, a full bath, an inviting living room, elegant dining room, well-designed kitchen, and convenient laundry nook. Upstairs, a private loft-style retreat creates an entirely separate-feeling space with an additional bedroom and full bath - the ideal primary retreat. THEN, THERE IS THE COTTAGE. Tucked discreetly behind the main residence is an extraordinary detached cottage of nearly 350 square feet, a feature that makes this property truly exceptional. Thoughtfully designed with a full bathroom, charming vintage-inspired kitchenette, and flexible living/sleeping space, the cottage offers a level of versatility rarely found in this location. Imagine a private guest retreat, multigenerational living quarters, a sophisticated home office or creative studio—or an opportunity to explore additional income potential.The cottage enjoys its own private fenced courtyard, creating a beautifully intimate outdoor setting separate from the main home’s backyard. The primary backyard is equally special, with a large entertaining deck, lush lawn, established garden space, and greenhouse. Timeless brick architecture, walkable location, detached charming cottage - 1201 Fairview. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Property details
- MLS #
- 642801
- Property type
- East Columbia
- Subdivision
- MELROSE HEIGHTS
- Status
- Active
- Days on market
- 13
- On market date
- September 11, 2026
- Stories
- 1.5
- Total bathrooms
- 3
- Garage spaces
- N/A
- Parking spaces
- N/A
- Lot size
- 0.17 acres
Location
Get directions →Nearby schools
Within 10 miles · public school directory data (NCES)
- Enrollment
- 762
- Student:teacher ratio
- 14.1:1
- District
- Richland 01
- Enrollment
- 948
- Student:teacher ratio
- 12.3:1
- District
- Richland 01
- Enrollment
- 1,401
- Student:teacher ratio
- 16.3:1
- District
- Richland 01
Walkability
Blended score for Columbia's center: EPA's National Walkability Index (street network, transit, land-use mix) combined with nearby-amenity density. 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in Columbia, from live MLS data.
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by Consolidated MLS (COLUMBIA) via Trestle/CoreLogic. Last updated 2 days ago.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.