I grew up a few miles from downtown Charleston and am very well aquainted w/ the area. The picture above looks to be just past the Battery aka White Point Gardens along the waterfront to me. Rainbow Row is located on East Bay Street which includes about 14 brightly painted homes from the 1700's. A beautiful sight to see for any tourist that makes it down there.