Mainstreet
The Company
Mainstreet Equity Corp. is a distinguished Property Management firm. We acquire, redevelop and manage boutique rental apartments. Mainstreet is proud to be setting a new standard in multi-family living across our vast portfolio, which stretches from Saskatchewan to British Columbia.
At Mainstreet we truly value our employees. We mean it when we say our people are vital to our success! Our team is a valuable mix of experience and new talent, trades, and professionals. Our workplace embraces challenges, new ideas, diversity and fun!
Why Mainstreet?
We offer competitive wages, company paid benefits, incentive programs and a promote from within culture! We are always seeking talented candidates who are driven to succeed, are focused on customers and enjoy working in a dynamic environment. If this sounds like you, we encourage you to submit your cover letter and resume.
*Mainstreet Equity Corp. is an equal opportunity employer.
Open Positions
(default) 9 queries took 0 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 `City`.`province_id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='surrey' LIMIT 1110
5SELECT `Province`.`province_code` FROM `mec_realport03`.`provinces` AS `Province` WHERE id=1 LIMIT 1110
6SELECT `Meta`.`title`, `Meta`.`keyword`, `Meta`.`description` FROM `mec_realport03`.`metas` AS `Meta` WHERE `Meta`.`page` = 'job_list_by_city' LIMIT 1110
7SELECT `City`.`id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='surrey' LIMIT 1110
8SELECT `Job`.`id`, `Job`.`title`, `Job`.`type`, `Job`.`deadline`, (`City`.`name`) AS `Job__city_name`, (`Province`.`province_code`) AS `Job__province_code` FROM `mec_realport03`.`jobs` AS `Job` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`Job`.`city_id`=`City`.`id`) INNER JOIN `mec_realport03`.`provinces` AS `Province` ON (`Province`.`id`=`Job`.`province`) WHERE posting='on' AND city_id=3 ORDER BY `Job`.`deadline` asc LIMIT 18330
9SELECT COUNT(*) AS `count` FROM `mec_realport03`.`jobs` AS `Job` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`Job`.`city_id`=`City`.`id`) INNER JOIN `mec_realport03`.`provinces` AS `Province` ON (`Province`.`id`=`Job`.`province`) WHERE posting='on' AND city_id=3110