CREATE TABLE table_49507 ("Name" TEXT, "Built" TEXT, "Listed" TEXT, "Location" TEXT, "County" TEXT)

In what county is the Canyon Padre Bridge?
SELECT "County" FROM table_49507 WHERE "Name" = 'canyon padre bridge'
SELECT "County" FROM "table_49507" WHERE "Name" = 'canyon padre bridge'