C
B
  780-445-4080
Connect
C
B

Connie Barnes

Homes & Gardens Real Estate Limited

Forgot password Extend Verify Contact
Save search Hide filters
1-12/259

  • 46 KINGSFORD Crescent: St. Albert House for sale : MLS®# E4441001

    46 KINGSFORD Crescent St. Albert St. Albert T8N 7J2
    Main Photo: 46 KINGSFORD Crescent: St. Albert House for sale : MLS®# E4441001

    46 KINGSFORD Crescent St. Albert T8N 7J2 St. Albert

    $6,495,000
    Single Family
    Courtesy of Ron Dickson of Sotheby's International Realty Canada
    Status:
    Active
    MLS® Num:
    E4441001
    Bedrooms:
    7
    Bathrooms:
    8
    Floor Area:
    7,721 sq. ft.
    1of1. A bespoke version of grandeur as seen through the lens of the owners discerning eye. Each space artfully designed from the culinary kitchen to the hotel inspired Royalty suite. Masterfully orchestrated with opulence as every room tells its own story of extravagance. Soaring ceilings invite beaming sunshine that cascades from every angle. The spa and swimming pool were inspired for recreation, relaxation and exercise. Stargaze on the rooftop patio by the fire. Entertain your guests and family while enjoying the screened 4 season sunroom. The 3 car oversized garage above converts to full sports court. The 5 car parkade below is ready for your finest automobiles. No expense has been spared, and every detail has been attended to, ensuring an award winning standard of excellence. Engineered to the highest merit equivalent to high rise construction. RAM elevator for convenience accessible to garage. This palatial estate could never be duplicated at this price. This labour of love is truly 1of1! More details
    LISTING DETAILS
    CONNIE BARNES

  • 54230 RR 255: St. Albert House for sale : MLS®# E4419320

    54230 RR 255 St. Albert St. Albert T8T 0T6
    Main Photo: 54230 RR 255: St. Albert House for sale : MLS®# E4419320

    54230 RR 255 St. Albert T8T 0T6 St. Albert

    $3,999,900
    Single Family
    Courtesy of Nicholas J Golden of RE/MAX Professionals
    Status:
    Active
    MLS® Num:
    E4419320
    Bedrooms:
    1
    Bathrooms:
    2
    Floor Area:
    1,938 sq. ft.
    This is an exceptional opportunity for someone seeking a substantial parcel of land in St. Albert. Spanning 78.09 private acres, this prime property is located in northwest St. Albert, just 0.5 km north of the vibrant Nouveau subdivision. The property features two older homes and several outbuildings & older barn, adding functional versatility. The oldest home does need TLC. Key nearby amenities include Jensen Lakes, Costco, Hospital, Landmark Theatre, Walmart, etc. Quick access to HWY 2, 633, 37, Ray Gibbon & Anthony Henday. Currently, half the land is being farmed, while the other half is rented, creating immediate income potential. This city farm property is very private with lots of mature tress, perfect for building a new home and shop. Properties of this caliber and size are rarely available on the market. More details
    LISTING DETAILS
    CONNIE BARNES

  • 54318 RGE RD 255: St. Albert House for sale : MLS®# E4439271

    54318 RGE RD 255 St. Albert St. Albert T8T 0T8
    Main Photo: 54318 RGE RD 255: St. Albert House for sale : MLS®# E4439271

    54318 RGE RD 255 St. Albert T8T 0T8 St. Albert

    $3,500,000
    Single Family
    Courtesy of Matthew D Barry of Exp Realty
    Status:
    Active
    MLS® Num:
    E4439271
    Bedrooms:
    3
    Bathrooms:
    1
    Floor Area:
    2,055 sq. ft.
    Easy access to HWY 2, 633, 37, Ray Gibbon Drive & Anthony Henday! Nearby amenities include Costco, Sturgeon Hospital, Landmark Theatre, Walmart etc. Here is an amazing opportunity to own in the newly annexed lands on the north west side of St. Albert. Discover 71.66 acres that are currently farmed. This property is bordered on two sides by Carrot Creek. There are two homes, but this property is about location and proximity to St. Albert. One home is a 2054 sq ft two storey, built in 1934. Its homesite has a triple carport and numerous smaller out buildings. The second residence has some services shared with the original homesite, is 2266 sqft two storey with a triple attached garage. A great property to hold onto as St. Alberts development gets closer. More details
    LISTING DETAILS
    CONNIE BARNES

  • 54320 HWY 2: St. Albert House for sale : MLS®# E4439867

    54320 HWY 2 St. Albert St. Albert T8T 1T1
    Main Photo: 54320 HWY 2: St. Albert House for sale : MLS®# E4439867

    54320 HWY 2 St. Albert T8T 1T1 St. Albert

    $3,250,000
    Single Family
    Courtesy of Nicholas J Golden of RE/MAX Professionals
    Status:
    Active
    MLS® Num:
    E4439867
    Bedrooms:
    3
    Bathrooms:
    2
    Floor Area:
    2,197 sq. ft.
    Prime 40-Acre Development Opportunity on St. Albert Trail Exceptional chance to own 40 acres along the high-traffic St. Albert Trail corridor. This land is positioned for future Highway Commercial, Highway Retail, and Residential development, making it an ideal holding property with massive upside. Located directly across from St. Albert Dodge, this site is surrounded by major ongoing developments to the east and south. Property Highlights: 2,196 sq ft bungalow with triple attached drive-thru garage Heated barn and five shops, including a 72' x 150' structure with a fully contained 1-bedroom suite Flat, usable land with high visibility and direct access to a major arterial route Live comfortably now, develop later—or hold for long-term appreciation. Either way, this is a strategic investment in one of the fastest-growing regions around. More details
    LISTING DETAILS
    CONNIE BARNES

  • 54322 RGE RD 253: St. Albert House for sale : MLS®# E4443789

    54322 RGE RD 253 St. Albert St. Albert T8T 1R8
    Main Photo: 54322 RGE RD 253: St. Albert House for sale : MLS®# E4443789

    54322 RGE RD 253 St. Albert T8T 1R8 St. Albert

    $2,999,000
    Single Family
    Courtesy of Rainy Noyes of Royal Lepage Arteam Realty
    Status:
    Active
    MLS® Num:
    E4443789
    Bedrooms:
    3
    Bathrooms:
    3
    Floor Area:
    2,700 sq. ft.
    What! An acreage in the City!!?? You bet! A 2.47 acre parcel of annexed land, zoned Transitional w a 120x50 barndominium style structure newly built in 2021. Peaceful acreage living in the City or prefer a business venture? ... the possibilities are endless!! The building houses 2 living spaces, garage & shop. The main residence showcases 2000 sqft open concept, 9' ceilings, 2 primary suites one steps out to a west facing deck, 2-4 pce ensuites, huge kitchen, dining & living rms w big wrap around windows & south facing deck, laundry rm & 2 pce guest bath. The garage suite is 700 sqft, 9' ceilings, 1 bdrm, 4pce bath w/laundry, living areas & separate entry w deck. The 50x80 shop has 20' ceilings, 2 pce bath, 4-12x14 overhead doors, each bay w man door, ceiling fan, exhaust fan, h&c water, floor drains & window. 30x40 garage has 9' ceilings, 2-12x8 overhead drs, man door, exhaust fan & floor drains. Did I mention A/C & the entire slab is in-floor heat, f/a heat up, 6' chainlink fence & gated w coded entry. More details
    LISTING DETAILS
    CONNIE BARNES

  • 1039 200 BELLEROSE Drive: St. Albert Condo for sale : MLS®# E4438952

    1039 200 BELLEROSE Drive St. Albert St. Albert T8N 7P7
    Main Photo: 1039 200 BELLEROSE Drive: St. Albert Condo for sale : MLS®# E4438952

    1039 200 BELLEROSE Drive St. Albert T8N 7P7 St. Albert

    $1,999,900
    Condo
    Courtesy of Dan E Lepine of MaxWell Devonshire Realty
    Status:
    Active
    MLS® Num:
    E4438952
    Bedrooms:
    2
    Bathrooms:
    2
    Floor Area:
    2,528 sq. ft.
    Reduced over $250,000 for quick sale!! Incredible corner penthouse suite at Botanica!! Newly finished with premium upgrades throughout. Very open & bright, 2 primary bedrooms plus den design with 12' & 16' ceilings. Expansive window walls on 3 sides with 270 degree view. Dream kitchen includes extended island, quartz countertops, 48" fridge/freezer, 36" gas cooktop, double wall oven, microwave, unique walk-in pantry. Quality features include; durable plank flooring, porcelain tile, 2 linear style fireplaces, steam shower, soaker tubs, extra large den, 1,049 sq ft. on 2 balconies that have 2 gas BBQ hookups & water access. Botanica's well designed amenities include; spacious social hall, fitness facility, rooftop patio, guest suites, community garden etc. Only steps to boutique shopping, restaurants & professional services at the "Shops at Boudreau" featuring Mercato Italian Market. Here's your opportunity to own the finest executive penthouse ever built in St. Albert. More details
    LISTING DETAILS
    CONNIE BARNES

  • 8 JARDIN Place: St. Albert House for sale : MLS®# E4442360

    8 JARDIN Place St. Albert St. Albert T8N 8A2
    Main Photo: 8 JARDIN Place: St. Albert House for sale : MLS®# E4442360

    8 JARDIN Place St. Albert T8N 8A2 St. Albert

    $1,999,900
    Single Family
    Courtesy of Kent Clark of Blackmore Real Estate
    Status:
    Active
    MLS® Num:
    E4442360
    Bedrooms:
    4
    Bathrooms:
    4
    Floor Area:
    3,135 sq. ft.
    No you're not dreaming. This dream worthy home by Veneto Homes Ltd is real. And it is BEAUTIFUL! With over 4000 SQFT of fully finished living space it exudes luxury. From the vast front entry to the basement wet room every detail has been carefully crafted with the highest quality finishes and consideration for everyday life. Get work done from home in the front office and relax at the end of the day in the open main floor looking over Jensen Lake. Host the perfect parties in the island kitchen with top of the line appliances, additional bar and massive pantry. Retreat to the primary oasis boasting a breathtaking 5 pce en-suite + walk-in closet with dedicated laundry. Upstairs is the family paradise. A huge family room + a hidden room for the kids toys. 3 large bedrooms, 2 full baths, and finally enjoy the 2nd laundry set with a view of the lake. The basement is perfect for hosting lake days. A large wine cellar, wet bar and rec room. An additional bedroom + full bath round out this jaw-dropping home! More details
    LISTING DETAILS
    CONNIE BARNES

  • 11 JUBILATION Drive: St. Albert House for sale : MLS®# E4438590

    11 JUBILATION Drive St. Albert St. Albert T8N 7S3
    Main Photo: 11 JUBILATION Drive: St. Albert House for sale : MLS®# E4438590

    11 JUBILATION Drive St. Albert T8N 7S3 St. Albert

    $1,599,000
    Single Family
    Courtesy of Paul S Lamba of MaxWell Polaris
    Status:
    Active
    MLS® Num:
    E4438590
    Bedrooms:
    3
    Bathrooms:
    2
    Floor Area:
    3,347 sq. ft.
    Ever thought of owning a LAKEFRONT property? ONE-OF-A-KIND HOME in Jensen Lakes, with DUAL ROOFTOP DECKS OVERLOOKING THE LAKE. This estate home features the " Okanogan Style" floor plan, placing the main living spaces on the second floor. THE THIRD-STORY SHOWCASES A ROOFTOP DECK OVERLOOKING THE LAKE. It’s a MUST SEE! The main floor includes three spacious bedrooms, highlighted by a MAGNIFICENT PRIMARY SUITE with a custom headboard, COFFEE AND WINE BAR, TWO-SIDED FIREPLACE, CUSTOM CLOSET, AND A SPA-LIKE ENSUITE. Ascend to the second floor and be greeted by grand TWO-STORY CEILINGS, a chef’s dream kitchen, a butler’s pantry, and a wine cellar. The elegant floating staircase leads to the rooftop patio. SELLER FINANCING is available. Seller will also consider trade-ins! Located within walking distance to schools, the beach, the lake and shopping, this showstopper is a must-see! More details
    LISTING DETAILS
    CONNIE BARNES

  • 930 200 BELLEROSE Drive: St. Albert Condo for sale : MLS®# E4438817

    930 200 BELLEROSE Drive St. Albert St. Albert T8N 7P7
    Main Photo: 930 200 BELLEROSE Drive: St. Albert Condo for sale : MLS®# E4438817

    930 200 BELLEROSE Drive St. Albert T8N 7P7 St. Albert

    $1,574,000
    Condo
    Courtesy of Leslie Benson of RE/MAX Elite
    Status:
    Active
    MLS® Num:
    E4438817
    Bedrooms:
    2
    Bathrooms:
    2
    Floor Area:
    2,450 sq. ft.
    Botanica is LUXURY LIVING in the heart of St. Albert! Nestled on the Sturgeon River, this exclusive penthouse offers towering 14 ft ceilings 2 spacious bedrooms & den. Floor to ceiling windows, A/C, UPGRADES GALORE entertainers' paradise white DREAM kitchen featuring a large island w/quartz counters, pendant lighting & MIELE appliances Spacious, open social/living area w/fireplace & access to the STUNNING 1400 sq ft COVERED PATIO! There’s ample in-suite storage & 3 titled storage units PLUS A PRIVATE 2 car garage in the PARKADE. Upgraded vinyl plank flooring blankets the suite throughout. The primary bedroom features a huge walk-in closet & spa-like 5 pce ensuite w/INFLOOR heat, dual sinks, soaker tub, steam shower & insuite laundry. Amenities include a 2-story fitness area, social hall & lounges, an amazing ROOFTOP TERRACE & guest suite. Located steps away from the Shops of Boudreau & the river walk trail system. This penthouse is sure to impress, its the epitome of luxurious & sophisticated living. More details
    LISTING DETAILS
    CONNIE BARNES

  • 49 JUBILATION Drive: St. Albert House for sale : MLS®# E4438822

    49 JUBILATION Drive St. Albert St. Albert T8N 7W7
    Main Photo: 49 JUBILATION Drive: St. Albert House for sale : MLS®# E4438822

    49 JUBILATION Drive St. Albert T8N 7W7 St. Albert

    $1,499,900
    Single Family
    Courtesy of Frederick E Trommeshauser of RE/MAX PREFERRED CHOICE
    Status:
    Active
    MLS® Num:
    E4438822
    Bedrooms:
    4
    Bathrooms:
    3
    Floor Area:
    3,291 sq. ft.
    Brand new Urbis masterpiece! The open foyer welcomes you to this opulent air conditioned 2 story that offers almost 4400 sqft of lake-house style living. Dedicated 4 bedrooms can be extended to 5 if needed. Amazing kitchen offers 9' island, Miele appliances, walkthrough pantry w/2nd fridge, large dinette and all this anchors the living room with stone f/p and wood beams. The main floor also features a home office, powder room, access to the large rear deck and a mudroom that takes you to the triple heated garage! Upstairs is home to the vaulted primary suite which is massive and complemented with a 5 piece ensuite & w/i closet. Two more bedrooms, 5 piece bathroom, laundry room and bonus room round out this level. Fully finished basement provides a rec/family area with f/p and bar. You will also enjoy another bedroom, exercise room with windows and mirrors, 4 piece bathroom and generous basement storage. This home is close to the lake/beach. Some photos are virtually staged. More details
    LISTING DETAILS
    CONNIE BARNES

  • 30 Kingsmeade Crescent: St. Albert House for sale : MLS®# E4441878

    30 Kingsmeade Crescent St. Albert St. Albert T8N 4C8
    Main Photo: 30 Kingsmeade Crescent: St. Albert House for sale : MLS®# E4441878

    30 Kingsmeade Crescent St. Albert T8N 4C8 St. Albert

    $1,290,000
    Single Family
    Courtesy of Aman Powar-Grewal of Royal Lepage Arteam Realty
    Status:
    Active
    MLS® Num:
    E4441878
    Bedrooms:
    5
    Bathrooms:
    4
    Floor Area:
    3,537 sq. ft.
    Located in the prestigious Regency Heights Estates of Kingswood, this exceptional custom built home was designed, built, and lived in by a highly respected home builder. Inside & out, this home reflects excellence, with premium materials, thoughtful layout, and timeless design. Walk in and you’ll notice the difference: soaring ceilings, hand-picked finishes, and a floor plan that balances open-concept living with family-focused functionality. The chef's kitchen features custom cabinetry, professional-grade appliances, and walk-thru pantry. The primary suite is a private retreat with a spa like bath, steam shower & heated flooring. Three additional bedrooms and two more bathrooms complete the upper level. The fully finished basement is designed as a perfect secondary space, featuring an additional bedroom, bathroom, bar and gym. This corner lot features triple garage, LED holiday lighting and professionally landscaped outdoor space. This is not just a house - it’s the personal residence of a craftsman. More details
    LISTING DETAILS
    CONNIE BARNES

  • 8 Loiselle Way: St. Albert House for sale : MLS®# E4433542

    8 Loiselle Way St. Albert St. Albert T8N 2P3
    Main Photo: 8 Loiselle Way: St. Albert House for sale : MLS®# E4433542

    8 Loiselle Way St. Albert T8N 2P3 St. Albert

    $1,275,000
    Single Family
    Courtesy of Amritpal Saul of RE/MAX Real Estate
    Status:
    Active
    MLS® Num:
    E4433542
    Bedrooms:
    5
    Bathrooms:
    5
    Floor Area:
    3,486 sq. ft.
    A stunning estate home with triple garage and walkout basement offering 4900 sqft (approx) of beautifully finished living space in the highly sought-after community of Lacombe Park in St. Albert. This elegant two-storey features 5 full-sized bedrooms, 5 full bathrooms, blending timeless traditional finishes. Stepping in, you’re greeted by open-to-above ceilings. The massive kitchen is a chef’s dream, outfitted with sleek modern cabinetry and all brand-new high-end appliances. On the main floor, you’ll find a full bedroom and full bathroom—perfect for guests or multi-generational living—as well as a separate family room. The fully finished walkout basement extends your living space with a state-of-the-art theatre room, a stylish wet bar, and warm in-floor heating throughout. New furnace, tankless water heater, central AC and a water softener system included. Don’t miss this rare opportunity to own a refined walkout home in one of St. Albert’s most desirable communities. More details
    LISTING DETAILS
    CONNIE BARNES
1-12/259
 <  123...22  > 
Data was last updated July 20, 2025 at 07:30 AM (UTC)
Copyright 2025 by the REALTORS® Association of Edmonton. All Rights Reserved. Data is deemed reliable but is not guaranteed accurate by the REALTORS® Association of Edmonton.
The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.
Data last updated on July 20, 2025 at 07:30 AM (UTC).
Copyright 2025 by the REALTORS® Association of Edmonton. All Rights Reserved.
Data is deemed reliable but is not guaranteed accurate by the REALTORS® Association of Edmonton.
The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.