Question: What county shares a border with another county, which itself borders a third county, where the neighborhood of Newport is found?

full_context: Document 1: Bringle Ferry Bridge: The Bringle Ferry Bridge is a crossing of the Yadkin River Channel and the Tuckertown Reservoir in Rowan County, North Carolina and Davidson County, North Carolina. The bridge is on Bringle Ferry Road between Salisbury, North Carolina and Denton, North Carolina. It is the only crossing of the Yadkin River between the Interstate 85 bridge at Spencer, North Carolina and the NC Hwy 49 bridge near Richfield, North Carolina. The Bringle Ferry Bridge has views of the High Rock Dam to the north, which separates Tuckertown Reservoir from High Rock Lake.
Document 2: Buster Boyd Bridge: The Buster Boyd Bridge is a four-lane automobile bridge spanning the Catawba River/Lake Wylie between Lake Wylie, York County, South Carolina and Steele Creek, Mecklenburg County, North Carolina. The bridge carries/connects SC 49 and NC 49, which is utilized by mostly local traffic. A sidewalk, along the east facing side of the bridge, provides pedestrian access.
Document 3: Deep River Camelback Truss Bridge: It spans the Deep River in North Carolina, United States between the hamlets of Gulf in Chatham County and Cumnock in Lee County in a quiet rural setting amid woods and farmlands on both sides of the river. It was originally constructed in 1901. The bridge is listed on the National Register of Historic Places. The bridge is open to pedestrian traffic only. Vehicles may use a replacement bridge located about a hundred yards east of the historic structure.
Document 4: Red Bank, South Carolina: Red Bank is a census-designated place (CDP) in Lexington County, South Carolina, United States. The population was 8,811 at the 2000 census. It is part of the Columbia, South Carolina Metropolitan Statistical Area
Document 5: Charleston, South Carolina: The Charleston-North Charleston-Summerville Metropolitan Statistical Area consists of three counties: Charleston, Berkeley, and Dorchester. As of the 2013 U.S. Census, the metropolitan statistical area had a total population of 712,239 people. North Charleston is the second-largest city in the Charleston-North Charleston-Summerville Metropolitan Statistical Area and ranks as the third-largest city in the state; Mount Pleasant and Summerville are the next-largest cities. These cities combined with other incorporated and unincorporated areas along with the city of Charleston form the Charleston-North Charleston Urban Area with a population of 548,404 as of 2010. The metropolitan statistical area also includes a separate and much smaller urban area within Berkeley County, Moncks Corner (with a 2000 population of 9,123).
Document 6: Newport, South Carolina: Newport is a census-designated place in York County, South Carolina. Most of Newport is annexed into the city of Rock Hill, while parts are still located in unincorporated York County, but Newport is still considered to be a census-designated place. The census of 2010 showed the population to be 4,136. During the 2000 Census, the population was 4,033.
Document 7: Newport, Oregon: Newport is a city in Lincoln County, Oregon, United States. It was incorporated in 1882, though the name dates back to the establishment of a post office in 1868. As of the 2010 census, the city had a total population of 9,989, an increase of nearly 5% over its 2000 population; as of 2013, it had an estimated population of 10,117.
Document 8: Shadow Lawn (Chase City, Virginia): Shadow Lawn is a historic home located at Chase City, Mecklenburg County, Virginia. The original section dates to about 1834, with the main Italianate style front section designed by Jacob W. Holt and built in 1869-1870. The house is two stories tall and three bays wide with a cross gable roof. It has a traditional central-passage, double-pile plan.
Document 9: John Seigenthaler Pedestrian Bridge: The John Seigenthaler Pedestrian Bridge (previously called the Shelby Street Bridge or Shelby Avenue Bridge) is a truss bridge that spans the Cumberland River in Nashville, Tennessee, United States. The bridge spans 960 m (3,150 ft) and is one of the longest pedestrian bridges in the world.
Document 10: Morrison City, Tennessee: Citizens just north of the Virginia state line were categorized by utility companies for several years in a grouping called "Morrison City, Virginia." They maintained Virginia residency, but were served by Tennessee telephone and mail service. The Virginia side had several businesses attracted to the area because of the proximity to the state line, and capitalizing on cheaper goods not available in Tennessee due to differences in state and county laws. These included cigarette sales businesses, liquor trafficking stores, fireworks stands, and a club where alcohol was served to customers.
Document 11: Rock Hill, South Carolina: Rock Hill is the largest city in York County, South Carolina, United States and the fifth-largest city in the state. It is also the fourth-largest city of the Charlotte metropolitan area, behind Charlotte, Concord, and Gastonia (all located in North Carolina, unlike Rock Hill). As of the 2010 Census, the population was 66,154. In 2016, the population had increased to 72,937.
Document 12: Rachel Carson Bridge: Rachel Carson Bridge, also known as the Ninth Street Bridge, spans the Allegheny River in Downtown Pittsburgh, Pennsylvania in the United States. The total length is including the main span and two side spans, or including the approaches. The total width of the deck is , including the roadway plus two sidewalks outside the compressive plate girder. Whereas the roadway formerly carried two vehicle lanes and two streetcar tracks, it now carries four wide vehicle lanes.
Document 13: U.S. Route 29 in Virginia: For most of its route through Virginia, US 29 has been constructed to be at least four lanes along its route, with the two short exceptions being where the highway passes through Manassas National Battlefield Park, where it is two lanes wide for approximately three miles, and through Fairfax and Arlington counties, where it is sometimes wider.
Document 14: Richmond, Virginia: Richmond is located at the fall line of the James River, 44 miles (71 km) west of Williamsburg, 66 miles (106 km) east of Charlottesville, and 98 miles (158 km) south of Washington, D.C. Surrounded by Henrico and Chesterfield counties, the city is located at the intersections of Interstate 95 and Interstate 64, and encircled by Interstate 295 and Virginia State Route 288. Major suburbs include Midlothian to the southwest, Glen Allen to the north and west, Short Pump to the west and Mechanicsville to the northeast.
Document 15: Fort Mitchell, Virginia: Fort Mitchell is located about 1.7 miles from US 360, 9.3 miles from Keysville, Virginia in Charlotte County, Virginia, 21.3 miles from Lunenburg, Virginia in Lunenburg County and 11.2 miles from Chase City, Virginia located in Mecklenburg County, Virginia.
ground_truth: Charlotte County
sub_queries: Newport >> located in the administrative territorial entity Answer: York County
York County >> shares border with Answer: Mecklenburg County
Mecklenburg County >> shares border with Answer: Charlotte County