select * from bland_slides_info where (province like '%PE%') AND (type like '%resident%') AND bland_slides_date >= 0 and end_date <= 9999 order by title
Number of matched records: 2
Beaconsfield
Charlottetown PEI
William Critchlow Harris
1877
residential
Yeo House
Green Park, Port Hill PEI
1865
residential
New Search
Building Canada
C.A. 101
Pop Quiz
Overview
Glossary
General search