CREATE TABLE table_48895 ("Name" CLOB, "Built" CLOB, "Listed" CLOB, "Location" CLOB, "County" CLOB)

On what date was the bridge located in McClain listed?
SELECT "Listed" FROM table_48895 WHERE "Location" = 'mcclain'
SELECT "Listed" FROM "table_48895" WHERE "Location" = 'mcclain'