Office Listings
-
1272 FIDDLERS GREEN Road in Ancaster: Single Family for sale : MLS®# 40701594
1272 FIDDLERS GREEN Road Ancaster L9G 3L1 
$19,999,777Single Family- Status:
- Active
- MLS® Num:
- 40701594
- Bedrooms:
- 6
- Bathrooms:
- 13
- Floor Area:
- 21,881 sq. ft.
Set amidst a 5.2-acre estate, this extraordinary 26,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
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
50 CREIGHTON Road in Dundas: Vacant Land for sale : MLS®# 40776839
50 CREIGHTON Road Dundas L9H 3B6
$5,995,000Vacant Land- Status:
- Active
- MLS® Num:
- 40776839
PRIME DEVELOPMENT OPPORTUNITY: This 2.39-acre waterfront property on Spencer Creek in downtown Dundas is currently being rezoned (‘Medium Density Multiple Dwelling–RM3 Modified’) for an 8-storey, 120-unit condominium development. The zoning will also allow for a retirement facility and there is still a massive upside potential with a maximum build allowance up to 12 storeys and 170 units. A full application has been submitted including the following studies: Hydrogeological; Geotechnical; Functional Servicing & Stormwater Management; Noise Impact; Sun/Shadow; Wind; Parking Analysis & Transportation Management. This luxury apartment style building will comprise of one, two, and three-bedroom configurations. The building is designed with recessed balconies enhancing its visual appeal. To accommodate residents, the development includes a total of 144 parking spaces in an underground garage along with 120 storage lockers and dedicated bicycle parking. However, a revised zoning by-law will allow for a reduction to a total of 78 spaces significantly reducing the underground requirements. A rooftop amenity space is also included in the plan. Access to the site is from the west side of Creighton Road, ensuring efficient circulation for both residents and visitors. The site is currently occupied by a single-storey building containing 10 rental units with plenty of interim opportunity. Located directly in front of Spencer Creek Trail connecting to the entire Dundas Valley Conservation with easy access to Webster Falls and the Dundas Valley Golf and Curling Club. This site is conveniently located on a bus route and just steps to the historic downtown Dundas with a vibrant mix of restaurants, shopping and amenities. This development represents a strategic use of land in alignment with the City of Hamilton’s Urban Official Plan and Design Guidelines. It notably advances the core objectives of intensification while considering the form and functional characteristics of the area. (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: Agriculture for sale : MLS®# 40766682
573 PARKSIDE Drive Hamilton L8B 0G7
$5,900,000Agriculture- Status:
- Active
- MLS® Num:
- 40766682
- 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: Agriculture for sale : MLS®# 40796886
1041 8TH CONCESSION Road W Flamborough N0B 2J0
$4,749,500Agriculture- Status:
- Active
- MLS® Num:
- 40796886
- 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
-
1041 8TH CONCESSION Road W in Flamborough: Single Family for sale : MLS®# 40796874
1041 8TH CONCESSION Road W Flamborough N0B 2J0
$4,749,500Single 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
-
8-14 NORTH RIDGE Terrace in Kitchener: Vacant Land for sale : MLS®# 40714614
8-14 NORTH RIDGE Terrace Kitchener N2A 2S5
$4,499,000Vacant Land- Status:
- Active
- MLS® Num:
- 40714614
ATTENTION BUILDERS & DEVELOPERS: This prime investment opportunity offers seven brand new serviced luxury building lots (8-14) backing onto Chicopee Park & Ski Resort. Only 14 homes will be built in this modern upscale subdivision accessed by a new private road ‘North Ridge Terrace’. The Chicopee Heights neighbourhood is conveniently located with easy access to schools, shopping, restaurants, and highways (7, 8, 85 and 401). For outdoor enthusiasts, there is direct access to walking trails literally in your backyard as well as the Chicopee Ski and Tube Park. The private road will offer snow removal, private garage removal and common elements with a $185 per month road fee. This incredible Kitchener location is only an hour from Toronto. A full information package is available including approved home designs and drawings. All lots are serviced and ready to build! (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®# 40777641
126 MCGREGOR Crescent Ancaster L9G 1B5
$4,398,000Single Family- Status:
- Active
- MLS® Num:
- 40777641
- 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
-
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
-
878 SULPHUR SPRINGS Road in Ancaster: Vacant Land for sale : MLS®# 40735893
878 SULPHUR SPRINGS Road Ancaster L9H 5E3
$3,999,000Vacant Land- Status:
- Active
- MLS® Num:
- 40735893
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
-
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
-
906 MAIN Street W in Hamilton: Vacant Land for sale : MLS®# 40774074
906 MAIN Street W Hamilton L8S 4P9
$2,900,000Vacant 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
-
102 CUMMING Court in Ancaster: Single Family for sale : MLS®# 40789103
102 CUMMING Court Ancaster L9G 1V3
$2,595,000Single Family- Status:
- Active
- MLS® Num:
- 40789103
- 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
Data was last updated January 9, 2026 at 08:15 PM (UTC)
My Featured Listings
61 IRWIN Avenue
Royal LePage State Realty Inc.
61 IRWIN Avenue
$999,900
Royal LePage State Realty Inc.
