hannahdarnellrealty.com Search Results

$275,000

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.

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.

$400,000

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.

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.

$465,000

Charming Shandon bungalow in the heart of it all, just steps to Devine Street's shops and restaurants. This 2-bedroom, 2-bath home has been fully renovated top to bottom, featuring true hardwood floors, quartz countertops, a large kitchen island, and stainless steel appliances. Updated bathrooms, a cozy gas fireplace, and recessed lighting in the main living areas add to the home's move-in-ready appeal, plus a new 2024 roof for peace of mind. The open floor plan flows into a flexible bonus space, ideal for a home office or playroom. Outside, enjoy a private, fenced backyard with a large patio, perfect for relaxing or entertaining. Zoned for Rosewood Elementary, Hand Middle, and Dreher High School. 1,342 square feet of thoughtfully updated living space in one of Columbia's most walkable and beloved neighborhoods. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

2 Beds ⋅ 2 Baths

Charming Shandon bungalow in the heart of it all, just steps to Devine Street's shops and restaurants. This 2-bedroom, 2-bath home has been fully renovated top to bottom, featuring true hardwood floors, quartz countertops, a large kitchen island, and stainless steel appliances. Updated bathrooms, a cozy gas fireplace, and recessed lighting in the main living areas add to the home's move-in-ready appeal, plus a new 2024 roof for peace of mind. The open floor plan flows into a flexible bonus space, ideal for a home office or playroom. Outside, enjoy a private, fenced backyard with a large patio, perfect for relaxing or entertaining. Zoned for Rosewood Elementary, Hand Middle, and Dreher High School. 1,342 square feet of thoughtfully updated living space in one of Columbia's most walkable and beloved neighborhoods. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

518 Maple St, Columbia

Listing courtesy of BHHS Midlands Real Estate.

$440,000

Investor Opportunity in the Heart of Shandon! Welcome to 3517 & 3519 Wilmot Avenue, a classic duplex nestled in the highly desirable Shandon neighborhood. This charming multi-family property offers timeless character with incredible flexibility for today’s buyer. Each side features 1 bedroom, 1 bath, a spacious living area, and a functional kitchen, stunning hardwood flooring and 1 side is totally renovated perfect for rental income, single family home or multigenerational living. The property offers nearly 2000+ square feet of living space, with a ton of storage, providing plenty of room to customize or reimagine. Endless Possibilities. Live in one side and rent the other, Convert back to a stunning single-family home, Add to your investment portfolio in a prime location. You could even pull your car into the detached open garage in the spacious back yard. Situated on a tree-lined street just minutes from Devine Street shopping, dining, the University of South Carolina, and downtown Columbia, this property delivers both convenience and classic Shandon charm. Whether you’re an investor or a visionary homeowner, this is a rare opportunity to own a versatile property in one of Columbia’s most sought-after neighborhoods. The possibilities here are truly endless! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

2 Beds ⋅ 2 Baths

Investor Opportunity in the Heart of Shandon! Welcome to 3517 & 3519 Wilmot Avenue, a classic duplex nestled in the highly desirable Shandon neighborhood. This charming multi-family property offers timeless character with incredible flexibility for today’s buyer. Each side features 1 bedroom, 1 bath, a spacious living area, and a functional kitchen, stunning hardwood flooring and 1 side is totally renovated perfect for rental income, single family home or multigenerational living. The property offers nearly 2000+ square feet of living space, with a ton of storage, providing plenty of room to customize or reimagine. Endless Possibilities. Live in one side and rent the other, Convert back to a stunning single-family home, Add to your investment portfolio in a prime location. You could even pull your car into the detached open garage in the spacious back yard. Situated on a tree-lined street just minutes from Devine Street shopping, dining, the University of South Carolina, and downtown Columbia, this property delivers both convenience and classic Shandon charm. Whether you’re an investor or a visionary homeowner, this is a rare opportunity to own a versatile property in one of Columbia’s most sought-after neighborhoods. The possibilities here are truly endless! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

3517/3519 Wilmot Ave, Columbia

Listing courtesy of EXIT Real Est Consultants.