Talahantasrealtor.com Search Results

Courtesy of Kelly L Grant of MaxWell Polaris.

* NEW LISTING * LUXURY MANSION IN RIVERSTONE POINTE, A NEWLY-BUILT 5200+ sq. ft. 2-Storey Walkout! Meticulous Superior Finishes: * Grand Entrance Double-Height Foyer, Statement Chandelier, & Travertine Fireplace * Custom Forge 53 Metal Railing & French Doors * Curated Gallery * 3-Floor Elevator * Chef's & Butlers' Kitchens * Miele (et al.) Appliances * Italian Island Waterfall Countertop * Soundproof Office + LED Cabinetry * Heated Tiles, plus Oak-Eng. Floors & Marble Floors * Remote Window Blinds * White Marble Vanities * 2000+ sq. ft. Balcony Deck + Upper Level Terrace (Valley & City Views) * His & Her Walk-in Closets * Premium Brizo & Riobel Fixtures * Triple-Glazed Floor-Ceiling Windows + Black-Clad Finish * Lower Level: Gym, Studio, Game Area, Theatre, & Cigar / Wine Room * Guest Suite + Nanny Suite * Integrated Audio & Visual Intercom * 2 A/C Units * TELSCO Alarm Security: 360° PTZ & 14 Extra Cameras * 1600+ sq. ft. Heated Garage Space (E & W Wings with 2 EV Chargers) * Large Driveway & 0.75 Acres!!

7 Beds ⋅ 7 Baths ⋅ E4500222 MLS® # ⋅ Kelly L Grant

* NEW LISTING * LUXURY MANSION IN RIVERSTONE POINTE, A NEWLY-BUILT 5200+ sq. ft. 2-Storey Walkout! Meticulous Superior Finishes: * Grand Entrance Double-Height Foyer, Statement Chandelier, & Travertine Fireplace * Custom Forge 53 Metal Railing & French Doors * Curated Gallery * 3-Floor Elevator * Chef's & Butlers' Kitchens * Miele (et al.) Appliances * Italian Island Waterfall Countertop * Soundproof Office + LED Cabinetry * Heated Tiles, plus Oak-Eng. Floors & Marble Floors * Remote Window Blinds * White Marble Vanities * 2000+ sq. ft. Balcony Deck + Upper Level Terrace (Valley & City Views) * His & Her Walk-in Closets * Premium Brizo & Riobel Fixtures * Triple-Glazed Floor-Ceiling Windows + Black-Clad Finish * Lower Level: Gym, Studio, Game Area, Theatre, & Cigar / Wine Room * Guest Suite + Nanny Suite * Integrated Audio & Visual Intercom * 2 A/C Units * TELSCO Alarm Security: 360° PTZ & 14 Extra Cameras * 1600+ sq. ft. Heated Garage Space (E & W Wings with 2 EV Chargers) * Large Driveway & 0.75 Acres!!

25015 Twp Road 544a Unit 136, Rural Sturgeon County

Courtesy of Nadia Osman of RE/MAX Elite.

$2,999,000

Welcome to this extraordinary, custom built bungalow in the prestigious Riverstone community of Sturgeon County minutes away from St Albert set on a professionally landscape 1 acre lot with a stunning waterfall this exceptional estate offers over 6900 ft.² of beautiful finished living space . Designed with on uncompromising quality, the home features 5 bedrooms, 10 bathrooms, handcrafted plaster ceiling by Vegas artisan exquisite, custom woodwork, 5 fireplaces, hand-scraped hardwood flooring, limestone & slate finishing, spacious walk-in closets all custom done, a four season sunroom. Adding to this unique appeal, this remarkable residence served as a filming location for a movie featuring Alan Thicke. Incredible garage is designed for automobiles enthusiast completed with vehicle lifts and floor drains with its own sump pump, even a suspended card table that comes out of the ceiling. Built to a standard that would be extraordinarily expensive to reproduce today . Don't miss out!!!!

4 Beds ⋅ 8 Baths ⋅ E4496944 MLS® # ⋅ Nadia Osman

Welcome to this extraordinary, custom built bungalow in the prestigious Riverstone community of Sturgeon County minutes away from St Albert set on a professionally landscape 1 acre lot with a stunning waterfall this exceptional estate offers over 6900 ft.² of beautiful finished living space . Designed with on uncompromising quality, the home features 5 bedrooms, 10 bathrooms, handcrafted plaster ceiling by Vegas artisan exquisite, custom woodwork, 5 fireplaces, hand-scraped hardwood flooring, limestone & slate finishing, spacious walk-in closets all custom done, a four season sunroom. Adding to this unique appeal, this remarkable residence served as a filming location for a movie featuring Alan Thicke. Incredible garage is designed for automobiles enthusiast completed with vehicle lifts and floor drains with its own sump pump, even a suspended card table that comes out of the ceiling. Built to a standard that would be extraordinarily expensive to reproduce today . Don't miss out!!!!

25015 Twp Road 544a Unit 106, Rural Sturgeon County

Courtesy of Sam Elias of RE/MAX Professionals.

$2,490,000

Prepare to be amazed by this extraordinary, fully renovated walkout bungalow set in prestigious Sturgeon County—an estate that blends luxury with exceptional craftsmanship. Featuring 5 bedrooms and 6 bathrooms, every upstairs bedroom offers its own private ensuite, creating an unmatched level of comfort and privacy. The massive chef’s kitchen showcases a grand island, brand-new appliances, and exquisite finishes illuminated by new windows. In-floor heating throughout. Step outside to an enormous backyard oasis complete with a sparkling swimming pool, elegant gazebo, and a giant storage shed. A huge, professionally built shop adds remarkable versatility with full RV parking, an upper-level bathroom, and a dedicated office area. The walkout basement impresses with a massive rec room, private gym, and abundant storage. Extravagant touches, modern style, and meticulous detailing define this one-of-a-kind property—an exceptional opportunity to own a home that truly stands apart in both beauty and function.

5 Beds ⋅ 5 Baths ⋅ E4509868 MLS® # ⋅ Sam Elias

Prepare to be amazed by this extraordinary, fully renovated walkout bungalow set in prestigious Sturgeon County—an estate that blends luxury with exceptional craftsmanship. Featuring 5 bedrooms and 6 bathrooms, every upstairs bedroom offers its own private ensuite, creating an unmatched level of comfort and privacy. The massive chef’s kitchen showcases a grand island, brand-new appliances, and exquisite finishes illuminated by new windows. In-floor heating throughout. Step outside to an enormous backyard oasis complete with a sparkling swimming pool, elegant gazebo, and a giant storage shed. A huge, professionally built shop adds remarkable versatility with full RV parking, an upper-level bathroom, and a dedicated office area. The walkout basement impresses with a massive rec room, private gym, and abundant storage. Extravagant touches, modern style, and meticulous detailing define this one-of-a-kind property—an exceptional opportunity to own a home that truly stands apart in both beauty and function.

185 Riverstone Drive, Rural Sturgeon County

Courtesy of Michael Pino of RE/MAX Elite.

$2,174,000

This thoughtfully designed home showcases clean lines and REFINED STYLE across 4,875 sqft of finished living space. Featuring plenty of windows for natural light, durable wood-look tile flooring, central A/C, 6 bedrooms, & 4.5 baths. The well-appointed kitchen is a dream for culinary enthusiasts, offering ample cabinetry, quartz countertops, induction cooktop, Sub-Zero fridge & freezer, walk-in pantry, & wine storage. The dining area easily accommodates large gatherings, while the elegant living room is anchored by a cozy fireplace. Upstairs, enjoy built-in workstations & a luxurious primary suite with a 5pc ensuite & a connected screened-in HOT TUB RETREAT. The fully finished basement includes 2 bedrooms, 3pc bath, spacious family & recreation room, wet bar, & in-floor heating. The QUAD garage comes complete with a pet bath, built in storage, drain, & heated floors. Set on 0.52 acres of beautifully landscaped grounds with a charming covered rear deck, this home is a true masterpiece!

6 Beds ⋅ 5 Baths ⋅ E4502480 MLS® # ⋅ Michael Pino

This thoughtfully designed home showcases clean lines and REFINED STYLE across 4,875 sqft of finished living space. Featuring plenty of windows for natural light, durable wood-look tile flooring, central A/C, 6 bedrooms, & 4.5 baths. The well-appointed kitchen is a dream for culinary enthusiasts, offering ample cabinetry, quartz countertops, induction cooktop, Sub-Zero fridge & freezer, walk-in pantry, & wine storage. The dining area easily accommodates large gatherings, while the elegant living room is anchored by a cozy fireplace. Upstairs, enjoy built-in workstations & a luxurious primary suite with a 5pc ensuite & a connected screened-in HOT TUB RETREAT. The fully finished basement includes 2 bedrooms, 3pc bath, spacious family & recreation room, wet bar, & in-floor heating. The QUAD garage comes complete with a pet bath, built in storage, drain, & heated floors. Set on 0.52 acres of beautifully landscaped grounds with a charming covered rear deck, this home is a true masterpiece!

25015 Twp Road 544a, Rural Sturgeon County

Courtesy of Sharon C Ryan of RE/MAX Elite.

$1,599,000

Gorgeous walk-out bungalow backing onto trails and environmental reserve leading to river, this extraordinary 0.54-acre property offers over 2,400 sq. ft. of meticulously designed living space with breathtaking views of nature from every level. Designed for year-round comfort, the home features in-floor heating throughout every level, including the heated quad garage. The chef-inspired kitchen is beautifully appointed with rich cherry cabinetry, wall ovens, stainless steel gas range, oversized island with eating bar, and workspace for entertaining. The adj living and dining areas are framed by extensive windows capturing the stunning landscape, w. gas fireplace. The luxurious primary suite offers a spa-inspired 6-piece ensuite. Private bonus room/bedroom above garage. Walkout basement has in-floor heating, 3 bedrooms, rec. area, and wet bar. Quad garage is heated. RV parking directly on property.

4 Beds ⋅ 3 Baths ⋅ E4494061 MLS® # ⋅ Sharon C Ryan

Gorgeous walk-out bungalow backing onto trails and environmental reserve leading to river, this extraordinary 0.54-acre property offers over 2,400 sq. ft. of meticulously designed living space with breathtaking views of nature from every level. Designed for year-round comfort, the home features in-floor heating throughout every level, including the heated quad garage. The chef-inspired kitchen is beautifully appointed with rich cherry cabinetry, wall ovens, stainless steel gas range, oversized island with eating bar, and workspace for entertaining. The adj living and dining areas are framed by extensive windows capturing the stunning landscape, w. gas fireplace. The luxurious primary suite offers a spa-inspired 6-piece ensuite. Private bonus room/bedroom above garage. Walkout basement has in-floor heating, 3 bedrooms, rec. area, and wet bar. Quad garage is heated. RV parking directly on property.

25015 Twp Road 544a Unit 161, Rural Sturgeon County