SELECT pht.fichier
FROM toa_photos pho,toa_photos_traites pht
WHERE pho.NO_INSCRIPTION=22272748
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 22272748_1.jpg
)
[1] => stdClass Object
(
[fichier] => 22272748_2.jpg
)
[2] => stdClass Object
(
[fichier] => 22272748_3.jpg
)
[3] => stdClass Object
(
[fichier] => 22272748_4.jpg
)
[4] => stdClass Object
(
[fichier] => 22272748_5.jpg
)
[5] => stdClass Object
(
[fichier] => 22272748_6.jpg
)
[6] => stdClass Object
(
[fichier] => 22272748_7.jpg
)
[7] => stdClass Object
(
[fichier] => 22272748_8.jpg
)
[8] => stdClass Object
(
[fichier] => 22272748_9.jpg
)
[9] => stdClass Object
(
[fichier] => 22272748_10.jpg
)
[10] => stdClass Object
(
[fichier] => 22272748_11.jpg
)
[11] => stdClass Object
(
[fichier] => 22272748_12.jpg
)
[12] => stdClass Object
(
[fichier] => 22272748_13.jpg
)
[13] => stdClass Object
(
[fichier] => 22272748_14.jpg
)
[14] => stdClass Object
(
[fichier] => 22272748_15.jpg
)
[15] => stdClass Object
(
[fichier] => 22272748_16.jpg
)
[16] => stdClass Object
(
[fichier] => 22272748_17.jpg
)
[17] => stdClass Object
(
[fichier] => 22272748_18.jpg
)
[18] => stdClass Object
(
[fichier] => 22272748_19.jpg
)
[19] => stdClass Object
(
[fichier] => 22272748_20.jpg
)
[20] => stdClass Object
(
[fichier] => 22272748_21.jpg
)
[21] => stdClass Object
(
[fichier] => 22272748_22.jpg
)
[22] => stdClass Object
(
[fichier] => 22272748_23.jpg
)
[23] => stdClass Object
(
[fichier] => 22272748_24.jpg
)
[24] => stdClass Object
(
[fichier] => 22272748_25.jpg
)
[25] => stdClass Object
(
[fichier] => 22272748_26.jpg
)
[26] => stdClass Object
(
[fichier] => 22272748_27.jpg
)
[27] => stdClass Object
(
[fichier] => 22272748_28.jpg
)
[28] => stdClass Object
(
[fichier] => 22272748_29.jpg
)
[29] => stdClass Object
(
[fichier] => 22272748_30.jpg
)
[30] => stdClass Object
(
[fichier] => 22272748_31.jpg
)
[31] => stdClass Object
(
[fichier] => 22272748_32.jpg
)
[32] => stdClass Object
(
[fichier] => 22272748_33.jpg
)
[33] => stdClass Object
(
[fichier] => 22272748_34.jpg
)
[34] => stdClass Object
(
[fichier] => 22272748_35.jpg
)
[35] => stdClass Object
(
[fichier] => 22272748_36.jpg
)
[36] => stdClass Object
(
[fichier] => 22272748_37.jpg
)
[37] => stdClass Object
(
[fichier] => 22272748_38.jpg
)
[38] => stdClass Object
(
[fichier] => 22272748_39.jpg
)
[39] => stdClass Object
(
[fichier] => 22272748_40.jpg
)
[40] => stdClass Object
(
[fichier] => 22272748_41.jpg
)
[41] => stdClass Object
(
[fichier] => 22272748_42.jpg
)
[42] => stdClass Object
(
[fichier] => 22272748_43.jpg
)
[43] => stdClass Object
(
[fichier] => 22272748_44.jpg
)
[44] => stdClass Object
(
[fichier] => 22272748_45.jpg
)
[45] => stdClass Object
(
[fichier] => 22272748_46.jpg
)
[46] => stdClass Object
(
[fichier] => 22272748_47.jpg
)
[47] => stdClass Object
(
[fichier] => 22272748_48.jpg
)
[48] => stdClass Object
(
[fichier] => 22272748_49.jpg
)
[49] => stdClass Object
(
[fichier] => 22272748_50.jpg
)
[50] => stdClass Object
(
[fichier] => 22272748_51.jpg
)
[51] => stdClass Object
(
[fichier] => 22272748_52.jpg
)
[52] => stdClass Object
(
[fichier] => 22272748_53.jpg
)
[53] => stdClass Object
(
[fichier] => 22272748_54.jpg
)
[54] => stdClass Object
(
[fichier] => 22272748_55.jpg
)
[55] => stdClass Object
(
[fichier] => 22272748_56.jpg
)
[56] => stdClass Object
(
[fichier] => 22272748_57.jpg
)
)
Nestled in the melodious avenues of CSL, this grand residence exudes sophistication. Meticulously preserved, it showcases soaring ceilings, an abundance of light, and an expansive layout. Revel in the allure of exotic jatoba wood floors, a majestic staircase, and large entertainment rooms. The spacious kitchen opens onto a private terrace, a verdan
Elegant 5+2 Cottage located on the musical streets of Cote-Saint-Luc. this home sits on 7200 Sf of land with no rear neighbours and backing onto the wooded Nathan Schuster Park. Upon entering this majestic home, one can appreciate its high ceilings, grand staircase and ample living spaces. A large entertaining kitchen with butler's pantry gives access to a beautiful exterior living space with a grand in-ground pool and terrace. The upper floors also boast high ceilings and large sleeping quarters . The lower level offer 2 large bedrooms, large storages spaces and a 3 car indoor garage.
Inclusions
2 ovens, refrigerators, (kitchen and laundry room), cooking plate, All light fixtures except those excluded). Alarm system, central vacuum system and accessories, swimming pool accessories, white electric curtains in the living room, wall bookcase in the first floor office.
Exclusions
. Dishwasher, washer/dryer, chandelier in dining room and kitchen, all curtains/blinds (except those included). Outdoor BBQ, furniture with built-in bed (Murphy Bed) in the basement bedroom. Sauna in the basement. Furniture and personal effects.
Description
Status : ActiveCategory : ResidentialGenre : Two or more storeyType : DetachedRented Water Heater(s) : 2 Occupancy
Listed since : 2024-01-22Occupancy Delay : 120 days
Location
City : Côte-Saint-LucStreet : Av. KrieghoffClose to : Wallenberg Construction
Year of construction : 1991
Building and Lot
Lot size : 18.29 x 36.58 MetersLot area : 668.9 Square metersIrregular : YesBuilding : 15.9 x 13.44 MetersIrregular : Yes
Rooms
Rooms : 22Bedrooms : 5 + 2Bathrooms : 4Shower room (s) : 1
Room Dimensions
Municipal Assessment
Lot : $745800Building : $1405100Total : $2150900
Costs
Municipal Taxes (2024) : $16356 (Yearly)School taxes (2024) : $1622 (Yearly)Total : $17978
End of Lease : -0001-11-30