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

Number of matched records: 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

New Search

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