New Westminster Apartments

4 locations. 87 apartments for rent.

Test Apartment's By Sneha

Des/;sd' )*(&^$%@#! Des/;sd' )*(&^$%@#!
Contact us for availability

Des/;sd' )*(&^$%@#!

$250 off the first month's rent on a yearly lease

             (OR)

Free TELUS cable (or) Internet on a yearly lease

Student Incentive:

Only $250 Security Deposit

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

Current Special Incentives at Test Apartment's By Sneha:

$250 off the first month's rent on a yearly lease

             (OR)

Free TELUS cable (or) Internet 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
  • Swimming Pool
  • Courtyard
  • Storage

This is a pet-friendly residence:-

Yes No
Sorry, we do not allow pets in this property. However, most of our properties are pet-friendly, so keep searching, or contact a property manager to find out which properties accept pets.
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)='new westminster' 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` = 2) 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` = 2 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)='new westminster' LIMIT 1110
10SELECT `Property`.`id` FROM `mec_realport03`.`properties` AS `Property` WHERE city_id=2 AND LOWER(name)="test apartment's by sneha" LIMIT 1110
11SELECT `PropertyMediaImage`.`title`, `PropertyMediaImage`.`file_name`, `PropertyMediaImage`.`order`, `PropertyMediaImage`.`featured` FROM `mec_realport03`.`property_media_images` AS `PropertyMediaImage` WHERE `PropertyMediaImage`.`property_id` = 224 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` = 224 LIMIT 1110
13SELECT `Province`.`province_code`, `Province`.`id` FROM `mec_realport03`.`provinces` AS `Province` WHERE `Province`.`id` = 4 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`=224 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` = 224 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`=224) 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`=224) WHERE 1 = 1000
18SELECT `FloorPlan`.`title`, `FloorPlan`.`file_name` FROM `mec_realport03`.`floor_plans` AS `FloorPlan` WHERE `FloorPlan`.`property_id` = 224000
19SELECT `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 2 LIMIT 1110