227 John Street N, Hamilton

Prime Mixed-Use Opportunity in Downtown Stoney Creek! Fully updated within the last 10 years, this newer building features one main-floor retail/office space and two residential units above. Zoned C5A, it offers incredible flexibility-perfect for medical, professional, or service-based businesses. High-visibility location with ample parking. Run your business on the main level and generate strong rental income upstairs. Bonus: all three units have separate hydro and gas meters. Own it. Operate it. Profit from it.

Escape to the quiet beauty of country living amid views of nature in every direction. Tucked away in a peaceful setting, this beautifully updated 3 + 1 bedroom home offers the perfect balance of tranquility and modern comfort-where every season can be enjoyed from the comfort of home.The exterior of the home has experienced a thoughtful transformation, including extensive landscaping, and the inside has been renovated throughout including the addition of stunning natural pine flooring, creating warmth and timeless character. At the heart of the home is a redesigned kitchen with top-end appliances and moveable butcher block island. The charming three-season sitting room ('25) and expansive new deck invite you to slow down, unwind, and soak in the beauty that surrounds you. The unique loft bedroom (added '25) above the garage offers incredible flexibility-ideal as a private guest retreat (w/ Murphy bed), home office, creative studio, or peaceful escape. All bathrooms have been updated and a new 3 piece bathroom was added to the 2nd floor. The primary suite is calming and serene with ample closet space and a stunning 4 piece ensuite. Adding to the home's unique character, both the primary and 2nd bedrooms feature their own loft spaces-inviting retreats that offer endless possibilities. The lower level offers a 4th bedroom with walkout access to the rear yard. Whether you're enjoying your morning coffee, hosting family and friends, or simply taking in the peaceful views, this is a cottage-like home has been curated to reconnect you with nature. Geo thermal heating and cooling. Driveway and Amish-built shed ('25). Idyllic rural setting just a short drive from Ancaster & Dundas conveniences. Close to tails and Conservation area. Peace. HWT & Propane tank rented. RSA.

Experience the perfect blend of luxury, comfort, and modern design in this stunning 6-bedroom, 4-bathroom home, beautifully positioned in one of Waterdown's most prestigious and serene neighbourhoods. Featuring a sleek modern elevation, main floor bedroom suite, and basement walk-up, this residence offers exceptional curb appeal and an elevated lifestyle. Step inside to a bright, sophisticated main floor with 10' smooth ceilings, upgraded tile flooring, wide-plank-stained hardwood, and a convenient full bathroom-ideal for guests or multigenerational living. The open-concept layout flows seamlessly into a high-end upgraded kitchen, complete with quartz countertops, built-in oven, gas cooktop, and JennAir refrigerator, perfect for both everyday living and entertaining. The second level continues the upscale feel with 9 ft ceilings, spacious bedrooms, and a versatile loft that can serve as a lounge, office, or playroom. Both staircases feature elegant, stained wood with iron spindles, adding to the home's elevated aesthetic. The basement walk-up offers incredible potential-ideal for extended family, recreation, or future income possibilities. Located just minutes from major amenities and offering easy access to Highway 407 and the Burlington border, this home combines luxury with unbeatable convenience. Enjoy the comfort of one of Waterdown's biggest homes! RSA.