SELECT pht.fichier
FROM toa_photos pho,toa_photos_traites pht
WHERE pho.NO_INSCRIPTION=22062273
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 22062273_1.jpg
)
[1] => stdClass Object
(
[fichier] => 22062273_2.jpg
)
[2] => stdClass Object
(
[fichier] => 22062273_3.jpg
)
[3] => stdClass Object
(
[fichier] => 22062273_4.jpg
)
[4] => stdClass Object
(
[fichier] => 22062273_5.jpg
)
[5] => stdClass Object
(
[fichier] => 22062273_6.jpg
)
[6] => stdClass Object
(
[fichier] => 22062273_7.jpg
)
[7] => stdClass Object
(
[fichier] => 22062273_8.jpg
)
[8] => stdClass Object
(
[fichier] => 22062273_9.jpg
)
[9] => stdClass Object
(
[fichier] => 22062273_10.jpg
)
[10] => stdClass Object
(
[fichier] => 22062273_11.jpg
)
[11] => stdClass Object
(
[fichier] => 22062273_12.jpg
)
[12] => stdClass Object
(
[fichier] => 22062273_13.jpg
)
[13] => stdClass Object
(
[fichier] => 22062273_14.jpg
)
[14] => stdClass Object
(
[fichier] => 22062273_15.jpg
)
[15] => stdClass Object
(
[fichier] => 22062273_16.jpg
)
[16] => stdClass Object
(
[fichier] => 22062273_17.jpg
)
[17] => stdClass Object
(
[fichier] => 22062273_18.jpg
)
[18] => stdClass Object
(
[fichier] => 22062273_19.jpg
)
[19] => stdClass Object
(
[fichier] => 22062273_20.jpg
)
[20] => stdClass Object
(
[fichier] => 22062273_21.jpg
)
[21] => stdClass Object
(
[fichier] => 22062273_22.jpg
)
[22] => stdClass Object
(
[fichier] => 22062273_23.jpg
)
[23] => stdClass Object
(
[fichier] => 22062273_24.jpg
)
[24] => stdClass Object
(
[fichier] => 22062273_25.jpg
)
[25] => stdClass Object
(
[fichier] => 22062273_26.jpg
)
[26] => stdClass Object
(
[fichier] => 22062273_27.jpg
)
[27] => stdClass Object
(
[fichier] => 22062273_28.jpg
)
[28] => stdClass Object
(
[fichier] => 22062273_29.jpg
)
[29] => stdClass Object
(
[fichier] => 22062273_30.jpg
)
[30] => stdClass Object
(
[fichier] => 22062273_31.jpg
)
[31] => stdClass Object
(
[fichier] => 22062273_32.jpg
)
[32] => stdClass Object
(
[fichier] => 22062273_33.jpg
)
[33] => stdClass Object
(
[fichier] => 22062273_34.jpg
)
[34] => stdClass Object
(
[fichier] => 22062273_35.jpg
)
[35] => stdClass Object
(
[fichier] => 22062273_36.jpg
)
[36] => stdClass Object
(
[fichier] => 22062273_37.jpg
)
[37] => stdClass Object
(
[fichier] => 22062273_38.jpg
)
[38] => stdClass Object
(
[fichier] => 22062273_39.jpg
)
[39] => stdClass Object
(
[fichier] => 22062273_40.jpg
)
[40] => stdClass Object
(
[fichier] => 22062273_41.jpg
)
[41] => stdClass Object
(
[fichier] => 22062273_42.jpg
)
[42] => stdClass Object
(
[fichier] => 22062273_43.jpg
)
[43] => stdClass Object
(
[fichier] => 22062273_44.jpg
)
[44] => stdClass Object
(
[fichier] => 22062273_45.jpg
)
[45] => stdClass Object
(
[fichier] => 22062273_46.jpg
)
[46] => stdClass Object
(
[fichier] => 22062273_47.jpg
)
)
Discover a fully renovated, bright, and exceptionally spacious Triplex in the prime location of Hampstead. This unique property not only boasts a stunning makeover but also offers the option for owner occupancy, making it a truly exclusive opportunity. The well-thought-out layout of the Triplex is not only functional but also sets the stage for sea
Inclusions
2 heat pumps, 3 water tanks, blinds ( excluded all sheers).
Exclusions
All appliaces of all 3 units, all chandeliers and drapes (sheers)
Description
Status : ActiveCategory : Multi-family (2 to 5 units)Genre : TriplexType : DetachedFloors : 3 Occupancy
Listed since : 2024-01-17Occupancy Delay : 45 days
Location
City : HampsteadStreet : Rue HolthamClose to : Hampstead Rd. Construction
Year of construction : 1976
Building and Lot
Lot size : 0 x 0 Lot area : 525.6 Square metersIrregular : YesBuilding : 0 x 0 Irregular : Yes
Rooms
Rooms : 14Bedrooms : 3Bathrooms : 3Shower room (s) : 1
Room Dimensions
Municipal Assessment
Lot : $833100Building : $852100Total : $1685200
Costs
Municipal Taxes (2023) : $12888 (Yearly)School taxes (2024) : $1326 (Yearly)Total : $14214
End of Lease : -0001-11-30