SELECT ID AS v, type AS l FROM architectural_types ORDER BY type
SELECT town AS v, town AS l FROM towns, heritage WHERE towns.town = heritage.city GROUP BY heritage.city ORDER BY town
*HINT: To search by address, enter only street name or number and street name, such as "52 Devon" then select the city from the Location list.
Type of building: Civic Address: 105 St. Andrew Street Mitchell, ON N0K 1N0 Architect: W.E. Binning
precast stone, stained glass windows (lamp of learning)
