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
-
383 PARKSIDE Drive in Hamilton: Vacant Land for sale : MLS®# 40809962
383 PARKSIDE Drive Hamilton L8B 0Y6
$6,200,000Vacant Land- Status:
- Active
- MLS® Num:
- 40809962
Rare opportunity to own an expansive 56.04 acre property in the heart of Waterdown offering exceptional versatility and long-term potential. Located at 383 Parkside Drive, this unique property features two residential units and lease-back opportunities, making it ideal for investors seeking immediate income while planning for the future. Zoned A2, P7 and P8, the land supports a wide range of uses. Conveniently located just minutes from Burlington, Hamilton, and major commuter routes, with quick access to Highway 6, the QEW, and the 403. Surrounded by continued growth and several nearby subdivision proposals, this property also represents an exceptional long-term investment and development opportunity. Note: potential lease back as the seller would consider leasing back a portion of the land. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
383 PARKSIDE Drive in Hamilton: Other for sale : MLS®# 40809607
383 PARKSIDE Drive Hamilton L8B 0Y6
$6,200,000Other- Status:
- Active
- MLS® Num:
- 40809607
- Floor Area:
- 2,050 sq. ft.
Rare opportunity to own an expansive 56.04 acre property in the heart of Waterdown offering exceptional versatility and long-term potential. Located at 383 Parkside Drive, this unique property features two residential units and lease-back opportunities, making it ideal for investors seeking immediate income while planning for the future. Zoned A2, P7 and P8, the land supports a wide range of uses. Conveniently located just minutes from Burlington, Hamilton, and major commuter routes, with quick access to Highway 6, the QEW, and the 403. Surrounded by continued growth and several nearby subdivision proposals, this property also represents an exceptional long-term investment and development opportunity. Note: potential lease back as the seller would consider leasing back a portion of the land. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
383 PARKSIDE Drive in Hamilton: Agriculture for sale : MLS®# 40809940
383 PARKSIDE Drive Hamilton L8B 0Y6
$6,200,000Agriculture- Status:
- Active
- MLS® Num:
- 40809940
- Bedrooms:
- 3
- Bathrooms:
- 3
- Floor Area:
- 2,050 sq. ft.
Rare opportunity to own an expansive 56.04 acre property in the heart of Waterdown offering exceptional versatility and long-term potential. Located at 383 Parkside Drive, this unique property features two residential units and lease-back opportunities, making it ideal for investors seeking immediate income while planning for the future. Zoned A2, P7 and P8, the land supports a wide range of uses. Conveniently located just minutes from Burlington, Hamilton, and major commuter routes, with quick access to Highway 6, the QEW, and the 403. Surrounded by continued growth and several nearby subdivision proposals, this property also represents an exceptional long-term investment and development opportunity. Note: potential lease back as the seller would consider leasing back a portion of the land. (id:2493) More detailsListed by Royal LePage State Realty Inc. - 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
-
44 DITTON Drive in Hamilton: Industrial for sale : MLS®# 40804714
44 DITTON Drive Hamilton L8W 0A9
$5,750,000Industrial- Status:
- Active
- MLS® Num:
- 40804714
- Floor Area:
- 17,400 sq. ft.
Here it is! Prime Hamilton Mountain Location. Just a short distance to the Linc! This fabulous custom build, very well maintained, industrial building. M3 zoning, offers many uses and applications. Fabulous opportunity for the right entrepreneur! An ideal owner/tenant arrangement, approximately 17,000 + square feet of a spectacular building space, 2 (2,200 square feet each), units are currently leased, leaving approximately 13,000+ square feet for YOU the new owner! Alternatively, the seller would be willing to find you, the Savvy Investor, a new tenant. The time is now, call today for more information and your Golden Opportunity to acquire this truly fantastic property! (id:2493) More detailsListed by Royal LePage State Realty Inc. and CBRE LIMITED - 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.
elcome 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
-
573 PARKSIDE Drive in Hamilton: Vacant Land for sale : MLS®# 40812425
573 PARKSIDE Drive Hamilton L8B 0G7
$5,300,000Vacant Land- Status:
- Active
- MLS® Num:
- 40812425
elcome 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
-
573 PARKSIDE Drive in Hamilton: Agriculture for sale : MLS®# 40812422
573 PARKSIDE Drive Hamilton L8B 0G7
$5,300,000Agriculture- Status:
- Active
- MLS® Num:
- 40812422
- Bedrooms:
- 6
- Bathrooms:
- 3
- Floor Area:
- 2,785 sq. ft.
elcome 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,499,900Agriculture- 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,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
Data was last updated March 17, 2026 at 10:15 AM (UTC)
My Featured Listings
624 UPPER OTTAWA Street
$769,900
Royal LePage State Realty Inc.
8 CLELAND Avenue
Royal LePage State Realty Inc.
