Property Single
SELECT pht.fichier,pht.photo_url
FROM wp_photos pho,wp_photos_traites pht
WHERE pho.NO_INSCRIPTION=10929340
AND pho.PhotoURL=pht.photo_url
Array
(
[0] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[1] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[2] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[3] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[4] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[5] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[6] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[7] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[8] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[9] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[10] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[11] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[12] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[13] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[14] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[15] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[16] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[17] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[18] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[19] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[20] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[21] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[22] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[23] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[24] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[25] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[26] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[27] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[28] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[29] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[30] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[31] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[32] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[33] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[34] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[35] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[36] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[37] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[38] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[39] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[40] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[41] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[42] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[43] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[44] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[45] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[46] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[47] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[48] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[49] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[50] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[51] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[52] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[53] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[54] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[55] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[56] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[57] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[58] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[59] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[60] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[61] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[62] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[63] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[64] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[65] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[66] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[67] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[68] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[69] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[70] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[71] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
[72] => stdClass Object
(
[fichier] => 10929340_1.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8BDD8A7C97D1A&t=pi&f=I
)
[73] => stdClass Object
(
[fichier] => 10929340_2.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8ADD8A7C97D4E&t=pi&f=I
)
[74] => stdClass Object
(
[fichier] => 10929340_3.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F88DD8A7C97D20&t=pi&f=I
)
[75] => stdClass Object
(
[fichier] => 10929340_4.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8FDD8A7C97DCD&t=pi&f=I
)
[76] => stdClass Object
(
[fichier] => 10929340_5.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F87DD8A7C97DE1&t=pi&f=I
)
[77] => stdClass Object
(
[fichier] => 10929340_6.jpg
[photo_url] => https://mediaserver.centris.ca/media.ashx?id=ADD25D7DEE56F8CDD8A7C97DA0&t=pi&f=I
)
)
Super-sized bungalow on an oversized lot with a detached three car garage in Beaconsfield south. The property features large sunken living room with nine foot ceiling. Renovated kitchen with granite counters overlooks your dinette and sunroom. There is also a main floor family room with ensuite bathroom which easily converts to a second primary suite or fourth bedroom. The basement consists of a large playroom and storage area only. The property requires some finishing touches and tlc. Set on an extra large south facing lot with inground concrete in a sough after location.
Welcome to 354 Beaconsfield Boulevard, Beaconsfield.
This remarkable ranch-style bungalow is set back from the street, offering both privacy and spacious living on a generous 29,000+ square foot south-facing lot, complete with an inground pool and a detached three-car garage.
Distinctive in design, the home features a large front kitchen with abundant cabinetry and granite countertops, overlooking the dinette and sunroom. The expansive dinette is bathed in natural light and opens to the south-facing sunroom, with a patio door leading out to the beautifully landscaped grounds.
The formal sunken living room (23.10 x 18.9) boasts a nine-foot ceiling, a wood-burning fireplace, and custom built-ins with a marble shelf, creating a warm and inviting space for relaxation and entertaining.
On the east side of the home, the spacious family room with exotic wood floors offers an ensuite bathroom with heated floors and large windows facing north and west, providing serene views of the front grounds and circular driveway. This versatile space could easily serve as a second primary suite or a fourth bedroom.
The bedrooms are located on the west side of the home. The primary suite, positioned on the south side, includes an ensuite bathroom with heated marble floors. The two additional bedrooms face north and share a vintage bathroom, offering the perfect opportunity for customization with your own renovation touches.
The lower level is dedicated to a playroom and additional storage space. Please note, the home does not feature a large basement.
Recent updates include a new roof (2017) and replacement of heat pumps (2019).
This is a rare opportunity to acquire a truly unique property and make it your own with your personal finishing touches.
Inclusions
Fridge, stove "as is" two elements non functional, dishwasher, alarm system, electric garage door openers, all pool accessories.
Exclusions
Dinette light fixture.
Description
Status : ActiveCategory : ResidentialGenre : BungalowType : Detached Occupancy
Listed since : 2025-03-06Occupancy Delay : 90 days
Location
City : BeaconsfieldStreet : Boul. Beaconsfield Construction
Year of construction : 1952
Building and Lot
Lot size : 35.97 x 75.9 MetersLot area : 2751 Square metersIrregular : YesBuilding : 22.84 x 19.66 MetersIrregular : Yes
Rooms
Rooms : 14Bedrooms : 3Bathrooms : 3Shower room (s) : 0
Room Dimensions
Living room : 23.10x18.9 PWoodDining room : 19.2x11.10 PWoodKitchen : 15.11x12.7 PCeramic tilesDinette : 13.11x11.8 PWoodSolarium : 18.5x11.2 PCeramic tilesFamily room : 20.6x16.9 PWoodBathroom : 6x7.7 PCeramic tilesPrimary bedroom : 15x17.10 PWoodBathroom : 7.9x5.10 PMarbleBedroom : 12x9.11 PWoodBathroom : 6.11x6.9 PCeramic tilesBedroom : 10.6x11.6 PPlayroom : 28.4x11.7 PWoodStorage : 13.5x11.11 PConcrete
Municipal Assessment
Lot : $1183800Building : $423500Total : $1607300
Costs
Municipal Taxes (2025) : $10272 (Yearly)School taxes (2025) : $1310 (Yearly)Total : $11582
End of Lease : -0001-11-30