That isn't your complete code: we know that becaus ethere are only 56 lines of code in there, and the error message specifically references line 71. So to be honest there isn't anything we could do to fix it if we wanted to.
But ... that looks like it was written by at least two people, and thrown together: the different indetention styles are a clue, and they also kinda point to what you problem is likely to be: some of the code is actually missing, even in your more complete version.
Start by matching up quotes, double quotes, brackets, parentheses and so forth: chances are there is one missing somewhere and the system is complaining as a reault.
But you have more important problems: Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Always use Parameterized queries instead.
When you concatenate strings, you cause problems because SQL receives commands like:
SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'
The quote the user added terminates the string as far as SQL is concerned and you get problems. But it could be worse. If I come along and type this instead: "x';DROP TABLE MyTable;--" Then SQL receives a very different command:
SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;
Which SQL sees as three separate commands:
SELECT * FROM MyTable WHERE StreetAddress = 'x';
A perfectly valid SELECT
DROP TABLE MyTable;
A perfectly valid "delete the table" command
And everything else is a comment.
So it does: selects any matching rows, deletes the table from the DB, and ignores anything else.
So ALWAYS use parameterized queries! Or be prepared to restore your DB from backup frequently. You do take backups regularly, don't you?