Could not get coordinates for the address.
Severity: Notice
Message: Undefined property: stdClass::$s_r
Filename: result/street_freehold.php
Line Number: 20
Backtrace:
File: /var/www/html/application/views/result/street_freehold.php
Line: 20
Function: _error_handler
File: /var/www/html/application/controllers/Result.php
Line: 858
Function: view
File: /var/www/html/index.php
Line: 298
Function: require_once
Type: Other
Style: 2 1/2 Storey
Size: Sq Ft
Age: Years
Taxes: $ 11,023 ( 2024)
Updated: 2025-06-06 14:23:25
Luxury, comfort & country living! 91.6-acre estate offers rolling farmland, dense woodlands & tranquil pond. Fully renovated 2.5-storey, 6 bed, 6 bath home w/ attached 2 bed 2 bath guest house was upgraded in 2022/23, featuring over $2M in premium finishes. DaVinci composite shake roof, custom windows, new doors, spacious living areas & elegant details throughout. Grand wrap-around veranda & glass-railed deck. Gourmet kitchen w/ 2 expansive islands, ample storage & top-tier appliances. Separate prep kitchen. Open-concept design leads to dining room, breakfast area & grand great room w/ 208 ceilings, stone fireplace & sliding doors to large deck. Main floor also includes powder room, laundry, mudroom, & 3pc bath. Upstairs, primary suite features timber frame accents & luxurious 5pc ensuite, while 2 additional bedrooms share a beautifully designed 4pc bath. Half-storey above offers bonus room, ideal for a studio or bedroom, along w/ a den. Lower level is perfect for extended family, w/ r
Status:
MLS #: X12197084
Price: $ 7,499,900
Address: 485 Concession 5 Road
Type:
Style: 2 1/2 Storey
Size: Sq Ft
Age: Years
Front On:
Taxes: $ 11,023
Tax Year: 2024
Lot Size:
Neighbourhood: Waterdown
Nearest Intersection: Concession 5 Rd E and Beeforth
City: Hamilton
Postal Code: L8B 0W8
DOM: 2 Days
Last Update: 2025-06-06 14:23:25
Bedrooms: 8
Bathrooms: 5
Rooms: 0
Kitchens:
Family Room:
Fireplace:
Basement: Full Finished with Walk-Out,
Central Vacuum:
Exterior: Other,
Driveway:
Garage: Private
Garage Spaces:
Parking Spaces: 14
Pool:
Electricity (Hydro):
Gas:
Phone:
Cable TV:
Heat Type:
Heat Source:
Air Conditioning:
Water:
Sewers: