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
-
1431 WILSON Street W in Ancaster: Vacant Land for sale : MLS®# 40682726
1431 WILSON Street W Ancaster L0R 1R0
$4,850,000Vacant Land- Status:
- Active
- MLS® Num:
- 40682726
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
-
8-14 NORTH RIDGE Terrace in Kitchener: Vacant Land for sale : MLS®# 40714614
8-14 NORTH RIDGE Terrace Kitchener N2A 2S5
$4,799,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
-
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
-
18 ELDER Crescent in Ancaster: Single Family for sale : MLS®# 40705747
18 ELDER Crescent Ancaster L0R 1R0
$3,797,000Single Family- Status:
- Active
- MLS® Num:
- 40705747
- Bedrooms:
- 5
- Bathrooms:
- 6
- Floor Area:
- 4,400 sq. ft.
2.5-acre nature paradise in the heart of Ancaster, nestled in an exclusive enclave of multi-million-dollar homes. The nearly 7,000 sqft custom-designed executive home blends modern luxury with natural beauty. New stone walkways and lush greenery provide stunning curb appeal. Inside, the grand 'Scarlett O’Hara' staircase makes a dramatic first impression. The main floor features formal living and dining rooms, a private office, two powder rooms, and a custom laundry/mudroom with garage access and second basement staircase. The elegant family room boasts a new Valor gas fireplace and stone feature wall providing warmth and ambience. The gourmet eat-in kitchen is a true masterpiece equipped with top-tier appliances, designer cabinetry, granite counters, and striking stone accents. Upstairs, there are 4 spacious bedrooms and 3 full baths including the hotel-inspired primary suite with a 5-piece spa ensuite and a massive walk-in dressing closet with custom built-ins. The newly renovated walkout basement includes a fifth bedroom (playroom), full bathroom, kitchenette & bar, media area with Valor gas fireplace and rustic barnboard wall, state-of-the-art home gym with mirrors & glass doors, and access to a private patio with hot tub—perfect for entertaining or an in-law suite. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
861 BOOK Road E in Ancaster: Vacant Land for sale : MLS®# 40707621
861 BOOK Road E Ancaster L9G 3L1
$2,999,900Vacant Land- Status:
- Active
- MLS® Num:
- 40707621
PRIME INDUSTRIAL DEVELOPMENT OPPORTUNITY: 12.5-Acres of land zoned M10: H37 – Airport Light Industrial in the Airport Employment Growth District. Minor consultation with the City of Hamilton and Niagara Peninsula Conservation Authority has confirmed there are no regulated features impacting future development. Located less than 400-ft to Glancaster Road (city water), only 1-km from Twenty Road (city sewers), and just 1.5-km to Hamilton International Airport lands. The existing property features a 3-bedroom, 2 full bath backsplit built in 1996 with a double garage and a separate entrance for easy duplex conversion. There is a large 40 x 30 ft workshop and some detached storage garages also onsite so there is plenty of interim opportunity. Hamilton International Airport is open 24/7 with 10,000+ ft of runway and no landing curfews. It is home to Cargojet, Purolator, Canada Post, UPS and DHL hubs, as well as Amazon Canada Fulfillment Centre. VTB financing available to qualified buyers (terms TBD). (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
861 BOOK Road E in Ancaster: Single Family for sale : MLS®# 40707617
861 BOOK Road E Ancaster L9G 3L1
$2,999,900Single Family- Status:
- Active
- MLS® Num:
- 40707617
- Bedrooms:
- 4
- Bathrooms:
- 2
- Floor Area:
- 1,357 sq. ft.
PRIME INDUSTRIAL DEVELOPMENT OPPORTUNITY: 12.5-Acres of land zoned M10: H37 – Airport Light Industrial in the Airport Employment Growth District. Minor consultation with the City of Hamilton and Niagara Peninsula Conservation Authority has confirmed there are no regulated features impacting future development. Located less than 400-ft to Glancaster Road (city water), only 1-km from Twenty Road (city sewers), and just 1.5-km to Hamilton International Airport lands. The existing property features a 3-bedroom, 2 full bath backsplit built in 1996 with a double garage and a separate entrance for easy duplex conversion. There is a large 40 x 30 ft workshop and some detached storage garages also onsite so there is plenty of interim opportunity. Hamilton International Airport is open 24/7 with 10,000+ ft of runway and no landing curfews. It is home to Cargojet, Purolator, Canada Post, UPS and DHL hubs, as well as Amazon Canada Fulfillment Centre. VTB financing available to qualified buyers (terms TBD). (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 May 10, 2025 at 09:45 AM (UTC)
My Featured Listings
150 PRINCESS Street
$725,000
Royal LePage State Realty
129 DUNDURN Street North
$649,900
Royal LePage State Realty
