Saskatoon Apartments

30 locations. 845 apartments for rent.

Capricorn Apartments

128 Avenue O South
Contact us for availability

 
This is a family friendly building with onsite laundry. Suites are newly renovated with balconies.
 
To search amenities around this property click on the Walk Score® tab.

Building Amenities

  • Balcony Deck
  • Secure Entry
  • On Site Laundry
  • Energized Parking

Suite Amenities

  • Water
  • Heat
  • Fridge
  • Stove
  • Window Coverings

This is a pet-friendly residence:-

Yes No
We are happy to welcome your family dog or cat to come live with you in this Mainstreet property, no reptiles please. In consideration of your neighbours we do have size and breed restrictions on dogs, speak with the property manager for details. A $200 non-refundable fee is required per pet (maximum of 2 pets per suite). A $25/month per pet rent fee is required.
Share with mail_icn
(default) 19 queries took 62 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `City`.`id`, `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE 1 = 18813
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 11111
8SELECT `Meta`.`title`, `Meta`.`keyword`, `Meta`.`description` FROM `mec_realport03`.`metas` AS `Meta` WHERE `Meta`.`page` = 'apartment_detail' LIMIT 11112
9SELECT `City`.`id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='saskatoon' LIMIT 1110
10SELECT `Property`.`id` FROM `mec_realport03`.`properties` AS `Property` WHERE city_id=8 AND LOWER(name)="capricorn apartments" LIMIT 1110
11SELECT `PropertyMediaImage`.`title`, `PropertyMediaImage`.`file_name`, `PropertyMediaImage`.`order`, `PropertyMediaImage`.`featured` FROM `mec_realport03`.`property_media_images` AS `PropertyMediaImage` WHERE `PropertyMediaImage`.`property_id` = 60 ORDER BY `order` asc118
12SELECT `Property`.`id`, `Property`.`name`, `Property`.`description`, `Property`.`zipcode`, `Property`.`address`, `Property`.`phone`, `Property`.`email_id`, `Property`.`city_id`, `Property`.`general_security`, `Property`.`senior_security`, `Property`.`brochure_file`, `Property`.`province_id`, `Property`.`special_incentive`, `Property`.`special_incentive_value`, `Property`.`allow_pets`, `Property`.`mobile` FROM `mec_realport03`.`properties` AS `Property` WHERE `Property`.`id` = 60 LIMIT 1110
13SELECT `Province`.`province_code`, `Province`.`id` FROM `mec_realport03`.`provinces` AS `Province` WHERE `Province`.`id` = 3 LIMIT 1110
14SELECT (MIN(`MultipleUnit`.`net_rent_from`)) AS `MultipleUnit__rent_from`, (MAX(`MultipleUnit`.`net_rent_to`)) AS `MultipleUnit__rent_to`, (MIN(`MultipleUnit`.`square_feet_from`)) AS `MultipleUnit__feet_from`, (MAX(`MultipleUnit`.`square_feet_to`)) AS `MultipleUnit__feet_to`, (MAX(`UnitType`.`name`)) AS `MultipleUnit__unit_type` FROM `mec_realport03`.`multiple_units` AS `MultipleUnit` INNER JOIN `mec_realport03`.`unit_types` AS `UnitType` ON (`MultipleUnit`.`unit_type_id`=`UnitType`.`id`) WHERE `MultipleUnit`.`property_id`=60 AND `MultipleUnit`.`unit_type_id`!=5 GROUP BY `MultipleUnit`.`unit_type_id`330
15SELECT `PropertyMeda`.`id`, `PropertyMeda`.`property_id`, `PropertyMeda`.`video_url`, `PropertyMeda`.`video_description`, `PropertyMeda`.`show_video`, `PropertyMeda`.`status`, `PropertyMeda`.`created`, `PropertyMeda`.`modified` FROM `mec_realport03`.`property_medas` AS `PropertyMeda` WHERE `PropertyMeda`.`property_id` = 60 AND `PropertyMeda`.`show_video` IN ('video_url', 'yes') LIMIT 1000
16SELECT (`BuildingAmenity`.`name`) AS `BuildingAmenitiesProperty__buildingAmenity` FROM `mec_realport03`.`building_amenities_properties` AS `BuildingAmenitiesProperty` INNER JOIN `mec_realport03`.`building_amenities` AS `BuildingAmenity` ON (`BuildingAmenity`.`id`=`BuildingAmenitiesProperty`.`building_amenities_id` AND `BuildingAmenitiesProperty`.`property_id`=60) WHERE 1 = 1440
17SELECT (`SuitAmenity`.`name`) AS `SuitAmenitiesProperty__suitAmenity` FROM `mec_realport03`.`suit_amenities_properties` AS `SuitAmenitiesProperty` INNER JOIN `mec_realport03`.`suit_amenities` AS `SuitAmenity` ON (`SuitAmenity`.`id`=`SuitAmenitiesProperty`.`suit_amenities_id` AND `SuitAmenitiesProperty`.`property_id`=60) WHERE 1 = 15517
18SELECT `FloorPlan`.`title`, `FloorPlan`.`file_name` FROM `mec_realport03`.`floor_plans` AS `FloorPlan` WHERE `FloorPlan`.`property_id` = 60330
19SELECT `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 8 LIMIT 1110