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 Front
Style: 2-Storey
Size: Sq Ft
Age: Years
Taxes: $ 0 ( 0)
Updated: 2025-03-13 00:20:44
Welcome to this stunning 3,485 sq. ft. home located in the highly sought-after Stoney Creek Mountain community. Designed for modern living, this spacious home offers elegance, comfort, and convenience perfect for families and professionals alike. Property Features: 4 Large Bedrooms Each with its own walk-in closet; 3 Full Bathrooms Upstairs Including a spa-like primary ensuite; Modern Open-Concept Kitchen & Breakfast Area Overlooking the bright and inviting family room; Separate Living Room & Main Floor Office Perfect for entertaining or working from home; 2nd Floor Laundry Added convenience for everyday living; No Front Neighbours Enjoy unobstructed views and enhanced privacy. Prime Location: Close to parks, schools, restaurants, shopping, and transit; Easy access to major highways; Situated in a quiet, family-friendly neighbourhood. This luxurious and move-in-ready home is perfect for tenants seeking a spacious, modern, and well-located rental property. Available for occupancy from A
Status:
MLS #: X12003249
Price: $ 3,700
Address: 52 Cactus Crescent
Type:
Style: 2-Storey
Size: Sq Ft
Age: Years
Front On:
Taxes: $ 0
Tax Year: 0
Lot Size:
Neighbourhood: Stoney Creek Mountain
Nearest Intersection: First Rd W & Bedrock Dr
City: Hamilton
Postal Code: L8J 0M4
DOM: 87 Days
Last Update: 2025-03-13 00:20:44
Bedrooms: 4
Bathrooms: 4
Rooms: 8
Kitchens:
Family Room:
Fireplace:
Basement: Unfinished,
Central Vacuum:
Exterior: Brick Front,
Driveway:
Garage: Private
Garage Spaces:
Parking Spaces: 4
Pool:
Electricity (Hydro):
Gas:
Phone:
Cable TV:
Heat Type:
Heat Source:
Air Conditioning:
Water:
Sewers: