View all the Columbia SC real estate, including homes for sale in Lake Murray SC below. Lake Murray is one of South Carolina's most beloved reservoirs, and is home to almost 500 miles of gorgeous freshwater coastline. It is located in the Midlands or central SC in technically Columbia SC with popular towns surrounding it such as: Irmo, Lexington and Chapin.