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: $ 0 ( 0)
Updated: 2025-05-04 19:53:19
Step into this exceptional custom design residence! With over 300k of upgrades. The main floor dazzles with custom wall & coffered ceiling designs throughout. Accentuated by media lights and pot-lights in the Foyer, Formal living, dining, office, family and Kitchen. The chef\'s kitchen, boasting high-end appliances, modern cabinets, Granite/Quartz countertops, backsplash & pot-lights, Under Cabinet lights, seamlessly connects to the family & Breakfast with large windows offering year-round pond view. Upstairs, discover 4 bedrooms and a flex room with smooth ceilings, pot lights, laundry &direct bathroom access from all rooms. The flex room can easily be transformed into a 5th BR. The Primary bedroom is a sanctuary, featuring a spacious layout, a luxurious bathroom, captivating pond views, complemented by two walk-in closets. BR 2&3 also have W/I closets and BR4 has 2 large his/her closets. Immerse yourself in the house\'s beauty through the virtual tour.
Status:
MLS #: X12123108
Price: $ 5,500
Address: 57 Pond View Gate
Type:
Style: 2-Storey
Size: Sq Ft
Age: Years
Front On:
Taxes: $ 0
Tax Year: 0
Lot Size:
Neighbourhood: Waterdown
Nearest Intersection: Pond View Gate & Skinner Road
City: Hamilton
Postal Code: L0R 2H1
DOM: 35 Days
Last Update: 2025-05-04 19:53:19
Bedrooms: 5
Bathrooms: 4
Rooms: 0
Kitchens:
Family Room:
Fireplace:
Basement: Full,
Central Vacuum:
Exterior: Brick Stone,
Driveway:
Garage: Available
Garage Spaces:
Parking Spaces: 2
Pool:
Electricity (Hydro):
Gas:
Phone:
Cable TV:
Heat Type:
Heat Source:
Air Conditioning:
Water:
Sewers: