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: Brick Concrete
Style: Bungalow
Size: Sq Ft
Age: Years
Taxes: $ 11,203 ( 2025)
Updated: 2025-05-27 12:37:09
Welcome to your dream home nestled in the heart of Historic Waterdown Village! This custom-built, executive-style all-brick bungalow offers almost 5,000 square feet of beautifully finished living space, perfectly designed for entertaining clients, hosting friends and family, or relaxing with the grandkids. Step inside the grand front entryway and you\'ll immediately feel the quality and craftsmanship throughout. The upper level boasts brand-new wide plank 7.5 white oak flooring, leading you into the breathtaking great room with floor-to-ceiling built-ins, an oversized gas fireplace, and a custom baran entertainers dream! The chefs kitchen is a showstopper, outfitted with professional-grade Thermador appliances, a coffee bar, dedicated server area, and abundant custom cabinetry designed for both everyday living and effortless entertaining. Enjoy seamless indoor-outdoor living with direct access to a meticulously maintained backyard oasis, complete with a saltwater pool, lounging area, a
Status:
MLS #: X12167942
Price: $ 2,749,000
Address: 38 Brian Boulevard
Type:
Style: Bungalow
Size: Sq Ft
Age: Years
Front On:
Taxes: $ 11,203
Tax Year: 2025
Lot Size:
Neighbourhood: Waterdown
Nearest Intersection: Braeheid & Brian
City: Hamilton
Postal Code: L8B 0C7
DOM: 12 Days
Last Update: 2025-05-27 12:37:09
Bedrooms: 4
Bathrooms: 3
Rooms: 0
Kitchens:
Family Room:
Fireplace:
Basement: Finished,
Central Vacuum:
Exterior: Brick Concrete,
Driveway:
Garage:
Garage Spaces:
Parking Spaces: 6
Pool:
Electricity (Hydro):
Gas:
Phone:
Cable TV:
Heat Type:
Heat Source:
Air Conditioning:
Water:
Sewers: