Abbotsford Apartments

16 locations. 889 apartments for rent.

  • Home
  • Abbotsford Apartments
16 Results
Featured Property : cheese burst ahaaaaaaaaa
Building
Building
Add
2 Appart
Click for details
Rent from
$1
Featured Property : Netsol
Netsol
Netsol
Netsol
B Appart
Click for details
Rent from
$92
Bridgeport Manor
Bridgeport Manor
33405 Bourquin Place
1 Appart
2 Appart
Click for details
Rent from
$725
Chelsea Park Gardens
Chelsea Park Gardens
33710 Marshall Road
1 Appart
2 Appart
Click for details
Rent from
$688
Dahlstrom Manor
Dahlstrom Manor
32030 George Ferguson Way
B Appart
1 Appart
2 Appart
3 Appart
Click for details
Rent from
$573
Hill-Tout Arms
Hill-Tout Arms
2485 Hill-Tout Street
B Appart
1 Appart
2 Appart
Click for details
Rent from
$550
Hillside Terrace
Hillside Terrace
2814 Pratt Crescent
B Appart
1 Appart
2 Appart
Click for details
Rent from
$600
Mount View Terrace
Mount View Terrace
33136 George Ferguson Way
1 Appart
2 Appart
Click for details
Rent from
$725
Pinetree Apartments
Pinetree Apartments
2525 Hill-Tout Street
1 Appart
2 Appart
Click for details
Rent from
$635
Puja teysting apartments
Puja Teysting Apartments
Puja Teysting Apartments Puja Teysting Apartments Puja Teysting Apartments Puja Teysting Apartments Puja Teysting Apartments Puja Teysting Apartments Puja Teysting Apartments Puja Teysting Apartments
B Appart
Click for details
Rent from
$102603
(default) 20 queries took 10 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)='abbotsford' 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` = 1) 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` = 1 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)='abbotsford' LIMIT 1110
10SELECT `City`.`name`, `City`.`id`, `City`.`content` FROM `mec_realport03`.`cities` AS `City` WHERE `City`.`id` = 1 LIMIT 1110
11SELECT `CityArea`.`id`, `CityArea`.`name` FROM `mec_realport03`.`city_areas` AS `CityArea` WHERE city_id=1550
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`='1') 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 (221, 236, 12, 13, 14, 15, 8, 16, 17, 216) 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 (13, 12, 11, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 540, 545, 557) 19190
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 (221, 236, 12, 13, 14, 15, 8, 16, 17, 216) 65650
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 (221, 236, 12, 13, 14, 15, 8, 16, 17, 216) AND `SuitAmenitiesProperty`.`suit_amenities_id` = `SuitAmenity`.`id`) 46460
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`='1') 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`16163
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`=1) 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=1 LIMIT 1110