select * from bland_slides_info where (province like '%NS%') AND (type like '%commercial%') AND bland_slides_date >= 0 and end_date <= 9999 order by title
Number of matched records: 19
Adams and Knikle Plant
Lunenburg NS
Commercial
Adams and Knikle Plant (detail)
Lunenburg NS
Commercial
Barn
Canso Straits NS
Commercial
Barn
Grandville NS
Commercial
Barn
Salmon River NS
Commercial
Building at 58 Queen Street
Halifax NS
Commercial
Building on Acadia Corner
Halifax NS
Commercial
Building on Acadia Corner
Halifax NS
Commercial
Building on Water Street
Halifax NS
Commercial
Building on Water Street
Halifax NS
Commercial
Buildings on Hollis Street
Halifax NS
Commercial
Buildings on Hollis Street
Halifax NS
Commercial
Canadian National Research Station
Pictou NS
1905
Commercial
Chateau Saint-Louis
Louisbourg NS
Commercial
Chateau Saint-Louis
Louisbourg NS
Commercial
Chateau Saint-Louis
Louisbourg NS
Commercial
Chateau Saint-Louis
Louisbourg NS
Commercial
Chateau Saint-Louis, Chapel, interior
Louisbourg NS
Commercial
Factory
Truro NS
1910
Commercial
New Search
Building Canada
C.A. 101
Pop Quiz
Overview
Glossary
General search