Surrey Apartments

13 locations. 1267 apartments for rent.

  • Home
  • Surrey Apartments
13 Results
Featured Property : my house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreamsmy house my dreams my house my dreamsmy house my dreams my house my dreams my house my dreams my house my dreams my house my dreams my house my dreams
2501
2501
2501 - 15 Street SW
1 Appart
2 Appart
Click for details
Rent from
$1100
Featured Property : my house my dreams
acme heights
Acme Heights
1612 - 24 Avenue SW
2 Appart
Click for details
Rent from
$6778
Featured Property : my style housemy style housemy style housemy style house
Alexander Apartments
Alexander Apartments
12220 - 82 Street NW
B Appart
1 Appart
Click for details
Rent from
$695
Featured Property : New Byline SA
XYZ
XYZ
#123 Demo Address
1 Appart
Click for details
Rent from
$24
1612
1612
1612 - 24 Avenue SW
1 Appart
2 Appart
Click for details
plot no 16
Plot No 16
Plot No 15
1 Appart
Click for details
Cedartree Village
Cedartree Village
113 - 7155 Hall Road
1 Appart
2 Appart
3 Appart
Click for details
Rent from
$750
Gateway Place
Gateway Place
11022 - 136 Street
2 Appart
3 Appart
Click for details
Rent from
$900
Greenwood Gardens
Greenwood Gardens
14831 - 104 Avenue
1 Appart
2 Appart
3 Appart
Click for details
Rent from
$750
Hillside Place
Hillside Place
12751 - 103 Avenue
1 Appart
2 Appart
3 Appart
Click for details
Rent from
$725
(default) 20 queries took 9 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` = 'aparment_listing' LIMIT 1110
9SELECT `City`.`id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='surrey' LIMIT 1110
10SELECT `City`.`name`, `City`.`id`, `City`.`content` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 3 LIMIT 1110
11SELECT `CityArea`.`id`, `CityArea`.`name` FROM `mec_realport03`.`city_areas` AS `CityArea` WHERE city_id=3330
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`='3') 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 1010104
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 (9, 234, 64, 235, 6, 239, 23, 24, 25, 26) 21210
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 (4, 5, 14, 15, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 154, 155, 537, 555, 556, 559) 18180
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 (9, 234, 64, 235, 6, 239, 23, 24, 25, 26) 63630
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 (9, 234, 64, 235, 6, 239, 23, 24, 25, 26) AND `SuitAmenitiesProperty`.`suit_amenities_id` = `SuitAmenity`.`id`) 43430
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`='3') 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`13132
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`=3) 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` ASC110
20SELECT `CitySliderTitle`.`title` FROM `mec_realport03`.`city_slider_titles` AS `CitySliderTitle` WHERE city_id=3 LIMIT 1110