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
-
443 PEARL Street in Burlington: Multi-family for sale : MLS®# 40710506
443 PEARL Street Burlington L7R 2N2
$7,499,000Multi-family- Status:
- Active
- MLS® Num:
- 40710506
- Bedrooms:
- 40
- Bathrooms:
- 24
- Floor Area:
- 21,108 sq. ft.
This 24-unit apartment building offers investors a rare opportunity to acquire a value-add, multi-family asset in downtown Burlington – one of Canada’s most sought-after residential neighbourhoods. This easy to manage 4-storey building has (8) one-bedroom units and (16) two-bedroom units with no elevator or underground parking and separately metered hydro. It also features three new IBC WIFI gas boilers. There is significant revenue growth potential with a 45% rental upside and future development potential. Located steps to restaurants, nightlife, shopping and cultural attractions. Just a short walk to the beautiful waterfront of Lake Ontario, the Brant Street Pier & Spencer Smith Park. With a Walk Score of 96 and easy access to public transit, every amenity is right at the doorstep. This neighbourhood is a gateway to the downtown core of Burlington and there is major highway access nearby easily connecting this area with downtown Toronto, Hamilton or Niagara. (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®# 40724990
50 CREIGHTON Road Dundas L9H 3B6
$6,995,000Vacant Land- Status:
- Active
- MLS® Num:
- 40724990
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 - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1041 CONCESSION 8 RR 3 W in Flamborough: Agriculture for sale : MLS®# 40714432
1041 CONCESSION 8 RR 3 W Flamborough N0B 2J0
$4,999,900Agriculture- Status:
- Active
- MLS® Num:
- 40714432
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 3,862 sq. ft.
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 nearly 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 - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1041 CONCESSION 8 RR 3 W in Flamborough: Single Family for sale : MLS®# 40714391
1041 CONCESSION 8 RR 3 W Flamborough N0B 2J0
$4,999,900Single Family- Status:
- Active
- MLS® Num:
- 40714391
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 3,862 sq. ft.
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 nearly 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 - 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
$4,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 - 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
$4,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 - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
6 SHAKESPEARE Road in Flamborough: Single Family for sale : MLS®# 40741741
6 SHAKESPEARE Road Flamborough L9H 7R5
$4,749,900Single Family- Status:
- Active
- MLS® Num:
- 40741741
- Bedrooms:
- 5
- Bathrooms:
- 7
- Floor Area:
- 6,000 sq. ft.
Discover unparalleled luxury in this custom-built modern masterpiece on a sprawling 1.6-acre estate in one of Flamborough’s most exclusive neighbourhoods. Enjoy the tranquility of a private country retreat just minutes from downtown Dundas and a short drive to Ancaster, Burlington, and McMaster. This stunning home offers over 6,000 sqft of exquisitely designed living space with 4+1 bedrooms and 7 bathrooms. From the striking architecture and custom millwork to the warm ambiance created by designer fixtures, soaring ceilings, 4-foot porcelain tiles, and ¾-inch engineered hardwood, every detail will impress. The dramatic 19-foot great room features floor-to-ceiling black frame windows with automated blinds and a sleek gas fireplace wrapped in 10-foot porcelain slabs. The chef’s kitchen is a showstopper, equipped with top-tier appliances, quartz countertops, a waterfall island, built-in espresso bar, and a hidden walk-in pantry for a clean, streamlined look. The main-floor primary suite offers a spa-like retreat with a five-piece ensuite including heated floors, glass shower, freestanding tub, double vanity, and an oversized walk-in dressing room with custom organizers. Upstairs, three bedrooms each have unique ensuite baths and 9-foot ceilings, ensuring privacy and comfort. The finished lower level expands your living space with a full secondary kitchen, recreation room, gym or guest bedroom, full bathroom, and a soundproof home theatre—ideal for entertaining or multi-generational living. Car enthusiasts will value the 5-car garages with a car lift, alarm system, and heated bay for year-round comfort. Outside, relax in your resort-style oasis with a heated saltwater pool, outdoor family room & kitchen, and full bathroom. A custom garage-style shed and pool house enhance the property’s sleek design. Additional features include a whole-home 20KW generator, Control4 smart home automation, and electric car rough-in. This estate is more than a home—it’s a lifestyle! (id:2493) More detailsListed by Royal LePage State Realty - 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,599,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 - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1431 WILSON Street W in Ancaster: Vacant Land for sale : MLS®# 40729210
1431 WILSON Street W Ancaster L0R 1R0
$4,499,000Vacant Land- Status:
- Active
- MLS® Num:
- 40729210
PRIME COMMERCIAL DEVELOPMENT OPPORTUNITY: Clean Phase II Environmental Report and a preliminary Geotechnical Study available. Tree removal on the property has just been completed leaving no impediments to development. 4.15-acres of industrial land zoned M3 Prestige Business Park, with municipal services at the lot line. Located at Wilson Street West / Hwy 2 and Tradewind Drive, directly across from the Ancaster Business Park with busy vehicle traffic for mass exposure. There is easy access to highway 403 & highway 6, and the Hamilton International Airport is less than 10 minutes away. The zoning allows for a long list of possible uses including: industrial, hospitality, administrative, manufacturing, mechanical, transportation and logistics. On the property there is a beautiful 4-bedroom home with an exterior garage, as well as a barn & workshop - plenty of interim use opportunity. *Renderings for visual representation only. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1467 BOOK Road W in Ancaster: Agriculture for sale : MLS®# 40724049
1467 BOOK Road W Ancaster L0R 1R0
$4,199,900Agriculture- Status:
- Active
- MLS® Num:
- 40724049
- Bedrooms:
- 7
- Bathrooms:
- 4
- Floor Area:
- 5,200 sq. ft.
Fall in love with this stunning custom built, 5200 sq. ft, 7 bedroom Country Estate on a sprawling 37.9 acres overlooking a pond, pastures & sunset views. This home is perfect for a large family and executive style living with 2800 sq. ft. on the beautifully appointed main level featuring a luxurious primary suite with a sitting room, fireplace & spa-like bathroom. Enjoy a gourmet kitchen open to a huge great room with floor to ceiling windows, a main level office and designer reading room with vaulted ceiling & custom wall unit. The impressively wide second level hallway leads to 6 large bedrooms and 2 bathrooms plus a second staircase to the kitchen.. Entertain in style in your private backyard oasis with inground salt water pool and hot tub, fire pit area, multi level deck & multiple lounging areas plus a multi purpose pole barn. 30 Acres leased to a local farmer. Located a short drive to shops, amenities and downtown Ancaster this home provides the best in Country Living. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1467 BOOK Road W in Ancaster: Single Family for sale : MLS®# 40724043
1467 BOOK Road W Ancaster L0R 1R0
$4,199,900Single Family- Status:
- Active
- MLS® Num:
- 40724043
- Bedrooms:
- 7
- Bathrooms:
- 4
- Floor Area:
- 5,200 sq. ft.
Fall in love with this stunning custom built, 5200 sq. ft, 7 bedroom Country Estate on a sprawling 37.9 acres overlooking a pond, pastures & sunset views. This home is perfect for a large family and executive style living with 2800 sq. ft. on the beautifully appointed main level featuring a luxurious primary suite with a sitting room, fireplace & spa-like bathroom. Enjoy a gourmet kitchen open to a huge great room with floor to ceiling windows, a main level office and designer reading room with vaulted ceiling & custom wall unit. The impressively wide second level hallway leads to 6 large bedrooms and 2 bathrooms plus a second staircase to the kitchen.. Entertain in style in your private backyard oasis with inground salt water pool and hot tub, fire pit area, multi level deck & multiple lounging areas plus a multi purpose pole barn. 30 Acres leased to a local farmer. Located a short drive to shops, amenities and downtown Ancaster this home provides the best in Country Living. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
Data was last updated July 5, 2025 at 03:45 PM (UTC)
My Featured Listings
150 PRINCESS Street
$725,000
Royal LePage State Realty
129 DUNDURN Street North
$629,900
Royal LePage State Realty
