1 / 19
MLS ID: 603019
Under Contract - $199,000

About this property

Bedrooms 4
Baths 1
sq2 1922
Lot Size 0.4500 acres
Year Built 1943
DOM 133

Address

Address:
5509 North Main
Subdivision:
COLLEGE PLACE
City:
Columbia
Zip Code:
29203
County:
Richland
State:
SC

Features and Amenities

Cooling
Central
Foundation
Slab
Style
Traditional
Water
Public
Kitchen
Eat In
Other
No Basement

Description

Welcome to 5509 North Main Street, a unique mixed-use property offering both residential comfort and commercial potential! Previously used as an office, this property is now being sold as a residential home, providing a fantastic opportunity for those looking for a spacious layout in a convenient location. Featuring multiple rooms that can be used as bedrooms, home offices, or flex spaces, this home is perfect for those who need versatility. With great street frontage, easy access to downtown Columbia, and a layout that allows for both living and working, this home is ideal for anyone seeking a dynamic space in a prime location. Don’t miss out—schedule your showing today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Schools

Name Address Phone Type Grade
A. J. Lewis Greenview Elementary 726 Easter Street 8037353417 Public PK-5 SPED
Arden Elementary 1300 Ashley Street 8037353400 Public PK-5 SPED
Edward E. Taylor Elementary 200 McRae Street 8033432924 Public PK-5 SPED
Forest Heights Elementary 2500 Blue Ridge Terrace 8036913780 Public PK-5 SPED
Hyatt Park Elementary 4200 Main Street 8037353421 Public PK-5 SPED
J. P. Thomas Elementary 6001 Weston Avenue 8037353430 Public PK-5 SPED
Name Address Phone Type Grade
Alcorn Middle 5125 Fairfield Road 8037353439 Public 6-8 SPED
Heyward Gibbes Middle 500 Summerlea Drive 8033432942 Public 6-8 SPED
Name Address Phone Type Grade
Carolina School for Inquiry 7405-A Fairfield Road 8036911250 Public PK-6 SPED
Name Address Phone Type Grade
Eau Claire High 4800 Monticello Road 8037357600 Public 9-12 SPED
Manning High School 502 Beckman Drive 8039357203 Public 9-12 SPED
W.J. Keenan High 361 Pisgah Church Road 8037142500 Public 9-12 SPED
Name Address Phone Type Grade
Palmetto Achievement Center for Excellence Academy (PACE) 6015 N Main Street 8032519138 Public 2-8 SPED
Name Address Phone Type Grade
Pendergrass Fairwold School 5935 Token Street 8037353435 Public PK-12 SPED
Name Address Phone Type Grade
Columbia Islamic School 1929 Gervais Street, 2nd Floor 803-995-5211 Private K-12
Grace Community Academy of Columbia 577 W. Killian Road 803-679-6423 Private K-12
Name Address Phone Type Grade
Daniel's Christian School 3019 Farrow Road 803-873-7132 Private K4-12
subdivision
Active Listings
Avg DoM
Avg Price
adesso, Columbia
4
62
$396,200
1
88
$181,000
2
63
$299,700
alta monte, Columbia
1
117
$179,900
alta vista, Columbia
2
35
$149,750
1
122
$229,900
1
54
$209,000
2
104
$137,450
arborwood, Columbia
1
182
$75,000
2
75
$499,500
1
51
$299,900
5
51
$289,980
arrowwood, Columbia
2
40
$246,750
1
52
$329,000
2
141
$259,750
1
35
$239,900
astoria, Columbia
41
62
$206,202
3
41
$501,600
1
79
$217,000
avalon, Columbia
3
36
$404,967
avebury, Columbia
2
54
$176,950
1
147
$185,000
alden glen, Columbia
2
40
$254,500
5
61
$130,480
ashcroft, Columbia
12
55
$378,143
1
4
$270,000
barony, Columbia
1
123
$128,000
1
42
$5,000
belleclave, Columbia
3
48
$606,300
1
38
$260,000
belmont, Columbia
8
84
$141,425
1
77
$275,000
1
39
$217,000
belvedere, Columbia
2
67
$129,250
1
49
$230,000
2
45
$97,500
6
50
$157,267
1
338
$149,995
braewick, Columbia
3
37
$234,333
1
13
$939,000
briargate, Columbia
8
100
$63,962
briarwood, Columbia
5
73
$281,140
1
54
$235,000
1
175
$135,000
brittany, Columbia
1
37
$450,000
2
53
$536,900
1
54
$260,000
2
63
$237,500
5
45
$168,780
brookfield, Columbia
4
187
$305,375
brookhaven, Columbia
7
141
$252,057
brookstone, Columbia
1
21
$370,000
1
35
$225,000
1
459
$8,000
byrneswood, Columbia
2
185
$149,450
9
43
$278,533
3
122
$298,998
1
45
$249,900
3
84
$263,000
2
41
$282,500
candlewood, Columbia
2
32
$199,950
cane brake, Columbia
1
29
$220,000
1
250
$1,990,000
2
59
$132,500
5
59
$84,900
2
21
$358,750
2
69
$190,000
2
46
$156,000
2
92
$144,500
1
75
$99,500
1
44
$215,000
cedar glen, Columbia
1
179
$177,500
1
8
$440,000
5
80
$190,990
1
57
$99,900
challedon, Columbia
5
67
$185,380
1
172
$232,400
5
53
$290,060
1
93
$289,990
1
88
$139,900
chartwell, Columbia
2
32
$237,500
4
56
$160,750
2
111
$255,500
7
29
$326,057
1
13
$350,000
1
56
$244,900
2
27
$116,250
claremont, Columbia
1
38
$275,000
1
38
$190,000
clearwater, Columbia
1
18
$418,900
1
19
$125,000
2
191
$260,950
1
10
$235,000
coldstream, Columbia
12
122
$275,708
2
98
$112,450
7
81
$143,971
6
86
$119,133
6
29
$167,567
2
70
$55,000
1
21
$299,000
1
178
$188,000
3
47
$390,000
3
180
$383,667
1
8
$165,000
cottontown, Columbia
3
107
$576,333
cottonwood, Columbia
2
43
$249,250
2
79
$193,975
1
111
$28,500
1
52
$170,000
1
112
$169,900
4
209
$111,450
1
63
$179,900
1
4
$154,500
3
71
$140,667
3
26
$160,633
2
72
$279,400
1
69
$145,000
dove park, Columbia
1
112
$225,900
2
24
$242,500
3
103
$228,667
4
43
$241,200
2
327
$6,250
1
116
$239,500
eagle park, Columbia
2
48
$239,500
earlewood, Columbia
19
53
$300,816
east lake, Columbia
7
67
$214,829
1
90
$297,000
east pines, Columbia
3
36
$245,830
eastfair, Columbia
3
25
$234,167
2
18
$209,500
eastview, Columbia
2
58
$167,000
1
79
$149,325
eau claire, Columbia
5
41
$309,580
edgewood, Columbia
2
135
$98,444
3
97
$181,000
2
38
$134,750
elm abode, Columbia
2
24
$302,450
11
44
$515,155
1
217
$222,000
enclave, Columbia
1
9
$1,000,000
1
25
$192,000
9
65
$74,333
falls mill, Columbia
2
27
$272,500
1
42
$86,000
2
115
$234,750
1
26
$214,900
2
55
$384,750
folkestone, Columbia
3
38
$231,333
28
45
$417,494
1
64
$409,000
3
64
$266,600
6
61
$734,000
3
40
$906,633
12
47
$571,400
1
123
$349,097
2
46
$132,500
1
2
$220,000
1
44
$238,900
fox run, Columbia
4
55
$273,725
3
97
$15,667
1
27
$225,888
2
19
$317,500
gardendale, Columbia
4
123
$287,225
1
36
$199,000
17
44
$302,572
1
140
$270,000
glenwood, Columbia
2
76
$812,250
1
106
$19,900
2
117
$118,600
1
134
$119,000
grand oaks, Columbia
29
78
$279,153
greenbriar, Columbia
1
35
$799,000
greenbrook, Columbia
1
29
$249,900
greengate, Columbia
3
53
$183,833
1
84
$214,900
greenview, Columbia
3
62
$109,167
gregg park, Columbia
1
32
$1,340,000
gatewood, Columbia
1
267
$195,000
1
124
$215,000
hallmark, Columbia
2
52
$262,450
1
26
$219,900
1
44
$235,000
1
233
$369,000
1
75
$2,350,000
6
76
$220,817
2
77
$79,950
2
33
$1,250,000
1
37
$399,000
3
27
$456,333
2
58
$432,500
2
44
$674,450
1
128
$325,000
harbison, Columbia
8
75
$295,611
harlem, Columbia
3
35
$133,333
harrington, Columbia
1
3
$226,000
2
71
$77,250
1
188
$715,000
1
1
$310,000
44
140
$255,186
1
129
$263,749
1
104
$174,000
3
131
$223,933
heathwood, Columbia
9
43
$693,878
1
142
$94,900
3
73
$166,300
1
23
$179,900
1
38
$350,000
hermitage, Columbia
2
30
$187,450
2
15
$200,000
1
1,451
$30,000
7
63
$163,186
2
10
$255,000
2
62
$26,750
1
14
$228,000
highlands, Columbia
2
60
$322,000
hillcreek, Columbia
3
52
$448,667
hillridge, Columbia
2
35
$321,950
2
41
$284,000
3
59
$812,667
6
194
$126,631
3
21
$184,333
1
22
$205,000
honeytree, Columbia
1
52
$210,000
2
89
$126,000
hyatt park, Columbia
1
2
$140,000
13
44
$194,338
1
105
$450,000
indigo, Columbia
1
1,261
$37,900
ivy hall, Columbia
1
181
$200,000
1
14
$659,000
1
39
$205,000
1
105
$359,999
1
181
$430,900
7
62
$263,030
1
202
$365,000
1
109
$285,000
1
54
$205,000
2
17
$1,925,000
3
67
$272,767
kingswood, Columbia
2
19
$216,000
knollwood, Columbia
2
30
$394,950
2
79
$315,750
4
128
$357,200
2
21
$357,500
1
109
$485,000
2
44
$332,500
11
85
$306,708
1
23
$650,000
2
11
$316,450
1
17
$265,000
1
69
$610,000
2
27
$363,450
2
27
$292,500
6
38
$1,074,967
1
85
$203,999
lakeshore, Columbia
1
86
$157,000
1
22
$85,000
1
42
$140,000
1
48
$380,000
lansdowne, Columbia
1
129
$392,000
2
89
$298,250
laureate, Columbia
2
33
$288,750
3
70
$351,633
lee hills, Columbia
3
88
$184,166
3
65
$229,267
17
132
$63,312
1
160
$85,000
4
64
$215,425
lionsgate, Columbia
3
40
$131,133
2
105
$349,950
lost creek, Columbia
2
46
$504,500
4
41
$306,393
73
87
$377,239
27
77
$414,137
1
10
$315,000
3
95
$372,333
3
40
$288,233
6
59
$404,250
1
123
$789,000
1
18
$343,000
12
130
$413,697
1
9
$399,900
2
40
$372,450
1
9
$425,000
1
24
$189,900
1
55
$205,000
1
26
$374,900
meadowlake, Columbia
2
8
$192,500
5
50
$588,880
10
55
$152,050
4
54
$171,250
miles glen, Columbia
1
65
$410,000
millbank, Columbia
1
36
$280,000
millpond, Columbia
1
71
$668,000
5
100
$199,380
1
60
$273,000
1
42
$190,000
murraywood, Columbia
3
103
$190,298
1
31
$350,000
newcastle, Columbia
4
58
$189,396
1
106
$209,000
1
1
$179,900
3
53
$382,000
1
32
$225,000
northlake, Columbia
1
155
$220,000
4
115
$179,125
2
50
$372,500
1
50
$245,000
5
77
$411,780
3
64
$440,800
olympia, Columbia
2
164
$200,000
1
168
$237,000
other, Columbia
1
646
$1,101,000
2
60
$349,950
2
72
$118,000
3
93
$174,967
park side, Columbia
4
76
$210,000
1
29
$249,900
1
28
$250,000
1
74
$208,000
1
51
$345,000
1
520
$235,000
5
61
$224,790
1
61
$218,000
1
158
$33,000
1
3
$235,000
pine lakes, Columbia
5
116
$159,980
6
45
$173,483
2
39
$239,950
10
73
$247,746
2
61
$167,000
2
58
$150,000
1
154
$117,000
polo ridge, Columbia
1
84
$295,000
1
2
$259,500
2
30
$222,500
2
12
$200,000
6
32
$351,033
1
50
$314,000
6
43
$253,833
2
39
$363,500
1
121
$292,000
3
63
$1,235,000
1
203
$179,000
1
56
$335,000
rice creek, Columbia
3
19
$193,833
1
46
$284,900
2
51
$169,500
ridgeview, Columbia
1
102
$260,000
rivendale, Columbia
1
28
$324,000
2
66
$107,543
4
68
$215,475
1
2
$265,000
1
74
$214,900
6
89
$129,300
rockbridge, Columbia
3
138
$638,167
5
764
$328,000
rosedale, Columbia
2
54
$189,000
rosewood, Columbia
33
67
$298,397
1
59
$250,000
1
218
$135,000
1
63
$500,000
2
112
$479,650
1
51
$159,900
sandwood, Columbia
2
91
$244,000
3
52
$271,667
1
49
$425,000
1
74
$339,750
1
128
$84,000
4
184
$259,750
1
126
$345,000
shandon, Columbia
23
71
$582,374
sheffield, Columbia
3
93
$592,967
2
32
$398,000
3
8
$363,167
1
365
$125,000
sims alley, Columbia
1
57
$324,900
1
411
$89,900
smith lake, Columbia
2
290
$148,750
southwell, Columbia
1
84
$347,000
southwood, Columbia
2
142
$247,500
19
66
$480,387
2
60
$287,400
1
29
$225,000
1
13
$109,000
1
122
$189,500
3
36
$211,433
10
84
$95,190
4
40
$359,250
1
2
$70,000
1
280
$17,500
2
33
$477,500
1
4
$265,000
1
120
$349,900
1
25
$249,000
1
1
$265,000
summerhill, Columbia
1
246
$185,000
1
50
$295,000
summerset, Columbia
3
35
$321,117
summerwood, Columbia
1
6
$220,000
2
42
$354,500
3
105
$304,600
1
56
$379,900
2
88
$185,000
1
132
$418,000
1
43
$249,000
2
55
$236,975
1
39
$359,900
starlite, Columbia
1
109
$171,900
tall pines, Columbia
1
77
$89,000
the arbors, Columbia
1
64
$210,000
1
77
$319,000
1
71
$85,000
1
1
$400,000
1
21
$199,900
11
53
$269,073
2
99
$189,900
the groves, Columbia
3
144
$339,500
4
44
$646,250
5
78
$256,580
2
48
$204,900
1
75
$400,000
the pines, Columbia
4
48
$232,125
2
58
$922,250
2
26
$64,000
the rapids, Columbia
1
56
$195,000
6
24
$248,908
1
86
$650,000
1
73
$259,000
1
20
$215,000
1
126
$230,000
2
7
$322,000
2
118
$244,950
2
15
$190,750
2
41
$221,000
1
40
$360,000
2
19
$254,500
1
113
$360,000
2
35
$259,000
2
21
$254,500
3
175
$264,633
1
70
$350,000
2
85
$194,950
3
21
$333,333
3
99
$274,967
the woods, Columbia
1
49
$52,500
timberlake, Columbia
2
118
$169,450
timbervale, Columbia
4
98
$218,925
2
54
$18,500
6
62
$152,733
4
90
$327,225
6
61
$262,800
2
165
$161,700
1
15
$163,000
2
79
$674,750
6
77
$262,081
1
9
$235,000
1
107
$650,000
1
53
$24,900
14
83
$285,557
2
57
$99,250
2
93
$229,950
5
78
$284,000
1
15
$285,990
1
98
$329,000
5
36
$867,580
4
91
$126,225
1
48
$110,000
waterbury, Columbia
1
32
$249,000
waverly, Columbia
2
25
$174,000
2
16
$122,500
wellington, Columbia
1
133
$299,900
2
140
$2,274,500
wexhurst, Columbia
1
2
$299,000
3
51
$534,667
whitehall, Columbia
20
97
$300,745
3
40
$278,300
3
31
$199,967
whitehurst, Columbia
2
25
$268,500
1
24
$249,000
wildewood, Columbia
29
70
$622,283
1
17
$245,000
2
11
$139,450
2
52
$321,500
3
77
$282,300
1
147
$254,900
2
39
$256,250
1
25
$146,000
winchester, Columbia
5
44
$267,960
1
4
$259,900
5
57
$311,600
4
45
$232,725
2
56
$164,950
winslow, Columbia
12
48
$209,058
1
97
$248,000
1
366
$183,000
wood moor, Columbia
3
166
$291,833
1
51
$775,000
1
112
$799,999
10
56
$178,100
woodhaven, Columbia
3
122
$220,267
1
890
$110,000
1
38
$222,500
woodlake, Columbia
7
39
$511,714
1
19
$235,000
10
55
$287,380
3
48
$74,633
woodlands, Columbia
14
64
$350,428
2
95
$310,949
1
107
$334,900
woodwinds, Columbia
3
51
$258,000
2
36
$214,900
yacht cove, Columbia
13
94
$285,291

Mortgage Calculator

$
$
%
%
Interest Rate as of: Fri, Jul. 11, 2025
$ 199,000Home Price
$ 1,037Monthly payment
$ 159,200Amount Financed
$ 12,442Annual cost of Loan
$ 373,250Total of 360 Payments

Map

SEE THIS PROPERTY

James Schiller

James Schiller

Realtor, Brand Name Real Estate
Live Chat:
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Similar Listings

Previus
Next
©2025 CTMLS, GGMLS, CCMLS & CMLS

The information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS boards of the SC Realtors.

Broker Logo
5509 North Main, Columbia, SC, 29203
Print