select * from bland_slides_info where (province like '%SK%') AND (type like '%commercial%') AND bland_slides_date >= 0 and end_date <= 9999 order by title

Number of matched records: 2


Birk's Building
Saskatoon SK
Percy Nobbs
1929
commercial
Canadian Bank of Commerce
Regina SK
Darling and Pearson
1900
commercial

New Search

Building Canada C.A. 101 Pop Quiz Overview Glossary General search