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 Stucco (Plaster)
Style: Bungalow
Size: Sq Ft
Age: Years
Taxes: $ 11,768 ( 2024)
Updated: 2025-05-20 14:33:55
Discover unparalleled luxury & serene lakefront living at this magnificent custom-built bungalow, nestled on a picturesque lot with 66 of waterfront, in the heart of Stoney Creeks prestigious Community Beach/Fifty Point area. Renovated inside & out, this open-concept masterpiece, originally constructed in 2004, offers breathtaking lake views from all principal rooms, blending modern elegance with timeless comfort. This sophisticated home features over 4700 sq ft of finished living space, 3+1 bedrooms & 4 bathrooms. Step into the grand foyer, showcasing Lakefront views, 14 ft ceilings, custom trim & millwork. The main floor features 10 ft ceilings with custom, fine finishes, enhancing the open-concept design. The gourmet kitchen, crafted with solid wood cabinetry, white quartz counters with waterfall edges & a book-matched backsplash, includes built-in Café white & gold appliances, a 10 ft island & a walk-out to the lanai. The expansive dining room boasts a built-in bookcase & bench, wh
Status:
MLS #: X12156645
Price: $ 2,849,000
Address: 142 Watercrest Drive
Type:
Style: Bungalow
Size: Sq Ft
Age: Years
Front On:
Taxes: $ 11,768
Tax Year: 2024
Lot Size:
Neighbourhood: Stoney Creek
Nearest Intersection: Fruitland
City: Hamilton
Postal Code: L8E 5C7
DOM: 19 Days
Last Update: 2025-05-20 14:33:55
Bedrooms: 4
Bathrooms: 4
Rooms: 0
Kitchens:
Family Room:
Fireplace:
Basement: Full Finished,
Central Vacuum:
Exterior: Brick Stucco (Plaster),
Driveway:
Garage: Private Double
Garage Spaces:
Parking Spaces: 14
Pool:
Electricity (Hydro):
Gas:
Phone:
Cable TV:
Heat Type:
Heat Source:
Air Conditioning:
Water:
Sewers: