Office Listings
-
1272 FIDDLERS GREEN Road in Ancaster: Single Family for sale : MLS®# 40807800
1272 FIDDLERS GREEN Road Ancaster L9G 3L1 
$19,888,000Single Family- Status:
- Active
- MLS® Num:
- 40807800
- Bedrooms:
- 6
- Bathrooms:
- 13
- Floor Area:
- 22,387 sq. ft.
Set amidst a 5.2-acre estate, this extraordinary 32,000+ sq ft mansion offers unparalleled luxury and privacy. The gated and secured property features a stunning 1/3-acre aerated pond leading to a sprawling contemporary bungalow with lofted in-law quarters and a 5,210 sq ft detached garage with lounge, wash bay, and private gas pump—ideal for car enthusiasts.Surrounded by serene countryside, yet minutes from the heart of Ancaster, the renowned Hamilton Golf & Country Club, and Highway 403, offering both seclusion and convenience. Inside, every room showcases soaring 14 to 18-foot custom moulded ceilings, 32-inch porcelain flooring, and the highest quality materials and craftsmanship. The state-of-the-art home features whole-home automation by Control4. Spacious living areas feature custom granite walls with Town & Country fireplaces. A gourmet kitchen is equipped with top-tier appliances, including Sub-Zero, Thermador, and Miele. The luxurious lanai is perfect for entertaining, with heated Eramosa flagstone, a full outdoor kitchen, 72” Woods gas fireplace, and phantom screens. The opulent primary suite includes a private patio with hot tub and an expansive dressing room. The ensuite features heated herringbone floors, a soaker tub with fireplace, towel warmer drawers and a digital rain shower. The opposite wing offers three additional bedroom suites, each with walk-in closets and ensuites. A Cambridge elevator provides access to the entertainer’s dream basement, with a party room, full bar, professional gym with sauna and steam shower, games room, and a state-of-the-art home theatre. This 24-seat Dolby Atmos theatre features a 254-inch screen, 24-foot ceiling height, and a Kaleidoscope movie server for the ultimate cinematic experience. Outdoor amenities include a 35’ x 75’ heated pool, a 14-person hot tub, and an entertainment cabana with a media area and hosting bar. A regulation-size sports court and a children’s playground complete this family-friendly estate. (id:2493) More detailsListed by Royal LePage State Realty Inc.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
573 PARKSIDE Drive in Hamilton: Single Family for sale : MLS®# 40812431
573 PARKSIDE Drive Hamilton L8B 0G7
$5,300,000Single Family- Status:
- Active
- MLS® Num:
- 40812431
- Bedrooms:
- 6
- Bathrooms:
- 3
- Floor Area:
- 2,785 sq. ft.
Welcome to 573 Parkside Drive! A truly rare offering with 116.5 acres of prime farmland on the outskirts of Waterdown. Featuring a 2,785 sq. ft. 2 storey brick farmhouse, and a beautiful old wood bank barn that was formerly used as a destination fruit and bake shop. This expansive property is just minutes from Burlington, Hamilton, and major commuter routes, with quick access to Hwy 6, the QEW, and the 403. Zoned A2 and P7, the land offers incredible versatility, ideal for continued agricultural use, a dream estate, horse and hobby farming, or even a wedding and event venue that takes advantage of the charming farmhouse and historic barn. The fertile acreage also supports cash crops, orchards, or farm-to-table opportunities. With steady growth in the Hamilton-Waterdown area and multiple subdivision proposals nearby, it also represents an exceptional long-term buy and hold investment (subject to approvals). Featuring established road frontage, proximity to municipal services, and surrounded by active development, 573 Parkside Drive is a one-of-a-kind opportunity that blends country charm, future potential, and unmatched location. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1041 8TH CONCESSION Road W in Flamborough: Single Family for sale : MLS®# 40796874
1041 8TH CONCESSION Road W Flamborough N0B 2J0
$4,499,900Single Family- Status:
- Active
- MLS® Num:
- 40796874
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 6,660 sq. ft.
108+ Acres and 25+ Acres of water nestled in the heart of Flamborough, this stunning 4-bedroom, 4+1-bathroom country estate blends historic charm with modern luxury. Extensively renovated in 2018, this property boasts over 6,000 sq. ft. of refined living space on 108+ acres featuring 7 picturesque bodies of water, including 3 connected to Bronte Creek. The home includes a walkaround porch, gourmet kitchen with Bosch appliances, a steam spa shower, two Rumford fireplaces, and a walk-out basement with in-floor heating. Outdoor living is unmatched with a pizza oven, a 4 ft fireplace, pool house with bar and drink fridge, and a swim spa / hot tub with an automatic Covana cover. A 60x40 workshop, complete with a 10,000 lb hoist, RV hookup, and framed second-level 2-bed apartment, offers endless possibilities. Modern amenities include high-speed fiber internet, a Kohler generator, and security cameras. With reduced property taxes and proximity to Waterdown, Cambridge, and Burlington, this property is the perfect private retreat or multi-functional family estate. Don’t miss this rare opportunity! (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
878 SULPHUR SPRINGS Road in Ancaster: Single Family for sale : MLS®# 40735894
878 SULPHUR SPRINGS Road Ancaster L9H 5E3
$3,999,000Single Family- Status:
- Active
- MLS® Num:
- 40735894
- Floor Area:
- 700 sq. ft.
Stunning 10-Acre Property in the Heart of Conservation Lands. Nestled in a serene and sought-after location, this breathtaking 10-acre parcel offers the perfect blend of natural beauty and future potential. Featuring approximately 2 acres of mature forest and expansive rolling meadows, this property is a rare opportunity to own a private slice of paradise. Previously approved for an impressive 8,200 sq ft custom residence. Municipal water and hydro available. Steps to the rail trail, ideal for walking, biking, and enjoying nature, Just minutes from local amenities, offering convenience without compromising tranquility. There is no access to the existing dwelling on the property. Don't miss this chance to build your dream estate in one of the area's most picturesque settings. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
126 MCGREGOR Crescent in Ancaster: Single Family for sale : MLS®# 40803364
126 MCGREGOR Crescent Ancaster L9G 1B5
$3,988,000Single Family- Status:
- Active
- MLS® Num:
- 40803364
- Bedrooms:
- 7
- Bathrooms:
- 8
- Floor Area:
- 8,850 sq. ft.
This multi-generational luxury dream home blends timeless design with superior craftsmanship, offering over 8,850 sqft. of finished living space with 7 bedrooms and 8 bathrooms on a 135-ft-wide lot in Ancaster’s prestigious Oakhill neighbourhood. Surrounded by mature trees and estate homes, the property showcases two separate garages, parking for 20+ vehicles, professional landscaping, and a commanding architectural façade. Inside, a 21-ft grand foyer with curved staircase and custom millwork sets an elegant tone, complemented by wide-plank hardwood, porcelain tile, and abundant natural light from oversized windows. The main level offers formal living and dining rooms, a private office, powder room, and one of two primary suites with backyard walk-out. At the heart of the home, a soaring family room with floor-to-ceiling windows connects to a gourmet kitchen featuring top-tier Thermador appliances, a servery, walk-in pantry, and a heated four-season sunroom with in-floor heating. Upstairs are four generous bedrooms, each with its own ensuite and heated floors, plus a convenient laundry room and a spectacular primary retreat with gas fireplace, dressing room, and spa-inspired 6-pc ensuite. A covered terrace with artificial turf extends the living space outdoors. The finished lower level offers incredible versatility for extended family living with a separate entrance, two bedrooms, two bathrooms, recreation room with gas fireplace, kitchenette, and a sound-isolated home theatre room that can be separated from the rest of the basement. The private backyard provides multiple patios under mature trees, with professional renderings available for a future pool, hot tub, and full landscaping. Smart-home features include Control4 automation, security system, 400-amp, dual furnaces & ACs, HRVs, and central vacuum with hide-a-hoses. A rare opportunity to own an Oakhill estate that combines sophistication, space, and modern functionality for today’s luxury lifestyle. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
18 ELDER Crescent in Ancaster: Single Family for sale : MLS®# 40802353
18 ELDER Crescent Ancaster L0R 1R0
$3,695,000Single Family- Status:
- Active
- MLS® Num:
- 40802353
- 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®# 40784027
2060 LAKESHORE Road Unit# 308 Burlington L7R 0G2
$3,499,000Single Family- Status:
- Active
- MLS® Num:
- 40784027
- 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.
Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity— an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic 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
-
34 HARRINGTON Place in Ancaster: Single Family for sale : MLS®# 40800631
34 HARRINGTON Place Ancaster L9G 4Z2
$2,595,000Single Family- Status:
- Active
- MLS® Num:
- 40800631
- 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®# 40803362
102 CUMMING Court Ancaster L9G 1V3
$2,595,000Single Family- Status:
- Active
- MLS® Num:
- 40803362
- 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, 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. (See full list of features.) (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
-
3 TURNER Avenue in Hamilton: Single Family for sale : MLS®# 40780764
3 TURNER Avenue Hamilton L8P 3K4
$2,499,900Single Family- Status:
- Active
- MLS® Num:
- 40780764
- Bedrooms:
- 6
- Bathrooms:
- 4
- Floor Area:
- 5,522 sq. ft.
Much-admired century home on a coveted and prestigious cul-de-sac nestled beneath the escarpment in Durand, Hamilton’s unique heritage enclave. This c.1910 beauty sits on an impressive 80x140ft lot, w. 6-bdrms, 4-bths & 5500+sqft. Soaring ceilings (10ft/main flr, 9.5ft/2nd), centre hall, hardwood floors, French & pocket doors, heated marble floors, clawfoot tub, one-of-a-kind fireplaces + upgrades galore (electrical, heat/a/c, concrete drive & patios, in-ground sprinklers & landscape lighting +++). Crystal chandeliers & tall dual-aspect windows flood principal rooms with light, while mature trees, an elevated position and deep front garden assure privacy. Irreplaceable craftsmanship throughout, notably in the large, Georgian-inspired dining room and serene main floor study with carved stone f/pl, ornate cornice & breathtaking panelling. Beautiful sunroom w. bespoke cabinetry & heated floor. Sunken family room w. skylight & walk-out to patio off sunny kitchen w. huge island & deck access for al fresco dining. Entertaining here is a dream, with further possibilities in the multiple garden areas. Spacious bedrooms, one w. anteroom, ideal for multigenerational living. Show-stopping staircase with window-lined landing sits to the side of the airy barrel-ceilinged foyer, enhancing flow & privacy, while a second stairway gives fast access to upper levels, incl. laundry room, teen/nanny/guest suite & gym. The quality of materials and details, from trim & mouldings to fine wood doors & hardware, imbue the home with a quiet elegance that must be seen to be appreciated. With private parking for 5 and a short walk to the GO train, this distinguished address offers a rare lifestyle balance: quiet, leafy tranquility within easy reach of the best schools, shops, cultural landmarks and parks. From waterfalls to cafes, this friendly, walkable neighbourhood has it all. Exceptional opportunity not to be missed to enjoy a true forever home on one of the city’s most desirable streets. (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 April 1, 2026 at 03:45 AM (UTC)
My Featured Listings
8 CLELAND Avenue
Royal LePage State Realty Inc.
624 UPPER OTTAWA Street
$749,900
Royal LePage State Realty Inc.
