Student Housing

  • Home
  • Student Housing

Student Housing

Abbotsford • Surrey • New Westminster • Calgary • Edmonton • Saskatoon


Attending school from: AROUND THE WORLD; ACROSS THE COUNTRY; or ACROSS TOWN? Mainstreet has an apartment for you.

We understand your needs. We offer comfortable, secure, affordable housing, that lets you focus on what’s important – your future.

Why choose Mainstreet as your student housing option?

- Save time & money, live close to school

- Be secure in our buildings

- Affordable rent, low security deposit

- Comfortable, NEWLY renovated suites

- No worries, 24/7 maintenance, professionally managed


- Get approved before you arrive

- Credit card acceptance

- Get picked up at the airport when you arrive in your residing city

- We speak your language - multi-lingual team members to help you transition

- Student Housing Specialist that is there when you need him

CONTACT: EMAIL // (403) 444-4086

India, Phillippines, Pakistan, Germany, ESL, University, College, Post-secondary, Housing, Students, International-Students, Canada

(default) 7 queries took 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `City`.`id`, `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE 1 = 1880
2SELECT `Province`.`id`, `Province`.`name`, `Province`.`province_code`, `Province`.`status`, `Province`.`created`, `Province`.`modified` FROM `mec_realport03`.`provinces` AS `Province` WHERE 1 = 1 ORDER BY `name` asc440
3SELECT `City`.`id`, `City`.`name`, `City`.`province_id`, `City`.`display_image`, `City`.`is_video_avail`, `City`.`content`, `City`.`status`, `City`.`created`, `City`.`modified`, `City`.`student_resource`, `City`.`citiescol` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`province_id` IN (2, 1, 4, 3) 880
4SELECT `Meta`.`title`, `Meta`.`keyword`, `Meta`.`description` FROM `mec_realport03`.`metas` AS `Meta` WHERE `Meta`.`page` = '' LIMIT 1000
5SELECT `StudentHousingSlide`.`id`, `StudentHousingSlide`.`title`, `StudentHousingSlide`.`image_name`, (`City`.`name`) AS `StudentHousingSlide__city`, (`Property`.`name`) AS `StudentHousingSlide__name`, (`Province`.`province_code`) AS `StudentHousingSlide__province_code` FROM `mec_realport03`.`student_housing_slides` AS `StudentHousingSlide` INNER JOIN `mec_realport03`.`properties` AS `Property` ON (`Property`.`id`=`StudentHousingSlide`.`property_id`) INNER JOIN `mec_realport03`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) INNER JOIN `mec_realport03`.`provinces` AS `Province` ON (`City`.`province_id` = `Province`.`id`) WHERE 1 = 1 ORDER BY `id` ASC13136
6SELECT `City`.`id`, `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE 1 = 1880
7SELECT `StudentHousing`.`id`, `StudentHousing`.`title`, `StudentHousing`.`description`, `StudentHousing`.`resource`, `StudentHousing`.`modified`, `StudentHousing`.`created` FROM `mec_realport03`.`student_housings` AS `StudentHousing` WHERE 1 = 1111