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 Stone
Style: 2-Storey
Size: Sq Ft
Age: Years
Taxes: $ 10,270 ( 2024)
Updated: 2025-05-12 20:56:01
Discover this stunning 5-bedroom, 4-bathroom detached home, offering 3,279 sq ft of elegant living space, a walk-out basement, and no rear neighbors providing exceptional privacy and scenic views. Nestled in the highly sought-after Waterdown community, this residence combines refined finishes with smart functionality, creating the ultimate family haven. Step into a carpet-free main level, where a spacious home office opens into an elegant, open-concept layout. The living, dining, and kitchen areas flow seamlessly ideal for both daily living and entertaining. The gourmet kitchen is a showstopper, featuring 24x24 porcelain tiles, custom cabinetry, and premium stainless steel appliances. Enjoy your morning coffee in the bright breakfast nook with direct access to the beautifully landscaped backyard perfect for outdoor gatherings. The inviting family room, anchored by a cozy gas fireplace, sets the tone for warm and memorable evenings. Upstairs, you\'ll find four generously sized bedrooms,
Status:
MLS #: X12142881
Price: $ 1,499,000
Address: 229 Agro Street
Type:
Style: 2-Storey
Size: Sq Ft
Age: Years
Front On:
Taxes: $ 10,270
Tax Year: 2024
Lot Size:
Neighbourhood: Waterdown
Nearest Intersection: GreaT Fls Blvd/ Agro St
City: Hamilton
Postal Code: L8B 1W9
DOM: 27 Days
Last Update: 2025-05-12 20:56:01
Bedrooms: 6
Bathrooms: 4
Rooms: 0
Kitchens:
Family Room:
Fireplace:
Basement: Unfinished,
Central Vacuum:
Exterior: Brick Stone,
Driveway:
Garage:
Garage Spaces:
Parking Spaces: 6
Pool:
Electricity (Hydro):
Gas:
Phone:
Cable TV:
Heat Type:
Heat Source:
Air Conditioning:
Water:
Sewers: