Property Single
SELECT pht.fichier,pht.photo_url
FROM wp_photos pho,wp_photos_traites pht
WHERE pho.NO_INSCRIPTION=24976307
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 24976307_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A128D1031992D1B&t=pi&f=I
)
[1] => stdClass Object
(
[fichier] => 24976307_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A123D1031992D44&t=pi&f=I
)
[2] => stdClass Object
(
[fichier] => 24976307_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A125D1031992D2C&t=pi&f=I
)
[3] => stdClass Object
(
[fichier] => 24976307_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1CDD1031992DCE&t=pi&f=I
)
[4] => stdClass Object
(
[fichier] => 24976307_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1C1D1031992DE0&t=pi&f=I
)
[5] => stdClass Object
(
[fichier] => 24976307_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1C2D1031992DAD&t=pi&f=I
)
[6] => stdClass Object
(
[fichier] => 24976307_7.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1CED1031992D02&t=pi&f=I
)
[7] => stdClass Object
(
[fichier] => 24976307_8.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1CAD1031992DBE&t=pi&f=I
)
[8] => stdClass Object
(
[fichier] => 24976307_9.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1C0D1031992DF0&t=pi&f=I
)
[9] => stdClass Object
(
[fichier] => 24976307_10.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1CFD1031992D80&t=pi&f=I
)
[10] => stdClass Object
(
[fichier] => 24976307_11.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1C8D1031992D9A&t=pi&f=I
)
[11] => stdClass Object
(
[fichier] => 24976307_12.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1C9D1031992D7B&t=pi&f=I
)
[12] => stdClass Object
(
[fichier] => 24976307_13.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1C3D1031992D31&t=pi&f=I
)
[13] => stdClass Object
(
[fichier] => 24976307_14.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1C5D1031992D52&t=pi&f=I
)
[14] => stdClass Object
(
[fichier] => 24976307_15.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1EDD1031992D6C&t=pi&f=I
)
[15] => stdClass Object
(
[fichier] => 24976307_16.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1E4D10319921DE&t=pi&f=I
)
[16] => stdClass Object
(
[fichier] => 24976307_17.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1E2D1031992110&t=pi&f=I
)
[17] => stdClass Object
(
[fichier] => 24976307_18.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1ECD103199214F&t=pi&f=I
)
[18] => stdClass Object
(
[fichier] => 24976307_19.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1EED1031992121&t=pi&f=I
)
[19] => stdClass Object
(
[fichier] => 24976307_20.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1E0D10319921CC&t=pi&f=I
)
[20] => stdClass Object
(
[fichier] => 24976307_21.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1EBD10319921EA&t=pi&f=I
)
[21] => stdClass Object
(
[fichier] => 24976307_22.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1EFD10319921AB&t=pi&f=I
)
[22] => stdClass Object
(
[fichier] => 24976307_23.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1E8D1031992100&t=pi&f=I
)
[23] => stdClass Object
(
[fichier] => 24976307_24.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1E9D10319921BF&t=pi&f=I
)
[24] => stdClass Object
(
[fichier] => 24976307_25.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1E3D10319921F4&t=pi&f=I
)
[25] => stdClass Object
(
[fichier] => 24976307_26.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1E6D1031992184&t=pi&f=I
)
[26] => stdClass Object
(
[fichier] => 24976307_27.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1ADD1031992194&t=pi&f=I
)
[27] => stdClass Object
(
[fichier] => 24976307_28.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1A1D103199217C&t=pi&f=I
)
[28] => stdClass Object
(
[fichier] => 24976307_29.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1A2D1031992130&t=pi&f=I
)
[29] => stdClass Object
(
[fichier] => 24976307_30.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1ACD103199215F&t=pi&f=I
)
[30] => stdClass Object
(
[fichier] => 24976307_31.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1AED1031992161&t=pi&f=I
)
[31] => stdClass Object
(
[fichier] => 24976307_32.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1A0D10319924D4&t=pi&f=I
)
[32] => stdClass Object
(
[fichier] => 24976307_33.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1ABD103199241C&t=pi&f=I
)
[33] => stdClass Object
(
[fichier] => 24976307_34.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1A8D103199244C&t=pi&f=I
)
[34] => stdClass Object
(
[fichier] => 24976307_35.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1A9D103199242A&t=pi&f=I
)
[35] => stdClass Object
(
[fichier] => 24976307_36.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1A7D10319924CB&t=pi&f=I
)
[36] => stdClass Object
(
[fichier] => 24976307_37.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1A5D10319924E1&t=pi&f=I
)
[37] => stdClass Object
(
[fichier] => 24976307_38.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A1A6D10319924A2&t=pi&f=I
)
[38] => stdClass Object
(
[fichier] => 24976307_39.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A101D103199240C&t=pi&f=I
)
[39] => stdClass Object
(
[fichier] => 24976307_40.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A104D10319924BA&t=pi&f=I
)
[40] => stdClass Object
(
[fichier] => 24976307_41.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A102D10319924FB&t=pi&f=I
)
[41] => stdClass Object
(
[fichier] => 24976307_42.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A10ED103199248B&t=pi&f=I
)
[42] => stdClass Object
(
[fichier] => 24976307_43.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A10AD103199249D&t=pi&f=I
)
[43] => stdClass Object
(
[fichier] => 24976307_44.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A10FD103199247C&t=pi&f=I
)
[44] => stdClass Object
(
[fichier] => 24976307_45.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A108D1031992432&t=pi&f=I
)
[45] => stdClass Object
(
[fichier] => 24976307_46.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A109D103199245E&t=pi&f=I
)
[46] => stdClass Object
(
[fichier] => 24976307_47.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A107D1031992460&t=pi&f=I
)
[47] => stdClass Object
(
[fichier] => 24976307_48.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A105D10319922DB&t=pi&f=I
)
[48] => stdClass Object
(
[fichier] => 24976307_49.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE8A129D1031992214&t=pi&f=I
)
)
Custom-built brick beauty located in a sough after neighborhood. The property features a large living room with coffered ceiling, a fully loaded gourmet kitchen with granite counters & large center island open to your dining room with soaring 18-foot ceiling and family room with gas fireplace. Upper level comprised of four bedrooms including two primary suites and three bathrooms. Completely finished intergenerational basement with two staircases, large playroom, two bedrooms and a full bath and kitchen area. Enjoy your West-facing yard with ingroud pool and patio areas. Steps away from Lakeshore road and a short walk to Beaurepaire village.
** Welcome to 6 St Louis Beaconsfield **
Custom built for family living and entertaining alike the property features generous room dimensions with high ceilings.
The main entrance leads into a formal vestibule (11.9 x 7.7) with large closet and double French doors leading into the foyer with hardwood floors.
The formal front living room has a coffered ceiling and pot lighting.
The fully loaded gourmet kitchen with granite counter and large center island is open to and overlooks your dining room with soaring 18-foot ceiling and ample windows overlooking the West facing yard with patio areas and inground pool.
The kitchen and dining rooms are also open to your main floor family room with gas fireplace.
A hardwood staircase leads to your upper level, which is comprised of four bedrooms, including two primary suites, three full bathrooms and one of your two laundry rooms.
The main primary suite features hardwood floors, a gas fireplace, a walk-in closet (10.11 x 6) and full ensuite bathroom complete with soaker tub and separate shower.
The property has a fully finished basement with access from the main home and also though an independent staircase from the garage which has an epoxy floor.
The basement easily accommodates INTERGENERATIONAL, nanny or teen living as its comprised of a large playroom with high ceilings, two full bedrooms, a full bathroom, plus your second laundry room which is ready for the kitchenette.
There is also a customized and temperature-controlled wine cellar in the basement too.
The property is equipped with two furnaces and two heat pumps plus In the furnace room you have an Ecoflow battery system which powers multiple zones inside the home in the event of a power failure.
Enjoy your fully fenced the West facing yard with inground pool and pavi-uni patio areas.
Sought after location just steps away from Lakeshore road and walking distance to Beaurepaire village. Your new lifestyle awaits.
Description
Status : ActiveCategory : ResidentialGenre : Two or more storeyType : Detached Occupancy
Listed since : 2025-02-21Occupancy Delay : 55 days
Location
City : BeaconsfieldStreet : Av. St-LouisClose to : Lakeshore road Construction
Year of construction : 2010
Building and Lot
Lot size : 26.67 x 36.12 MetersLot area : 1047 Square metersIrregular : YesBuilding : 17.38 x 13.12 MetersIrregular : Yes
Rooms
Rooms : 18Bedrooms : 4 + 2Bathrooms : 4Shower room (s) : 1
Room Dimensions
Living room : 24.4x18.1 PWoodKitchen : 18.4x16 PCeramic tilesDining room : 16x14.4 PWoodFamily room : 21.6x16 PWoodPrimary bedroom : 17.8x16.3 PWoodBathroom : 13x10.4 PCeramic tilesBedroom : 17x15.11 PWoodBathroom : 7.9x10.11 PMarbleBedroom : 14.7x13.2 PWoodBathroom : 14.8x8.8 PCeramic tilesBedroom : 17x13 PWoodLaundry room : 7x7 PCeramic tilesPlayroom : 24.3x22.11 POtherBedroom : 17.10x15.11 POtherBathroom : 11.10x9.3 PCeramic tilesBedroom : 18.6x15.9 POtherLaundry room : 11.9x7.10 PCeramic tilesStorage : 10x10 PConcrete
Municipal Assessment
Lot : $581100Building : $1486100Total : $2067200
Costs
Municipal Taxes (2025) : $13167 (Yearly)School taxes (2024) : $1735 (Yearly)Total : $14902
End of Lease : -0001-11-30