Motivated Seller! *** Attention Investors! *** Seize the opportunity to own a prime piece of commercial real estate in the heart of Columbia's bustling business district. This corner lot offers an unbeatable location with exceptional road frontage, ensuring your venture stands out in a thriving commercial hub. Zoned for general commercial use so lots of possibilities! Whether you envision a chic retail boutique, a fast-casual diner, a modern office space, or an innovative service center, this property is the blank canvas on which you can bring your entrepreneurial dreams to life. With surrounding retail stores and gas stations, the area offers a constant flow of potential customers and ample exposure for your business. The visibility of the lot makes it a standout option for investors
Booker Washington Heights, located between North Main Street and River Drive, is a residential and historic Columbia neighborhood with a grid of shaded blocks and a close-in riverfront edge. The neighborhood’s character concentrates around the North Main Street corridor near River Drive, where corner markets, barbershops, and small eateries set a steady daytime rhythm. Modest early- to mid-century houses and older cottages sit beside newer infill, giving the streetscape a layered, lived-in look. Riverfront paths and open lawns at nearby parks shape an outdoors-forward routine. Community life often orbits local gathering spots such as The War Mouth, Curiosity Coffee Bar, and The Nickelodeon Theatre.
Provided by Walk Score and Local Logic
Property details
Interior
Exterior
Interior features
No interior details provided
Exterior features
Bus line access
Home design
Land parcel (vacant land)
Construction
Vacant land (no structures listed)
Utilities
Electricity connected
Water connected
Sewer at site
Sale and tax history for 3101 Farrow Rd
Sale History
Tax History
Date
Event
Price
Charleston Trident MLS #26004673
Jun 30, 2026
Price Changed
$49,900
May 20, 2026
Relisted
—
May 20, 2026
Listing Removed
—
Feb 19, 2026
Listed
$55,000
Charleston Trident MLS #25028919
Feb 20, 2026
Listing Removed
—
Feb 16, 2026
Price Changed
$55,000
Feb 2, 2026
Relisted
—
Feb 1, 2026
Listing Removed
—
Jan 1, 2026
Relisted
—
Jan 1, 2026
Listing Removed
—
Nov 14, 2025
Price Changed
$60,000
Oct 27, 2025
Listed
$75,000
Consolidated MLS #613000
Oct 12, 2025
Delisted
—
Jul 13, 2025
Listed
$75,000
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Vacant Land
County
Richland County
APN
11504-30-30
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 27, 2025.
Historical weather
Columbia, SC • 29203
Average low and high temperatures (°F)
54
32
62
40
74
47
81
55
83
62
92
70
95
75
89
70
85
65
76
53
69
46
58
37
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
100/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.