Property Single
SELECT pht.fichier,pht.photo_url
FROM wp_photos pho,wp_photos_traites pht
WHERE pho.NO_INSCRIPTION=10010164
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 10010164_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C05F6DDFB952CD10&t=pi&f=I
)
[1] => stdClass Object
(
[fichier] => 10010164_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0582DDFB952CD40&t=pi&f=I
)
[2] => stdClass Object
(
[fichier] => 10010164_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0594DDFB952CD2B&t=pi&f=I
)
[3] => stdClass Object
(
[fichier] => 10010164_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0580DDFB952CDC2&t=pi&f=I
)
[4] => stdClass Object
(
[fichier] => 10010164_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0311DDFB952CDE1&t=pi&f=I
)
[5] => stdClass Object
(
[fichier] => 10010164_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0312DDFB952CDAC&t=pi&f=I
)
[6] => stdClass Object
(
[fichier] => 10010164_7.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C031CDDFB952CD0A&t=pi&f=I
)
[7] => stdClass Object
(
[fichier] => 10010164_8.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C031EDDFB952CDBB&t=pi&f=I
)
[8] => stdClass Object
(
[fichier] => 10010164_9.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0310DDFB952CDF1&t=pi&f=I
)
[9] => stdClass Object
(
[fichier] => 10010164_10.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C031FDDFB952CD81&t=pi&f=I
)
[10] => stdClass Object
(
[fichier] => 10010164_11.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0318DDFB952CD9D&t=pi&f=I
)
[11] => stdClass Object
(
[fichier] => 10010164_12.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0317DDFB952CD72&t=pi&f=I
)
[12] => stdClass Object
(
[fichier] => 10010164_13.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0315DDFB952CD3A&t=pi&f=I
)
[13] => stdClass Object
(
[fichier] => 10010164_14.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0316DDFB952CD5B&t=pi&f=I
)
[14] => stdClass Object
(
[fichier] => 10010164_15.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0341DDFB952CD6F&t=pi&f=I
)
[15] => stdClass Object
(
[fichier] => 10010164_16.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0344DDFB952C1DF&t=pi&f=I
)
[16] => stdClass Object
(
[fichier] => 10010164_17.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0342DDFB952C111&t=pi&f=I
)
[17] => stdClass Object
(
[fichier] => 10010164_18.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C034CDDFB952C142&t=pi&f=I
)
[18] => stdClass Object
(
[fichier] => 10010164_19.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C034ADDFB952C12A&t=pi&f=I
)
[19] => stdClass Object
(
[fichier] => 10010164_20.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0340DDFB952C1CB&t=pi&f=I
)
[20] => stdClass Object
(
[fichier] => 10010164_21.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C034BDDFB952C1ED&t=pi&f=I
)
[21] => stdClass Object
(
[fichier] => 10010164_22.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0348DDFB952C1AD&t=pi&f=I
)
[22] => stdClass Object
(
[fichier] => 10010164_23.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0349DDFB952C104&t=pi&f=I
)
[23] => stdClass Object
(
[fichier] => 10010164_24.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0343DDFB952C1BE&t=pi&f=I
)
[24] => stdClass Object
(
[fichier] => 10010164_25.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0345DDFB952C1F0&t=pi&f=I
)
[25] => stdClass Object
(
[fichier] => 10010164_26.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0346DDFB952C18A&t=pi&f=I
)
[26] => stdClass Object
(
[fichier] => 10010164_27.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0321DDFB952C190&t=pi&f=I
)
[27] => stdClass Object
(
[fichier] => 10010164_28.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C05F9DDFB952C174&t=pi&f=I
)
[28] => stdClass Object
(
[fichier] => 10010164_29.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0324DDFB952C13D&t=pi&f=I
)
[29] => stdClass Object
(
[fichier] => 10010164_30.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C03D5DDFB952C150&t=pi&f=I
)
[30] => stdClass Object
(
[fichier] => 10010164_31.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DE3C0587DDFB952C16C&t=pi&f=I
)
)
Turnkey brick beauty backing on to a green space. The property features 4+2 bedrooms, 3.5 bathrooms, fully loaded kitchen with granite counters open to you spacious dinette, main floor family room with fireplace, the upper level features a large landing and four bedrooms. One of which is on its own level. The finished basement is comprised of a large playroom, full bathroom and two bedrooms. Meticulously landscaped with a paviuni patio and large deck with covered pergola overlooking a green space. Live on a family friendly street within walking distance to the REM. **Original owners, first time making its debut onto the market**.
Welcome to 114 Château, KirklandDiscover the perfect blend of comfort and convenience in this impeccably maintained, move-in-ready home--ideally located within walking distance to Académie Marie-Claire, parks, shopping, and the REM.
Step inside to a bright formal living room with gleaming hardwood floors, flowing seamlessly into the elegant dining area. The chef's kitchen is fully equipped with granite counters and a stylish ceramic backsplash, open to a spacious dinette with patio doors leading to a large deck, covered pergola, and peaceful views of the bike path and lush green space.
Adjacent to the kitchen is the cozy family room, featuring a charming wood-burning fireplace--perfect for gathering with loved ones.
Upstairs, you'll find four generously sized bedrooms, all with hardwood flooring. One bedroom is uniquely situated on its own split level, offering added privacy. The generous primary suite includes a spa-like ensuite with a freestanding soaker tub, separate glass shower, and sleek quartz vanity.
The finished basement adds valuable living space with a large playroom enhanced by coffered ceilings and pot lights, two additional bedrooms, and a full bathroom--ideal for guests, extended family, or a home office setup.
This is your chance to enjoy turnkey living in a quiet, family-friendly neighborhood with unbeatable access to schools, transit, and green spaces.
Description
Status : ActiveCategory : ResidentialGenre : Two or more storeyType : Detached Occupancy
Listed since : 2026-01-30Occupancy Delay : 60 days
Location
City : KirklandStreet : Rue du Château-KirklandClose to : Discepola Construction
Year of construction : 1999
Building and Lot
Lot size : 20 x 32 MetersLot area : 650.33 Square metersIrregular : YesBuilding : 13.44 x 11.29 MetersIrregular : Yes
Rooms
Rooms : 15Bedrooms : 4 + 2Bathrooms : 3Shower room (s) : 1
Room Dimensions
Living room : 14x12.8 PWoodDining room : 11.8x11.2 PWoodKitchen : 12.10x9.1 PCeramic tilesDinette : 11.1x11.9 PCeramic tilesFamily room : 17.7x15 PWoodBedroom : 16.4x13.1 PWoodPrimary bedroom : 16x12.11 PWoodBathroom : 9.6x7.8 PCeramic tilesBedroom : 11.4x10 PWoodBathroom : 7.3x7.5 PCeramic tilesBedroom : 12.3x10 PWoodPlayroom : 23.10x16 POtherBedroom : 11.10x10 POtherBathroom : 9x4.9 PCeramic tilesBedroom : 10.1x9.11 POther
Municipal Assessment
Lot : $468200Building : $787000Total : $1255200
Costs
Municipal Taxes (2025) : $7082 (Yearly)School taxes (2025) : $977 (Yearly)Total : $8059
End of Lease : -0001-11-30