select * from bland_slides_info where (province like '%AB%') AND (type like '%resident%') AND bland_slides_date >= 0 and end_date <= 9999 order by title
Number of matched records: 8
Detail of Rural House
Markerville AB
residential
McLean Residence
Edmonton AB
1896
Residential
Nimmons House
Calgary AB
1898
Residential
Rural House
Markerville AB
residential
Rural House
Markerville AB
residential
Stefansson House
Markerville AB
Residential
View of Buildings
Calgary AB
Residential
View of House
Calgary AB
Residential
New Search
Building Canada
C.A. 101
Pop Quiz
Overview
Glossary
General search