Saskatoon Apartments

30 locations. 845 apartments for rent.

  • Home
  • Saskatoon Apartments
30 Results
Belmae Manor
Belmae Manor
445 - 3 Avenue North
B Appart
1 Appart
Click for details
Rent from
$775
Booth Apartments
Booth Apartments
106 - 111 Street
1 Appart
2 Appart
Click for details
Rent from
$925
Camino Manor
Camino Manor
115 Avenue O South
1 Appart
2 Appart
Click for details
Rent from
$725
Capricorn Apartments
Capricorn Apartments
128 Avenue O South
1 Appart
2 Appart
3 Appart
Click for details
Rent from
$775
Coronation Place
Coronation Place
444 - 5 Avenue North
B Appart
1 Appart
2 Appart
Click for details
Rent from
$825
Diane Apartments 1
Diane Apartments 1
541 Avenue W South
1 Appart
2 Appart
Click for details
Rent from
$800
Diane Apartments 2
Diane Apartments 2
2310 17 Street West
B Appart
1 Appart
2 Appart
Click for details
Rent from
$80
Duchess Manor
Duchess Manor
901 - 5 Avenue North
B Appart
1 Appart
Click for details
Rent from
$875
Fairhaven
Fairhaven
365 - 377 Pendygrasse Road
1 Appart
2 Appart
3 Appart
Click for details
Rent from
$850
Gemini
Gemini
403 Avenue P South
1 Appart
2 Appart
Click for details
Rent from
$800
(default) 20 queries took 13 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)='saskatoon' LIMIT 1110
5SELECT `Province`.`province_code` FROM `mec_realport03`.`provinces` AS `Province` WHERE id=3 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` = 8) 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 1111
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` = 8 AND `Property`.`is_completed`='complete') LEFT JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 LIMIT 1112
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)='saskatoon' LIMIT 1110
10SELECT `City`.`name`, `City`.`id`, `City`.`content` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 8 LIMIT 1110
11SELECT `CityArea`.`id`, `CityArea`.`name` FROM `mec_realport03`.`city_areas` AS `CityArea` WHERE city_id=8440
12SELECT `UnitType`.`id`, `UnitType`.`name` FROM `mec_realport03`.`unit_types` AS `UnitType` WHERE `id` <> 5440
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`='8') 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 1010106
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 (33, 57, 58, 60, 61, 62, 63, 66, 67, 68) 24240
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 (80, 79, 137, 138, 139, 140, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 159, 160, 161, 162, 163, 164, 165) 19190
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 (33, 57, 58, 60, 61, 62, 63, 66, 67, 68) 43430
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 (33, 57, 58, 60, 61, 62, 63, 66, 67, 68) AND `SuitAmenitiesProperty`.`suit_amenities_id` = `SuitAmenity`.`id`) 61610
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`='8') 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`30304
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`=8) 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` ASC000
20SELECT `CitySliderTitle`.`title` FROM `mec_realport03`.`city_slider_titles` AS `CitySliderTitle` WHERE city_id=8 LIMIT 1000