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,799,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
-
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
-
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
-
906 MAIN Street W in Hamilton: Vacant Land for sale : MLS®# 40712321
906 MAIN Street W Hamilton L8S 4P9
$2,900,000Vacant Land- Status:
- Active
- MLS® Num:
- 40712321
For Developers,Investors , Builders. Site Plan 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 - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
175 OAKHILL Place in Ancaster: Single Family for sale : MLS®# 40696563
175 OAKHILL Place Ancaster L9G 1C8
$2,699,900Single Family- Status:
- Active
- MLS® Num:
- 40696563
- Bedrooms:
- 6
- Bathrooms:
- 4
- Floor Area:
- 5,582 sq. ft.
Luxury living in Ancaster’s prestigious Oakhill with a stunning backyard oasis! Situated on a quiet court steps to top-rated schools, parks, all shopping amenities in town and conservation trails. This spectacular custom home offers almost 5600 sqft with 7 above grade bedrooms, 9 ft ceilings on all levels and superior construction. Exquisite curb appeal and a grand foyer are immediately impressive. The main level features a private office (or bedroom), formal dining overlooking the pool, powder room and a laundry/mudroom with custom built-ins from the oversized double garage. The open concept gourmet eat-in kitchen and family room is a perfect entertaining space offering a large island, quartz counters, high-end stainless appliances with RO ice & water and a gas fireplace. The upper level has 5 spacious bedrooms, a 5-piece bath, and a stunning primary with a reclaimed wall, walk-in dressing closet and spa-like 5-piece ensuite. The finished walkout basement features an above grade bedroom and full bath with in-law potential, recreation spaces for a theatre or home gym, and plenty of storage. Large windows allow a ton of natural light, there is an insulated concrete floor for warmth and safe & sound insulation for sound proofing/fire safety. Outside, there is a covered patio for lounging and landscaped gardens surround a heated ozonator pool with waterfall, coloured lights and jump rocks. Upgrades: Generac generator, lighting & fixtures from Restoration Hardware - see full list. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
149 MILLER Drive in Ancaster: Single Family for sale : MLS®# 40710415
149 MILLER Drive Ancaster L9G 4W2
$2,599,000Single Family- Status:
- Active
- MLS® Num:
- 40710415
- Bedrooms:
- 6
- Bathrooms:
- 5
- Floor Area:
- 6,711 sq. ft.
Welcome to 149 Miller Drive in Ancaster, a truly exceptional home offering over 6,000 square feet of luxurious, finished living space. This impressive residence features 5+1 bedrooms and 4+1 bathrooms, making it the perfect retreat for families seeking both comfort and elegance. The heart of the home is the stunning gourmet kitchen, equipped with high-end Bosch appliances, including a built-in oven, stove, and two dishwashers, complemented by a Fisher &Paykel fridge. The striking Cambria Quartz countertops add a touch of sophistication and durability, making the kitchen both functional and visually stunning. Open-concept living areas are perfect for entertaining, with ample space for family gatherings or hosting guests. The property also features a detached garage with its own washroom and hydro, offering versatility for a workshop, home office, or additional storage. In addition, a spacious 3-car garage provides plenty of space for all your vehicles and more. Located in one of Ancaster’s most desirable neighborhoods, 149 Miller Drive is a perfect blend of privacy, luxury, and practicality. Don’t miss the opportunity to make this dream home your own (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 April 14, 2025 at 01:47 PM (UTC)
My Featured Listings
200 KENSINGTON Avenue North
$649,900
Royal LePage State Realty
336 OTTAWA Street North
Royal LePage State Realty
