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: Aluminum Siding Brick
Style: Bungalow
Size: Sq Ft
Age: Years
Taxes: $ 6,846 ( 2024)
Updated: 2025-04-16 15:36:31
This bungalow is a haven of tranquility situated on half acre property in a quiet community and truly turn-key and ready for you to move in. Located in Flamborough just outside the village of Carlisle. Beautifully renovated from top to bottom with almost 2500 square feet of living space. As you step inside you\'ll feel right at home in this open concept floor plan featuring a state of the art chefs kitchen with high end appliances, island, dining area and walk out to deck which overlooks a mature setting. The bedroom wing offers 3 generous size bedrooms and a main bathroom. The lower level is finished with a large great room, wet bar, office/4th Bedroom, gym and laundry room. A short drive brings you to Waterdown, a vibrant town offering all modern conveniences, shopping, boutiques, restaurants and various services. Close to Schools, Parks, Trails and most Amenities.
Status:
MLS #: X12076841
Price: $ 1,479,900
Address: 39 John Martin Crescent
Type:
Style: Bungalow
Size: Sq Ft
Age: Years
Front On:
Taxes: $ 6,846
Tax Year: 2024
Lot Size:
Neighbourhood: Rural Flamborough
Nearest Intersection: Concession Road 6 East
City: Hamilton
Postal Code: L8B 0Z9
DOM: 53 Days
Last Update: 2025-04-16 15:36:31
Bedrooms: 5
Bathrooms: 2
Rooms: 0
Kitchens:
Family Room:
Fireplace:
Basement: Full Finished,
Central Vacuum:
Exterior: Aluminum Siding Brick,
Driveway:
Garage: Private Double
Garage Spaces:
Parking Spaces: 8
Pool:
Electricity (Hydro):
Gas:
Phone:
Cable TV:
Heat Type:
Heat Source:
Air Conditioning:
Water:
Sewers: