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
-
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
-
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
-
4558 LAKESIDE Drive in Beamsville: Vacant Land for sale : MLS®# XH4200814
4558 LAKESIDE Drive Beamsville L0R 1B1
$3,750,000Vacant Land- Status:
- Active
- MLS® Num:
- XH4200814
Build your dream estate home with 350 ft. of unrivaled Lake Ontario views set on 10.48 acres backing onto a vineyard and winery. Welcome to 4558 Lakeside Drive, where every sunrise over the lake is a testament to the extraordinary life you've envisioned – unfolding against the picturesque backdrop of Ontario’s esteemed wine country. This newly severed parcel beckons with sweeping vistas of Lake Ontario, the Toronto skyline and the majestic Niagara Escarpment. Located on a private cul-de-sac, mere steps from the Lake, this property offers both seclusion and convenience, accessible to all major amenities including the QEW highway. Perfectly suited for connoisseurs of wine, your future estate will blend natural beauty with artisanal craftsmanship. Here, panoramic water views meet the allure of vineyards, creating a sanctuary where tranquility and luxury converge. (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®# 40679307
175 OAKHILL Place Ancaster L9G 1C8
$2,799,900Single Family- Status:
- Active
- MLS® Num:
- 40679307
- 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
-
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
Data was last updated December 22, 2024 at 03:45 AM (UTC)
My Featured Listings
336 OTTAWA Street North
Royal LePage State Realty
350 Ottawa Street North
Royal LePage State Realty
