Total number of units 8461

Property
Address
Total Units
Lam Tower
10020 - 103 Avenue
348
Pacific Park Apartments
9450 - 128 Street
288
Woolner Apartments
220 Woolner Avenue
260
Cedartree Village
113 - 7155 Hall Road
228
Trevella Park Townhomes
1300 - 41 Street SE
218
Imperial Parkside
9555 - 128 Street
204
Bonaventure Apartments
205 Heritage Drive SE
195
Greenwood Gardens
14831 - 104 Avenue
182
Falconcrest Village
360 Falshire Drive NE
176
Fairhaven
365 - 377 Pendygrasse Road
165
Ashley Court
14921 - 104 Avenue
150
Hampton Court
16404 - 115 Street NW
150
Gateway Place
11022 - 136 Street
133
Wedgewood Homes
12235 - 129A Street NW
132
Puja teysting apartments
Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments
122
Chelsea Park Gardens
33710 Marshall Road
114
Regent Place Apartments
14955 - 107 A Avenue
101
Etain Estates
3147 - 151 Avenue
99
Doverglen Estates
216 Doverglen Crescent SE
98
Hill-Tout Arms
2485 Hill-Tout Street
92
Pinetree Apartments
2525 Hill-Tout Street
89
Windsor Green
4610 Hubalta Road SE
88
Clareview Court
3820 - 134 Avenue NW
86
Mount View Terrace
33136 George Ferguson Way
84
Avenue Tower
333 - 17 Avenue SW
82
Hillside Place
12751 - 103 Avenue
72
Meadow
517 - 521 Avenue X South
72
Oakmount Manor
10710 - 110 Street NW
72
Hartford
11819 - 106 Street NW
71
Sunshine
33184 George Ferguson Way
69
Haddon Arms
50 Haddon Road SW
69
McCam 2
10325 - 123 Street NW
66
Bannerman Apartments
2606 - 139 Avenue NW
64
Bridgeport Manor
33405 Bourquin Place
60
Dahlstrom Manor
32030 George Ferguson Way
60
Huntsville
412 Huntsville Crescent NW
52
Glenbow Manor
4646 - 73 Street NW
50
Mainstreet Place
1122 - 8 Avenue SW
48
Rosslyn Apartments
13220 -113A Street NW
48
Cornerstone
10040 - 152 Street NW
48
Villa Vista
33292 Robertson Avenue East
47
Delburn House
1419 - 17 Avenue NW
47
Villa Monaco
33263 Bourquin Crescent East
44
Cameron Manor Apts. 2
1211 Cameron Street
43
Granville Place
10605 - 112 Street NW
43
Cameron Manor Apts. 1
1210 Cameron Street
41
Lauderdale Manor
10423 - 132 Avenue NW
39
Lancelot
1702 - 22 Street W
38
Seventh Street Manor
10716 - 107 Street NW
38
Second Street Manor
10620 - 102 Street NW
38
Hillside Terrace
2814 Pratt Crescent
37
Whitehouse
10136 - 153 Street NW
36
Coronation Place
444 - 5 Avenue North
35
Kewanee Manor
502 - 5 Avenue North
35
Gilford Apartments
10638 - 106 Street NW
35
Royal Manor
33298 Robertson Avenue
34
White Plains Manor
2620 - 16 Street SW
34
Belmae Manor
445 - 3 Avenue North
33
Wellington
10730 - 111 Street NW
33
Waselenak Place
10720 - 108 Street NW
33
McCam 1
10330 - 123 Street NW
33
Majestic
11416 - 124 Street NW
33
Hilton Manor
10633 - 111 Street NW
33
Hudson Arms
10625 - 117 Street NW
33
King's Court
11065 - 149 Street
33
Vintage Squared
528 - 15 Ave SW
32
Westwinds
211 - 14 Avenue SW
32
Nova Manor
15628 - 100 Avenue
32
Camino Manor
115 Avenue O South
31
Park Manor
102 Avenue O South
31
Trinity A
10720 - 104 Street NW
31
Trinity B
10730 - 104 Street NW
31
Oliver 3
10330 - 115 St NW
31
Marc Manor
8215 - 144 Avenue NW
31
Anna Court
4508 - 8 Avenue SE
30
Wilmax
1212 - 13 Avenue SW
30
Cochrane House Apts.
205 Ross Avenue
30
Montrose Manor
305 - 26 Street East
30
Eileen Manor
10735 - 104 Street NW
30
Virginian Arms
10615 - 107 Street NW
29
Maggie Manor
1431 - 37 Street SW
27
Redwood Meadows
11848 - 87 Street
27
Deluca Manor
10128 - 161 Street NW
27
1612
1612 - 24 Avenue SW
26
Parkview Manor
445 - 5 Avenue North
26
Queen Mary
10835 - 115 Street NW
26
McQueen Place
14224 McQueen Road NW
26
Elizabeth Manor
11343 - 124 Street NW
25
Bankview Place
1715 - 24 Avenue SW
24
Chinook Winds
707 - 57 Avenue SW
24
Westview Terrace
1611 - 23 Avenue SW
24
Booth Apartments
106 - 111 Street
24
Diane Apartments 1
541 Avenue W South
24
Argyll A
7107 - 79 Avenue NW
24
Argyll B
7108 - 78 Avenue NW
24
Key West Apartments
135 Avenue W South
24
Peat Place
3701 - 8 Street East
24
Pisces Manor
1622 - 22 Street West
24
Washington Court
10715 - 104 Street NW
24
Twilight Manor
10723 - 102 Street NW
24
Tiffany
10721 - 117 Street NW
24
Oasis Apartments
10155 - 153 Street NW
24
Malibu House
10717 - 107 Street NW
24
Lincoln Terrace
2111 - 54 Avenue SW
23
North Hill Manor
305 - 13 Avenue NE
23
Byron
10650 - 103 Street NW
23
Vista Green
10610 - 115 Street NW
23
Rosa Manor
10630 - 105 Street NW
23
Oliver 1
10320 - 115 St NW
23
Oliver 4
10315 - 116 St NW
23
Julliard North
10735 - 103 Street NW
23
Julliard South
10727 - 103 Street NW
23
Karen Hall
9415 - 94 Avenue
23
Tarun testing apartments1
Mainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMains
23
Floyd Manor
1607 - 4 Street NW
22
Amera Manor1
11615 - 124 Street NW
22
Cedar Grove
10633 - 110 Street NW
22
Villa
11217 - 124 Street NW
22
Somerset
10710 - 111 Street NW
22
Carina Court
10610 - 106 Street NW
22
Cypress Manor
10745 - 110 Street NW
22
Dickens
10325 - 117 Street NW
22
Oliver 2
10325 - 115 St NW
22
Norland House
10630 - 115 Street NW
22
McLaren Manor
10720 - 111 Street NW
22
McCam 3
10320 - 123 Street NW
22
Hansen House
10630 - 112 Street NW
22
Lorraine Manor
10727 - 110 Street NW
22
Kane
10316 - 119 Street NW
22
Spring Garden Terrace
1723 - 26 Avenue SW
21
Taurus
11937 - 105 Street NW
21
Prairie Manor
11820 - 101 Street NW
21
Palmont Place
10823 - 115 Street NW
21
Grand
11919 - 105 Street NW
21
Murray
11906 - 104 Street NW
21
MACK Apartments
10630 - 107 Street NW
21
King Edward
7108 - 79 Ave
21
Astoria Manor
1735 - 26 Avenue SW
20
Sunshine Mills
11124 - 124 Street
20
Chelsey
10730 - 109 Street NW
20
Dorset Arms
11708 - 124 Street NW
20
Ingle Apartments
11545 - 124 Street
20
Libra Apartments
202 Avenue N South
19
Grapes Manor
1639 - 26 Avenue SW
18
Westbrook Manor
937 - 37 Street SW
18
Diane Apartments 2
2310 17 Street West
18
Alexander Apartments
12220 - 82 Street NW
18
Linde Apartments
1101 Avenue W North
18
Preston Apartments
909 Preston Avenue South
18
Preston 2 Apartments
905 Preston Avenue South
18
Rockhill Manor
11930 - 104 Street NW
18
Rockcliffe Manor
10715 - 116 Street NW
18
Confederation Place
15216 - 100 Avenue NW
18
Pine Manor
10741 - 112 Street NW
18
Ariel Apartments
10729 - 104 Street NW
17
Laurentian Apartments
2513 - 7 Street East
17
Saint Paul's
1701 - 20 Street West
17
Shardan Manor
10224 - 122 Street NW
17
Pride Apartments
13608 -109A Avenue NW
17
Plaza Manor
11841 - 105 Street NW
17
Erin Place
11828 - 105 Street NW
17
Grace Manor
10634 - 113 Street NW
17
Leo Manor
355 Avenue T South
16
Gemini
403 Avenue P South
15
Aspen Apartments
12207 - 82 Street NW
15
Berkley Manor
10810 - 114 Street NW
15
Capitol Manor
10125 - 152 Street NW
15
Victoria Park Apartments
612 Spadina Cres. West
15
Willow Apartments
10303 - 120 Avenue NW
15
Westmore
10820 - 114 Street NW
15
Serenity
10416 - 119 Avenue NW
15
Salem Court
10819 - 111 Street NW
15
Riverside Estates C
9245 Jasper Avenue NW
15
Riverside Estates E
9315 Jasper Avenue NW
15
Windfall Court
10356 – 92 Street Edmonton
15
Cedarwood Arms
10614 - 122 Street NW
14
Madison Court
11807 - 102 Street NW
14
Eastwood Manor
11920 - 82 Street
13
Duchess Manor
901 - 5 Avenue North
12
Kerpel
131 Avenue P South
12
Aurora Place
10041 - 152 Street NW
12
Beauview Apartments
10443 - 156 Street NW
12
Raydel Manor
339 Avenue Q South
12
Riverside Estates A
9209 Jasper Avenue NW
12
Riverside Estates B
9217 Jasper Avenue NW
12
Riverside Estates D
9305 Jasper Avenue NW
12
Priya Place A
10711 - 103 Street NW
12
Priya Place B
10715 - 103 Street NW
12
Prince Rupert
11225 - 117 Street NW
12
College Grove
10619 - 104 Street NW
12
Jasmin Court
10016 - 152 Street NW
12
Tarun testing apartments
Tarun testing apartments Tarun apartments
12
Capricorn Apartments
128 Avenue O South
11
Pleasant Hill
1628 - 22 Street
11
Rosedale
10955 - 97 Street
11
2501
2501 - 15 Street SW
10
Charles Rutherford Apartments
9804 - 102 Street
9
Building Name
India (Listeni/??ndi?/), officially the Republic of India (Bh?rat Ga?ar?jya),[13][c] is a country in South Asia. It is the seventh-largest country by area, the second-most populous country with over 1
8
Avenue Houses
336 - 18 Avenue SW
7
silvia apartment
1617 - 124 Street NW
3
XYZ
#123 Demo Address
2
plot no 17
plot no 17
2
test first building
test first buildingtest first buildingtest first buildingtest first buildingtest first building
2
Test by sneha
as
1
Tetsing
add
1
Building
add
1
Testing
add
1
Test apartment's by sneha
Des/;sd' )*(&^$%@#! Des/;sd' )*(&^$%@#!
1
Buildingtesttttttt
addd
1
FT building
FULLY RENOVATED. Rental Suite Amenities: Newly renovated. New kitchen cabinets and appliances, sleek black granite counter top, ceramic tile flooring in the kitchen and bathroom. Wood laminate floor
1
Test apartment's by sneha
add
1
acme heights
1612 - 24 Avenue SW
1
Netsol
Netsol
1
plot no 15
plot no 15
1
plot no 16
plot no 15
1

Abbotsford number of units 889

Property
Address
Total Units
Puja teysting apartments
Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments Puja teysting apartments
122
Chelsea Park Gardens
33710 Marshall Road
114
Hill-Tout Arms
2485 Hill-Tout Street
92
Pinetree Apartments
2525 Hill-Tout Street
89
Mount View Terrace
33136 George Ferguson Way
84
Sunshine
33184 George Ferguson Way
69
Bridgeport Manor
33405 Bourquin Place
60
Dahlstrom Manor
32030 George Ferguson Way
60
Villa Vista
33292 Robertson Avenue East
47
Villa Monaco
33263 Bourquin Crescent East
44
Hillside Terrace
2814 Pratt Crescent
37
Royal Manor
33298 Robertson Avenue
34
Tarun testing apartments1
Mainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMainstreet TVMains
23
Tarun testing apartments
Tarun testing apartments Tarun apartments
12
Building
add
1
Netsol
Netsol
1

Calgary number of units 1810

Property
Address
Total Units
Trevella Park Townhomes
1300 - 41 Street SE
218
Bonaventure Apartments
205 Heritage Drive SE
195
Falconcrest Village
360 Falshire Drive NE
176
Ashley Court
14921 - 104 Avenue
150
Doverglen Estates
216 Doverglen Crescent SE
98
Windsor Green
4610 Hubalta Road SE
88
Avenue Tower
333 - 17 Avenue SW
82
Haddon Arms
50 Haddon Road SW
69
Huntsville
412 Huntsville Crescent NW
52
Glenbow Manor
4646 - 73 Street NW
50
Mainstreet Place
1122 - 8 Avenue SW
48
Delburn House
1419 - 17 Avenue NW
47
White Plains Manor
2620 - 16 Street SW
34
Vintage Squared
528 - 15 Ave SW
32
Westwinds
211 - 14 Avenue SW
32
Anna Court
4508 - 8 Avenue SE
30
Wilmax
1212 - 13 Avenue SW
30
Maggie Manor
1431 - 37 Street SW
27
Bankview Place
1715 - 24 Avenue SW
24
Chinook Winds
707 - 57 Avenue SW
24
Westview Terrace
1611 - 23 Avenue SW
24
Argyll A
7107 - 79 Avenue NW
24
Argyll B
7108 - 78 Avenue NW
24
Lincoln Terrace
2111 - 54 Avenue SW
23
North Hill Manor
305 - 13 Avenue NE
23
Floyd Manor
1607 - 4 Street NW
22
Amera Manor1
11615 - 124 Street NW
22
Spring Garden Terrace
1723 - 26 Avenue SW
21
Astoria Manor
1735 - 26 Avenue SW
20
Grapes Manor
1639 - 26 Avenue SW
18
Westbrook Manor
937 - 37 Street SW
18
Ariel Apartments
10729 - 104 Street NW
17
Aspen Apartments
12207 - 82 Street NW
15
Aurora Place
10041 - 152 Street NW
12
Building Name
India (Listeni/??ndi?/), officially the Republic of India (Bh?rat Ga?ar?jya),[13][c] is a country in South Asia. It is the seventh-largest country by area, the second-most populous country with over 1
8
Avenue Houses
336 - 18 Avenue SW
7
silvia apartment
1617 - 124 Street NW
3
test first building
test first buildingtest first buildingtest first buildingtest first buildingtest first building
2
Buildingtesttttttt
addd
1

Cochrane number of units 31

Property
Address
Total Units
Cochrane House Apts.
205 Ross Avenue
30
Test apartment's by sneha
add
1

Edmonton number of units 3239

Property
Address
Total Units
Lam Tower
10020 - 103 Avenue
348
Hampton Court
16404 - 115 Street NW
150
Wedgewood Homes
12235 - 129A Street NW
132
Etain Estates
3147 - 151 Avenue
99
Clareview Court
3820 - 134 Avenue NW
86
Oakmount Manor
10710 - 110 Street NW
72
Hartford
11819 - 106 Street NW
71
McCam 2
10325 - 123 Street NW
66
Bannerman Apartments
2606 - 139 Avenue NW
64
Rosslyn Apartments
13220 -113A Street NW
48
Cornerstone
10040 - 152 Street NW
48
Granville Place
10605 - 112 Street NW
43
Lauderdale Manor
10423 - 132 Avenue NW
39
Seventh Street Manor
10716 - 107 Street NW
38
Second Street Manor
10620 - 102 Street NW
38
Whitehouse
10136 - 153 Street NW
36
Gilford Apartments
10638 - 106 Street NW
35
Wellington
10730 - 111 Street NW
33
Waselenak Place
10720 - 108 Street NW
33
McCam 1
10330 - 123 Street NW
33
Majestic
11416 - 124 Street NW
33
Hilton Manor
10633 - 111 Street NW
33
Hudson Arms
10625 - 117 Street NW
33
King's Court
11065 - 149 Street
33
Nova Manor
15628 - 100 Avenue
32
Trinity A
10720 - 104 Street NW
31
Trinity B
10730 - 104 Street NW
31
Oliver 3
10330 - 115 St NW
31
Marc Manor
8215 - 144 Avenue NW
31
Eileen Manor
10735 - 104 Street NW
30
Virginian Arms
10615 - 107 Street NW
29
Redwood Meadows
11848 - 87 Street
27
Deluca Manor
10128 - 161 Street NW
27
Queen Mary
10835 - 115 Street NW
26
McQueen Place
14224 McQueen Road NW
26
Elizabeth Manor
11343 - 124 Street NW
25
Washington Court
10715 - 104 Street NW
24
Twilight Manor
10723 - 102 Street NW
24
Tiffany
10721 - 117 Street NW
24
Oasis Apartments
10155 - 153 Street NW
24
Malibu House
10717 - 107 Street NW
24
Byron
10650 - 103 Street NW
23
Vista Green
10610 - 115 Street NW
23
Rosa Manor
10630 - 105 Street NW
23
Oliver 1
10320 - 115 St NW
23
Oliver 4
10315 - 116 St NW
23
Julliard North
10735 - 103 Street NW
23
Julliard South
10727 - 103 Street NW
23
Cedar Grove
10633 - 110 Street NW
22
Villa
11217 - 124 Street NW
22
Somerset
10710 - 111 Street NW
22
Carina Court
10610 - 106 Street NW
22
Cypress Manor
10745 - 110 Street NW
22
Dickens
10325 - 117 Street NW
22
Oliver 2
10325 - 115 St NW
22
Norland House
10630 - 115 Street NW
22
McLaren Manor
10720 - 111 Street NW
22
McCam 3
10320 - 123 Street NW
22
Hansen House
10630 - 112 Street NW
22
Lorraine Manor
10727 - 110 Street NW
22
Kane
10316 - 119 Street NW
22
Taurus
11937 - 105 Street NW
21
Prairie Manor
11820 - 101 Street NW
21
Palmont Place
10823 - 115 Street NW
21
Grand
11919 - 105 Street NW
21
Murray
11906 - 104 Street NW
21
MACK Apartments
10630 - 107 Street NW
21
King Edward
7108 - 79 Ave
21
Sunshine Mills
11124 - 124 Street
20
Chelsey
10730 - 109 Street NW
20
Dorset Arms
11708 - 124 Street NW
20
Ingle Apartments
11545 - 124 Street
20
Rockhill Manor
11930 - 104 Street NW
18
Rockcliffe Manor
10715 - 116 Street NW
18
Confederation Place
15216 - 100 Avenue NW
18
Pine Manor
10741 - 112 Street NW
18
Shardan Manor
10224 - 122 Street NW
17
Pride Apartments
13608 -109A Avenue NW
17
Plaza Manor
11841 - 105 Street NW
17
Erin Place
11828 - 105 Street NW
17
Grace Manor
10634 - 113 Street NW
17
Berkley Manor
10810 - 114 Street NW
15
Capitol Manor
10125 - 152 Street NW
15
Willow Apartments
10303 - 120 Avenue NW
15
Westmore
10820 - 114 Street NW
15
Serenity
10416 - 119 Avenue NW
15
Salem Court
10819 - 111 Street NW
15
Riverside Estates C
9245 Jasper Avenue NW
15
Riverside Estates E
9315 Jasper Avenue NW
15
Windfall Court
10356 – 92 Street Edmonton
15
Cedarwood Arms
10614 - 122 Street NW
14
Madison Court
11807 - 102 Street NW
14
Eastwood Manor
11920 - 82 Street
13
Beauview Apartments
10443 - 156 Street NW
12
Riverside Estates A
9209 Jasper Avenue NW
12
Riverside Estates B
9217 Jasper Avenue NW
12
Riverside Estates D
9305 Jasper Avenue NW
12
Priya Place A
10711 - 103 Street NW
12
Priya Place B
10715 - 103 Street NW
12
Prince Rupert
11225 - 117 Street NW
12
College Grove
10619 - 104 Street NW
12
Jasmin Court
10016 - 152 Street NW
12
Rosedale
10955 - 97 Street
11
plot no 17
plot no 17
2
plot no 15
plot no 15
1

Ft Saskatchewan number of units 33

Property
Address
Total Units
Karen Hall
9415 - 94 Avenue
23
Charles Rutherford Apartments
9804 - 102 Street
9
FT building
FULLY RENOVATED. Rental Suite Amenities: Newly renovated. New kitchen cabinets and appliances, sleek black granite counter top, ceramic tile flooring in the kitchen and bathroom. Wood laminate floor
1

New Westminster number of units 87

Property
Address
Total Units
Cameron Manor Apts. 2
1211 Cameron Street
43
Cameron Manor Apts. 1
1210 Cameron Street
41
Test by sneha
as
1
Testing
add
1
Test apartment's by sneha
Des/;sd' )*(&^$%@#! Des/;sd' )*(&^$%@#!
1

Saskatoon number of units 845

Property
Address
Total Units
Fairhaven
365 - 377 Pendygrasse Road
165
Meadow
517 - 521 Avenue X South
72
Lancelot
1702 - 22 Street W
38
Coronation Place
444 - 5 Avenue North
35
Kewanee Manor
502 - 5 Avenue North
35
Belmae Manor
445 - 3 Avenue North
33
Camino Manor
115 Avenue O South
31
Park Manor
102 Avenue O South
31
Montrose Manor
305 - 26 Street East
30
Parkview Manor
445 - 5 Avenue North
26
Booth Apartments
106 - 111 Street
24
Diane Apartments 1
541 Avenue W South
24
Key West Apartments
135 Avenue W South
24
Peat Place
3701 - 8 Street East
24
Pisces Manor
1622 - 22 Street West
24
Libra Apartments
202 Avenue N South
19
Diane Apartments 2
2310 17 Street West
18
Linde Apartments
1101 Avenue W North
18
Preston Apartments
909 Preston Avenue South
18
Preston 2 Apartments
905 Preston Avenue South
18
Laurentian Apartments
2513 - 7 Street East
17
Saint Paul's
1701 - 20 Street West
17
Leo Manor
355 Avenue T South
16
Gemini
403 Avenue P South
15
Victoria Park Apartments
612 Spadina Cres. West
15
Duchess Manor
901 - 5 Avenue North
12
Kerpel
131 Avenue P South
12
Raydel Manor
339 Avenue Q South
12
Capricorn Apartments
128 Avenue O South
11
Pleasant Hill
1628 - 22 Street
11

Surrey number of units 1267

Property
Address
Total Units
Pacific Park Apartments
9450 - 128 Street
288
Cedartree Village
113 - 7155 Hall Road
228
Imperial Parkside
9555 - 128 Street
204
Greenwood Gardens
14831 - 104 Avenue
182
Gateway Place
11022 - 136 Street
133
Regent Place Apartments
14955 - 107 A Avenue
101
Hillside Place
12751 - 103 Avenue
72
1612
1612 - 24 Avenue SW
26
Alexander Apartments
12220 - 82 Street NW
18
2501
2501 - 15 Street SW
10
XYZ
#123 Demo Address
2
Tetsing
add
1
acme heights
1612 - 24 Avenue SW
1
plot no 16
plot no 15
1
(default) 17 queries took 30 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 (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 1111
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) 110
7SELECT `Property`.`name`, `Property`.`address`, (SUM(`MultipleUnit`.`unit`)) AS `Property__total_units` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id` AND `Property`.`is_completed`='complete') WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc2152154
8SELECT `City`.`id`, `City`.`name`, (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 `Property`.`is_completed`='complete') LEFT JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `City`.`id`8813
9SELECT (SUM(`MultipleUnit`.`unit`)) AS `Property__total_suits`, (`Property`.`name`) AS `Property__property_name`, (`Property`.`address`) AS `Property__property_address` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `City`.`id`=1) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc16162
10SELECT (SUM(`MultipleUnit`.`unit`)) AS `Property__total_suits`, (`Property`.`name`) AS `Property__property_name`, (`Property`.`address`) AS `Property__property_address` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `City`.`id`=2) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc551
11SELECT (SUM(`MultipleUnit`.`unit`)) AS `Property__total_suits`, (`Property`.`name`) AS `Property__property_name`, (`Property`.`address`) AS `Property__property_address` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `City`.`id`=3) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc14141
12SELECT (SUM(`MultipleUnit`.`unit`)) AS `Property__total_suits`, (`Property`.`name`) AS `Property__property_name`, (`Property`.`address`) AS `Property__property_address` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `City`.`id`=4) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc39392
13SELECT (SUM(`MultipleUnit`.`unit`)) AS `Property__total_suits`, (`Property`.`name`) AS `Property__property_name`, (`Property`.`address`) AS `Property__property_address` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `City`.`id`=5) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc221
14SELECT (SUM(`MultipleUnit`.`unit`)) AS `Property__total_suits`, (`Property`.`name`) AS `Property__property_name`, (`Property`.`address`) AS `Property__property_address` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `City`.`id`=6) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc1051052
15SELECT (SUM(`MultipleUnit`.`unit`)) AS `Property__total_suits`, (`Property`.`name`) AS `Property__property_name`, (`Property`.`address`) AS `Property__property_address` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `City`.`id`=7) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc331
16SELECT (SUM(`MultipleUnit`.`unit`)) AS `Property__total_suits`, (`Property`.`name`) AS `Property__property_name`, (`Property`.`address`) AS `Property__property_address` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `City`.`id`=8) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 GROUP BY `Property`.`id` ORDER BY (SUM(`MultipleUnit`.`unit`)) desc30302
17SELECT `InvestorSliderImage`.`id`, `InvestorSliderImage`.`image_name`, `InvestorSliderImage`.`title`, (`Property`.`name`) AS `InvestorSliderImage__name`, (`City`.`name`) AS `InvestorSliderImage__city`, (`Province`.`province_code`) AS `InvestorSliderImage__province_code` FROM `mec_realport03`.`investor_slider_images` AS `InvestorSliderImage` INNER JOIN `mec_realport03`.`properties` AS `Property` ON (`Property`.`id` = `InvestorSliderImage`.`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 `investor_page` = 'property_portfolio' ORDER BY (`Property`.`name`) ASC000