Photo Main Photo of the property
$1,375,000
New
ULS: 25514525

Two or more storey house for sale
2040 Rue Denis-Tremblay, Sherbrooke (Brompton/Rock Forest/Saint-Élie/Deauville) (Saint-Élie d'Orford)

Magnificent contemporary private estate nestled in an exceptional setting, where water and nature create an atmosphere that is both peaceful and spectacular. Set on a beautifully landscaped lot featuring a decorative pond, fountain, and waterfall, this residence makes a striking first impression with its remarkable volumes, cathedral ceilings, and abundant natural light. Boasting high-end finishes, five integrated garages, an in-ground pool, and thoughtfully designed outdoor spaces, this exclusive property will appeal to buyers seeking prestige, privacy, and an unparalleled lifestyle.
Number of rooms 19
Living area 3,565 ft²

Property features

4 Bedrooms
2 Bathrooms
2 Powder rooms

KENNY HAMEL

Residential and Commercial Real Estate Broker

RE/MAX D'ABORD INC.

Main Floor
* Entrance Hall: Spacious and bright, featuring a majestic wood staircase.
* Living Room: Elegant relaxation area with wood-burning fireplace.
* Closed Office: Quiet and filled with natural light, ideal for working from home.
* Kitchen: Large and functional with central island, generous countertops, ample storage and high-end finishes.
* Dining Room: Abundant windows offering open views of nature.
* Rear Family Room: Large space with access to the terrace and backyard.
* Powder Room / Laundry Room: Integrated space with laundry chute and storage.
* Attached Double Heated Garage: Interior access, concrete floor, storage and side exterior door.

Upper Level
* Primary Bedroom: Luxurious suite with large walk-in closet and spa-style ensuite bathroom.
* Ensuite Bathroom: Freestanding tub, glass shower and high-end finishes.
* Bedroom 2: Spacious and bright with double closet.
* Bedroom 3: Good-sized bedroom with closet.
* Bedroom 4: With private bathroom and walk-in closet.

Basement
* Family Room: Huge multifunctional space (game room, home theatre or gym).
* Powder Room
* Mechanical Room: Geothermal system, water treatment and technical equipment.
* Storage: Very large.

Garages
* Attached double heated garage
* Detached double garage
* Single garage for pool equipment and storage

Exterior
* Private lot bordered by mature trees
* Private pond with illuminated fountain and waterfall
* Walking path with benches and hammocks
* Outdoor lounge area
* Heated in-ground pool
Year constructed 1998
Living area 3,565 ft²
Energy efficiency Novoclimat certification
Windows PVC
Window Type Casement
Siding Stone, Wood
Roofing Asphalt shingles
Garage Double width or more, Built-in, Detached, Attached, Heated, Single width
Washer/Dryer (installation) Powder room (RC)
Kitchen Cabinets Wood
Bathroom Whirlpool bath, Separate shower, Ensuite bathroom
Basement 6 feet and more, Finished basement
Lot size 442' 11" X 283' 7"
Lot area 2.88 ac
Water (access) Access (LAC)
Topography Flat
View View of the water
Distinctive Features No rear neighbours
Driveway Asphalt, Double width or more
Parking (total) Driveway (10), Garage (5)
Pool Heated, Inground
Proximity Hospital, Park, Bicycle path, Elementary school, Alpine skiing, Highway, Cross-country skiing, Snowmobile trail, ATV trail, University, High school, CEGEP, Daycare centre, Golf
Hall
Level: 1st level/Ground floor
Dimensions: 6'6" X 19'1" irr.
Flooring: Wood
Details:
Den
Level: 1st level/Ground floor
Dimensions: 19'1" X 14'3"
Flooring: Wood
Details:
Dining room
Level: 1st level/Ground floor
Dimensions: 18'4" X 11'9" irr.
Flooring: Wood
Details:
Kitchen
Level: 1st level/Ground floor
Dimensions: 18'5" X 15'5"
Flooring: Ceramic
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:
Office
Level: 1st level/Ground floor
Dimensions: 12'7" X 9'5" irr.
Flooring: Wood
Details:
Primary bedroom
Level: 2nd level
Dimensions: 23'9" X 21'8" irr.
Flooring: Wood
Details:
Bathroom
Level: 2nd level
Dimensions: 8'3" X 8'5" irr.
Flooring: Ceramic
Details:
Walk-in closet
Level: 2nd level
Dimensions: 13'11" X 5' irr.
Flooring: Wood
Details:
Bedroom
Level: 2nd level
Dimensions: 13'2" X 12'10"
Flooring: Wood
Details:
Bathroom
Level: 2nd level
Dimensions: 16'5" X 11'2" irr.
Flooring:
Details:
Bedroom
Level: 2nd level
Dimensions: 15'2" X 12'
Flooring: Wood
Details:
Bedroom
Level: 2nd level
Dimensions: 13'8" X 14' irr.
Flooring: Wood
Details:
Playroom
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:
Family 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:
Heating System Forced air
Energy efficiency Novoclimat certification
Heating Energy Electricity, Geothermal
Fireplace-Stove Wood fireplace
Property or unit amenity Air exchange system, Electric garage door opener, Outdoor storage space, Alarm system, Central heat pump, Fire detector (O), Central vacuum cleaner system installation, Water softener, Private balcony, Central air conditioning
Water Supply Artesian well
Sewage System Disposal field, Septic tank

Financial details

Municipal assessment (2026)

Lot assessment
$ 155,400
Building assessment
$ 892,000
Total
$ 1,047,400

Taxes

Municipal (2026)
$ 7,404
School (2025)
$ 641
Total
$ 8,045
Desjardins

Mortgage payment calculator

$
$
$
%

Learn more about this property's neighbourhood

The sector in a few statistics

What you need to know about real estate