Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE Locations ( Location_ID VARCHAR, Address VARCHAR )
TABLE: CREATE TABLE Tourist_Attractions ( Name VARCHAR, Location_ID VARCHAR, How_to_Get_There VARCHAR )

### Question ###
What are the names of tourist attractions that can be reached by bus or is at address 254 Ottilie Junction?

### Accurate SQL ###

SELECT T2.Name FROM Locations AS T1 JOIN Tourist_Attractions AS T2 ON T1.Location_ID = T2.Location_ID WHERE T1.Address = "254 Ottilie Junction" OR T2.How_to_Get_There = "bus"