CREATE TABLE table_45895 ("Name" CLOB, "Listed" CLOB, "Location" CLOB, "County" CLOB, "Type" CLOB)

What type of Bridge is in Stanley?
SELECT "Type" FROM table_45895 WHERE "Location" = 'stanley'
SELECT "Type" FROM "table_45895" WHERE "Location" = 'stanley'