New Westminster Apartments

4 locations. 87 apartments for rent.

  • Home
  • New Westminster Apartments
4 Results
Cameron Manor Apts. 1
Cameron Manor Apts. 1
1210 Cameron Street
B Appart
1 Appart
2 Appart
Click for details
Rent from
$695
Cameron Manor Apts. 2
Cameron Manor Apts. 2
1211 Cameron Street
B Appart
1 Appart
2 Appart
Click for details
Rent from
$695
Test apartment's by sneha
Test Apartment's By Sneha
Des/;sd' )*(&^$%@#! Des/;sd' )*(&^$%@#!
2 Appart
Click for details
Rent from
$1
Testing
Testing
Add
1 Appart
Click for details
Rent from
$1
(default) 20 queries took 5 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` = 'aparment_listing' LIMIT 1110
9SELECT `City`.`id` FROM `mec_realport03`.`cities` AS `City` WHERE LOWER(name)='new westminster' LIMIT 1110
10SELECT `City`.`name`, `City`.`id`, `City`.`content` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 2 LIMIT 1110
11SELECT `CityArea`.`id`, `CityArea`.`name` FROM `mec_realport03`.`city_areas` AS `CityArea` WHERE city_id=2110
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`='2') 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 10442
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 (99, 107, 224, 223) 880
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 (239, 240, 243, 251, 253, 256, 547, 548) 000
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 (99, 107, 224, 223) 20200
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 (99, 107, 224, 223) AND `SuitAmenitiesProperty`.`suit_amenities_id` = `SuitAmenity`.`id`) 10100
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`='2') 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`441
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`=2) 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` ASC000
20SELECT `CitySliderTitle`.`title` FROM `mec_realport03`.`city_slider_titles` AS `CitySliderTitle` WHERE city_id=2 LIMIT 1000