Find an Apartment

Abbotsford

British Columbia

Abbotsford Apartments

British Columbia

16

Locations

889

Suites

New Westminster

British Columbia

New Westminster Apartments

British Columbia

4

Locations

87

Suites

Surrey

British Columbia

Surrey Apartments

British Columbia

13

Locations

1267

Suites

Calgary / Cochrane

Alberta

39

Locations

1810

Suites

2

Locations

31

Suites

Edmonton

Alberta

105

Locations

3239

Suites

Ft Saskatchewan

Alberta

3

Locations

33

Suites

Saskatoon

Saskatchewan

Saskatoon Apartments

Saskatchewan

30

Locations

845

Suites

Latest Blog Posts

(default) 17 queries took 29 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` asc441
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` = 'home' LIMIT 1110
5SELECT (SUM(`MultipleUnit`.`unit`)) AS `MultipleUnit__suitCount`, `MultipleUnit`.`id` FROM `mec_realport03`.`multiple_units` AS `MultipleUnit` INNER JOIN `mec_realport03`.`properties` AS `Property` ON (`Property`.`id` = `MultipleUnit`.`property_id` AND `Property`.`is_completed`='complete') WHERE 1 = 1 LIMIT 1114
6SELECT `FloorPlan`.`id`, `FloorPlan`.`property_id`, `FloorPlan`.`multiple_unit_id`, `FloorPlan`.`title`, `FloorPlan`.`file_name`, `FloorPlan`.`status`, `FloorPlan`.`created`, `FloorPlan`.`modified` FROM `mec_realport03`.`floor_plans` AS `FloorPlan` WHERE `FloorPlan`.`multiple_unit_id` = (4) 111
7SELECT COUNT(*) AS `count` FROM `mec_realport03`.`cities` AS `City` WHERE 1 = 1110
8SELECT `City`.`id`, `City`.`name`, `City`.`display_image`, (`Province`.`name`) AS `City__province`, (COUNT(DISTINCT(`Property`.`id`))) AS `City__total_appartments` FROM `mec_realport03`.`cities` AS `City` INNER JOIN `mec_realport03`.`provinces` AS `Province` ON (`Province`.`id` = `City`.`province_id`) INNER JOIN `mec_realport03`.`properties` AS `Property` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `Property`.`featured`='true') INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id` AND `MultipleUnit`.`unit_type_id` !=5) WHERE 1 = 1 GROUP BY `City`.`id`882
9SELECT (SUM(`MultipleUnit`.`unit`)) AS `City__total_suits` FROM `mec_realport03`.`cities` AS `City` LEFT JOIN `mec_realport03`.`properties` AS `Property` ON (`City`.`id` = `Property`.`city_id` AND `City`.`id` = 1 AND `Property`.`is_completed`='complete') LEFT JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 LIMIT 1112
10SELECT (SUM(`MultipleUnit`.`unit`)) AS `City__total_suits` FROM `mec_realport03`.`cities` AS `City` LEFT JOIN `mec_realport03`.`properties` AS `Property` ON (`City`.`id` = `Property`.`city_id` AND `City`.`id` = 2 AND `Property`.`is_completed`='complete') LEFT JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 LIMIT 1111
11SELECT (SUM(`MultipleUnit`.`unit`)) AS `City__total_suits` FROM `mec_realport03`.`cities` AS `City` LEFT JOIN `mec_realport03`.`properties` AS `Property` ON (`City`.`id` = `Property`.`city_id` AND `City`.`id` = 3 AND `Property`.`is_completed`='complete') LEFT JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 LIMIT 1112
12SELECT (SUM(`MultipleUnit`.`unit`)) AS `City__total_suits` FROM `mec_realport03`.`cities` AS `City` LEFT JOIN `mec_realport03`.`properties` AS `Property` ON (`City`.`id` = `Property`.`city_id` AND `City`.`id` = 4 AND `Property`.`is_completed`='complete') LEFT JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 LIMIT 1113
13SELECT (SUM(`MultipleUnit`.`unit`)) AS `City__total_suits` FROM `mec_realport03`.`cities` AS `City` LEFT JOIN `mec_realport03`.`properties` AS `Property` ON (`City`.`id` = `Property`.`city_id` AND `City`.`id` = 5 AND `Property`.`is_completed`='complete') LEFT JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `Multipl