INCREDIBLE LIVE/WORK OPPORTUNITY! Situated on approximately . 88 acre, this unique property combines approximately 2,500 square feet of heated and cooled interior space with an attached approximately 1,500-square-foot insulated warehouse, creating exceptional possibilities for someone looking to combine home, business, workshop and storage space in one location. Originally constructed as a residence, the property was later converted for use as a plumbing business with a showroom, offices and warehouse. The current configuration presents an exciting opportunity to reimagine the property as a residence with an attached workspace. Conceptual redesign photos included with the listing illustrate one possibility for transforming the former showroom into an impressive open-concept kitchen, dining and great room, while creating a private owner's suite with ensuite bath. Much of the framework for a residential conversion is already in place. The showroom is currently outfitted with extensive kitchen cabinetry and plumbing, providing an excellent starting point for a future kitchen. Several interior display and partition walls could be removed to create a large, open living area. Multiple existing rooms provide flexibility for potential bedrooms, home offices or other uses. A full bathroom with toilet, bidet and shower is already in place, along with a separate laundry room and sunroom. The sunroom provides access to the attached approximately 1,500-square-foot insulated warehouse, featuring high ceilings, two garage doors, loading access, a dedicated valve room, additional office and half bath. Whether used for a business, workshop, equipment, vehicles, hobbies or storage, this is space rarely found attached to a property with residential potential. Outside, the approximately . 88-acre property includes abundant front parking with room for residents, guests, clients or employees. Additional features include a fuel tank, irrigation system, Koi pond, gutters with leaf guards and loading dock. For the entrepreneur, contractor, tradesperson, collector, hobbyist or buyer who simply wants substantial workspace at home. Disclaimer: CMLS has not reviewed and, therefore, does not
West Metro, located between the Congaree River and I-26, is a residential and commercial West Columbia neighborhood with a riverfront edge and a warehouse-to-workshop streetscape. The neighborhood’s character concentrates around the Meeting Street and State Street corridor, where patios, murals, and small storefronts set a steady, walkable rhythm. Terra draws a loyal following for seasonal plates in a converted industrial space. State Street Trading Co. anchors the daytime scene with coffee and a curated retail mix. The Riverwalk and Amphitheater adds open-air concerts and long views across the water. Housing ranges from mid-century ranches to newer infill near the main corridors.
Provided by Walk Score and Local Logic
Offer insights
301 Ramblin Rd · $279,900
$280K and above
75% chance or better to win
Why $280K+ is a strong offer
DAYS ON MARKET
29 days
The average home goes pending in 50 days.
SALE-TO-LIST
98.2%
Most homes are selling 2% below list price.
About offer insights
Property details
Interior
Exterior
Finance
Kitchen
Bedroom
Living
Interior features
Central heating and central air conditioning
Bedrooms
Master bedroom on the main level
Bedrooms 2–4 on the main level
Bathrooms
One full bathroom on the main level
Kitchen
Kitchen located on the main level
Laundry & utility
Washer and dryer area on the main level
Heating & cooling
Central heating
Central cooling
Exterior features
Brick exterior above the foundation
Paved road access
Approximately 0.88-acre lot
Home design
Single-story home
Parking
Attached side-entry garage (2 garage spaces)
Total of 20 parking spaces
Garage located on the lower level
Construction
Slab foundation
Utilities
Public water
Septic sewer
Electricity and solar
View estimated energy costs and solar savings for this home
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
Single Family Residential
County
Lexington County
APN
007797-01-008
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 28, 2026.
Historical weather
West Columbia, SC • 29170
Average low and high temperatures (°F)
54
32
62
40
74
48
81
56
83
63
91
70
95
75
85
70
85
65
76
54
69
47
58
37
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
99/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 14% for direct sun exposure in West Columbia. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.7 hrs
6.9 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 301 Ramblin Rd
$277,554
$2,346 under list price of $280K
More resources
Rental earnings
Est. $1,592 per month, based on comparable rentals
Tour for free, no strings attached
Make a winning offer with the help of a local agent