29205 Homes with Hand Middle school

29205 Homes with Hand Middle school

Welcome to the vibrant zip code 29205, nestled in the heart of Columbia, South Carolina. This charming area, part of Richland County, is known for its rich history, lush landscapes, and a strong sense of community. Whether you're a first-time homebuyer or looking to settle down in a family-friendly neighborhood, 29205 offers a delightful blend of suburban tranquility and urban convenience.

The homes in this area are as diverse as the community itself, featuring a mix of historic architecture and modern designs. Tree-lined streets are adorned with beautifully maintained properties, creating an inviting atmosphere for residents and visitors alike. With a variety of local parks, shops, and eateries just a stone’s throw away, you'll find everything you need right at your fingertips.

One of the standout features of this zip code is its proximity to Hand Middle School. Known for its commitment to academic excellence and a supportive learning environment, this school is a major draw for families with children. Parents can rest easy knowing their kids have access to quality education just a short walk or drive from home.

In addition to the educational opportunities, 29205 boasts a vibrant cultural scene, with art galleries, theaters, and music venues that breathe life into the community. The nearby Riverbanks Zoo and Garden also offer family-friendly activities for all ages.

If you’re seeking a place that combines charm, convenience, and a strong community spirit, look no further than zip code 29205 in Columbia, SC. Your dream home awaits!

Newest 29205 Homes with Hand Middle school

$249,000
2 Beds ⋅ 1 Baths
Ready for divine living in Shandon? Look no further than the Historic Grandevine. This two-bedroom, one-bathroom, first floor condo is located in the wonderful, walkable Old Shandon district. You can relax by the pool or take a short walk to your favorite boutique or restaurant. just 0.2 miles from Cantina 76 and 0.3 miles from Eggs Up Grill. An easy walk to five points or USC. The condo offers high ceilings, large windows, granite countertops, hardwood floors, stainless steel appliances and in-unit washer and dryer. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

705 Maple St Unit G102, Columbia

Listing courtesy of Fathom Realty SC LLC.

$500,000
4 Beds ⋅ 2 Baths
Welcome to a rare opportunity in an incredible location! Just a short walk to Devine Street, Five Points, the University of South Carolina, and Emily Douglas Park, this charming 4 bed/2 bath Craftsman is full of character and classic Shandon charm.Inside, you'll find original hardwood floors, high ceilings, and plenty of natural light throughout. All four bedrooms are generously sized with ample closet space. The centrally located kitchen includes a pantry, utility closet, and an oversized sink.Outside, enjoy the deep covered front porch, a convenient pull-through circular driveway with additional parking along the side of the home, and a private backyard featuring a patio, fire pit, and a large workshop with an attached carport.The home has been refreshed with brand-new interior and exterior paint, fresh landscaping, and a professional deep clean. If you've been looking for a home with character in one of Columbia's most desirable neighborhoods, you won't want to miss this one. Schedule your showing today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

2410 Blossom St, Columbia

Listing courtesy of BHHS Midlands Real Estate.

$275,000
2 Beds ⋅ 1 Baths
Been looking for a Shandon original to turn into your dream home? Look no further than 3507 Yale Avenue! This 3 bedroom, 1 bathroom cream puff has been sitting vacant and lonely for around 25 years. It's time to bring it back to life! It's gonna need new plumbing, electric & hvac, but the bones are good and our inspectors were impressed with the condition, having been vacant for so long. Oh, and did I mention the unfinished walkup attic? So much potential here! We have 3 different plans already drawn up for renovation options, so you're halfway through the planning stage already if you like one. Conveniently located to everything on Rosewood, Devine & Five Points, you're right in the middle of all the action! And, of course, the schools in this area are top notch. Don't miss out on this one!! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

3507 Yale Ave, Columbia

Listing courtesy of Coldwell Banker Realty.

$1,025,000
3 one-story brick quadraplexes on one lot. Each quadraplex has just been extensively renovated July 2026. A total of approx 5,300 sq ft with 12 studio apartments all on a .60 acre lot. Rent rates are projected at $925/unit per month or $133,200 per year. The seller has prepared this asset for a seamless transition by fully renovating all 12 units providing a rare opportunity to launch any strategy- STR, mid-term, student rentals, long-term tenants, or Section 8- with immediate, rent ready units Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

3940 Gill St, Columbia

Listing courtesy of Coldwell Banker Realty.

$100,000
3 Beds ⋅ 1 Baths
Investor Special in 29205! Don't miss this vacant 3BR/1BA property offering endless potential in a convenient Columbia location. Located just minutes from downtown, USC, local hospitals, dining, and shopping. Perfect project for investors looking for strong rental income or a flip opportunity in a high-demand area. Property is sold as-is. Schedule your private tour today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

1203 Chevis St, Columbia

Listing courtesy of Home Advantage Realty.

$699,000
5 Beds ⋅ 4 Baths
Welcome to 2826 Blossom Street, a beautifully updated home in the heart of Shandon, one of Columbia's most sought-after neighborhoods. Offering 5 bedrooms, 3 full bathrooms, and a newly added half bath, this spacious residence perfectly blends timeless character with modern updates.Inside, you'll find beautiful hardwood floors, soaring ceilings, and an abundance of natural light throughout. The newly renovated kitchen serves as the heart of the home, featuring stylish finishes and an ideal layout for both everyday living and entertaining. Thoughtful improvements throughout the home ensure it's move-in ready while maintaining its classic Shandon charm.Step outside to discover an incredible backyard retreat with ample off-street parking, a covered gathering area perfect for hosting, and a storage shed that conveys with the property for added convenience.Ideally located just minutes from the University of South Carolina, Devine Street, Five Points, and downtown Columbia, this home offers the perfect combination of historic charm, modern updates, and an unbeatable location. **Currently leased for the 2026–2027 University of South Carolina school year**, this property presents an outstanding turnkey investment opportunity with immediate rental income already in place.Whether you're looking to expand your investment portfolio or secure a premier property in one of Columbia's most desirable neighborhoods, don't miss the opportunity to own this exceptional Shandon home. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

2826 Blossom St, Columbia

Listing courtesy of Better Homes and Gardens Real Est Medley.

$400,000
2 Beds ⋅ 3 Baths
Every great home has a story — and this remarkable Shandon home has been collecting them for generations.Nestled on Queen Street and backing directly to Emily Douglas Park, this one-of-a-kind property is filled with authentic character, timeless craftsmanship, and an unbeatable location just a short stroll from Five Points, USC, and downtown Columbia. Creative souls, collectors, professors, and anyone who appreciates architecture with personality will recognize immediately how special this home is.Rich hardwood floors, handcrafted details, and custom tilework create distinctive living spaces with warmth at every turn — if you've grown tired of cookie-cutter renovations, this may be the one you've been waiting for. The dramatic sunroom steals the show, with soaring cathedral ceilings, walls of windows, and a sunken hot tub unlike anything else on the market. An extraordinary floor-to-ceiling built-in library serves as the home's architectural centerpiece, a reflection of its legacy as the longtime residence of USC English professors and artists.Beyond the screened front porch and brick patio, a detached 319 sf studio — with a half bath, mini-split HVAC, owned solar, and its own metal roof — served most recently as a pottery studio, would be ideal as an art space, office, or guest retreat.Offered as-is, this is a rare opportunity to own one of Shandon's truly distinctive properties. Bring your imagination, preserve its remarkable character, and write the next chapter of a home that simply could not be recreated today. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

528 Queen St, Columbia

Listing courtesy of Coldwell Banker Realty.

$379,000
3 Beds ⋅ 3 Baths
Welcome home to this beautifully updated 3-bedroom, 3-bath townhouse in the desirable Doors of Shandon community. Ideally located just minutes from Devine Street's popular shopping and dining, the University of South Carolina, and downtown Columbia, this home offers the perfect blend of convenience and neighborhood charm. Nestled in the heart of Shandon, you'll enjoy one of Columbia's most beloved neighborhoods, known for its tree-lined streets, sidewalks, and timeless character.Inside, hardwood floors flow throughout the main level, where an updated kitchen has been thoughtfully opened to the dining area, creating a bright and inviting space for everyday living and entertaining. The spacious living room features a cozy fireplace, custom built-ins, and access to a private back patio—perfect for relaxing outdoors.The flexible floor plan includes a main-level bedroom and a beautifully updated full bath, ideal for guests, a home office, or multigenerational living. Upstairs, you'll find two generously sized bedrooms, each with its own private en-suite bath. The primary suite offers a large walk-in closet, while the conveniently located laundry area at the top of the stairs makes everyday chores a breeze.Whether you're looking for low-maintenance living close to USC, downtown Columbia, or all that the Devine Street district has, this move-in-ready home is an exceptional opportunity in one of Columbia's most sought-after neighborhoods. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

600 Woodrow St Unit K, Columbia

Listing courtesy of Bollin Ligon Walker Realtors.

$700,000
3 Beds ⋅ 3 Baths
Corner-Lot Charm with a Rare Inground Pool in the Heart of Shandon. Location, location, location — and this one has it. Set on a desirable corner lot in Columbia's beloved Shandon neighborhood, 3223 Blossom Street offers something truly hard to find in this historic in-town community: a private inground pool. In a neighborhood defined by mature oaks, wide sidewalk-lined streets, and classic early-1900s character, an existing pool is a genuine rarity — your own backyard retreat just minutes from everything.Inside, the home blends timeless character with comfortable living space, offering generous bedrooms and the warm architectural details Shandon is known for. The primary bedroom is over 800sqft of private space that takes up the entire second floor while a secondary primary is located downstairs with additional private ensuite bathroom. The bonus sunroom/living room brings extra light that overlooks the private pool oasis for relaxing, entertaining, or cooling off through Columbia's warm summers.Why the location matters: Shandon is one of Columbia's most walkable and sought-after neighborhoods, tucked between Five Points, the Devine Street shopping and dining district. From here you can stroll to local favorites — coffee shops, the Gourmet Shop, boutiques, restaurants, and bars — while downtown Columbia are all just minutes away. Everyday errands, dining, and entertainment are genuinely walkable, a lifestyle premium that keeps demand in Shandon consistently high.Families also benefit from access to some of the area's top-rated schools, including Rosewood Elementary, Hand Middle, and Dreher High. With its prime unbeatable walkable location, and a rare private pool, this Shandon gem is an opportunity that doesn't come along often.Don't miss your chance to own a piece of one of Columbia's most desirable neighborhoods — schedule your showing today Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

3223 Blossom St, Columbia

Listing courtesy of Keller Williams Palmetto.

$899,000
3 Beds ⋅ 4 Baths
This FANTASTIC NEW CONSTRUCTION home in Sherwood Forest has it all! As you walk in the gorgeous entry to the vaulted Great Room and Kitchen you appreciate the space of this open floor plan. Your dream kitchen awaits as the focal point of gatherings with friends and family. There are 3 bedrooms and an office on the first floor as well as a huge FROG with closet and full bath. The primary bedroom has trey ceilings, a private bath with free standing soaking tub, shower, water closet, double vanities, and a HUGE walk in closet! This split floor plan home's two additional bedrooms share a hall bath. Step outside on your covered porch and take in the expanse of your beautiful back yard of this 1/3 Acre lot. Truly upscale living in one of Columbia's best neighborhoods can be yours today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

4206 Devine St, Columbia

Listing courtesy of Coldwell Banker Realty.

$270,000
3 Beds ⋅ 2 Baths
Welcome to 39 Cavalier Court, a charming Rosewood home with the perfect blend of comfort, functionality, and opportunity. With 1,369 square feet, this 3-bedroom, 2-bathroom home features two spacious living areas, providing plenty of room to relax, entertain, or create a home office or play space.Durable luxury vinyl plank flooring flows throughout the home, while abundant natural light pours in through the many windows, creating a bright and welcoming atmosphere. Step outside to enjoy the covered porch or step out back and enjoy the fully fenced backyard. The backyard offers privacy and ready for your landscaping vision with potential for gardening, entertaining, or creating your own outdoor retreat.Conveniently located in Rosewood, this property is an excellent opportunity for first-time homebuyers, investors, or anyone looking to enjoy one of Columbia’s well known neighborhoods. Don’t miss your chance to make this one yours! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

39 Cavalier Ct, Columbia

Listing courtesy of Wilson Real Estate Company LLC.

$849,900
5 Beds ⋅ 6 Baths
Situated on a spacious corner lot in Shandon, one of Columbia's most established downtown neighborhoods, 3726 Blossom Street is a completely renovated and beautifully reimagined residence offering exceptional space, timeless character, and modern luxury. Located directly across from St. Joseph Catholic Church and just minutes from the University of South Carolina, Devine Street, and downtown Columbia, this impressive home features 5 bedrooms, 3 full baths, 1 three-quarter bath, and 2 half baths with a thoughtfully designed floor plan that provides flexibility for everyday living and entertaining. The luxurious owner’s suite serves as a private retreat with a spa-inspired bath featuring dual vanities, a freestanding soaking tub, and an oversized double shower. Rich hardwood floors, fresh designer finishes, and abundant natural light create a warm and inviting atmosphere throughout, while the stunning chef’s kitchen features custom cabinetry, premium finishes, and a large center island that opens seamlessly to the main living areas. The expansive family room is a true showpiece with exposed wood beams, a striking stone fireplace, a sunken wet bar, and French doors leading to the outdoor living area. Multiple gathering spaces throughout the home provide plenty of room for entertaining guests or enjoying quiet evenings at home. Outside, the property includes a detached two-car garage, a separate workshop, and generous outdoor space with endless possibilities for recreation, gardening, or future enhancements. This one-of-a-kind property offers a rare combination of size, style, character, and location, and an even rarer opportunity to find this much interior space and outdoor potential in the heart of Shandon. Come take a look! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

3726 Blossom St, Columbia

Listing courtesy of Century 21 Vanguard.

Start Your Search