@Eli Fazzo The 6% rate is a bit of a misnomer. That's the starting rate and then there are millage rates that bring it down to the actual tax rate. The 4% and 6% rates are just the names given to differentiate commercial and owner-occupied.
The 6% rate is obviously significantly high, but it's fairly average nationally. It would likely be comparable to what you pay in the NE.
Just google "Lexington County tax estimator" or whatever county you're interested in and you'll usually find a web tool from the County you can use to estimate the tax bill based on the previous year's assessments.
There is also a law called the ATI tax exemption that can potentially lower than 6% rate by 25%. Just look that up. There are conditions that must be met.
Also, I believe the taxes are higher in Richland County than Lexington County, but I don't like there, so I don't have personal experience with that. I've just heard that from many people over the years.
In general, SC is experiencing an economic renaissance, so it is a good time to invest here.