-
243 Queen Street N in Hamilton: 101 - Strathcona Central North Building and Land for sale (10 - Hamilton West) : MLS®# 40857056
243 Queen Street N Hamilton L8R 3N6 
$12,250,000Commercial Sale- Status:
- Active
- MLS® Num:
- 40857056
- Floor Area:
- 2 acre(s)
Fully leased income-producing industrial investment situated on a 7.44-acre site near Hamilton’s West Harbor. The property offers approximately 80,939 SF across three industrial units and is being offered at a 6.73% going-in cap rate, with a 3.8-year WALT and built-in rental escalations. The building features clear heights reaching approximately 54’, eight drive-in doors, and 15-ton and 45-ton cranes. Zoned D2 and P5, with significant land area, ample surface parking and outdoor yard space. An opportunity to acquire a stabilized industrial asset with secure in-place income and contractual rental growth. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
413 Indian Road in Burlington: 303 - Aldershot South Single Family Residence for sale (30 - Burlington) : MLS®# 40861326
413 Indian Road Burlington L7T 3T4
$4,190,000Residential- Status:
- Active
- MLS® Num:
- 40861326
- Bedrooms:
- 6
- Bathrooms:
- 4
- Floor Area:
- 3,720 sq. ft.
A rare opportunity in prestigious Indian Point, one of South Burlington's most exclusive waterfront enclaves, where properties of this scale and setting rarely come to market. Set on nearly an acre with 250 feet of private shoreline, 413 Indian Road delivers the kind of space, privacy and connection to the water that most buyers assume they have to leave the city to find. Country living in the city, with Spencer Smith Park, waterfront festivals, restaurants, shops and bars of downtown Burlington all a short walk away. Keep the boat and toys ready at all times with a 30' x 15' dock, 4 lifts and a double Sea-Doo/kayak float dock. Two driveways, one of them gated, provide parking for 10+ vehicles and enough room for an RV or boat trailer. A pool, hot tub, sauna and firepit sit between the house and the shoreline, joined by multiple sitting and entertaining areas along the water and a 3 hole putting green with sand trap for friendly competition between swims. A separate bunkie adds more flexibility as a teen hangout, guest retreat, studio or quiet workspace. Days begin with coffee on the dock and end with the fire lit as the sun sets over the lake. Boating, swimming, skating in winter, hosting friends and family, unwinding in the sauna or hot tub, all of it happens right here. The residence is equally generous, with over 3,500 square feet of finished living space, 5+1 bedrooms, 3.5 baths, a main floor office, 4 fireplaces and a lower level in-law suite, offering room for extended family, guests and every stage of life. Beyond the lifestyle, the land holds lasting value. Roughly 33,500 sq. ft. of oversized waterfront frontage with a severable configuration provides future flexibility rarely found on Burlington's shoreline. An exceptional chance to own one of Indian Point's signature waterfront properties while staying close to the city, amenities and everyday convenience. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
147 Mary Street in Brantford: 2050 - Echo Place Building and Land for sale (2049 - Echo Place/Braneida) : MLS®# 40848204
147 Mary Street Brantford N3S 3C1
$2,790,000Commercial Sale- Status:
- Active
- MLS® Num:
- 40848204
- Floor Area:
- 12,688 sq. ft.
12,500 SF industrial building situated on a 1.1+ acre fully fenced and secured lot with a large outdoor storage area. The building features 200 Amp/600 Volt electrical service, a full sprinkler system, an open gas furnace and radiant heating, three brand new washrooms, two truck-level shipping doors, and one drive-in door. Recent renovations include a new roof, refinished concrete floors, new water service, LED lighting throughout, new windows, and serviced truck-level and drive-in doors. Clean environmental available More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
307 Martin Street in Milton: 1035 - OM Old Milton Single Family Residence for sale (2 - Milton) : MLS®# 40846214
307 Martin Street Milton L9T 2R7
$2,548,000Residential- Status:
- Active
- MLS® Num:
- 40846214
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 4,008 sq. ft.
A rare blend of luxury, craftsmanship, and thoughtful design, this custom-built home sits on an extra-deep 185-foot lot in the heart of Old Milton. Just steps to charming local restaurants, boutique shops, schools, and parks, it offers both elegance and convenience. Inside, 19-foot ceilings with exposed wood beams create a dramatic first impression. Oversized patio doors lead to a private, peaceful backyard, complete with a composite deck, stunning stone fireplace, and a powered outbuilding ready to become a pool house, studio, or inspiring work-from-home space.The custom kitchen is an entertainers dream, featuring a walk-in pantry and seamless flow into the open-concept living space. The main floor also includes a serene primary suite and a front office with a closet that easily converts into a fifth bedroom.Upstairs, a second primary suite and spacious bedrooms all feature large closets with built-in organizers. Heated floors in every bathroom and laundry room bring elevated comfort. The walk-out basement adds a rec room, wet bar, 3-piece bath, cold cellar, and ample storage.This is more than a home its the lifestyle you've been waiting for. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
9 Flanders Drive in Waterdown: 461 - Waterdown East Single Family Residence for sale (46 - Waterdown) : MLS®# 40862942
9 Flanders Drive Waterdown L8B 0G6 OPEN HOUSE: Sep 19, 202602:00 PM - 04:00 PM EDTOpen House on Saturday, September 19, 2026 2:00PM - 4:00PMOPEN HOUSE: Sep 20, 202602:00 PM - 04:00 PM EDTOpen House on Sunday, September 20, 2026 2:00PM - 4:00PM
$2,299,900Residential- Status:
- Active
- MLS® Num:
- 40862942
- Bedrooms:
- 5
- Bathrooms:
- 5
- Floor Area:
- 5,318 sq. ft.
Welcome to 9 Flanders Drive—an exceptional executive residence nestled in one of Waterdown’s most coveted and established neighbourhoods. Offering over 5,200 sq/ft of beautifully finished living space, this stunning home blends timeless elegance with modern comfort, ideal for families seeking both luxury and functionality. Boasting 4+1 spacious bedrooms and 4.5 bathrooms, this home is thoughtfully designed with generous principal rooms, refined finishes, and a layout that effortlessly accommodates both everyday living and entertaining. The heart of the home features an inviting kitchen and living space, complemented by elegant formal areas and abundant natural light throughout. Step outside to your own private backyard retreat—professionally landscaped and designed for enjoyment. The show-stopping concrete pool is surrounded by lush greenery and ample space for lounging, creating the perfect setting for summer entertaining or quiet relaxation. Located in a prestigious Waterdown pocket known for its executive homes, top-rated schools, parks, and community feel, this is a rare opportunity to own a truly remarkable property in a prime location. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
2205 Shaftesbury Court in Oakville: 1009 - JC Joshua Creek Single Family Residence for sale (1 - Oakville) : MLS®# 40836934
2205 Shaftesbury Court Oakville L6H 6C6
$2,100,000Residential- Status:
- Active
- MLS® Num:
- 40836934
- Bedrooms:
- 5
- Bathrooms:
- 4
- Floor Area:
- 3,000 sq. ft.
Welcome to 2205 Shaftesbury Court, nestled in Oakville’s beloved Joshua Creek community. This stunning 4+1 bedroom home features a thoughtfully designed main floor with a formal living and dining room, eat-in kitchen, and family room, perfect for everyday family living and entertaining. The walkout basement complete with in-law suite offers incredible flexibility for multigenerational families, a teenager retreat, or rental income potential. Sitting at the end of a quiet court, enjoy an extended driveway with ample parking for family and guests. Steps to top-rated Halton district schools, a park, and all the charm that makes Joshua Creek one of Oakville’s most sought-after communities. A home that adapts to every stage of family life, this one is truly special. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
6 Campbell Farm Road in Brantford: 2118 - Oakland Single Family Residence for sale (2115 - SW Rural) : MLS®# 40838640
6 Campbell Farm Road Brantford N3T 5L6
$1,998,000Residential- Status:
- Active
- MLS® Num:
- 40838640
- Bedrooms:
- 3
- Bathrooms:
- 4
- Floor Area:
- 3,182 sq. ft.
Experience the ultimate blend of cutting-edge technology and refined luxury in this exceptional brand-new estate. Set on a private lot with a drilled well and septic system, this impressive 3-bedroom, 3.5-bath home offers a thoughtfully designed open-concept layout with in-floor heating throughout the main level for year-round comfort. Designed for modern living, the home is fully equipped with advanced smart features including Wi-Fi controlled shades, a custom facial recognition smart lock, a premium water treatment system, and an integrated Sonos sound system. The chef-inspired kitchen is a true showpiece, complete with high-end Bosch appliances, a Dacor refrigerator, a built-in coffee station, custom cabinetry, quartz countertops, and striking oversized tile flooring. The living space is warm and inviting, highlighted by a custom Heat & Glo fireplace and seamless flow for entertaining. The primary suite offers a spa-like retreat with a luxurious ensuite featuring multiple body sprayers, a hydrotherapy tub, heated towel rack, Bluetooth mirrors, and designer lighting. Entertainment continues in the fully equipped home theatre with premium audio-visual components and a large projection screen, perfect for movie nights. Step outside to your own private oasis featuring a saltwater pool, a fully outfitted natural gas outdoor kitchen, granite fireplace, and wiring for outdoor entertainment—ideal for hosting or relaxing in style. Built with quality and longevity in mind, this home also includes a high-capacity septic system, two-stage leaching bed, and a durable 40-year fiberglass roof. A rare offering that perfectly combines luxury, comfort, and innovation. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
4202 1 Side Road in Burlington: 380 - North Burlington Rural Single Family Residence for sale (38 - Burlington) : MLS®# 40859211
4202 1 Side Road Burlington L7M 0X3
$1,779,900Residential- Status:
- Active
- MLS® Num:
- 40859211
- Bedrooms:
- 6
- Bathrooms:
- 3
- Floor Area:
- 3,473 sq. ft.
WHAT IF THE LIFE YOU’VE ALWAYS DREAMED OF ISN’T HOURS OUTSIDE THE CITY... BUT FIVE MINUTES FROM EVERYTHING? There’s a moment when you turn onto 1 Side Road when Burlington starts to disappear. Traffic fades, lots open up, & farmland stretches out around you as Mt. Nemo & the Niagara Escarpment rise in the distance. Welcome to 4202 1 Side Road, where everyday life feels like a private retreat, yet the conveniences of Appleby & Dundas are approx 5 mins away. Inside, 2,218 sf above grade plus a fully finished W/O lower level gives a growing family total freedom to live, work, & entertain. At its heart is a reno'd chef’s kitchen featuring custom cabinetry, quartz counters, built-in s/s appliances, radiant heated tile floors, & a showpiece live-edge island, flowing naturally through the main living spaces into the sunroom & out to the elevated rear deck. With 3 bedrooms up, 3 down, 3 full bathrooms with heated floors, & a fireside family room below, there is room for everyone to carve out their own space. And just when you think you’ve seen it all, look above the garage. Waiting there is 500 sf of newly finished bonus space, completely separated from the main living quarters & ready to become an executive home office, creative studio, gym, or homeschool room. Outside, the property comes alive: morning coffee overlooking open countryside, summer dinners beneath the covered patio, kids claiming the backyard bunkie, & friends gathered around the stone fire-pit as the sun sets behind the escarpment. With high-speed fibre-optic internet, 200-amp electrical service, generator wiring, connected well and cistern with UV/carbon filtration, & recently restored asphalt driveway using a professional seal coating service giving it a refreshed look & protecting it against weathering, with parking for 6-8 vehicles, country living comes with zero compromise. Quick access to Hwy 407 & the Bruce Trail. Most people spend their weekends driving somewhere to escape. Here, you just come home. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
54 Mayfair Avenue in Dundas: 413 - Highland Park Single Family Residence for sale (41 - Dundas) : MLS®# 40862337
54 Mayfair Avenue Dundas L9H 3L1 OPEN HOUSE: Sep 19, 202602:00 PM - 04:00 PM EDTOpen House on Saturday, September 19, 2026 2:00PM - 4:00PMOPEN HOUSE: Sep 20, 202602:00 PM - 04:00 PM EDTOpen House on Sunday, September 20, 2026 2:00PM - 4:00PM
$1,750,000Residential- Status:
- Active
- MLS® Num:
- 40862337
- Bedrooms:
- 5
- Bathrooms:
- 3
- Floor Area:
- 2,800 sq. ft.
Fully renovated since 2021, this custom-designed bungalow has been meticulously curated by designer Alison Knapp and is nestled in one of Dundas’s most sought-after neighbourhoods. Offering 2600sqft of total living space, 3+2 bedrooms and 3 full bathrooms, the home blends timeless design with a modern, sophisticated aesthetic and thoughtful functionality throughout. A grand family room anchors the main living space, flowing seamlessly into the chef’s kitchen, complete with a beautifully crafted statement island, refined glass details, and large windows that fill the home with natural light. Every space has been thoughtfully considered, creating a warm and inviting atmosphere that feels both elevated and effortlessly livable. The spacious primary suite features two closets and a spa-like ensuite complete with a walk-in shower and oversized soaker tub. The fully finished basement offers walk-up access and exciting future in-law suite potential, providing additional flexibility for family, guests, or entertaining. Step outside to your private, beautifully landscaped yard complete with an in-ground saltwater pool; a peaceful retreat and the perfect setting for summer entertaining. Local trails are just a short walk away, while Dundas’s historic downtown is only steps from your door. A rare opportunity to own a beautifully renovated home where timeless design, modern comfort, and an exceptional location come together effortlessly. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
571 Leonard Court in Burlington: 303 - Aldershot South Single Family Residence for sale (30 - Burlington) : MLS®# 40861609
571 Leonard Court Burlington L7T 2P4
$1,649,000Residential- Status:
- Active
- MLS® Num:
- 40861609
- Bedrooms:
- 4
- Bathrooms:
- 3
- Floor Area:
- 2,129 sq. ft.
Tucked into one of Aldershot’s most sought-after pockets, this fully renovated 4-level sidesplit offers over 2,100 sq. ft. of total living space of beautifully finished living space on a quiet cul-de-sac court with no through traffic. From the moment you arrive, the private covered front porch sets the tone for a home designed to be enjoyed. Inside, a striking designer archway off the foyer creates a beautiful sightline through to the custom kitchen and beyond to the backyard through new sliding doors. The thoughtfully designed kitchen features natural stone countertops and backsplash, skinny shaker cabinetry, and a refined, timeless aesthetic. The living room is anchored by a gas fireplace and tailored built-ins, while the dining area is filled with natural light and complemented by built-in bench storage. A generous eat-in space completes the main level. Upstairs, two spacious bedrooms share a beautifully updated 3-piece bath with a walk-in shower, while the private primary suite features its own ensuite — a rare and coveted feature in Aldershot. A few steps down, the fourth bedroom offers an oversized window and exceptional flexibility as a guest room, home office or additional living space. This level also includes a convenient mudroom and laundry, powder room, and direct interior access to the attached garage. The finished basement provides a cozy retreat tucked away from the main living spaces, ideal for movie nights, a home gym, playroom or quiet escape. Outside, the fully landscaped backyard is made for summer entertaining, relaxing and gathering with friends and family. Set on an impressive 70 x 120 ft lot and just steps from Burlington Golf & Country Club, with easy highway access via King Road, this solid-brick home combines thoughtful design, extensive renovations and an exceptional Aldershot location. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
775 4th Concession Road Enr: Fairground Agriculture for sale (Houghton) : MLS®# 40837654
775 4th Concession Road Enr Fairground N0E 1G0
$1,599,000Farm- Status:
- Active
- MLS® Num:
- 40837654
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 2,199 sq. ft.
Welcome to your private countryside escape—where lifestyle meets opportunity. Set on just under 50 acres of peaceful forest and open land, this exceptional hobby farm offers not only a stunning place to call home, with a fully functioning Airbnb or guest retreat. Approximately 40 acres of scenic wooded trails invite year-round exploration, while just under 10 acres of workable land with an irrigation pond provide space for farming, recreation, or expansion. The beautifully maintained 3-bedroom, 2-bath raised bungalow showcases pride of ownership throughout, featuring a newer steel roof, propane furnace, main floor laundry, a carport, and a spacious deck to soak in the tranquil surroundings. What truly sets this property apart is the fully equipped, four-season guest house—complete with hydro, hot water, propane heating, full bathroom, and 2-bed loft. Whether hosting short-term rentals, extended family, or creating a private retreat experience, the setup is generating additional income. The property continues to impress with a large barn/workshop and outbuildings (all with hydro and water), a backup propane generator servicing the entire property, and two solar panel systems providing supplemental monthly income. Thoughtful extras include landscaped gardens with a pond, a dedicated art studio/garden shed. A rare opportunity to own a turn-key rural retreat with built-in income potential—perfect for those looking to live, host, and invest all in one place. More detailsListed by Real Broker Ontario Ltd.- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
-
775 4th Concession Road Enr: Fairground Single Family Residence for sale (Houghton) : MLS®# 40837645
775 4th Concession Road Enr Fairground N0E 1G0
$1,599,000Residential- Status:
- Active
- MLS® Num:
- 40837645
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 2,199 sq. ft.
Welcome to your private countryside escape—where lifestyle meets opportunity. Set on just under 50 acres of peaceful forest and open land, this exceptional hobby farm offers not only a stunning place to call home, with a fully functioning Airbnb or guest retreat. Approximately 40 acres of scenic wooded trails invite year-round exploration, while just under 10 acres of workable land with an irrigation pond provide space for farming, recreation, or expansion. The beautifully maintained 3-bedroom, 2-bath raised bungalow showcases pride of ownership throughout, featuring a newer steel roof, propane furnace, main floor laundry, a carport, and a spacious deck to soak in the tranquil surroundings. What truly sets this property apart is the fully equipped, four-season guest house—complete with hydro, hot water, propane heating, full bathroom, and 2-bed loft. Whether hosting short-term rentals, extended family, or creating a private retreat experience, the setup is generating additional income. The property continues to impress with a large barn/workshop and outbuildings (all with hydro and water), a backup propane generator servicing the entire property, and two solar panel systems providing supplemental monthly income. Thoughtful extras include landscaped gardens with a pond, a dedicated art studio/garden shed. A rare opportunity to own a turn-key rural retreat with built-in income potential—perfect for those looking to live, host, and invest all in one place. More detailsListed by Real Broker Ontario Ltd. and REAL BROKER ONTARIO LTD BROKERAGE- IRENA TUNJIC
- REAL BROKER ONTARIO LTD., BROKERAGE
- 1 (905) 5363235
- Contact by Email
Data was last updated September 18, 2026 at 05:50 AM (UTC)
Irena Tunjic
Office Address:
130 King Street W, Suite 1900
Toronto, ON, M5X 1E3
