Bayview Columbia SC Homes For Sale | James Schiller Team

? FULLY RENOVATED CHARM | NEW ROOF | PRIME LOCATION ?Step into luxury and history at 200 Ferrell Dr! This stunning 1947 ranch has been completely reimagined for 2026 living. Sitting on a massive corner lot, this home offers the perfect blend of modern convenience and classic Columbia soul.The "New" Everything:Roof & Systems: Brand-new roof (2026) for ultimate peace of mind.Kitchen: Sleek new appliances and modern finishes.Paint: Fresh, neutral designer paint throughout.Original Hardwoods: Take a look at those floors! The original wood in the family room and all bedrooms has been professionally re-stained to a deep, beautiful glow.Laundry Room: Unusually large laundry area—perfect for extra storage or a home organization hub.Detached Carport: Includes a dedicated storage/workshop area.Prime Spot: Minutes from Downtown Columbia and instant access to Highway 277. Whether you're commuting to USC, Prisma Health, or the State House, you are exactly where you need to be. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Wonderful opportunity for a value add triplex in 29204! One unit is practically move in ready, while the other two require some level or rehab. Ask agent for details. This rare chance to own a triplex will not last long! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Welcome to 5225 Two Notch Rd, a classic bungalow-style property that combines character, convenience, and opportunity. Ideally located just minutes from Downtown Columbia, the University of South Carolina, and Fort Jackson, with quick access to I-20 and I-77, this property sits in one of Columbia’s most connected corridors—perfect for both residential living and business visibility. Currently used as a residential home, this property is zoned for commercial use, offering incredible flexibility. Whether you envision it as a personal residence, home office, small business, or investment property, the possibilities are endless. Enjoy the convenience of a high-traffic location while maintaining the comfort and charm of a home setting—ideal for entrepreneurs, professionals, or investors seeking a work-live opportunity in the heart of Columbia. The 2-bedroom, 1-bath layout features a welcoming living area, a kitchen with brand-new luxury vinyl flooring, and a sunroom that can serve as an office, workout space, or dining area—adapting easily to your lifestyle or business needs. Outside, the fully fenced backyard includes a drive gate for secure, additional parking with rear access through a screened back porch—perfect for customers, employees, or guests. A separate cement pad at the back of the property provides endless options for outdoor entertaining, expansion, or business storage. The location truly shines—just minutes from major highways, employers, shopping, dining, and entertainment. Whether you're looking to bring a business to a highly visible corridor or create a home tailored to your style, 5225 Two Notch Rd offers a rare combination of convenience, flexibility, and potential. Bring your creativity and make this versatile property your next success story—live, work, or invest in one of Columbia’s most accessible locations! **MORE PHOTOS TO COME** Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.