Property Single
SELECT pht.fichier,pht.photo_url
FROM wp_photos pho,wp_photos_traites pht
WHERE pho.NO_INSCRIPTION=21990530
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 21990530_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB4FD1C6B7B4D14&t=pi&f=I
)
[1] => stdClass Object
(
[fichier] => 21990530_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB48D1C6B7B4D41&t=pi&f=I
)
[2] => stdClass Object
(
[fichier] => 21990530_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB49D1C6B7B4D22&t=pi&f=I
)
[3] => stdClass Object
(
[fichier] => 21990530_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB47D1C6B7B4DCE&t=pi&f=I
)
[4] => stdClass Object
(
[fichier] => 21990530_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB43D1C6B7B4DE0&t=pi&f=I
)
[5] => stdClass Object
(
[fichier] => 21990530_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB45D1C6B7B4DAF&t=pi&f=I
)
[6] => stdClass Object
(
[fichier] => 21990530_7.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB46D1C6B7B4D01&t=pi&f=I
)
[7] => stdClass Object
(
[fichier] => 21990530_8.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB2DD1C6B7B4DB1&t=pi&f=I
)
[8] => stdClass Object
(
[fichier] => 21990530_9.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB22D1C6B7B4DFE&t=pi&f=I
)
[9] => stdClass Object
(
[fichier] => 21990530_10.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB2CD1C6B7B4D8C&t=pi&f=I
)
[10] => stdClass Object
(
[fichier] => 21990530_11.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB2ED1C6B7B4D9A&t=pi&f=I
)
[11] => stdClass Object
(
[fichier] => 21990530_12.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB2AD1C6B7B4D7B&t=pi&f=I
)
[12] => stdClass Object
(
[fichier] => 21990530_13.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB20D1C6B7B4D3D&t=pi&f=I
)
[13] => stdClass Object
(
[fichier] => 21990530_14.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB2FD1C6B7B4D52&t=pi&f=I
)
[14] => stdClass Object
(
[fichier] => 21990530_15.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB28D1C6B7B4D64&t=pi&f=I
)
[15] => stdClass Object
(
[fichier] => 21990530_16.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB29D1C6B7B41D4&t=pi&f=I
)
[16] => stdClass Object
(
[fichier] => 21990530_17.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB23D1C6B7B411E&t=pi&f=I
)
[17] => stdClass Object
(
[fichier] => 21990530_18.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA11EB25D1C6B7B4140&t=pi&f=I
)
)
Turnkey two floor condo with a full basement suite, separate entrance, parking and garage. Units feature modern kitchens with granite counters, renovated bathrooms, updated laundry rooms, and new windows and doors. Unit 5739 is a fully renovated two-level ground floor unit in a duplex, with hardwood floors and formal living and dining rooms, plus interior access to the easily lockable basement suite. The basement is open-concept with its own side entrance. Centrally located--enjoy two units for the price of one! Occupancy July 1st 2026.
Description
Status : ActiveCategory : ResidentialGenre : ApartmentType : Semi-detachedLevel : 1st floor Occupancy
Listed since : 2026-06-04Occupancy Date : 2026-07-01Occupancy Delay :
Location
City : Montréal (Côte-des-Neiges/Notre-Dame-de-Grâce)Street : Av. Trans IslandClose to : Cote-St-Catherine Construction
Year of construction : 1934
Building and Lot
Lot size : 9.14 x 24.38 MetersLot area : 223 Square metersIrregular : YesBuilding : 7.61 x 13.67 MetersIrregular : Yes
Rooms
Rooms : 9Bedrooms : 2Bathrooms : 1Shower room (s) : 0
Room Dimensions
Living room : 16x12.10 PDining room : 9.9x12.4 PKitchen : 13.6x8.6 PPrimary bedroom : 16x10.10 PBathroom : 5.8x6.8 PBedroom : 9.8x10.10 PLiving room : 26.6x19.9 PBathroom : 7.1x4.11 PLaundry room : 6.5x5.6 P
Municipal Assessment
Lot : $164300Building : $659500Total : $823800
Costs
Co-ownership fees : $1800 (Yearly)Municipal Taxes (2026) : $4757 (Yearly)School taxes (2025) : $577 (Yearly)Total : $7134
Shared property : DIVEnd of Lease : -0001-11-30