SELECT pht.fichier
FROM toa_photos pho,toa_photos_traites pht
WHERE pho.NO_INSCRIPTION=12433772
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 12433772_1.jpg
)
[1] => stdClass Object
(
[fichier] => 12433772_2.jpg
)
[2] => stdClass Object
(
[fichier] => 12433772_3.jpg
)
[3] => stdClass Object
(
[fichier] => 12433772_4.jpg
)
[4] => stdClass Object
(
[fichier] => 12433772_5.jpg
)
[5] => stdClass Object
(
[fichier] => 12433772_6.jpg
)
[6] => stdClass Object
(
[fichier] => 12433772_7.jpg
)
[7] => stdClass Object
(
[fichier] => 12433772_8.jpg
)
[8] => stdClass Object
(
[fichier] => 12433772_9.jpg
)
[9] => stdClass Object
(
[fichier] => 12433772_10.jpg
)
[10] => stdClass Object
(
[fichier] => 12433772_11.jpg
)
[11] => stdClass Object
(
[fichier] => 12433772_12.jpg
)
[12] => stdClass Object
(
[fichier] => 12433772_13.jpg
)
[13] => stdClass Object
(
[fichier] => 12433772_14.jpg
)
[14] => stdClass Object
(
[fichier] => 12433772_15.jpg
)
[15] => stdClass Object
(
[fichier] => 12433772_16.jpg
)
[16] => stdClass Object
(
[fichier] => 12433772_17.jpg
)
[17] => stdClass Object
(
[fichier] => 12433772_18.jpg
)
[18] => stdClass Object
(
[fichier] => 12433772_19.jpg
)
[19] => stdClass Object
(
[fichier] => 12433772_20.jpg
)
[20] => stdClass Object
(
[fichier] => 12433772_21.jpg
)
[21] => stdClass Object
(
[fichier] => 12433772_22.jpg
)
[22] => stdClass Object
(
[fichier] => 12433772_23.jpg
)
[23] => stdClass Object
(
[fichier] => 12433772_24.jpg
)
[24] => stdClass Object
(
[fichier] => 12433772_25.jpg
)
[25] => stdClass Object
(
[fichier] => 12433772_26.jpg
)
[26] => stdClass Object
(
[fichier] => 12433772_27.jpg
)
[27] => stdClass Object
(
[fichier] => 12433772_28.jpg
)
[28] => stdClass Object
(
[fichier] => 12433772_29.jpg
)
[29] => stdClass Object
(
[fichier] => 12433772_30.jpg
)
[30] => stdClass Object
(
[fichier] => 12433772_31.jpg
)
[31] => stdClass Object
(
[fichier] => 12433772_32.jpg
)
[32] => stdClass Object
(
[fichier] => 12433772_33.jpg
)
[33] => stdClass Object
(
[fichier] => 12433772_34.jpg
)
[34] => stdClass Object
(
[fichier] => 12433772_35.jpg
)
[35] => stdClass Object
(
[fichier] => 12433772_36.jpg
)
[36] => stdClass Object
(
[fichier] => 12433772_37.jpg
)
[37] => stdClass Object
(
[fichier] => 12433772_38.jpg
)
[38] => stdClass Object
(
[fichier] => 12433772_39.jpg
)
[39] => stdClass Object
(
[fichier] => 12433772_40.jpg
)
[40] => stdClass Object
(
[fichier] => 12433772_41.jpg
)
[41] => stdClass Object
(
[fichier] => 12433772_42.jpg
)
[42] => stdClass Object
(
[fichier] => 12433772_43.jpg
)
[43] => stdClass Object
(
[fichier] => 12433772_44.jpg
)
[44] => stdClass Object
(
[fichier] => 12433772_45.jpg
)
[45] => stdClass Object
(
[fichier] => 12433772_46.jpg
)
[46] => stdClass Object
(
[fichier] => 12433772_47.jpg
)
[47] => stdClass Object
(
[fichier] => 12433772_48.jpg
)
[48] => stdClass Object
(
[fichier] => 12433772_49.jpg
)
[49] => stdClass Object
(
[fichier] => 12433772_50.jpg
)
[50] => stdClass Object
(
[fichier] => 12433772_51.jpg
)
[51] => stdClass Object
(
[fichier] => 12433772_52.jpg
)
)
Contemporary corner unit townhome , bathed in natural light, adjacent to the musical streets of Cote-Saint-Luc. Built in 2012, this modern home promises utmost comfort and convenience. Meticulously designed, this residence boasts a layout that optimizes space and functionality. An elegantly designed kitchen, with floor-to-ceiling cabinetry, offers
Several upgrades were made during the construction of this complex, exclusively for this unit:
-Dual-zone A/C and heating, making it the only unit in the complex with this feature.
-Over 50 additional pot lights have been installed throughout the unit.
-The kitchen boasts floor-to-ceiling cabinets.
-A soaking tub has been added to the family bath.
-Every closet is equipped with custom wood shelving and built-ins.
-The basement level features new engineered wood flooring.
-Custom wood blinds adorn all windows.
-Additional closets have been included for extra storage space.
PLease note** The plans supplied should be regarded as designer plans and not relied upon for accuracy as would a certificate of location. It's important to note that the addition of the third bedroom serves to offer a conceptual representation of how the space can be reconfigured into such a room.
Inclusions
Refrigerator stove, dishwasher, washer, and dryer, central vac and accessories. Blackout blinds in upstairs bedrooms and custom wood blinds.
Exclusions
Dining room fixture kitchen fixture, one sconce in living room, Murphy bed combination in upstairs bedroom/office, personal effects.
Description
Status : ActiveCategory : ResidentialGenre : Two or more storeyType : Attached Occupancy
Listed since : 2024-02-29Occupancy Delay : 120 days
Location
City : Côte-Saint-LucStreet : Av. Marc-ChagallClose to : Kildare Construction
Year of construction : 2012Living Area Type : As per cadastral plan
Building and Lot
Lot size : 0 x 0 Lot area : 278.28 Square metersIrregular : YesBuilding : 0 x 0 Living Area : 159.6 Irregular : Yes
Rooms
Rooms : 21Bedrooms : 3 + 1Bathrooms : 3Shower room (s) : 1
Room Dimensions
Municipal Assessment
Lot : $257400Building : $687800Total : $945200
Costs
Energy cost : $2579 (Yearly)Co-ownership fees : $4200 (Yearly)Municipal Taxes (2023) : $7779 (Yearly)School taxes (2023) : $713 (Yearly)Total : $15271
Shared property : DIVEnd of Lease : -0001-11-30