Bland information request result

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


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