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

Prime investment opportunity located downtown and just across from Providence Hospital. This newly constructed property offers incredible potential for USC parents, Airbnb hosts, medical personnel or savvy home hackers. Fully furnished and currently turnkey AirBnB with management in place with Heartwood. Property grandfathered in as AirBnB in Columbia. With 6 spacious bedrooms and 6 bathrooms, this property is designed to maximize rental income and convenience. The building boasts a sleek, modern design creating a stylish and functional space. The private parking pad in the back provides convenient, off-street parking adding additional privacy and security. Whether you’re seeking a student rental or a flexible living arrangement, this property offers versatility and a strong potential return on investment. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

1825 Saint Julian Place, Unit 12-I, Columbia, SC 29204Welcome to this spacious 2-bedroom, 2-bath condo located in the heart of Forest Acres. This home features an open living area, a bright kitchen, and an incredible screened balcony porch with sweeping views.The building offers secure access, onsite parking, and a community pool for your enjoyment. Conveniently located just minutes from Forest Acres shopping, dining, and everyday necessities, this condo provides affordable living in one of Columbia's most desirable areas. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Welcome home to this classic split level, mid-century modern, all brick home, northeast of downtown Columbia, in a quaint neighborhood, just mintues from the heart of Forest Acres. This lovely home has been well maintained for many years and now it is time for it’s new owner. This spacious 3 bedroom, 2 full bath home has close to 1800 square foot of livable space, an attached garage, and a large backyard. In addition to the large living room, dining area, and kitchen, the lower level boasts a huge recreational room or den. Perfect for first time home buyers, investors, or someone who just wants to live in a charming neighborhood close to the amenities of Forest Acres, this one just awaits your finishing touches. Conveniently located near route 1, the 277, and just 11 minutes to USC, 11 minutes to the South Carolina State House downtown Columbia, and 17 minutes to Fort Jackson. This home has a newer roof, windows, kitchen cabinets and much more. This is being sold as is and is an estate sale. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Nice home in a great location convenient to Downtown Columbia, multiple hospitals, the University of South Carolina, Ft Jackson and two interstates. Newer Roof (1.5 years per owner) Two car garage with workshop/storage room, pull down attic, and convenient side entry door. There has been flooring installed in the attic covering most of the area over the garage for extra storage. Expansive living room comes complete with ten foot ceilings, two ceiling fans, built-in book shelves and a custom wood burning fireplace and hearth with granite surround. Large eat-in kitchen boasts custom maple cabinets, free standing self cleaning range, and a dishwasher. Good size heated laundry room with lots of shelving and a utility sink complete with sprayer. Spacious master bedroom highlighted by tray ceilings, walk-in closet, second closet with a built in maple dresser, wooden blinds and a private bathroom complete with tile floors. Both secondary bedrooms have private closets. One has a 9 foot cathedral ceiling and the other has built in maple shelving and cabinets. Custom blinds and window treatments through out the home. Guest bathroom with a new tub shower (per owner). Relaxing screened in porch overlooking a cozy back yard. Extensive flower bedding varieties across the breath of the yard. All this and the house is within walking distance of Bradley Elementary and Sanders Middle School. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Completely remodeled and move-in ready, this stunning 3-bedroom, 1-bath home offers modern style and effortless living. The open living space flows seamlessly into a brand-new kitchen featuring new cabinetry, granite countertops, stainless steel appliances and updated finishes throughout. Enjoy peace of mind with a completely renovated bathroom, new LVP flooring throughout the home, new windows, a new roof, and new systems—basically new everything! A one-car attached carport adds convenience and the low maintenance fenced in yard is great everyone from the fur babies to the humans! The prime location provides easy access to Forest Acres, downtown Columbia, shopping, dining, and more. This beautifully updated home is a must-see. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

This fully renovated, one-of-a-kind condo is a downtown hidden gem—offering more space, more privacy, and more luxury than anything else in this price range. High-end updates include custom cabinetry, marble countertops, LVP flooring, recessed lighting, updated electrical and insulation, new windows, and a Bosch washer/dryer. The owner’s suite features his/her closets and a large walk-in shower, while the spacious second bedroom with dual closets outshines most others you’ll find in downtown condos. The kitchen/living areas look out onto covered patio with your own garden space, equipped with ceiling fan, epoxy flooring, and storage room. The glass doors to outdoor space and courtyard have been treated to provide complete privacy with one way glass. Enjoy the view of the lightscaped courtyard from inside your home! This unit is also just a few short steps to the pool. Best of all, it’s an easy walk to the Richland Fashion Mall redevelopment—Kroger, brewery, restaurants, retail, and a new park—tucked away in a quiet location right in the heart of Columbia. Luxury finishes. Walkable living. Hidden-gem value. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Located in the highly desirable and well-established Forest Hills neighborhood, this beautifully updated 4-bedroom, 3-bath home offers a prime location just minutes from downtown Columbia. Inside, you’ll find a thoughtfully updated kitchen featuring bar seating and an open flow to the living space—perfect for entertaining and everyday living—filled with bright natural light. The spacious primary suite boasts an updated en suite bath with a modern zero-clearance shower. Numerous updates throughout provide peace of mind, including a newer roof (2022) and HVAC system (2023). Enjoy the charm of an established neighborhood paired with modern updates in one of Columbia’s most sought-after locations. Come take a look! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Prime location zoned Mixed Used (MU-1) Residential/Commercial Development in the heart of Columbia, SC! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Welcome home to this beautifully maintained 4BR/3BA split-level home offering flexible living spaces and thoughtful updates throughout. Freshly painted, the main level features a spacious formal living room with fireplace, formal dining room, and a kitchen with granite countertops, tile flooring, and eat-in area. Off the kitchen, a large sunroom provides the perfect spot for relaxing or entertaining year-round. Upstairs, you’ll find three bedrooms, including the primary suite, and two full baths. The primary suite has a deck leading down to the hot tub, perfect for taking a soak on cool evenings. The lower level includes a fourth bedroom (ideal for guests or a home office), a full bath, laundry room, and a cozy den with gas-log fireplace and private entrance. Enjoy outdoor living with an expansive deck, workshop, and storage shed. Additional highlights include a brand-new roof (October 2025), updated windows, carport, and no HOA. Conveniently located near shopping, dining, and top-rated schools in the heart of Forest Acres! Schedule your tour today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.