Welcome Home to this Custom Renovation near Downtown Columbia and Columbia College where you get the timeless brick exterior with a wrap around covered front stoop and a covered side porch that welcomes you into this Southern Charmer located near all the colleges, dining, entertaining, shopping, churches and the employment opportunities of Downtown Columbia. This completely remodeled home offers a New HVAC Heat Pump unit installed in 2023, new architectural shingles installed in 2022, some new rear chain linked fencing, new Double hung Thermopane energy efficient windows easy to clean were added about 2023, new Luxury Vinyl Plank flooring was added throughout, new Kitchen Cabinets, a pantry, new Granite Countertops and tiled backsplash, newer upgraded stainless steel appliances with a gas grill convection stove, updated bathrooms and a tankless gas hot water heater and Laundry room with new Washer and dryer that will remain was added in 2023. As you step inside you will see the high soaring ten foot smooth ceilings and the open floor plan as the previous owners removed walls to open the home up the flow & all work was permitted and approved by the City of Columbia Construction Department so all the wiring, LED Lighting and plumbing in the home were replaced as well in 2023 per the previous owners. There is a Dining Room area between the Open Great Room with a storage closet, Recessed Lights, Ceiling fan and a wood burning Masonry fireplace with mantle, LVP flooring, and you look into the all new gorgeous gourmet kitchen with new cabinets, double sink, countertops, tiled backsplash and huge window to let natural light inside. The owner opened up a wall to make a pantry off the rear of the home that goes outside to the landscaped rear yard with a new wooden deck & pavers for entertaining and a storage shed for your gardening & lawn equipment. The private lot has large shade trees and a private street location. The master bedroom suite has the high ceilings, fresh paint, a private closet and new private bath with a shower & rear door to the back yard. The two other large bedrooms share a hall bathroom with updated counters & a tub/shower combination. Show & Enjoy!
Source: Public Records
Source: Sperling's Best Places
55/100
Walk Score ®
31/100
Transit Score ®
31/100
Bike Score ®
4 nearby routes: 4 bus, 0 rail, 0 other
The average walkability score in the surrounding area is Walk Score: 25/100, Transit Score: 15/100, Bike Score: 27/100.
2 bds • 1 ba • 1,218 sqft
1100 Columbia College Drive, Columbia, SC 29203
3 bds • 2 ba • 1,412 sqft
5619 MIDDLETON Court, Columbia, SC 29203
3 bds • 2 ba • 1,189 sqft
4912 WOODBRIER ST, Columbia, SC 29203
3 bds • 2 ba • 1,280 sqft
3105 Hammond Avenue, Columbia, SC 29204
3 bds • 2 ba • 1,337 sqft
1010 Duke Avenue, Columbia, SC 29203
3 bds • 2 ba • 1,380 sqft
3720 Fern Avenue, Columbia, SC 29203
3 bds • 2 ba • 1,200 sqft
1814 McAlister Street, Columbia, SC 29204
3 bds • 2 ba • 1,264 sqft
1729 Cody St, Columbia, SC 29203
3 bds • 2 ba • 1,180 sqft
4313 Catherine Avenue, Columbia, SC 29203
3 bds • 2 ba • 1,262 sqft
3910 Highland Park Drive, Columbia, SC 29210
3 bds • 2 ba • 1,350 sqft
4017 Highland Park Drive, Columbia, SC 29204
3 bds • 2 ba • 1,372 sqft
507 Belle Claire Dr, Columbia, SC 29203
3 bds • 2 ba • 1,150 sqft
4222 Woodridge Drive, Columbia, SC 29203
3 bds • 2 ba • 1,200 sqft
230 Pineneedle Road, Columbia, SC 29203
3 bds • 4 ba • 1,400 sqft
3839 Ayshire Avenue, Columbia, SC 29203
4 bds • 2 ba • 1,484 sqft
1810 Ashby Road, Columbia, SC 29204
3 bds • 2 ba • 1,145 sqft
2900 Chestnut Street, Columbia, SC 29204
3 bds • 2 ba • 1,469 sqft
1825 St. julian 18-L, Columbia, SC 29204
3 bds • 1 ba • 1,161 sqft
1746 Westminster Drive, Columbia, SC 29204
3 bds • 1 ba • 1541 sqft
5318 N Main Street
2 bds • 1 ba • 1218 sqft
1100 Columbia College Drive
4 bds • 2 ba • 1761 sqft
924 Stebondale Road
3 bds • 2 ba • 1412 sqft
5619 MIDDLETON Court
3 bds • 1 ba • 1537 sqft
1009 Wildwood Avenue
3 bds • 2 ba • 1189 sqft
4912 WOODBRIER ST
3 bds • 2 ba • 1882 sqft
716 Columbia College Drive
3 bds • 2 ba • 1280 sqft
3105 Hammond Avenue
4 bds • 3 ba • 1561 sqft
2201 Liberty Street
3 bds • 2 ba • 1337 sqft
1010 Duke Avenue
2 bds • 1 ba • 998 sqft
618 Joan Street
3 bds • 2 ba • 1509 sqft
504 Lakeside
3 bds • 2 ba • 1380 sqft
3720 Fern Avenue
3 bds • 2 ba • 1099 sqft
5020 Barony Drive
3 bds • 2 ba • 1566 sqft
5901 Barksdale Drive
4 bds • 2 ba • 1528 sqft
3709 Ridgewood Avenue
3 bds • 2 ba • 1200 sqft
1814 McAlister Street
3 bds • 2 ba • 1507 sqft
3116 Windwood Place
3 bds • 2 ba • 1264 sqft
1729 Cody St
Source: Realty.com
1504 Hergett Drive, Columbia, SC 29203 is a Single Family 1,310 sq. ft. home listed for sale. Realty.com has 27 photos available of this 3 bed, 2 bath house, listed at $224,888. View sales and tax history, use our mortgage calculator and more on Realty.com
Realty.com has 27 photos of 1504 Hergett Drive.
Our records indicate that 1504 Hergett Drive was built in 1950.
The full address for this home is 1504 Hergett Drive, Columbia, SC 29203.
1504 Hergett Drive has been listed on Realty.com since Wed December 10, 2025
Some errands can be accomplished on foot. A few nearby public transportation options. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 25/100, Transit Score: 15/100, Bike Score: 27/100.
There are 3 schools assigned to this home. Check out the schools near 1504 Hergett Drive. Arden (Grades: K - 5), W. A. Perry Middle School (Grades: 6 - 8), Eau Claire High School (Grades: 9 - 12)
Listing provided courtesy of:
Era Wilder Realty
(tel: 803-736-7870)
Listing agent:
Grey Farthing
(#216)
This content last refreshed on 2025-12-15 23:20:05. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Export listing data of 1504 Hergett Drive, Columbia, SC 29203 : MLS# 623092
