Property Record
597 Saint Andrews Rd, Columbia, SC 29210
NEARBY LISTINGS FOR SALE OR LEASE
Property Detail
597 Saint Andrews Rd
002899-04-022
PT TRACT Z 100 & 150 100X140X100X140
Restaurantdrivein
Lexington
X
South Carolina
45063C0142J
0.28 AC
2025
St Andrews
2024
Columbia
020511
Columbia, SC
2,601 SF
DEMOGRAPHICS near 597 Saint Andrews Rd
1 Mile
3 Mile
5 Mile
2024 Total Population
10,972
52,562
114,126
2029 Population
11,829
55,033
120,253
Pop Growth 2024-2029
+ 7.81%
+ 4.70%
+ 5.37%
Average Age
38
39
39
2024 Total Households
4,932
22,273
48,852
HH Growth 2024-2029
+ 8.07%
+ 5.06%
+ 5.49%
Median Household Inc
$45,790
$49,087
$53,619
Avg Household Size
2.10
2.10
2.20
2024 Avg HH Vehicles
2.00
2.00
2.00
Median Home Value
$159,193
$158,019
$169,852
Median Year Built
1976
1978
1979
Nearby Places
Map Layers
Map Styles
Street
Aerial
- Restaurants
- Banks
- Shops
- Fitness
- Groceries
PUBLIC TRANSPORTATION
COMMUTER RAIL
Columbia Amtrak Station (Silver Star - Amtrak)
DRIVE
WALK
Distance
Columbia Amtrak Station (Silver Star - Amtrak)
11 min
6.6 mi
AIRPORT
Columbia Metro
DRIVE
WALK
Distance
Columbia Metro
22 min
11.4 mi
Freight Ports
North Charleston Terminal
DRIVE
WALK
Distance
North Charleston Terminal
122 min
107.6 mi
SALE & LEASE HISTORY
LISTING DATE
SALE/LEASE
Feb 12, 2021
For Sale
Nearby Properties
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
128,160 SF
9.31 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
358,561 SF
42.10 AC
EC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
128,877 SF
24.71 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
9,620 SF
18.91 AC
GC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
183,392 SF
14.77 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
302,835 SF
11.48 AC
PD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
1,549.59 AC
T/C
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
278,912 SF
23.24 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
207,112 SF
16.86 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
161,636 SF
12.38 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
208,688 SF
13.02 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
73,380 SF
16.07 AC
PDD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
2,268 SF
27.70 AC
RM-1
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
129,108 SF
11.90 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
195,550 SF
17.19 AC
GC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
169,278 SF
12.21 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
153,272 SF
9.63 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
100 SF
465.41 AC
INS-GEN
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
192,966 SF
13.23 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
127,063 SF
14.70 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
204,968 SF
17.39 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
178,000 SF
11.71 AC
RM-1
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
159,139 SF
16.95 AC
GC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
146,254 SF
12.12 AC
PD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
89,376 SF
6.85 AC
CAC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
126,596 SF
10.84 AC
PD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
87,200 SF
7 AC
PDD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
122,820 SF
10.46 AC
RM-HD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
187,298 SF
9.11 AC
PD
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
136,641 SF
9 AC
PDD
The World's #1 Commercial Real Estate Marketplace
Connect with us
© 2026 CoStar Group
The information above has been obtained from sources believed reliable. While we do not doubt its accuracy we have not verified it and make no guarantee, warranty or representation about it. It is your responsibility to independently confirm its accuracy and completeness. Any projections, opinions, assumptions, or estimates used are for example only and do not represent the current or future performance of the property. The value of this transaction to you depends on tax and other factors which should be evaluated by your tax, financial, and legal advisors. You and your advisors should conduct a careful, independent investigation of the property to determine to your satisfaction the suitability of the property for your needs.