$1,685,000
ULS: 22820573
Two or more storey house
for sale
2040 Rue Denis-Tremblay, Sherbrooke (Brompton/Rock Forest/Saint-Élie/Deauville) (Saint-Élie d'Orford)
A private estate of rare beauty where water, nature, and architecture unite in perfect harmony. The pond, enhanced by a fountain and waterfall, evokes the grandeur of world-class retreats. Inside, majestic volumes, soaring ceilings, and exquisite finishes define pure refinement. Five garages and an inground pool complete this remarkable residence of prestige.
Sale with exclusion(s) of legal warranty - See listing broker(s)
Number of rooms
19
Property features
4
Bedrooms
2
Bathrooms
2
Powder rooms
KENNY HAMEL
Residential and Commercial Real Estate Broker
SIMON-P. MARCIL
Real Estate Broker
Addendum
Main Floor
*Entrance Hall: Spacious and bright, featuring a grand wooden staircase and a stunning chandelier that set the tone for this prestigious home.
*Living Room: Refined and welcoming, complete with a wood-burning fireplace for a cozy, elegant ambiance.
*Office: Quiet and filled with natural light, perfect for working from home.
*Kitchen: Expansive and beautifully designed, with a central island, generous counter space, abundant cabinetry, and high-end finishes.
*Dining Room: Bathed in natural light with large windows and seamless flow with the main living areas.
*Family Room: Vast and bright, opening directly onto the terrace and backyard - ideal for entertaining.
*Powder Room / Laundry Room: Combined space offering convenience and style, with laundry chute and storage.
*Attached Heated Double Garage: Interior access, concrete floor, storage area, and exterior side door.
Upper Level
*Bedroom 1: Spacious and bright with a double closet.
*Bedroom 2: Generous room, perfect for guests or children.
*Bedroom 3: Features private ensuite bathroom and walk-in closet.
*Primary Bedroom: A luxurious master suite with a large walk-in and a spa-inspired ensuite bathroom.
*Ensuite Bathroom (Primary): Includes freestanding tub, glass shower, and refined finishes.
Basement
*Family / Recreation Room: Expansive, versatile space ideal for a home theatre, gym, or game room.
*Powder Room: Convenient and well-appointed.
*Mechanical Room: Houses geothermal system, water treatment, and main utilities.
*Storage: Large, practical space for seasonal or recreational equipment.
Garages
*Attached Heated Double Garage: Concrete floor, interior access, storage.
*Detached Double Garage: Perfect for additional vehicles or workshop use.
*Single Garage: Dedicated to pool equipment and exterior storage.
Exterior
*Grounds: Private, beautifully landscaped, and surrounded by mature trees.
*Private Pond: Featuring illuminated fountain and cascading waterfall - a true natural retreat.
*Walking Path: Encircling the pond, with benches and hammocks for relaxation.
*Outdoor Lounge: Stylish seating area for summer gatherings.
oHeated Inground Pool: Elegantly integrated into the setting, blending luxury and tranquility.
*Entrance Hall: Spacious and bright, featuring a grand wooden staircase and a stunning chandelier that set the tone for this prestigious home.
*Living Room: Refined and welcoming, complete with a wood-burning fireplace for a cozy, elegant ambiance.
*Office: Quiet and filled with natural light, perfect for working from home.
*Kitchen: Expansive and beautifully designed, with a central island, generous counter space, abundant cabinetry, and high-end finishes.
*Dining Room: Bathed in natural light with large windows and seamless flow with the main living areas.
*Family Room: Vast and bright, opening directly onto the terrace and backyard - ideal for entertaining.
*Powder Room / Laundry Room: Combined space offering convenience and style, with laundry chute and storage.
*Attached Heated Double Garage: Interior access, concrete floor, storage area, and exterior side door.
Upper Level
*Bedroom 1: Spacious and bright with a double closet.
*Bedroom 2: Generous room, perfect for guests or children.
*Bedroom 3: Features private ensuite bathroom and walk-in closet.
*Primary Bedroom: A luxurious master suite with a large walk-in and a spa-inspired ensuite bathroom.
*Ensuite Bathroom (Primary): Includes freestanding tub, glass shower, and refined finishes.
Basement
*Family / Recreation Room: Expansive, versatile space ideal for a home theatre, gym, or game room.
*Powder Room: Convenient and well-appointed.
*Mechanical Room: Houses geothermal system, water treatment, and main utilities.
*Storage: Large, practical space for seasonal or recreational equipment.
Garages
*Attached Heated Double Garage: Concrete floor, interior access, storage.
*Detached Double Garage: Perfect for additional vehicles or workshop use.
*Single Garage: Dedicated to pool equipment and exterior storage.
Exterior
*Grounds: Private, beautifully landscaped, and surrounded by mature trees.
*Private Pond: Featuring illuminated fountain and cascading waterfall - a true natural retreat.
*Walking Path: Encircling the pond, with benches and hammocks for relaxation.
*Outdoor Lounge: Stylish seating area for summer gatherings.
oHeated Inground Pool: Elegantly integrated into the setting, blending luxury and tranquility.
Building details and property interior
Year constructed
1998
Energy efficiency
Novoclimat certification
Windows
PVC
Window Type
Casement
Siding
Wood, Stone
Roofing
Asphalt shingles
Garage
Heated, Attached, Detached, Double width or more
Washer/Dryer (installation)
Powder room
Basement
6 feet and more, Finished basement
Lot and exterior features
Lot size
442' 11" X 283' 7"
Lot area
2.88 ac
Topography
Flat
View
View of the water
Distinctive Features
No rear neighbours
Driveway
Asphalt
Parking (total)
Driveway (10), Garage (4)
Pool
Inground, Heated
Proximity
Hospital, Park, Bicycle path, Elementary school, Alpine skiing, Highway, Cross-country skiing, Snowmobile trail, ATV trail, University, High school, CEGEP, Daycare centre, Golf
Room details
Hall
Level:
1st level/Ground floor
Dimensions:
6'6" X 19'1" irr.
Flooring:
Wood
Details:
Office
Level:
1st level/Ground floor
Dimensions:
12'7" X 9'5" irr.
Flooring:
Wood
Details:
Salle de séjour
Level:
1st level/Ground floor
Dimensions:
19'1" X 14'3"
Flooring:
Wood
Details:
Kitchen
Level:
1st level/Ground floor
Dimensions:
18'5" X 15'5"
Flooring:
Ceramic
Details:
Dining room
Level:
1st level/Ground floor
Dimensions:
18'4" X 11'9" irr.
Flooring:
Wood
Details:
Living room
Level:
1st level/Ground floor
Dimensions:
17'3" X 24'11" irr.
Flooring:
Wood
Details:
Salle d'eau/lavage
Level:
1st level/Ground floor
Dimensions:
9'11" X 5'6" irr.
Flooring:
Ceramic
Details:
Bedroom
Level:
2nd level
Dimensions:
15'2" X 12'
Flooring:
Wood
Details:
Bedroom
Level:
2nd level
Dimensions:
13'2" X 12'10"
Flooring:
Wood
Details:
Bathroom
Level:
2nd level
Dimensions:
8'3" X 8'5" irr.
Flooring:
Ceramic
Details:
Bedroom
Level:
2nd level
Dimensions:
13'8" X 14' irr.
Flooring:
Wood
Details:
Primary bedroom
Level:
2nd level
Dimensions:
23'9" X 21'8" irr.
Flooring:
Wood
Details:
Walk-in closet
Level:
2nd level
Dimensions:
13'11" X 5' irr.
Flooring:
Wood
Details:
Bathroom
Level:
2nd level
Dimensions:
16'5" X 11'2" irr.
Flooring:
Details:
Family room
Level:
Basement 1
Dimensions:
24'2" X 19' irr.
Flooring:
Laminate floor
Details:
Powder room
Level:
Basement 1
Dimensions:
3'1" X 7'8"
Flooring:
Details:
Living room
Level:
Basement 1
Dimensions:
36' X 17'1" irr.
Flooring:
Laminate floor
Details:
Storage
Level:
Basement 1
Dimensions:
15'8" X 7'1" irr.
Flooring:
Laminate floor
Details:
Salle mécanique
Level:
Basement 1
Dimensions:
12'1" X 12'8" irr.
Flooring:
Concrete
Details:
Characteristics
Heating System
Other, Forced air
Energy efficiency
Novoclimat certification
Heating Energy
Geothermal, Electricity
Fireplace-Stove
Wood fireplace
Property or unit amenity
Central vacuum cleaner system installation, Electric garage door opener
Water Supply
Artesian well
Sewage System
Disposal field, Septic tank
Financial details
Municipal assessment (2025)
- Lot assessment
- $ 155,400
- Building assessment
- $ 892,000
- Total
- $ 1,047,400
Taxes
- Municipal (2025)
- $ 7,207
- School (2025)
- $ 641
- Total
- $ 7,848
Inclusions and exclusions
Mortgage payment calculator
$
$
$
%
Learn more about this property's neighbourhood
The sector in a few statistics