Ft Saskatchewan Apartments

3 locations. 33 apartments for rent.

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
Contact us for availability

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 floors throughout. New bathrooms.

Building Amenities:  On-site laundry, secured entry with intercom, parking. 

Pet friendly.

Neighborhood:  Cameron 1 rental apartment building has easy access to: Hwy 1, Pattulo Bridge and Queensborough Bridge. Gorgeous panoramic view of the Fraser and River Quay Market Place. 5 minute walk to sky train station. Near Mercer Stadium, schools, colleges, parks and night life. Walking distances to Royal City Shopping Centre and Colombia Square Plaza.

Current Special Incentives at FT Building:

Free TELUS cable (or) Internet on a yearly lease

            (OR)

$200 off first month's rent on a yearly lease

Student Incentive:

Only $250 Security Deposit

*Student ID (or) Offer Letter from University (or) College is a must.

Free TELUS cable (or) Internet on a yearly lease $200 off first month's rent on a yearly lease $200 off first month's rent on a yearly lease $200 off first month's rent on a yearly lease $200 off first month's rent on a yearly lease

            (OR)

$200 off first month's rent on a yearly lease

Student Incentive:

Only $250 Security Deposit

*Student ID (or) Offer Letter from University (or) College is a must.

Building Amenities

  • Surface Parking

Suite Amenities

  • Electric&Hydro

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 2 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)='ft saskatchewan' 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` = 7) 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` = 7 AND `Property`.`is_completed`='complete') LEFT JOIN `mec_realport03`.`multiple_units` AS `MultipleUnit` ON (`Property`.`id` = `MultipleUnit`.`property_id`) WHERE 1 = 1 LIMIT 1111
8SELECT `Meta`.`title`, `Meta`.`keyword`, `Meta`.`description` FROM `mec_realport03`.`metas` AS `Meta` WHERE `Meta`.`page` = 'apartment_detail' LIMIT 1110
9SELECT `City`.`id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='ft saskatchewan' LIMIT 1110
10SELECT `Property`.`id` FROM `mec_realport03`.`properties` AS `Property` WHERE city_id=7 AND LOWER(name)="ft building" LIMIT 1110
11SELECT `PropertyMediaImage`.`title`, `PropertyMediaImage`.`file_name`, `PropertyMediaImage`.`order`, `PropertyMediaImage`.`featured` FROM `mec_realport03`.`property_media_images` AS `PropertyMediaImage` WHERE `PropertyMediaImage`.`property_id` = 228 ORDER BY `order` asc110
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` = 228 LIMIT 1110
13SELECT `Province`.`province_code`, `Province`.`id` FROM `mec_realport03`.`provinces` AS `Province` WHERE `Province`.`id` = 1 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`=228 AND `MultipleUnit`.`unit_type_id`!=5 GROUP BY `MultipleUnit`.`unit_type_id`110
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` = 228 AND `PropertyMeda`.`show_video` IN ('video_url', 'yes') LIMIT 1110
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`=228) WHERE 1 = 1110
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`=228) WHERE 1 = 1110
18SELECT `FloorPlan`.`title`, `FloorPlan`.`file_name` FROM `mec_realport03`.`floor_plans` AS `FloorPlan` WHERE `FloorPlan`.`property_id` = 228000
19SELECT `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 7 LIMIT 1110