Calgary Apartments

39 locations. 1810 apartments for rent.

  • Home
  • Calgary Apartments
41 Results
Featured Property : my style house
Amera Manor1
Amera Manor1
11615 - 124 Street NW
B Appart
1 Appart
2 Appart
Click for details
Rent from
$695
Featured Property : my style housemy style house
Anna Court
Anna Court
4508 - 8 Avenue SE
1 Appart
Click for details
Rent from
$995
Featured Property : my style house
Argyll B
Argyll B
7108 - 78 Avenue NW
B Appart
1 Appart
2 Appart
Click for details
Rent from
$820
Featured Property : Renovations just completed
Ariel Apartments
Ariel Apartments
10729 - 104 Street NW
1 Appart
2 Appart
Click for details
Rent from
$770
Featured Property : Pizzaaaaa
Astoria Manor
Astoria Manor
1735 - 26 Avenue SW
1 Appart
2 Appart
Click for details
Rent from
$1075
Argyll A
Argyll A
7107 - 79 Avenue NW
B Appart
1 Appart
2 Appart
Click for details
test first building
Test First Building
Test First Buildingtest First Buildingtest First Buildingtest First Buildingtest First Building
1 Appart
Click for details
Ashley Court
Ashley Court
14921 - 104 Avenue
1 Appart
2 Appart
3 Appart
Click for details
Rent from
$750
Aspen Apartments
Aspen Apartments
12207 - 82 Street NW
B Appart
1 Appart
2 Appart
Click for details
Rent from
$670
Aurora Place
Aurora Place
10041 - 152 Street NW
1 Appart
2 Appart
Click for details
Rent from
$850
(default) 20 queries took 44 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`.`id`, `City`.`province_id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='calgary' LIMIT 1110
5SELECT `Province`.`province_code` FROM `mec_realport03`.`provinces` AS `Province` WHERE id=2 LIMIT 1110
6SELECT (COUNT(DISTINCT(`Property`.`id`))) AS `City__total_appartments` FROM `mec_realport03`.`cities` AS `City` INNER JOIN `mec_realport03`.`properties` AS `Property` ON (`City`.`id` = `Property`.`city_id` AND `Property`.`is_completed`='complete' AND `Property`.`featured`='true' AND `City`.`id` = 4) 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` LIMIT 1118
7SELECT (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
8SELECT `Meta`.`title`, `Meta`.`keyword`, `Meta`.`description` FROM `mec_realport03`.`metas` AS `Meta` WHERE `Meta`.`page` = 'aparment_listing' LIMIT 1110
9SELECT `City`.`id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='calgary' LIMIT 1110
10SELECT `City`.`name`, `City`.`id`, `City`.`content` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 4 LIMIT 1110
11SELECT `CityArea`.`id`, `CityArea`.`name` FROM `mec_realport03`.`city_areas` AS `CityArea` WHERE city_id=4662
12SELECT `UnitType`.`id`, `UnitType`.`name` FROM `mec_realport03`.`unit_types` AS `UnitType` WHERE `id` <> 5441
13SELECT `Property`.`id`, `Property`.`name`, `Property`.`category`, `Property`.`byline_text`, `Property`.`byline_color`, `Property`.`zipcode`, `Property`.`address`, `Property`.`phone`, `Property`.`latitude`, `Property`.`longitude`, `Byline`.`bylineText`, (MIN(`MultipleUnit`.`net_rent_from`)) AS `Property__rent_from`, (`PropertyMediaImage`.`file_name`) AS `Property__file_name`, (`City`.`name`) AS `Property__city`, (`Country`.`name`) AS `Property__country` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id`=`Property`.`city_id` AND (`Property`.`city_id`='4' or `Property`.`city_id`='5')) INNER JOIN `mec_realport03`.`countries` AS `Country` ON (`Country`.`id`=`Property`.`country_id`) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`MultipleUnit`.`property_id`=`Property`.`id` AND unit_type_id!=5) left JOIN `mec_realport03`.`bylines` AS `Byline` ON (`Byline`.`idbylines`=`Property`.`byline_text`) INNER JOIN `mec_realport03`.`property_media_images` AS `PropertyMediaImage` ON (`PropertyMediaImage`.`property_id`=`Property`.`id` AND `PropertyMediaImage`.`featured`="yes") WHERE `Property`.`featured`='true' GROUP BY `Property`.`id` ORDER BY `Property`.`category` desc, `Property`.`name` asc LIMIT 10101019
14SELECT `MultipleUnit`.`id`, `MultipleUnit`.`property_id`, `MultipleUnit`.`unit_type_id`, `MultipleUnit`.`unit`, `MultipleUnit`.`square_feet_from`, `MultipleUnit`.`square_feet_to`, `MultipleUnit`.`market_rent_from`, `MultipleUnit`.`market_rent_to`, `MultipleUnit`.`net_rent_from`, `MultipleUnit`.`net_rent_to`, `MultipleUnit`.`incentive`, `MultipleUnit`.`manual`, `MultipleUnit`.`status`, `MultipleUnit`.`created`, `MultipleUnit`.`modified`, (`MultipleUnit`.`net_rent_from`) AS `MultipleUnit__tmp_net_rent_from`, (`MultipleUnit`.`net_rent_to`) AS `MultipleUnit__tmp_net_rent_to`, (`MultipleUnit`.`unit`) AS `MultipleUnit__tmp_unit` FROM `mec_realport03`.`multiple_units` AS `MultipleUnit` WHERE `MultipleUnit`.`property_id` IN (65, 10, 71, 74, 11, 69, 241, 22, 78, 81) 23230
15SELECT `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` IN (16, 17, 18, 45, 46, 47, 156, 157, 158, 166, 167, 168, 171, 172, 173, 179, 181, 189, 191, 192, 194, 196, 561) 14141
16SELECT `PropertyMediaImage`.`id`, `PropertyMediaImage`.`property_id`, `PropertyMediaImage`.`file_name`, `PropertyMediaImage`.`title`, `PropertyMediaImage`.`order`, `PropertyMediaImage`.`featured`, `PropertyMediaImage`.`status`, `PropertyMediaImage`.`created`, `PropertyMediaImage`.`modified` FROM `mec_realport03`.`property_media_images` AS `PropertyMediaImage` WHERE `PropertyMediaImage`.`property_id` IN (65, 10, 71, 74, 11, 69, 241, 22, 78, 81) 27270
17SELECT `SuitAmenity`.`id`, `SuitAmenity`.`name`, `SuitAmenity`.`status`, `SuitAmenity`.`created`, `SuitAmenity`.`modified`, `SuitAmenitiesProperty`.`id`, `SuitAmenitiesProperty`.`property_id`, `SuitAmenitiesProperty`.`suit_amenities_id`, `SuitAmenitiesProperty`.`created`, `SuitAmenitiesProperty`.`modified` FROM `mec_realport03`.`suit_amenities` AS `SuitAmenity` JOIN `mec_realport03`.`suit_amenities_properties` AS `SuitAmenitiesProperty` ON (`SuitAmenitiesProperty`.`property_id` IN (65, 10, 71, 74, 11, 69, 241, 22, 78, 81) AND `SuitAmenitiesProperty`.`suit_amenities_id` = `SuitAmenity`.`id`) 47471
18SELECT COUNT(*) AS `count` FROM `mec_realport03`.`properties` AS `Property` INNER JOIN `mec_realport03`.`cities` AS `City` ON (`City`.`id`=`Property`.`city_id` AND (`Property`.`city_id`='4' or `Property`.`city_id`='5')) INNER JOIN `mec_realport03`.`countries` AS `Country` ON (`Country`.`id`=`Property`.`country_id`) INNER JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`MultipleUnit`.`property_id`=`Property`.`id` AND unit_type_id!=5) left JOIN `mec_realport03`.`bylines` AS `Byline` ON (`Byline`.`idbylines`=`Property`.`byline_text`) INNER JOIN `mec_realport03`.`property_media_images` AS `PropertyMediaImage` ON (`PropertyMediaImage`.`property_id`=`Property`.`id` AND `PropertyMediaImage`.`featured`="yes") WHERE `Property`.`featured`='true' GROUP BY `Property`.`id`41415
19SELECT `CitySliderImage`.`id`, `CitySliderImage`.`title`, `CitySliderImage`.`image_name`, (`Property`.`name`) AS `CitySliderImage__name`, (`City`.`name`) AS `CitySliderImage__city`, (`Province`.`province_code`) AS `CitySliderImage__province_code` FROM `mec_realport03`.`city_slider_images` AS `CitySliderImage` INNER JOIN `mec_realport03`.`properties` AS `Property` ON (`Property`.`id`=`CitySliderImage`.`property_id` AND `Property`.`city_id`=4) 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` ASC002
20SELECT `CitySliderTitle`.`title` FROM `mec_realport03`.`city_slider_titles` AS `CitySliderTitle` WHERE city_id=4 LIMIT 1002