select * from bland_slides_info where (province like '%AB%') AND (type like '%commercial%') AND bland_slides_date >= 0 and end_date <= 9999 order by title
Number of matched records: 27
Banff Springs Hotel
Banff AB
Bruce Price
1911 - 1928
commercial
Banff Springs Hotel (CPR)
Banff AB
Bruce Price
1886 - 1888
Commercial
Banff Springs Hotel (CPR)
Banff AB
Bruce Price
1886 - 1888
Commercial
Bank of Montréal
Calgary AB
1930
Commercial
Business Block
Lacombe AB
Commercial
Business Block
Lacombe AB
Commercial
Business Block, detail
Lacombe AB
Commercial
Canada Life Building
Calgary AB
Brown and Vallance
1911 - 1913
Commercial
Canada Permanent Building
Edmonton AB
Roland W. Lines
1910
Commercial
Central Business District
Edmonton AB
Commercial
Central Business District
Edmonton AB
Commercial
Central Business District
Edmonton AB
Commercial
Dominion Hotel
Edmonton AB
1903
Commercial
Grain Elevator
Red Deer AB
commercial
Grain Elevator
Lacombe AB
commercial
Grain Elevator
Lacombe AB
Commercial
MacDonald Hotel
Edmonton AB
Ross and MacFarlane/MacDonald
1912 - 1915
Commercial
MacDonald Hotel
Edmonton AB
Ross and MacFarlane/MacDonald
1912 - 1915
Commercial
MacDonald Hotel
Edmonton AB
Ross and MacFarlane/MacDonald
1912 - 1915
Commercial
McLeod Building
Edmonton AB
John Dow
1913 - 1915
Commercial
Medalta Stoneware (Medalta Potteries)
Medicine Hat AB
1912
Commercial
North West Trust
Edmonton AB
Roland W. Lines
1910
Commercial
Palliser Hotel
Calgary AB
Edward and William S. Maxwell
1911 - 1914
Commercial
Palliser Hotel
Calgary AB
Edward and William S. Maxwell
1911 - 1914
Commercial
Princess Cinema
Edmonton AB
Wilson and Herarld
1915
Commercial
Stephens Street Mall
Calgary AB
Commercial
Stephens Street Mall
Calgary AB
Commercial
New Search
Building Canada
C.A. 101
Pop Quiz
Overview
Glossary
General search