Office Listings
-
1272 FIDDLERS GREEN Road in Ancaster: Single Family for sale : MLS®# XH4196838
1272 FIDDLERS GREEN Road Ancaster L9G 3L1 
$22,900,000Single Family- Status:
- Active
- MLS® Num:
- XH4196838
- Bedrooms:
- 6
- Bathrooms:
- 13
- Floor Area:
- 22,387 sq. ft.
Set amongst a 5.2-acre paradise estate with a 1/3-acre, 17-foot-deep aerated pond, is a spectacular mansion with over 26,000 square feet of luxury living. A sprawling contemporary bungalow, with lofted in-law quarters above an over-sized four-car garage, plus a 5210 square foot detached garage with lounge, wash bay and private gas pump. Surrounded by peaceful countryside, yet only five minutes from all amenities in the heart of Ancaster, including the Hamilton Golf & Country Club. You will be awestruck by the grandeur of 14 to 18-foot unique custom moulded ceilings in every room with the highest quality of materials, craftsmanship and attention to detail throughout. There is a spectacular gourmet kitchen, grand living spaces, and a magnificent primary suite. The lower level has elevator access with a professional gym & spa, party room, and an amazing games room. This state-of-the-art home features the latest technologies including a whole home automation with Control 4 and a masterpiece 24-seat Dolby Atmos home theatre with 24-foot ceiling height, 254-inch screen, and a Kaleidoscope movie server. Sensational outdoor amenities include a lanai with heated Eramosa flagstone and full outdoor kitchen, as well as a cabana with 14-person hot tub & bar overlooking the 35’ x 75’ heated pool. There is a regulation-sized sports court with concussion-free flooring and a children’s playground. See virtual tour website and property details page for full description and feature list. (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®# 40683419
1041 CONCESSION 8 RR 3 W Flamborough N0B 2J0
$4,999,900Agriculture- Status:
- Active
- MLS® Num:
- 40683419
- 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 Brontë 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®# 40683417
1041 CONCESSION 8 RR 3 W Flamborough N0B 2J0
$4,999,900Single Family- Status:
- Active
- MLS® Num:
- 40683417
- 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 Brontë 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
-
861 BOOK Road E in Ancaster: Vacant Land for sale : MLS®# XH4202432
861 BOOK Road E Ancaster L9G 3L1
$3,995,000Vacant Land- Status:
- Active
- MLS® Num:
- XH4202432
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
-
18 ELDER Crescent in Ancaster: Single Family for sale : MLS®# 40682668
18 ELDER Crescent Ancaster L0R 1R0
$3,995,000Single Family- Status:
- Active
- MLS® Num:
- 40682668
- 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: Single Family for sale : MLS®# XH4202430
861 BOOK Road E Ancaster L9G 3L1
$3,995,000Single Family- Status:
- Active
- MLS® Num:
- XH4202430
- 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
-
858 KING Street W in Hamilton: Office for sale : MLS®# 40661531
858 KING Street W Hamilton L8S 1K3
$2,449,000Office- Status:
- Active
- MLS® Num:
- 40661531
- Floor Area:
- 6,962 sq. ft.
Rare offering of 2 mixed use retail/commercial and residential buildings on one lot. High visibility and traffic street in Westdale. Close to parks, schools, religious institutions, dining and entertainment, McMaster U, Columbia College, McMaster Innovation Park, McMaster Pediatrics Hospital (HHS) & public transit, mins to QEW, Westdale Village and downtown Hamilton, Locke St shopping and dining. 856-858 King St W includes two retail units on the first floor and one spacious 3 bedroom residential unit on the second floor. 850-854 includes 3 retail units and one 4 bedroom residential unit above and 8 parking spaces at rear of the buildings for tenants. Plenty of street parking. The two buildings must be purchased together. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
347 QUEEN Street S in Hamilton: Multi-family for sale : MLS®# 40683158
347 QUEEN Street S Hamilton L8P 3T8
$2,385,000Multi-family- Status:
- Active
- MLS® Num:
- 40683158
- Bedrooms:
- 10
- Bathrooms:
- 6
- Floor Area:
- 6,295 sq. ft.
A Rare Opportunity to Own a Piece of Hamilton’s History. Step into the storied past and timeless elegance of The Queen St Castle, a magnificent Victorian, legal non-conforming triplex situated at the prestigious corner of Queen Street South and Aberdeen Avenue. Built in 1881, this architectural gem, also k/a Hawkin’s House and Henson Queen, is recognized as one of Hamilton’s most iconic homes and is listed as of interest and among the city’s Architecturally Significant Properties. This white Victorian masterpiece, complete with a turret, has been lovingly maintained by a select few owners and is being offered for the first time in years after being acquired off-market. Grandfathered as a triplex in 2014, the property effortlessly combines historical charm with modern practicality. Features a prime location nestled in the heart of the Durand neighborhood, at the base of the escarpment, you’re just steps from Locke Street’s vibrant shops, restaurants, and dog park. Augusta, James, and Hess streets are all within walking distance, with access to the Bruce Trail and major highways just minutes away. Enjoy ample parking & outdoor space. A triple car attached garage/carport, plus driveway parking for up to 7 vehicles, ensures convenience. The fully fenced yard offers privacy and potential for outdoor entertaining. Modern Updates Include: Front Porch and Hallway Painting (2024), Chimney Cap (2024), Carport Roof (2023), Soffit and Fascia (2020 & 2024). This unique residence offers the flexibility of a triplex layout while preserving its historical grandeur. Its proximity to Hamilton’s hospitals, McMaster University, Mohawk College, and multiple GO stations makes it ideal for professionals, families, or investors seeking a property that combines location, history, and prestige. Don’t miss the chance to own one of Hamilton’s most admired landmarks—experience the grandeur of The Queen St Castle and create your own chapter in its remarkable history. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
347 QUEEN Street S in Hamilton: Single Family for sale : MLS®# 40684661
347 QUEEN Street S Hamilton L8P 3T8
$2,385,000Single Family- Status:
- Active
- MLS® Num:
- 40684661
- Bedrooms:
- 10
- Bathrooms:
- 6
- Floor Area:
- 6,295 sq. ft.
A Rare Opportunity to Own a Piece of Hamilton’s History. The “Queen St Castle is a magnificent circa 1881 home situated at the prestigious corner of Queen Street South and Aberdeen Avenue. This architectural gem, also known as Hawkin’s House and Henson Queen (after its original owner), is recognized as one of Hamilton’s most iconic homes and is listed among the city’s Architecturally Significant Properties. This white Victorian masterpiece, complete with a turret, has been lovingly maintained by a select few owners and is being offered for the first time in years after being acquired off-market. Grandfathered as a legal non-conforming triplex in 2014, it presents the potential to be restored to its original grandeur as a stunning single-family home for those looking to create a bespoke estate. Features a prime location nestled in the heart of the Durand neighborhood, at the base of the escarpment, you’re just steps from Locke Street’s vibrant shops, restaurants, and dog park. Augusta, James, and Hess Streets are all within walking distance, with access to the Bruce Trail and major highways just minutes away. Enjoy ample parking & outdoor space. A triple car attached garage/carport, plus driveway parking for up to 7 vehicles, ensures convenience. The fully fenced yard offers privacy and potential for outdoor entertaining. Modern Updates Include: Front Porch and Hallway Painting (2024), Chimney Cap (2024), Carport Roof (2023), Soffit and Fascia (2020 & 2024). Its proximity to Hamilton’s hospitals, McMaster University, Mohawk College, and multiple GO stations makes it ideal for professionals and families seeking a property that combines location, history, and prestige. Don’t miss the chance to own one of Hamilton’s most admired landmarks—experience the grandeur of The Queen St Castle and create your own chapter in its remarkable history. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
397 King Street W Unit# 215 in Dundas: Condo for sale : MLS®# XH4207009
397 King Street W Unit# 215 Dundas L9H 1W9
$2,195,000Single Family- Status:
- Active
- MLS® Num:
- XH4207009
- Bedrooms:
- 2
- Bathrooms:
- 2
- Floor Area:
- 2,399 sq. ft.
Stunning luxury at the District Lofts! Circa 1929 this boutique building was completely rebuilt in 2013 offering only 44 unique units. Unit 215 is one of the largest two units offering a rare opportunity for the discerning buyer. An over-sized double-car garage and a private entrance make it feel like living in a home without the exterior maintenance. Enjoy the grandeur of this loft style 2-storey condo. A spectacular open living space filled with natural light offers a 17-ft ceiling highlighted by a dramatic Restoration Hardware chandelier and breathtaking views of the Dundas Peak. The stunning gourmet kitchen has extended height cabinetry, high-end appliances, quartz counters and a large island with seating for six. This unit offers two spacious bedrooms and two spa-like bathrooms with upgraded fixtures. There are two private balconies, full-sized laundry, plenty of custom closet storage and fantastic upgrades: trim & millwork, Swarovski crystal handles and motorized blinds. The building offers state-of-the-art in-floor radiant heating and this unit has a brand-new a/c system. Amenities at the Lofts include a fitness studio, large locker exclusive to the unit, and a roof top patio for entertaining or relaxing (enjoy the views and tranquil sounds of the waterfall). Located at the foot of the Dundas Peak just steps to the Bruce Trail, Webster’s Falls, the Dundas Valley Golf and Curling Club and the historic Dundas downtown core with a vibrant mix of shops and restaurants. (id:2493) More detailsListed by Royal LePage State Realty - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
LOT 4 PLOVER MILLS Road in Ilderton: Single Family for sale : MLS®# 40655262
LOT 4 PLOVER MILLS Road Ilderton N0M 2A0
$1,999,000Single Family- Status:
- Active
- MLS® Num:
- 40655262
- Floor Area:
- 4,000 sq. ft.
Experience luxury and privacy at Bryanston Estates, where XO Homes presents an exclusive opportunity to build CUSTOM your dream home. Located just outside of London's city limits. Available on Lot 4 and Lot 5, these premium 2/3 acre estate lots offer the perfect canvas for stunning custom homes. This model boasts 4,000 sq ft of modern open-concept living, featuring high-end luxury finishes, expensive windows, and chef's kitchen. The South0facing backyards provide tranquil views of grassy farm fields with endless privacy, enhancing the serene setting. These thoughtfully designed homes include 4 bedrooms, each with its own private ensuite bathroom, plus a bonus work-from-home office space and a loft area on the second floor. XO Homes offer you the freedom to tailor your home to your unique vision. Whether you choose to modify existing designs, make adjustments, or create a completely custom build from scratch, the possibilities are endless. (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 December 30, 2024 at 12:45 PM (UTC)
My Featured Listings
443 CENTENNIAL FOREST Drive
$699,900
Royal LePage State Realty
25 LINDSAY Drive
$859,900
Royal LePage State Realty
