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
-
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
-
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
-
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
Data was last updated March 10, 2026 at 04:15 PM (UTC)
My Featured Listings
1 262 OTTAWA Street North
Royal LePage State Realty Inc.
8 CLELAND Avenue
Royal LePage State Realty Inc.
