Surrey Apartments

13 locations. 1267 apartments for rent.

2501

2501 - 15 Street SW
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

  • Secure Entry
  • On Site Laundry
  • Energized Parking

Suite Amenities

  • Window Coverings
  • Stove
  • Fridge
  • Heat
  • Water
  • In Suite Laundry

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 refundable fee is required.
Share with mail_icn
(default) 19 queries took 3 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)='surrey' LIMIT 1110
5SELECT `Province`.`province_code` FROM `mec_realport03`.`provinces` AS `Province` WHERE id=1 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` = 3) 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` = 3 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` = 'apartment_detail' LIMIT 1110
9SELECT `City`.`id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='surrey' LIMIT 1110
10SELECT `Property`.`id` FROM `mec_realport03`.`properties` AS `Property` WHERE city_id=3 AND LOWER(name)="2501" LIMIT 1110
11SELECT `PropertyMediaImage`.`title`, `PropertyMediaImage`.`file_name`, `PropertyMediaImage`.`order`, `PropertyMediaImage`.`featured` FROM `mec_realport03`.`property_media_images` AS `PropertyMediaImage` WHERE `PropertyMediaImage`.`property_id` = 9 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` = 9 LIMIT 1110
13SELECT `Province`.`province_code`, `Province`.`id` FROM `mec_realport03`.`provinces` AS `Province` WHERE `Province`.`id` = 2 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`=9 AND `MultipleUnit`.`unit_type_id`!=5 GROUP BY `MultipleUnit`.`unit_type_id`220
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` = 9 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`=9) WHERE 1 = 1330
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`=9) WHERE 1 = 1660
18SELECT `FloorPlan`.`title`, `FloorPlan`.`file_name` FROM `mec_realport03`.`floor_plans` AS `FloorPlan` WHERE `FloorPlan`.`property_id` = 9220
19SELECT `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 3 LIMIT 1110