Columbia SC Zip Code 29205 Homes For Sale | James Schiller Team

Live beautifully. Invest intelligently.Located in the heart of Shandon, this rare dual-residence property offers charm, flexibility, and built-in income potential. The main home features 3 bedrooms and 2 full baths, while the detached carriage house provides a private 1-bedroom, 1-bath retreat — ideal for guests, long-term tenants, or short-term rental income.Short-term rental permits will transfer to the new owner per City of Columbia, offering immediate opportunity for continued revenue.Whether you’re looking to offset your mortgage, build your portfolio, or secure a prime location property with multiple income streams, this one checks every box. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Do not miss out on this awesome opportunity just steps away from the University of South Carolina campus! The front house was rebuilt from the studs in 2019 with all new plumbing, electrical, HVAC & ductwork, roof, windows, flooring & appliances. This house has four bedrooms (2 downstairs) and three full baths. The old house charm is still present along with an inviting, open floor plan! Across the large back yard you have the second house, also totally renovated in 2019. This house has three beds, two full baths, kitchen, dining room, den and a large laundry/storage area. There is a ton of space between the houses for parking, a firepit...anything you dream up! Catawba St. is right in the middle of the best features of Columbia: the USC campus, parks and rivers, great shopping and restaurants, and beautiful downtown neighborhoods. This is a must see!! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Situated on the prettiest block in Wales Garden, this classic two-story brick home blends timeless architecture with thoughtful modern updates in one of Columbia’s most cherished historic districts. Offering more than 2,400 square feet, the home features four bedrooms and two and a half baths, all carefully renovated by the current owners to enhance both function and style. Updates to the kitchen, bathrooms, fixtures, and finishes were completed with intention—preserving character while elevating everyday living. The formal layout provides gracious, well-defined spaces, beginning with a spacious living room anchored by a fireplace and flanked by built-in bookshelves—large enough to comfortably accommodate a baby grand piano. Just beyond, a bright sunroom offers the perfect setting for morning coffee or a quiet afternoon with a good book. The formal dining room sits conveniently adjacent to the kitchen, creating an ideal flow for hosting and gathering. The renovated kitchen features quartz countertops, a tiled backsplash, stainless steel appliances, and easy access to the mudroom. From there, step out to the driveway or into the beautifully landscaped backyard, where a thoughtfully designed patio surrounded by lush greenery creates a private outdoor retreat—perfect for enjoying South Carolina’s spring evenings. With its historic charm, curated updates, and convenient downtown location, this Wales Garden home is ready for its next chapter and its next owner. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

This charming brick bungalow in the heart of Rosewood blends classic character with thoughtful modern updates. Beautiful hardwood floors run throughout, creating a warm and inviting feel from the moment you step inside. The living and dining areas flow seamlessly at the front of the home, offering an ideal layout for both everyday living and entertaining.The galley-style kitchen features white tile backsplash, granite countertops, and stainless steel appliances—delivering both style and functionality. There's three bedrooms and two full bathrooms, including a private primary suite with a tiled shower and separate his-and-her closets. A spacious laundry room provides flexibility, with plenty of room to incorporate a home office setup or workout area. Outside, the detached garage offers secure storage for tools and outdoor equipment and is equipped with a NEMA 14-50 outlet—perfect for EV charging or high-powered appliances. Located just minutes from both Garners Ferry and the Assembly Street corridor, this home puts you close to everything. The growing Rosewood Drive is filled with local restaurants, fitness studios, and unique shops, making it one of Columbia’s most vibrant and convenient neighborhoods. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Don't miss the one level home in Melrose Heights on quiet section of Pickett St. This is an adorable brick bungalow on a quiet tree lined street in highly desirable neighborhood. A short walk to dining and shopping along Millwood Ave. There are 3 bedrooms, 2 baths plus and extra room which makes a great home office/library. The living room has a classic fireplace with interior historical period updates throughout. Look at those gorgeous hardwood floors! This home is situated on a wonderful lot with a great fenced backyard for entertaining family and friends. A covered back deck to relax on and unwind from a busy day. It even has a workshop/ She-shed which is a gardener's delight! Encapsulated crawlspace, 2025 HVAC and Inline tankless water heater add to this Great value in Melrose Heights! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Welcome to 3812 Duncan Street — a beautifully maintained 3-bedroom, 2-bathroom bungalow nestled in the heart of the desirable Sherwood Forest neighborhood. This home blends classic character with modern updates, featuring a beautifully renovated kitchen, and a recently added spacious primary en-suite bathroom and generous walk-in closet. Enjoy a screened in front porch, newly refinished hardwood floors, abundant natural light, and a functional layout perfect for everyday living or entertaining. The kitchen opens to a cozy dining area, and the living room provides a warm and inviting space to relax. Outside, the large, fenced-in backyard offers a private retreat with room to garden, entertain, or simply unwind. It is beautifully landscaped with mesh netting underneath all pinestraw throughout the yard. Located just minutes from downtown Columbia, USC, and Devine Street shops and dining, this home offers the perfect blend of charm, comfort, and convenience.Don't miss your chance to own a move-in-ready gem in one of Columbia’s most beloved neighborhoods! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Are you looking for an updated, move-in ready and fully furnished home in the desirable Rosewood community! Welcome to 4105 Beecliff Drive. This all-brick, all white ranch welcomes you with a charming covered front porch, perfect for relaxing and enjoying the neighborhood. Inside, you’ll find beautiful hardwood flooring throughout and a bright, inviting layout. The spacious living area flows seamlessly into the updated eat-in kitchen featuring granite countertops, painted cabinetry, bar seating, recessed lighting, and modern finishes. All three bedrooms have hardwood floors, ceiling fans, and ample closet space, with a shared full bath designed for everyday convenience. Step outside to enjoy the patio and generously sized backyard, with plenty of space for entertaining, gardening, or simply unwinding. Conveniently located near shopping, dining, and downtown Columbia, this thoughtfully renovated home is ready for its next owner. Schedule your showing today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Charming 3-bedroom, 2-bath home in the highly desirable Shandon neighborhood. This home offers a functional layout with comfortable living spaces and well-sized bedrooms. Major updates include windows replaced in 2024, HVAC and gas water heater installed in 2024, and a newer roof (2024).Conveniently located near Devine Street shopping and dining, downtown Columbia, the University of South Carolina, and Fort Jackson. An excellent opportunity for owner-occupants or investors seeking a prime location. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

What was once a neighborhood corner store in the heart of Shandon has been thoughtfully transformed into a warm and welcoming home full of character and charm. Lovingly maintained by its current owners, this unique property offers more than 1,800 square feet of comfortable, functional living space in one of Columbia’s most walkable neighborhoods. Inside, you’ll find a spacious layout that includes a formal dining room, three bedrooms, and two full bathrooms. The open kitchen flows easily into the main living areas, creating an inviting space for everyday living and entertaining. Just off the back of the home, a generous deck provides the perfect setting for enjoying South Carolina’s spring and summer evenings. The primary suite offers a private retreat with direct access to the deck, dual vanities, a walk-in closet, and convenient access to the laundry room. Every detail reflects care and thoughtful upkeep. With a walkability score that feels like a 10, you’re just minutes from the shops, restaurants, and local favorites along Devine Street, and a quick commute to downtown Columbia. This former corner store turned charming residence is a rare opportunity to own a piece of Shandon history—reimagined for modern living. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.