Property Single
SELECT pht.fichier,pht.photo_url
FROM wp_photos pho,wp_photos_traites pht
WHERE pho.NO_INSCRIPTION=24605331
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 24605331_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0150D10004F2D12&t=pi&f=I
)
[1] => stdClass Object
(
[fichier] => 24605331_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B015ED10004F2D44&t=pi&f=I
)
[2] => stdClass Object
(
[fichier] => 24605331_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B04D9D10004F2D2A&t=pi&f=I
)
[3] => stdClass Object
(
[fichier] => 24605331_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B04D5D10004F2DCD&t=pi&f=I
)
[4] => stdClass Object
(
[fichier] => 24605331_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B04C4D10004F2DEA&t=pi&f=I
)
[5] => stdClass Object
(
[fichier] => 24605331_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B04EED10004F2DA1&t=pi&f=I
)
[6] => stdClass Object
(
[fichier] => 24605331_7.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B041BD10004F2D01&t=pi&f=I
)
[7] => stdClass Object
(
[fichier] => 24605331_8.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B041DD10004F2DBC&t=pi&f=I
)
[8] => stdClass Object
(
[fichier] => 24605331_9.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0412D10004F2DFB&t=pi&f=I
)
[9] => stdClass Object
(
[fichier] => 24605331_10.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B041AD10004F2D8F&t=pi&f=I
)
[10] => stdClass Object
(
[fichier] => 24605331_11.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B04BAD10004F2D90&t=pi&f=I
)
[11] => stdClass Object
(
[fichier] => 24605331_12.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B04B8D10004F2D7F&t=pi&f=I
)
[12] => stdClass Object
(
[fichier] => 24605331_13.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B04BDD10004F2D32&t=pi&f=I
)
[13] => stdClass Object
(
[fichier] => 24605331_14.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B04B5D10004F2D5E&t=pi&f=I
)
[14] => stdClass Object
(
[fichier] => 24605331_15.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B047ED10004F2D61&t=pi&f=I
)
[15] => stdClass Object
(
[fichier] => 24605331_16.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0478D10004F21D4&t=pi&f=I
)
[16] => stdClass Object
(
[fichier] => 24605331_17.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B047BD10004F211C&t=pi&f=I
)
[17] => stdClass Object
(
[fichier] => 24605331_18.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B021FD10004F214F&t=pi&f=I
)
[18] => stdClass Object
(
[fichier] => 24605331_19.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0219D10004F212F&t=pi&f=I
)
[19] => stdClass Object
(
[fichier] => 24605331_20.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0212D10004F21CE&t=pi&f=I
)
[20] => stdClass Object
(
[fichier] => 24605331_21.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B021DD10004F21E2&t=pi&f=I
)
[21] => stdClass Object
(
[fichier] => 24605331_22.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B021AD10004F21AD&t=pi&f=I
)
[22] => stdClass Object
(
[fichier] => 24605331_23.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0CC5D10004F210D&t=pi&f=I
)
[23] => stdClass Object
(
[fichier] => 24605331_24.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0CE1D10004F21B4&t=pi&f=I
)
[24] => stdClass Object
(
[fichier] => 24605331_25.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0A0CD10004F21FD&t=pi&f=I
)
[25] => stdClass Object
(
[fichier] => 24605331_26.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0BCBD10004F2181&t=pi&f=I
)
[26] => stdClass Object
(
[fichier] => 24605331_27.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0BCFD10004F2192&t=pi&f=I
)
[27] => stdClass Object
(
[fichier] => 24605331_28.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0BC8D10004F2174&t=pi&f=I
)
[28] => stdClass Object
(
[fichier] => 24605331_29.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0BC9D10004F213C&t=pi&f=I
)
[29] => stdClass Object
(
[fichier] => 24605331_30.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0BC3D10004F2150&t=pi&f=I
)
[30] => stdClass Object
(
[fichier] => 24605331_31.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B00D9D10004F2161&t=pi&f=I
)
[31] => stdClass Object
(
[fichier] => 24605331_32.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B00D5D10004F24D2&t=pi&f=I
)
[32] => stdClass Object
(
[fichier] => 24605331_33.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0AAAD10004F241C&t=pi&f=I
)
[33] => stdClass Object
(
[fichier] => 24605331_34.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0AA7D10004F244B&t=pi&f=I
)
[34] => stdClass Object
(
[fichier] => 24605331_35.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0AA6D10004F2424&t=pi&f=I
)
[35] => stdClass Object
(
[fichier] => 24605331_36.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0A0BD10004F24CD&t=pi&f=I
)
[36] => stdClass Object
(
[fichier] => 24605331_37.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DA1B0A09D10004F24E1&t=pi&f=I
)
)
Navigable waterfront with breathtaking views and sunsets. Formal living room with gas fireplace, spacious dining and family rooms with wall-to-wall windows and patio doors overlooking the waterfront. Kitchen with granite counters and adjoining office area both also, enjoying water views. Originally a four-bedroom home, the upper level has been converted to three bedrooms, featuring a generous primary suite with sitting area, walk-in closet, ensuite bathroom, wall-to-wall windows and access to a private rooftop balcony. Finished basement with separate exterior entrance. An exceptional waterfront lifestyle awaits.
Set well back from the street on a navigable waterfront lot, this exceptional property is approached by a long private asphalt driveway with ample parking, transitioning to elegant paving stones near the home and beneath the carport.
A formal vestibule with stone flooring welcomes you into a spacious living room featuring hardwood floors and a gas fireplace.
Designed to capture the spectacular water views, the open-concept dining and family rooms showcase a full wall of windows and patio doors overlooking the waterfront.
The kitchen offers granite countertops, abundant cabinetry, and a built-in office area, both enjoying water views.
The generous primary suite features a private sitting room, walk-in closet, ensuite bathroom, and a wall of windows overlooking the water, with direct access to a private 18.9' x 25' rooftop terrace.
The finished basement includes two large playrooms and a storage area.
The rear playroom benefits from a separate exterior entrance, making it ideal for teens, guests, a home office, or intergenerational living.
Description
Status : ActiveCategory : ResidentialGenre : Two or more storeyType : Detached Occupancy
Listed since : 2026-06-18Occupancy Delay : 120 days
Location
City : Montréal (L'Île-Bizard/Sainte-Geneviève)Street : Boul. Gouin O. Construction
Year of construction : 1940
Building and Lot
Lot size : 22 x 131 MetersLot area : 1996.5 Square metersIrregular : YesBuilding : 9.78 x 11.45 MetersIrregular : Yes
Rooms
Rooms : 16Bedrooms : 3Bathrooms : 2Shower room (s) : 1
Room Dimensions
Other : 7.2x6.1 POtherLiving room : 22x14.5 PWoodDining room : 10.10x13 PFlexible floor coveringsFamily room : 20x13 PFlexible floor coveringsKitchen : 17.6x10.5 PFlexible floor coveringsHome office : 5.6x7 PFlexible floor coveringsWashroom : 4.3x3.7 PPrimary bedroom : 29.2x12.7 PWoodWalk-in closet : 12.11x6.3 PWoodBathroom : 7.8x10.5 PCeramic tilesBedroom : 14.1x10.5 PWoodBathroom : 5.10x7.6 PConcreteBedroom : 11.11x10.4 PWoodOther : 21x21 POtherPlayroom : 23.10x11.11 POtherStorage : 11.11x5.11 POther
Municipal Assessment
Lot : $959700Building : $359900Total : $1319600
Costs
Municipal Taxes (2026) : $7857 (Yearly)School taxes (2025) : $906 (Yearly)Total : $8763
End of Lease : -0001-11-30