The Next Generation
Blackmore Real Estate
Your Trusted Partner in Real Estate. Contact me at (780) 239-4489 for all your property needs.
138 25015 TWP ROAD 544A
Rural Sturgeon County
T8T 0B9
$2,300,000
Country Residential
beds: 5
baths: 6.0
3,147 sq. ft.
built: 2010
- Status:
- Active
- Prop. Type:
- Country Residential
- MLS® Num:
- E4483146
- Bedrooms:
- 5
- Bathrooms:
- 6
- Year Built:
- 2010
* Sold date and price are as reported on the RAE’s MLS® system
- Photos (67)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
Award-winning estate by Rimrock Elevations, showcasing exceptional design, craftsmanship & timeless luxury. Set on a beautifully landscaped 0.7 acre walkout lot with stamped concrete, this residence offers 5 bedrooms & 5 bathrooms, thoughtfully designed for both everyday living & elevated entertaining. The chef-inspired gourmet kitchen is complemented by a butler’s kitchen, while elegant dining & expansive living spaces feature soaring ceilings & natural light. The primary retreat is truly hotel-inspired, complete with a spa-like ensuite with steam shower & access to an expansive walk-in wardrobe room. Rich wenge wood finishes & in-floor heating add warmth & a refined modern aesthetic. The fully developed lower level is an entertainer’s dream with a stunning bar, wine room, media & recreation spaces, plus a dedicated office. Wellness is elevated with a private exercise room including sauna & steam shower. Double attached garages on either side (4 car+) & Control4 automation complete this exceptional home.
- Property Type:
- Country Residential
- Dwelling Type:
- Detached Single Family
- Home Style:
- Bungalow
- Total Floor Area:
- 3,146.86 sq. ft.
- Price Per SqFt:
- $730.89
- Total area above grade.:
- 3,147 sq. ft.
- Secondary Suite:
- No
- Second Residence:
- No
- Taxes:
- Signup
- Lot Area:
- 30,492 sq. ft.
- Lot Shape:
- Pie Shaped
- Grade Level Entry:
- No
- Levels:
- 2
- Year built:
- 2010 (Age: 16)
- Bedrooms:
- 5 (Above Grd: 3)
- Bathrooms:
- 6.0 (Full:4/Half:2)
- Total Rooms Above Grade:
- 6
- Plan:
- 0729512
- Building Type:
- Detached Single Family
- Exterior Finish:
- Acrylic Stucco, Stone
- Power Service:
- Paid For
- Heating Source Desc:
- Paid For
- Efficiency Rating:
- High - 92%+ Efficiency
- Construction:
- Wood
- Foundation:
- Concrete Perimeter
- Basement:
- Full, Finished
- Basement Development:
- Fully Finished
- Floor Finish:
- Carpet, Ceramic Tile
- Heating:
- Forced Air-2, In Floor Heat System, Natural Gas
- Fireplace:
- Yes
- Fireplace Fuel:
- Gas
- Fireplace Type:
- Double Sided, Stone Facing
- Parking:
- Heated, Over Sized, Quad or More Attached
- Enclosed Parking:
- 4
- Total Parking Spaces:
- 12
- Garage:
- Yes
- Ensuite:
- Yes
- Phone Desc:
- Paid
- Water Supply:
- Municipal
- Water Paid For:
- Paid For
- Sewer Septic:
- Municipal/Community
- Air Conditioner, Bar, Ceiling 9 ft., Deck, Exercise Room, Fire Pit, Hot Tub, No Smoking Home, Parking-Extra, Patio, Sauna; Swirlpool; Steam, Sprinkler Sys-Underground, Vaulted Ceiling, Walkout Basement, Wet Bar, HRV System, Natural Gas BBQ Hookup, Natural Gas Stove Hookup, 9 ft. Basement Ceiling
- Riverstone Pointe
- Cul-De-Sac, Fenced, Golf Nearby, Landscaped, Private Setting, Schools, Shopping Nearby
- Cul-De-Sac, Fenced, Golf Nearby, Landscaped, Private Setting, Schools, Shopping Nearby
- ensuite bathroom
- Air Conditioning-Central, Alarm/Security System, Dryer, Oven-Built-In, Oven-Microwave, Refrigerator, Stove-Countertop Gas, Stove-Gas, Washer, Water Softener, Window Coverings, Wine/Beverage Cooler, Dishwasher-Two, Garage Heater, Hot Tub
- None Known
- Private
- Floor
- Type
- Size
- Other
- Main
- Living Room
- 22'8" × 19'
- -
- Main
- Dining Room
- 14'5" × 13'8"
- -
- Main
- Kitchen
- 19'1¼" × 11'2"
- -
- Lower
- Family Room
- 24'4¾" × 20'10"
- -
- Main
- Master Bedroom
- 21'10" × 16'1¼"
- -
- Main
- Bedroom 2
- 12'6" × 12'
- -
- Main
- Bedroom 3
- 12'11" × 12'
- -
- Lower Level(s)
- Bedroom 4
- 13'2" × 12'7"
- -
- Lower Level(s)
- Bedroom
- 13'2" × 12'7"
- -
- Floor
- Ensuite
- Pieces
- Other
- Main
- No
- 2
- Main
- Yes
- 4
- Main
- Yes
- 7
- Lower Level(s)
- No
- 5
- Lower Level(s)
- No
- 3
- Lower Level(s)
- No
- 2
- Association Fee Frequency:
- Signup
- Association Fee Amount:
- Signup
- HOA Fee Includes:
- Amenities w/HOA
- Seller Rights Reserved:
- No
- Zone:
- Zone 60
- Zoning:
- Zone 60
- Title to Land:
- Fee Simple
- Legal Lot:
- 26
- Road Access:
- Paved
- LINC Number:
- 0032824260
- Days On Website:
- 1 day(s)
-
The property features an extensive driveway leading to a grand entrance, surrounded by landscaped grounds with mature evergreen trees and decorative plantings -
The property features a large circular driveway, a prominent front entrance, and a well-maintained exterior
-
The property features a stucco exterior, an attached garage, and a stamped concrete driveway
-
The main living area features high ceilings, smooth tile flooring, and an integrated fireplace
-
The property features a bright entryway with a high ceiling, large windows, and sleek tile flooring
-
The property features a high ceiling with recessed lighting and a decorative chandelier
-
Living area featuring expansive windows, recessed lighting, and a neutral wall color
-
This open concept living space features sleek tiled flooring, a modern kitchen with dark cabinetry and stainless steel appliances, and a dining area with contemporary lighting
-
The property features a staircase with glass panels and dark wood railing, and polished tile flooring
-
The open concept kitchen features dark wood cabinetry, stainless steel appliances, and a central island with counter seating
-
The dining area features a dark wood table with upholstered chairs, complemented by a large hanging light fixture
-
Gourmet kitchen with an expansive island featuring a dark granite countertop, pendant lighting, and contemporary cabinetry
-
The kitchen features dark wood cabinetry, a granite island with an undermount sink, and stainless steel appliances
-
Modern kitchen featuring sleek dark cabinetry, integrated stainless steel appliances, a large island with a granite countertop, and recessed lighting
-
Gourmet kitchen with stainless steel appliances, granite countertops, a tiled backsplash, and recessed lighting
-
The kitchen features dark wood cabinetry, granite countertops, a stainless steel gas range with a matching range hood, and a mosaic tile backsplash
-
The kitchen features dark wood cabinetry, granite countertops, and stainless steel appliances
-
The property features a dining area with dark flooring, light-colored walls, and a decorative ceiling fixture
-
Elegant dining area with a contemporary chandelier, recessed ceiling detail, and a dark wood dining table with seating
-
This property features a unique spiral staircase visible through a large window, complemented by a decorative spherical light fixture
-
This room features light-colored carpeting, a bay window with a view of trees, and a wall-mounted fireplace
-
Bedroom featuring light-colored carpet flooring, a large window with a view of snow-covered trees, and a bed with a dark comforter
-
This room features a large window with a view of snow-covered trees, a built-in fireplace, and a wet bar area with cabinetry and a compact refrigerator
-
This interior space features light grey carpet flooring and a built-in wet bar with dark wood cabinetry and a stainless steel appliance
-
Luxurious bathroom featuring a built-in bathtub, a walk-in shower with a glass door, and tiled flooring
-
The bathroom features a dual vanity with dark wood cabinetry, a granite countertop, and polished chrome fixtures
-
The bathroom features a built-in bathtub with polished chrome fixtures, set into a light-colored countertop
-
Shower with white tiled walls, a patterned mosaic tile accent wall, and a built-in bench with a dark countertop
-
Walk-in closet featuring carpeted floors, built-in shelving, a window with a blind, and a central island with drawers and a dark countertop
-
Well-appointed walk-in closet featuring extensive built-in shelving, a central island with drawers and a dark countertop, and a window providing natural light
-
Well-appointed bedroom featuring light gray walls, carpet flooring, and two tall windows providing natural light
-
This bathroom features a double vanity with dark wood cabinetry and a polished countertop
-
The bedroom features a window with a view of snow-covered trees, plush carpeting, and wainscoting along the lower walls
-
Hallway featuring extensive dark wood cabinetry, a granite countertop, and polished tile flooring
-
The kitchen features dark wood cabinetry, a mosaic tile backsplash, stainless steel appliances, and dark countertops
-
Laundry room featuring ample cabinetry, a tiled backsplash, and a window providing natural light
-
This powder room features a contemporary vanity with a dark countertop and cabinetry, a modern toilet, and an accent wall with patterned wallpaper
-
The property features a staircase with wooden railings and glass panels, a bar area with a stone countertop, a built-in television, and recessed lighting
-
The property features a well-appointed bar area with a large countertop, integrated shelving, and illuminated displays
-
This property features an entertainment space with extensive counter space, custom cabinetry, a built-in sink, and integrated shelving with accent lighting
-
Spacious room featuring light-colored carpet, recessed lighting, and large windows
-
This living area offers expansive windows, a fireplace with a stone-textured surround, and built-in shelving with integrated lighting
-
This inviting living space features light-colored carpeting, a dark accent ceiling with recessed lighting, and a prominent dark wood coffee table
-
This room features a built-in wine storage system with integrated cabinetry and two beverage refrigerators
-
The bathroom features a vanity with a dark granite countertop, a vessel sink, and an integrated mirror
-
This versatile space features tiled flooring, recessed lighting, and multiple windows providing natural light
-
Bathroom featuring a glass-enclosed shower with a tiled bench and a private sauna
-
This shower features white wall tiles accented with decorative mosaic tile bands, a built-in bench, and a clear glass shower door with a chrome handle
-
Spacious room featuring tile flooring, built-in shelving, extensive cabinetry with dark countertops, and a window providing natural light
-
This bedroom features neutral-toned walls, recessed lighting, and a window with a view of snow-covered trees
-
This room features neutral-toned walls, a large window with privacy blinds, and light-colored carpeting
-
Bathroom featuring a dual vanity with wood cabinetry, granite countertops, and two undermount sinks
-
Well-appointed garage with ample storage cabinetry, a durable speckled floor, and a window for natural light
-
The garage features extensive cabinetry with dark finishes, a light-colored speckled floor, and windows providing natural light
-
The property features an expansive covered patio with a stone-clad fireplace and large windows offering views of the surrounding trees
-
Expansive covered patio featuring a textured concrete floor, a beadboard ceiling, and sliding glass doors leading to the interior
-
The property features a multi-level rear exterior with extensive window placements, providing abundant natural light
-
The property features a covered patio with a textured concrete surface, supported by columns
-
The property features a multi-story exterior with a screened-in porch and numerous windows
-
The property features an extensive snow-covered yard with mature evergreen and deciduous trees, and a multi-level exterior with balconies
-
The property features extensive landscaping, including mature evergreen trees and various shrubs, with a pathway visible through the snowy ground
-
The property features a large exterior with numerous windows, a deck, and an expansive yard with mature trees and landscaping
-
Aerial view of the property and its surrounding neighborhood, featuring snow-covered rooftops and mature trees
-
This aerial view showcases a residential area with a variety of properties, all featuring snow-covered roofs
-
Aerial view showcasing a residential area with properties featuring snow-covered roofs and surrounding terrain
-
Floor plan
-
Floor plan
Courtesy of Robby Halabi of Rimrock Real Estate
Data was last updated April 20, 2026 at 05:30 AM (UTC)
Area Statistics
- Listings on market:
- 50
- Avg list price:
- $1,115,000
- Min list price:
- $189,000
- Max list price:
- $5,600,000
- Avg days in system:
- 29
- Min days in system:
- 1
- Max days in system:
- 566
- Avg price per sq.ft.:
- $480.03
These statistics are generated based on the current listing's property type
and located in
Rural Sturgeon County. Average values are
derived using median calculations. This data is not produced by
The Association's MLS® System.
- THE NEXT GENERATION
- Blackmore Real Estate
- (780) 239-4489
- Contact by Email
Quick Links
Contact Me
Kent: (780) 239-4489
{phone_2_label}: {phone_2}
kent@thenextgeneration.ca
Head Office
40-17 Boudreau Road
St. Albert, Alberta, T8N 7K5