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

Nombre de dossiers trouvés: 5


Log Barn
King's Landing NB
commercial
MacDonald Farm
Bartibog NB
Alexander Macdonald
1815 - 1820
Commercial
Market Square
Saint John NB
Commercial and View
Mill
King's Landing NB
Commercial

Royal Hotel
Saint John NB
Commercial

Nouvelle recherche

Édifices Canada A.C. 101 Quiz Vue d'ensemble Glossaire Recherche générale