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: $ 7,947 ( 2024)
Updated: 2025-05-01 14:39:30
Welcome to 57 Orr Crescent! This custom-built 4 Bedroom, 3 Bathroom family home is located in a beautiful enclave on the Stoney Creek Plateau nestled just under the Niagara Escarpment with spectacular views of the lake. On the main level are a grand foyer with high ceilings, separate living room, dining room, family room with fireplace, office, and bright eat-in kitchen with large windows overlooking the backyard. On this level are also a powder room and convenient laundry. On the upper lever are a spacious Primary Suite with walk-in closet and 4-piece en-suite with jetted bathtub; 3 more good sized bedrooms and a shared 5-piece bath, also with jetted bathtub. Large basement awaiting your finishing touches. Unique wine cellar located under the garage, perfect for bringing out the wine-maker in you. 2 car garage and 4 car driveway. This is a great property in a wonderful location, close to parks, trails, shops, restaurants and the many wineries of Niagara Wine Country. Easy access to QE
Status:
MLS #: X12107365
Price: $ 1,199,900
Address: 57 Orr Crescent
Type:
Style: 2-Storey
Size: Sq Ft
Age: Years
Front On:
Taxes: $ 7,947
Tax Year: 2024
Lot Size:
Neighbourhood: Stoney Creek
Nearest Intersection: Adriatic Blvd and Orr Crescent
City: Hamilton
Postal Code: L8G 5C5
DOM: 39 Days
Last Update: 2025-05-01 14:39:30
Bedrooms: 4
Bathrooms: 3
Rooms: 0
Kitchens:
Family Room:
Fireplace:
Basement: Unfinished,
Central Vacuum:
Exterior: Brick Stone,
Driveway:
Garage: Private Double
Garage Spaces:
Parking Spaces: 6
Pool:
Electricity (Hydro):
Gas:
Phone:
Cable TV:
Heat Type:
Heat Source:
Air Conditioning:
Water:
Sewers: