OFFICE LISTINGS
-
347 QUEEN Street S in Hamilton: Multi-family for sale : MLS®# 40821461
347 QUEEN Street S Hamilton L8P 3T8 
$1,999,000Multi-family- Status:
- Active
- MLS® Num:
- 40821461
- Bedrooms:
- 10
- Bathrooms:
- 6
- Floor Area:
- 6,295 sq. ft.
An extraordinary opportunity to own one of Hamilton’s most iconic residences. Known as the “Queen St Castle,” this circa 1881 Victorian masterpiece commands a prominent corner in the Durand neighbourhood at the base of the escarpment. With its signature turret and timeless architectural detail, this historically significant home stands among the city’s most admired properties. Rich in character and carefully preserved, it offers exceptional flexibility. Grandfathered as a legal non-conforming triplex, it presents a rare opportunity to create a stunning single-family estate, maintain a strong income property, or live in one unit while generating revenue. Inside, the original charm blends w/ impressive scale—soaring ceilings, intricate period details, and 6 fireplaces, including a wood-burning fireplace on the main level. Outside, a fully fenced yard offers privacy and ample space for entertaining, complemented by a rare triple-car covered carport and additional parking accommodating up to 10 vehicles. Many recent updates include a new boiler in 2026, carport roof 2023, flat roof 2025, new porch, steps and railings 2024, and so much more. Located just steps to Locke Street boutiques and dining, and easy walking distance to Augusta, James, and Hess Village. Enjoy easy access to the escarpment and Bruce Trail, close proximity to hospitals, McMaster University, Mohawk College, GO stations and transit routes. A rare offering of architectural significance, income potential and lifestyle. (id:2493) More detailsListed by Royal LePage State Realty Inc.
- GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
-
311 BROCK Road in Hamilton: Multi-family for sale : MLS®# 40823983
311 BROCK Road Hamilton L9H 5H4
$1,375,423Multi-family- Status:
- Active
- MLS® Num:
- 40823983
- Bedrooms:
- 6
- Bathrooms:
- 3
- Floor Area:
- 4,855 sq. ft.
Rare opportunity with endless possibilities . Beautifully restored & updated 1870's century triple brick home with side addition with charm & character of yesteryear. Original red pine plank flooring, old growth ashwood 14 hi baseboards & 10ft high ceilings on original main level. Beautiful updated kitchen w/oak hardwood flooring & bath on a mature treed lot backing onto conservation/ravine of large 275 x 253 irregular treed lot. Loads of parking, above Dundas in the desireable Village of Greensville near Hwy's #5 & #8 (commuters!) Same owner lived in since '03 with 2 additional units for extra income, zoned settlement commercial non conforming. Previous side addition used for Art Studio. Many possibilities B&B/live in/rent others/small business. Seller does not warrant its existing use or zoning. Upgrades: 200 amp hydro, 2 sep gas meters , 2 gas furnaces '22, heat pump'25, air ducts on mnflr'21, windows 6 on mn fl, 4 on 2nd flr '22, eaves back building'25, kitchen/bth main '23, roof main house'13, flat roof back building '16, septic & alarm '12 commercial 5,450litre '24, h20 pressure & softner '24, heat 2nd flr electric bsboards/oil rads, 2 partial unfinished basements. permits obtained for interior modification of Art Studio to 2 bedroom apartment '09. (id:2493) More detailsListed by Royal LePage State Realty Inc. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
-
OPEN HOUSE: 358 DUNDAS Street E in Hamilton: Multi-family for sale : MLS®# 40830141
358 DUNDAS Street E Hamilton L0R 2H1 OPEN HOUSE: Jul 12, 202602:00 PM - 04:00 PM EDTOpen House on Sunday, July 12, 2026 2:00PM - 4:00PM
$998,880Multi-family- Status:
- Active
- MLS® Num:
- 40830141
- Bedrooms:
- 4
- Bathrooms:
- 2
- Floor Area:
- 2,800 sq. ft.
VACANT OCCUPANCY AVAILABLE. This side-by-side duplex offers two spacious 2-bedroom, 1-bathroom units. Each unit has fully separated utilities and two dedicated parking spaces, keeping operating costs low and providing convenience for tenants. More than $150,000 in recent upgrades have been completed including plumbing, electrical, HVAC systems, kitchens, windows, siding, doors, and exterior improvements. Both units can be delivered vacant, offering flexibility for investors or owner-occupiers looking to live in one unit and rent the other. Located in the heart of downtown Waterdown, the property is steps from shopping, coffee shops, and restaurants, and only a 10-minute drive to the Aldershot GO station. (id:2493) More detailsListed by Royal LePage State Realty Inc.- GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
-
258-260 EMERSON Street in Hamilton: Multi-family for sale : MLS®# 40836416
258-260 EMERSON Street Hamilton L8S 2Y6
$599,900Multi-family- Status:
- Active
- MLS® Num:
- 40836416
- Bedrooms:
- 6
- Bathrooms:
- 2
- Floor Area:
- 1,785 sq. ft.
Rare investment opportunity in West Hamilton (258-260 Emerson Street) Featuring 2 side-by-side semi detached homes on a generous 50 x 135 ft lot, just minutes from McMaster University. Each home offers a functional layout with a family room, kitchem and bedroom on the main level, plus 2 additional bedrooms and a full bathroom upstairs. Incredible potential for investors, developors, renovators, or owner-occupants. Renovate and lease both homes, live in one and rent the other, or support for 2 side-by-side duplexes (4 units total), with potential for an accessory dwelling unit (ADU) at the rear, subject to municipal approvals. Prime location close to McMaster, trails, future LRT, transit, highway access, shopping, and amenities. Fantastic opportunity with multiple potential uses in a highly desirable area. (id:2493) More detailsListed by Royal LePage State Realty Inc.- GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
Data was last updated July 10, 2026 at 10:45 AM (UTC)
Girard Team
Get in touch
Girard Team
1122 Wilson Street West
Ancaster,
ON,
L9G 3K9
