Property Single
SELECT pht.fichier,pht.photo_url
FROM wp_photos pho,wp_photos_traites pht
WHERE pho.NO_INSCRIPTION=11480773
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 11480773_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD2AD96DD86457ED10&t=pi&f=I
)
[1] => stdClass Object
(
[fichier] => 11480773_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B0DDD86457ED4E&t=pi&f=I
)
[2] => stdClass Object
(
[fichier] => 11480773_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B0CDD86457ED2D&t=pi&f=I
)
[3] => stdClass Object
(
[fichier] => 11480773_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B04DD86457EDCF&t=pi&f=I
)
[4] => stdClass Object
(
[fichier] => 11480773_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B00DD86457EDEE&t=pi&f=I
)
[5] => stdClass Object
(
[fichier] => 11480773_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B0ADD86457EDAE&t=pi&f=I
)
[6] => stdClass Object
(
[fichier] => 11480773_7.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B0BDD86457ED0B&t=pi&f=I
)
[7] => stdClass Object
(
[fichier] => 11480773_8.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B0FDD86457EDBD&t=pi&f=I
)
[8] => stdClass Object
(
[fichier] => 11480773_9.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B09DD86457EDFD&t=pi&f=I
)
[9] => stdClass Object
(
[fichier] => 11480773_10.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B07DD86457ED8F&t=pi&f=I
)
[10] => stdClass Object
(
[fichier] => 11480773_11.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B03DD86457ED91&t=pi&f=I
)
[11] => stdClass Object
(
[fichier] => 11480773_12.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B05DD86457ED72&t=pi&f=I
)
[12] => stdClass Object
(
[fichier] => 11480773_13.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B06DD86457ED3E&t=pi&f=I
)
[13] => stdClass Object
(
[fichier] => 11480773_14.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BBDDD86457ED5E&t=pi&f=I
)
[14] => stdClass Object
(
[fichier] => 11480773_15.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BB1DD86457ED60&t=pi&f=I
)
[15] => stdClass Object
(
[fichier] => 11480773_16.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BB4DD86457E1D0&t=pi&f=I
)
[16] => stdClass Object
(
[fichier] => 11480773_17.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BBCDD86457E11D&t=pi&f=I
)
[17] => stdClass Object
(
[fichier] => 11480773_18.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BBEDD86457E144&t=pi&f=I
)
[18] => stdClass Object
(
[fichier] => 11480773_19.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BBADD86457E12C&t=pi&f=I
)
[19] => stdClass Object
(
[fichier] => 11480773_20.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BB0DD86457E1CA&t=pi&f=I
)
[20] => stdClass Object
(
[fichier] => 11480773_21.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BBFDD86457E1EF&t=pi&f=I
)
[21] => stdClass Object
(
[fichier] => 11480773_22.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BB8DD86457E1AB&t=pi&f=I
)
[22] => stdClass Object
(
[fichier] => 11480773_23.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BB7DD86457E101&t=pi&f=I
)
[23] => stdClass Object
(
[fichier] => 11480773_24.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BB3DD86457E1B2&t=pi&f=I
)
[24] => stdClass Object
(
[fichier] => 11480773_25.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BFDDD86457E1FE&t=pi&f=I
)
[25] => stdClass Object
(
[fichier] => 11480773_26.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BFEDD86457E18B&t=pi&f=I
)
[26] => stdClass Object
(
[fichier] => 11480773_27.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BF0DD86457E191&t=pi&f=I
)
[27] => stdClass Object
(
[fichier] => 11480773_28.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BF8DD86457E174&t=pi&f=I
)
[28] => stdClass Object
(
[fichier] => 11480773_29.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47BF3DD86457E13A&t=pi&f=I
)
[29] => stdClass Object
(
[fichier] => 11480773_30.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B81DD86457E15A&t=pi&f=I
)
[30] => stdClass Object
(
[fichier] => 11480773_31.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B84DD86457E16B&t=pi&f=I
)
[31] => stdClass Object
(
[fichier] => 11480773_32.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B80DD86457E4D4&t=pi&f=I
)
[32] => stdClass Object
(
[fichier] => 11480773_33.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B8FDD86457E41E&t=pi&f=I
)
[33] => stdClass Object
(
[fichier] => 11480773_34.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B85DD86457E44B&t=pi&f=I
)
[34] => stdClass Object
(
[fichier] => 11480773_35.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B9DDD86457E42F&t=pi&f=I
)
[35] => stdClass Object
(
[fichier] => 11480773_36.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B9EDD86457E4CE&t=pi&f=I
)
[36] => stdClass Object
(
[fichier] => 11480773_37.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B01DD86457E4E1&t=pi&f=I
)
[37] => stdClass Object
(
[fichier] => 11480773_38.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DAD47B0EDD86457E4AA&t=pi&f=I
)
)
Spectacular turnkey waterfront residence custom built in 2002, offering timeless elegance and exceptional living spaces throughout. Featuring a classic cross-hall floor plan, two fireplaces, and five generously sized bedrooms on the upper level, plus a fully finished basement complete with a cinema room. Predominantly hardwood flooring throughout the main and upper levels, with ceramic finishes in the kitchen and bathrooms. Step outside to a resort-style backyard oasis featuring a patio, pool, terrace, and breathtaking sunset views over the water.
Spectacular turnkey waterfront residence offering luxury living, exceptional entertaining spaces, and breathtaking sunsets.
The exterior boasts outstanding curb appeal with a semi-circular uni-stone driveway accommodating 6+ vehicles, a full irrigation system, and a resort-style backyard oasis featuring a large patio, heated in-ground concrete pool, waterside terrace near the seawall, and magnificent sunset views.
Double entry doors open to a closed vestibule with closets on each side, followed by elegant French doors leading into the formal foyer.
Designed with a classic cross-hall floor plan, the home features spacious principal rooms, a gourmet kitchen with center island and granite countertops, and an adjoining dinette with glass-paneled double doors opening directly onto the patio and overlooking the beautifully landscaped yard and waterfront. The inviting main-floor family room is complete with a gas fireplace.
The upper level offers a grand primary suite with its own gas fireplace and a luxurious ensuite bathroom featuring a deep therapeutic Jacuzzi soaker tub and separate shower. Four additional bedrooms complete the upper level, including one ideally suited as a home office with elegant double French doors.
The fully finished basement is ideal for teenagers, extended family, or live-in help, featuring a playroom, full bathroom, separate bedroom with adjoining private lounge/play area, and a dedicated cinema room.
Additional highlights include approximately 9-foot ceilings on the main floor and hardwood flooring throughout the main and upper levels, excluding the kitchen and bathrooms.
An exceptional navigable waterfront property where luxury, comfort, and lifestyle come together. Raise your sails and chart your course home.
Description
Status : ActiveCategory : ResidentialGenre : Two or more storeyType : Detached Occupancy
Listed since : 2026-05-08Occupancy Delay : 100 days
Location
City : Montréal (Pierrefonds-Roxboro)Street : Boul. Gouin O.Close to : St-Jean Construction
Year of construction : 2002
Building and Lot
Lot size : 36 x 56 MetersLot area : 1623.3 Square metersIrregular : YesBuilding : 13.28 x 10.73 MetersIrregular : Yes
Rooms
Rooms : 17Bedrooms : 5 + 1Bathrooms : 3Shower room (s) : 1
Room Dimensions
Living room : 13.8x15 PWoodDining room : 14.9x13.9 PWoodKitchen : 12.11x11.11 PCeramic tilesDinette : 14.8x13 PWoodFamily room : 13.9x17.8 PWoodPrimary bedroom : 27.5x16.9 PWoodBathroom : 12.11x9 PCeramic tilesBedroom : 13.10x11.7 PWoodBedroom : 13.7x12.8 PWoodBathroom : 10.4x8 PCeramic tilesBedroom : 13x11.4 PWoodBedroom : 13.11x12.6 PWoodPlayroom : 28.10x12.11 PCarpetOther : 32x13.5 PFloating floorBedroom : 12.4x13.5 PCarpetPlayroom : 18.4x13.6 PCarpetBathroom : 12.8x8.8 PCeramic tiles
Municipal Assessment
Lot : $1022700Building : $654700Total : $1677400
Costs
Municipal Taxes (2026) : $10411 (Yearly)School taxes (2025) : $1245 (Yearly)Total : $11656
End of Lease : -0001-11-30