Office Listings
-
18 ELDER Crescent in Ancaster: Single Family for sale : MLS®# 40819157
18 ELDER Crescent Ancaster L0R 1R0 
$3,495,000Single Family- Status:
- Active
- MLS® Num:
- 40819157
- Bedrooms:
- 5
- Bathrooms:
- 6
- Floor Area:
- 6,875 sq. ft.
Experience unparalleled luxury in this fully renovated, nearly 7,000 sqft custom-designed executive home on a stunning 2.5-acre property in one of Ancaster's most exclusive enclaves. Surrounded by nature yet minutes from city conveniences, this home blends upscale living with serene privacy-you have to see it to believe it. New stone walkways and lush greenery create exceptional curb appeal. Inside, every detail has been meticulously crafted to maximize space and functionality. Upon entering, you're immediately captivated by the grand 'Scarlett O'Hara' staircase. The main level boasts formal living and dining areas, a private office, and two powder rooms. The spacious custom laundry/mudroom features garage access and a second staircase to the basement. The elegant family room is a true focal point, with a Valor gas fireplace and a stone feature wall. The gourmet eat-in kitchen is equipped with top-of-the-line appliances, custom cabinetry, granite countertops, and stone accents. Rich hardwood, marble tiles, and high-end fixtures flow throughout. Upstairs, the primary suite is a private oasis featuring a spa-inspired 5-piece ensuite with a curbless glass shower and a deep soaker tub, as well as an expansive walk-in dressing room with custom built-ins. Three additional bedrooms and two beautifully updated baths complete the upper level. The newly renovated walkout basement is the ultimate entertainment hub, offering a fifth bedroom, full bathroom, and a stylish kitchenette or wet bar. Relax in the media area with a Valor fireplace or workout in the state-of-the-art gym. Step outside to a private patio with a hot tub-perfect for unwinding in nature. This level also offers excellent in-law suite potential. Outside, serene ponds and breathtaking views create a peaceful, cottage-like atmosphere. A multi-tiered deck extends the home's living space, ideal for dining and entertaining. The expansive yard completes this one-of-a-kind luxury retreat. (id:2493) More detailsListed by Royal LePage State Realty Inc.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
2060 LAKESHORE Road Unit# 308 in Burlington: Condo for sale : MLS®# 40821646
2060 LAKESHORE Road Unit# 308 Burlington L7R 0G2
$3,299,000Single Family- Status:
- Active
- MLS® Num:
- 40821646
- Bedrooms:
- 3
- Bathrooms:
- 3
- Floor Area:
- 2,200 sq. ft.
Luxury Waterfront Living in the Heart of Downtown Burlington at the prestigious Bridgewater Residences — where timeless elegance meets lakeside tranquility. Spanning 2,200 square feet of refined living space, plus an expansive 725+ square foot private wrap-around terrace, this southeast-facing corner suite offers breathtaking, unobstructed views of Lake Ontario. Designed with meticulous attention to detail, this 2- bedroom plus den, 3-bathroom residence is rich with luxury upgrades and sophisticated design elements. Soaring floor-to-ceiling windows flood the space with natural light, while the open-concept layout features a gas fireplace and a spectacular gourmet kitchen equipped with premium Thermador appliances, a generous granite island, and custom cabinetry — ideal for both everyday living and entertaining. The hotel-inspired primary suite is a true retreat, complete with terrace access, panoramic lake views, a spacious walk-in closet, and a spa-like ensuite featuring an oversized glass shower and elegant finishes. A second bedroom with ensuite and a separate den/home office (easily adaptable as a third bedroom) ensure flexibility and privacy for guests or family. A dedicated laundry room and a stylish powder room round out the suite’s thoughtful layout. Step outside to your private terrace and take in the serenity of waterfront living — the perfect backdrop for morning coffee, summer dining, or evening relaxation. As a Bridgewater resident, enjoy access to resort-style amenities, including a rooftop terrace, party lounge, fitness centre, piano room, and VIP privileges at The Pearle Hotel & Spa, featuring a second gym and a luxurious indoor pool. This rare offering also includes two premium accessible parking spaces next to the elevator, as well as a private storage locker. Experience the best of Downtown Burlington — just steps to the Waterfront Trail, Spencer Smith Park, the Pier, and a vibrant mix of boutique shopping, fine dining, and cultural attractions (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
100 WATERSHORE Drive Unit# 19 in Stoney Creek: House for sale : MLS®# 40798532
100 WATERSHORE Drive Unit# 19 Stoney Creek L8E 0C1
$3,100,000Single Family- Status:
- Active
- MLS® Num:
- 40798532
- Bedrooms:
- 3
- Bathrooms:
- 3
- Floor Area:
- 2,841 sq. ft.
Rare Lakefront Bungalow on the Shores of Lake Ontario in this Project of the Year award-winning community- Residences at Watershore! A truly exceptional opportunity- an exquisite 2,841 sq.ft. bungalow positioned along the sparkling shoreline offering breathtaking views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island- ideal for both casual meals and upscale entertaining. As a purchaser, you'll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home's living and dining areas, centered around a 46 gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer- a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
875 SAFARI Road in Hamilton: Single Family for sale : MLS®# 40824943
875 SAFARI Road Hamilton L0R 1V0
$2,899,900Single Family- Status:
- Active
- MLS® Num:
- 40824943
- Bedrooms:
- 6
- Bathrooms:
- 2
- Floor Area:
- 3,548 sq. ft.
WELCOME TO 875 SAFARI ROAD! Lovingly maintained by its current owners for 47 years, this property—with 48.25 total acres, 37 of which are farmable, feels like home. Less than 5 minutes to Highway 6, with access to Waterdown Village, 403, 401 and Aldershot GO. A beautiful pond welcomes you at the entrance, leading to a large parking area and finally the 300+ ft long multipurpose barn for all your equipment and toys. This is a truly rare property with endless income-generation possibilities. Notable features include 3 fireplaces, 2 sump pumps, 2 wells, large above ground pool. Roof, windows, air conditioning and furnace replaced in 2020. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
875 SAFARI Road in Hamilton: Agriculture for sale : MLS®# 40824923
875 SAFARI Road Hamilton L8B 1S9
$2,899,900Agriculture- Status:
- Active
- MLS® Num:
- 40824923
- Bedrooms:
- 6
- Bathrooms:
- 2
- Floor Area:
- 2,338 sq. ft.
WELCOME TO 875 SAFARI ROAD! Lovingly maintained by its current owners for 47 years, this property—with 48.25 total acres, 37 of which are farmable, feels like home. Less than 5 minutes to Highway 6, with access to Waterdown Village, 403, 401 and Aldershot GO. A beautiful pond welcomes you at the entrance, leading to a large parking area and finally the 300+ ft long multipurpose barn for all your equipment and toys. This is a truly rare property with endless income-generation possibilities. Notable features include 3 fireplaces, 2 sump pumps, 2 wells, large above ground pool. Roof, windows, air conditioning and furnace replaced in 2020. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
906 MAIN Street W in Hamilton: Vacant Land for sale : MLS®# 40774074
906 MAIN Street W Hamilton L8S 4P9
$2,699,900Vacant Land- Status:
- Active
- MLS® Num:
- 40774074
For Developers, Investors , Builders. Site Plan Conditionally approved. Zoning is TOC1 Exception 310. Highly visible and trafficked location in close proximity to McMaster innovation Park and University, Hamilton Health Sciences (Children's pediatric hospital), Columbia International College. Close to hwy 403 access, future LRT, Westdale Village and minutes to downtown Hamilton. Close to parks, conservation areas, pubic and private elementary and secondary schools, religious institutions, public transportation, dining, shopping and entertainment areas. Properties include 906 Main St W and 122 Longwood Rd S which are automatically merged and must be purchased and completed simultaneously. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
5 UNDERCLIFFE Avenue in Hamilton: Single Family for sale : MLS®# 40827274
5 UNDERCLIFFE Avenue Hamilton L8P 3G9
$2,595,000Single Family- Status:
- Active
- MLS® Num:
- 40827274
- Bedrooms:
- 6
- Bathrooms:
- 6
- Floor Area:
- 5,058 sq. ft.
Nestled beneath the escarpment in Hamilton’s prestigious Durand neighbourhood, this stately Georgian Revival residence offers a rare opportunity to own a piece of architectural and cultural history. Built in 1924 by the Levy family, this distinguished home was once owned by philanthropist and art collector Herman H. Levy, whose notable collections were later donated to McMaster University and the Royal Ontario Museum. Offering over 5,000 sq. ft. of living space with ample room for both comfortable family-living and elegant entertaining, the home blends timeless character with thoughtful updates. A classic centre hall layout and 9-foot ceilings create an elegant flow throughout the main level, complemented by original millwork, detailed mouldings, and three fireplaces. The walnut library provides a warm and refined retreat, while the updated kitchen features granite counters, a large island, quality appliances, and a secondary staircase that reflects the original design. The second level offers four spacious bedrooms, each with ensuite access. The primary dressing area includes original built-ins, a vintage ironing board, and a discreetly integrated safe installed by the Levy family. The third floor adds flexibility with two additional bedrooms, a full bathroom, and a separate living area ideal for a nanny suite, multigenerational living or a private workspace. The lower level includes a laundry area with original cedar chute servicing all levels, a workshop, bathroom, walk-in safe or wine cellar, and interior access to the heated garage. Additional features include a slate roof, copper downspouts, central vacuum, EV charging station, and zoned heating and cooling. Set on a private, tree-lined lot, the backyard features a heated saltwater pool, year-round hot tub, and covered porch, offering a quiet setting for relaxation and entertaining. Located close to parks, schools, hospitals, the Bruce Trail, downtown amenities, and Highway 403, this is a truly rare offering. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
2047 ARDLEIGH Road in Oakville: Single Family for sale : MLS®# 40812242
2047 ARDLEIGH Road Oakville L6J 1V6
$2,549,000Single Family- Status:
- Active
- MLS® Num:
- 40812242
- Bedrooms:
- 4
- Bathrooms:
- 2
- Floor Area:
- 2,640 sq. ft.
Residing on a mature, landscaped lot in Oakville with tree-lined streets creates a gorgeous setting for this lovely 3+1 bedroom bungalow where there are green views from every window. This home provides both a private, tranquil setting and great entertaining spaces. There is a covered porch off the back of the house where views of trees and greenery can be enjoyed. A large, stone patio area hosts an L-shaped pergola framing a sitting or dining area and surrounds the in-ground pool. Centrally located within highly desirable, prestigious Eastlake community of southeast Oakville, this location makes it ideal for accessing both the lake and the area's top amenities and schools. The large, gourmet kitchen has an island breakfast bar and a large window with a view of a Japanese Maple tree. Three bay windows offer a warm, inviting ambience; two in bedrooms and one in the dining room. The basement has in-law suite potential as there is a storage area under the kitchen that sides onto the bathroom, and there is separate entrance potential. Situated close to the town's most valuable amenities, there is top-tier education, lakeside leisure with green spaces and close proximity to the waterfront including Gairloch Gardens and scenic Lake Ontario trails. For convenience and community, enjoy a short drive to vibrant shops, gourmet restaurants, and cultural attractions of historic downtown Oakville. Maple Grove Village offers excellent shopping and services. Come and see all that this area and home have to offer! (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
34 HARRINGTON Place in Ancaster: Single Family for sale : MLS®# 40819695
34 HARRINGTON Place Ancaster L9G 4Z2
$2,495,000Single Family- Status:
- Active
- MLS® Num:
- 40819695
- Bedrooms:
- 4
- Bathrooms:
- 4
- Floor Area:
- 4,886 sq. ft.
Located on a quiet court in Ancaster’s prestigious Oakhill neighbourhood, 34 Harrington Place is a one-of-a-kind bungaloft designed for elegant living and unforgettable entertaining. Set on a pie-shaped, nearly half-acre lot with an impressive 217 ft across the rear, this custom-built Atherton home is surrounded by estate properties and award-winning Trillium gardens that elevate the curb appeal and outdoor experience. Boasting almost 5,000 sqft of impeccably finished living space, this home offers 3+1 bedrooms, 4 full baths, and a layout that perfectly blends everyday comfort with timeless sophistication. The main floor features a gourmet eat-in kitchen with custom cabinetry, cathedral ceiling, and access to a covered porch, flowing into a striking 12-ft great room with gas fireplace and floor-to-ceiling windows overlooking the oasis backyard. A formal dining room provides the ideal setting for hosting family gatherings and elegant dinner parties. The luxurious main-floor primary suite includes a cozy gas fireplace, an oversized walk-in dressing room, and a 5-pc spa-inspired ensuite. Also on the main level: a large private office, a full laundry room, and a stylish guest bath with direct outdoor access—perfect for rinsing off after a dip in the custom-designed hot and cold soaker pool spa or post-garden clean-up. Upstairs, two well-appointed bedrooms, a full bath, and a versatile loft area offer space for teens, guests, or a second home office. The bright walk-out basement features a 3-sided gas fireplace, spacious recreation room, kitchenette/bar, 4th bedroom, full spa bath, gym area, and abundant storage—ideal for in-laws or extended family.The backyard is a showstopper: private, lush, and tailored for gatherings large or small. Multiple seating and dining areas, a covered porch, and the signature pool spa create an outdoor sanctuary you’ll enjoy in every season. This is more than a home—it’s a statement of lifestyle in one of Ancaster’s most exclusive enclaves (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
102 CUMMING Court in Ancaster: Single Family for sale : MLS®# 40827830
102 CUMMING Court Ancaster L9G 1V3
$2,495,000Single Family- Status:
- Active
- MLS® Num:
- 40827830
- Bedrooms:
- 6
- Bathrooms:
- 6
- Floor Area:
- 5,780 sq. ft.
Crafted with exceptional attention to detail and completed in 2025 (Tarion warranty), this custom two-storey luxury home offers nearly 6,000 sqft. of finished living, 5+1 bedrooms, OR 6 total baths, and a contemporary transitional design blending sophistication with family-friendly functionality. Situated on a 75 x 105 ft lot in Ancaster's Nakoma neighbourhood, it features striking curb appeal with a stone-and-stucco exterior and a 2.5-car triple tandem garage. Inside, soaring 9 ft ceilings on all three levels, wide-plank white oak hardwood, 8 ft solid core doors, 9 baseboards, and oversized windows create a sense of grandeur. The 19-ft great room showcases floor-to-ceiling windows and a 42 gas fireplace flanked by custom cabinetry. A main-floor office with built-ins, formal dining room, and powder room provide elegant, purposeful spaces, while the dining table converts into a pool table for dual-purpose entertaining. The gourmet kitchen features black cabinetry, a 9' x 5' waterfall quartz island, full-slab quartz backsplash, champagne and honey bronze fixtures, Bertazzoni appliances, and a walk-in pantry and servery with black stainless-steel sink. Adjacent are the mudroom/laundry with garage entry and a main-level bedroom with ensuite. Upstairs, four bedrooms each have ensuite access, including a primary retreat with 10 ft tray ceiling, oversized walk-in closet, linear fireplace, and spa-inspired 5-piece ensuite with heated floors. The finished lower level offers 9 ft ceilings, oversized windows, sixth bedroom, full bathroom, linear fireplace, and endless possibilities. Additional features include radon mitigation, 200-amp service, hardwired security system, and DryCore subfloor. Outside, the back patio provides a starting point for a dream outdoor space, with a pre-approved building permit for an in-ground pool and gas lines for BBQ. Centrally located, this home offers walkability to schools, parks, shops, and quick access to Hwy 403. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
4558 LAKESIDE Drive in Beamsville: Vacant Land for sale : MLS®# 40798992
4558 LAKESIDE Drive Beamsville L0R 1B1
$2,490,000Vacant Land- Status:
- Active
- MLS® Num:
- 40798992
BUILD YOUR LEGACY: A LUXURY DREAM ESTATE HOME or ESTATE WINERY ON LAKE ONTARIO. With 350 ft. of unrivaled Lake Ontario views set on 10.48 acres backing onto a vineyard and winery. Welcome to 4558 Lakeside Drive, where every sunrise over the lake is a testament to the extraordinary life you've envisioned - unfolding against the picturesque backdrop of Ontario's esteemed wine country. This newly severed parcel beckons with sweeping vistas of Lake Ontario, the Toronto skyline and the majestic Niagara Escarpment. Located on a private cul-de-sac, mere steps from the Lake, this property offers both seclusion and convenience, accessible to all major amenities including the QEW highway. Perfectly suited for connoisseurs of wine, your future estate will blend natural beauty with artisanal craftsmanship. Here, panoramic water views meet the allure of vineyards, creating a sanctuary where tranquility and luxury converge. This is the ultimate opportunity for those seeking to create a family legacy with unmatched convenience. Located in the heart of wine country just a short drive to Burlington or Hamilton, and also Niagara Falls or Niagara-on-the-Lake. Also available for expansion is an adjacent 9.22-acre parcel that offers 143-feet of direct private beachfront (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
402 PROGRESTON Road in Hamilton: Single Family for sale : MLS®# 40809106
402 PROGRESTON Road Hamilton L0R 1H1
$2,349,000Single Family- Status:
- Active
- MLS® Num:
- 40809106
- Bedrooms:
- 3
- Bathrooms:
- 4
- Floor Area:
- 4,465 sq. ft.
Welcome to your private country retreat on nearly 4 acres in the heart of Carlisle. From the moment you arrive, this property leaves a lasting impression with its winding driveway, lush natural surroundings, and timeless centre-hall design. Nestled on a quiet hill and surrounded by mature trees, this custom-built home offers an exceptional blend of craftsmanship, quality, and classic charm. The inviting front and covered side porches provide peaceful spaces to relax and take in the views. Inside, the home showcases maple hardwood flooring and a bright, open-concept layout designed for modern living. The kitchen is equipped with high-end stainless steel appliances, quartz countertops, and a large central island that flows seamlessly into the dining and living areas, perfect for both entertaining and everyday comfort. Just off the kitchen, a sunroom offers a serene spot to enjoy morning coffee while overlooking the greenery. The family room exudes warmth with its inviting fireplace and direct walkout to the backyard. Upstairs, the primary suite is a true retreat. Designed with spa-like comfort in mind, this space features a spacious layout, walk-in closets, and a luxurious en-suite bathroom complete with a glass shower, soaker tub, double vanity, and heated floors. The fully finished basement offers generous additional living space and ample storage, making it perfectly suited for a variety of needs. A standout feature of this property is the workshop, ideal for storage, projects, or equipment. Another highlight is the spacious, fully finished apartment above the double garage with a separate entrance, offering incredible potential for guests, in-laws, or rental income. This is a rare opportunity to own a truly versatile property in one of Carlisle’s most picturesque locations. With premium finishes, thoughtful design, and expansive indoor and outdoor living spaces, this home delivers a lifestyle that’s increasingly hard to come by. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
Data was last updated May 13, 2026 at 08:15 AM (UTC)
My Featured Listings
113 NIAGARA Street
$429,900
Royal LePage State Realty Inc.
314 MAIN Street East
Royal LePage State Realty Inc.
