Property Single
SELECT pht.fichier,pht.photo_url
FROM wp_photos pho,wp_photos_traites pht
WHERE pho.NO_INSCRIPTION=17979431
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 17979431_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461BAFD114EB40D1A&t=pi&f=I
)
[1] => stdClass Object
(
[fichier] => 17979431_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461BA7D114EB40D40&t=pi&f=I
)
[2] => stdClass Object
(
[fichier] => 17979431_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA46137ED114EB40D2F&t=pi&f=I
)
[3] => stdClass Object
(
[fichier] => 17979431_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA46137FD114EB40DCC&t=pi&f=I
)
[4] => stdClass Object
(
[fichier] => 17979431_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461BA3D114EB40DE1&t=pi&f=I
)
[5] => stdClass Object
(
[fichier] => 17979431_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461B0DD114EB40DA2&t=pi&f=I
)
[6] => stdClass Object
(
[fichier] => 17979431_7.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461B01D114EB40D0E&t=pi&f=I
)
[7] => stdClass Object
(
[fichier] => 17979431_8.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461B04D114EB40DB0&t=pi&f=I
)
[8] => stdClass Object
(
[fichier] => 17979431_9.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461BBCD114EB40DF1&t=pi&f=I
)
[9] => stdClass Object
(
[fichier] => 17979431_10.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461BBED114EB40D8D&t=pi&f=I
)
[10] => stdClass Object
(
[fichier] => 17979431_11.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461FE3D114EB40D9C&t=pi&f=I
)
[11] => stdClass Object
(
[fichier] => 17979431_12.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461FE9D114EB40D72&t=pi&f=I
)
[12] => stdClass Object
(
[fichier] => 17979431_13.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461BBAD114EB40D3C&t=pi&f=I
)
[13] => stdClass Object
(
[fichier] => 17979431_14.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461FE7D114EB40D5A&t=pi&f=I
)
[14] => stdClass Object
(
[fichier] => 17979431_15.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461F58D114EB40D61&t=pi&f=I
)
[15] => stdClass Object
(
[fichier] => 17979431_16.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461F59D114EB401D1&t=pi&f=I
)
[16] => stdClass Object
(
[fichier] => 17979431_17.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461F57D114EB40112&t=pi&f=I
)
[17] => stdClass Object
(
[fichier] => 17979431_18.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461587D114EB40144&t=pi&f=I
)
[18] => stdClass Object
(
[fichier] => 17979431_19.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461B91D114EB40122&t=pi&f=I
)
[19] => stdClass Object
(
[fichier] => 17979431_20.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461B9DD114EB401C2&t=pi&f=I
)
[20] => stdClass Object
(
[fichier] => 17979431_21.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA4618DAD114EB401E1&t=pi&f=I
)
[21] => stdClass Object
(
[fichier] => 17979431_22.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA461589D114EB401AE&t=pi&f=I
)
)
Excellent investment opportunity in the heart of Lachine! Well-maintained three-storey commercial building offering approximately 3,399 sq. ft. above ground plus an additional 1,084 sq.ft. of unfinished basement. Currently configured entirely as offices. Zoned M402, offering a broad range of residential and commercial possibilities. Situated on well trafficked Notre Dame with excellent visibility and easy access to major highways. Ground Floor available November 2026.The entire building can be made available for full owner occupancy or conversion/renovation by August 2027, or sooner.
Description
Status : ActiveCategory : CommercialGenre : Commercial building/OfficeType : Detached Occupancy
Listed since : 2026-08-19Occupancy Delay :
Location
City : Montréal (Lachine)Street : Rue Notre-DameClose to : 25e Ave Construction
Year of construction : 1920
Building and Lot
Lot size : 0 x 0 Lot area : 0 Irregular : YesBuilding : 30 x 36.45 MetersIrregular : Yes
Rooms
Rooms : 0Bedrooms : 0Bathrooms : 0Shower room (s) : 0
Room Dimensions
Municipal Assessment
Lot : $171400Building : $486300Total : $657700
Costs
Municipal Taxes (2026) : $14573 (Yearly)School taxes (2026) : $445 (Yearly)Total : $15018
End of Lease : -0001-11-30