FEATURED LISTINGS

1-12/23
  • 1272 FIDDLERS GREEN Road in Ancaster: Single Family for sale : MLS®# 40701594

    1272 FIDDLERS GREEN Road Ancaster L9G 3L1
    Main Photo: 1272 FIDDLERS GREEN Road in Ancaster: Single Family for sale : MLS®# 40701594
    $19,999,777
    Single 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 details
    Listed by Royal LePage State Realty
  • OPEN HOUSE: 1041 CONCESSION 8 RR 3 W in Flamborough: Agriculture for sale : MLS®# 40683419

    1041 CONCESSION 8 RR 3 W Flamborough N0B 2J0
    OPEN HOUSE: Mar 16, 2025
    02:00 PM - 04:00 PM EDT
    Open House on Sunday, March 16, 2025 2:00PM - 4:00PM
    Main Photo: 1041 CONCESSION 8 RR 3 W in Flamborough: Agriculture for sale : MLS®# 40683419
    $4,999,900
    Agriculture
    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 details
    Listed by Royal LePage State Realty
  • OPEN HOUSE: 1041 CONCESSION 8 RR 3 W in Flamborough: Single Family for sale : MLS®# 40683417

    1041 CONCESSION 8 RR 3 W Flamborough N0B 2J0
    OPEN HOUSE: Mar 16, 2025
    02:00 PM - 04:00 PM EDT
    Open House on Sunday, March 16, 2025 2:00PM - 4:00PM
    Main Photo: 1041 CONCESSION 8 RR 3 W in Flamborough: Single Family for sale : MLS®# 40683417
    $4,999,900
    Single 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 details
    Listed by Royal LePage State Realty
  • 1431 WILSON Street W in Ancaster: Vacant Land for sale : MLS®# 40682726

    1431 WILSON Street W Ancaster L0R 1R0
    Main Photo: 1431 WILSON Street W in Ancaster: Vacant Land for sale : MLS®# 40682726
    $4,850,000
    Vacant 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 details
    Listed by Royal LePage State Realty
  • 18 ELDER Crescent in Ancaster: Single Family for sale : MLS®# 40705747

    18 ELDER Crescent Ancaster L0R 1R0
    Main Photo: 18 ELDER Crescent in Ancaster: Single Family for sale : MLS®# 40705747
    $3,797,000
    Single 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 details
    Listed by Royal LePage State Realty
  • 861 BOOK Road E in Ancaster: Single Family for sale : MLS®# 40687068

    861 BOOK Road E Ancaster L9G 3L1
    Main Photo: 861 BOOK Road E in Ancaster: Single Family for sale : MLS®# 40687068
    $3,499,000
    Single Family
    Status:
    Active
    MLS® Num:
    40687068
    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 details
    Listed by Royal LePage State Realty
  • 861 BOOK Road E in Ancaster: Vacant Land for sale : MLS®# 40687071

    861 BOOK Road E Ancaster L9G 3L1
    Main Photo: 861 BOOK Road E in Ancaster: Vacant Land for sale : MLS®# 40687071
    $3,499,000
    Vacant Land
    Status:
    Active
    MLS® Num:
    40687071
    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 details
    Listed by Royal LePage State Realty
  • OPEN HOUSE: 175 OAKHILL Place in Ancaster: Single Family for sale : MLS®# 40696563

    175 OAKHILL Place Ancaster L9G 1C8
    OPEN HOUSE: Mar 16, 2025
    02:00 PM - 04:00 PM EDT
    Open House on Sunday, March 16, 2025 2:00PM - 4:00PM
    Main Photo: 175 OAKHILL Place in Ancaster: Single Family for sale : MLS®# 40696563
    $2,699,900
    Single 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 details
    Listed by Royal LePage State Realty
  • 1645 MAIN Street E in Hamilton: Other for sale : MLS®# 40696707

    1645 MAIN Street E Hamilton L8H 1C7
    Main Photo: 1645 MAIN Street E in Hamilton: Other for sale : MLS®# 40696707
    $2,499,900
    Other
    Status:
    Active
    MLS® Num:
    40696707
    Floor Area:
    8,405 sq. ft.
    This exceptionally built almost 8405 sq ft all brick commercial building offers an ideal live-work opportunity or a prime commercial space to grow your business. Located in the heart of downtown Hamilton, perfectly positioned on a corner lot offering prominent signage and unbeatable exposure. The industrial shop boasts a massive open area with a 21-foot ceiling, an upper-level mezzanine storage area, a heavy-duty (3 metric tonne) commercial crane, hydro and independent heat. There is a bright front showroom with a luxurious full bathroom, as well as a large main level office space or warehouse with a 2-piece bath, and a kitchen with gas fireplace that opens to a stunning outdoor entertaining oasis with inground pool, stamped concrete, outdoor kitchen, and a stone fireplace. This area can also be converted back to extra parking for primary commercial users. The upper level, previously used as premium office space, is currently set up as a luxurious residential living space with two bedrooms, two full baths, and a laundry room including a gourmet kitchen with granite counters, large living areas with high end gas fireplaces, and a primary bedroom with lavish ensuite. There are two accesses from inside the showroom or directly from outside the building. The full unfinished basement provides abundant storage and houses all the mechanicals with access doors also leading directly outside. This rare property offers endless possibilities offering irreplaceable value. (id:2493) More details
    Listed by Royal LePage State Realty
  • 397 KING Street W Unit# 215 in Dundas: Condo for sale : MLS®# XH4207009

    397 KING Street W Unit# 215 Dundas L9H 1W9
    Main Photo: 397 KING Street W Unit# 215 in Dundas: Condo for sale : MLS®# XH4207009
    $2,195,000
    Single 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 details
    Listed by Royal LePage State Realty
  • 209 HIGHWAY 8 in Stoney Creek: Vacant Land for sale : MLS®# 40687789

    209 HIGHWAY 8 Stoney Creek L8G 1C6
    Main Photo: 209 HIGHWAY 8 in Stoney Creek: Vacant Land for sale : MLS®# 40687789
    $1,299,900
    Vacant Land
    Status:
    Active
    MLS® Num:
    40687789
    PRIME DEVELOPMENT OPPORTUNITY: Offering 80 ft. of frontage directly onto Highway 8 in Stoney Creek – a major artery with easy access to all amenities including transit, schools, shopping, entertainment, commercial services and highway access. 126 ft. of depth fronting onto Chester Road offers a lucrative severance opportunity to build semis, duplexes or possibly live/work. The existing zoning (R6) allows for single/semi/duplex. Further opportunity exists to join the neighbouring property – a perfect site for a future multi-residential or mixed-use development with existing mid-rise condos, townhome complexes, commercial, as well as many projects already under development along Highway 8. 209 Highway 8 has an existing 4-bedroom, 2-storey single family home on the property to ease the process of financing. Inquire for more information about this fantastic development opportunity! (id:2493) More details
    Listed by Royal LePage State Realty
  • 209 HIGHWAY 8 in Stoney Creek: Single Family for sale : MLS®# 40687783

    209 HIGHWAY 8 Stoney Creek L8G 1C6
    Main Photo: 209 HIGHWAY 8 in Stoney Creek: Single Family for sale : MLS®# 40687783
    $1,299,900
    Single Family
    Status:
    Active
    MLS® Num:
    40687783
    Bedrooms:
    4
    Bathrooms:
    2
    Floor Area:
    1,318 sq. ft.
    PRIME DEVELOPMENT OPPORTUNITY: Offering 80 ft. of frontage directly onto Highway 8 in Stoney Creek – a major artery with easy access to all amenities including transit, schools, shopping, entertainment, commercial services and highway access. 126 ft. of depth fronting onto Chester Road offers a lucrative severance opportunity to build semis, duplexes or possibly live/work. The existing zoning (R6) allows for single/semi/duplex. Further opportunity exists to join the neighbouring property – a perfect site for a future multi-residential or mixed-use development with existing mid-rise condos, townhome complexes, commercial, as well as many projects already under development along Highway 8. 209 Highway 8 has an existing 4-bedroom, 2-storey single family home on the property to ease the process of financing. Inquire for more information about this fantastic development opportunity! (id:2493) More details
    Listed by Royal LePage State Realty
1-12/23
Data was last updated March 13, 2025 at 02:15 AM (UTC)
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are member’s of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.