New Westminster Apartments

4 locations. 87 apartments for rent.

Cameron Manor Apts. 1

1210 Cameron Street
Contact us for availability

Building Amenities:

This is a family friendly building with onsite laundry.

To search amenities around this property click on the Walk Score® tab.

This is a test message
Please ignore

Building Amenities

  • Secure Entry
  • On Site Laundry
  • Surface Parking
  • Elevators

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 refundable 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)='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)="cameron manor apts. 1" LIMIT 1110
11SELECT `PropertyMediaImage`.`title`, `PropertyMediaImage`.`file_name`, `PropertyMediaImage`.`order`, `PropertyMediaImage`.`featured` FROM `mec_realport03`.`property_media_images` AS `PropertyMediaImage` WHERE `PropertyMediaImage`.`property_id` = 99 ORDER BY `order` asc990
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` = 99 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`=99 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` = 99 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`=99) 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`=99) WHERE 1 = 1550
18SELECT `FloorPlan`.`title`, `FloorPlan`.`file_name` FROM `mec_realport03`.`floor_plans` AS `FloorPlan` WHERE `FloorPlan`.`property_id` = 99000
19SELECT `City`.`name` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 2 LIMIT 1110