Office Listings
1-3/3
-
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.585 m2
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.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- 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.451 m2
Rare opportunity with so much 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.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
147 HOMEWOOD Avenue in Hamilton: Multi-family for sale : MLS®# 40806334
147 HOMEWOOD Avenue Hamilton L8P 2M6 $899,900Multi-family- Status:
- Active
- MLS® Num:
- 40806334
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 2,092 sq. ft.194 m2
Located in the heart of Hamilton’s coveted Kirkendall neighbourhood, this spacious 2.5-stry home w/ 2 self-contained units presents an exceptional opportunity. Well-maintained & thoughtfully configured, the home's units each have separate rear decks & both are currently tenanted on a month-to-month basis. Tenants pay their own hydro, & financials are available upon request. The charming covered front porch sets a welcoming tone, while the front vestibule w/ 2 separate unit entry doors provides private access to each suite. Unit 1 (main lvl + bsmt access) offers a bright & inviting 1 bdrm, 1 bath layout highlighted by hardwood flooring throughout & oversized trim and mouldings. The form liv rm feat coved ceil, a FP (as-is) w/ wood mantle, & a large bay window overlooking the front yard. The updated kitch has white cab, S/S app, & a tiled backsplash, opening to a sep din area w/ expansive windows overlooking the yard & has access to a private rear deck. The bdrm incl a storage closet, while the 3-pc bath feat a walk-in shower & updated vanity. The unspoiled bsmt offers laund & ample storage. Unit 2 (2nd + 3rd lvls) is accessed from the vestibule via a private staircase leading to a generous 2nd-lvl liv rm w/ 2 large bay windows & a FP (as-is). The updated kitch mirrors the main lvl w/ white cab, S/S app, & tiled backsplash, while the din rm provides access to an oversized upper balcony w/ a metal fire escape to the yard. This lvl also includes laund facilities & an updated 4-pc bath w/ a shower/tub combination. The 3rd lvl offers 2 generously sized bdrms, creating a comfortable and private living space. At the rear of the property, surfaced parking for 2 vehicles is conveniently accessed via the alley connecting Locke St S to Dundurn St S. The location is exceptional - just steps from the vibrant shops, restaurants, cafés, and boutiques of Locke Street South. A rare opportunity to own a character-filled income property in one of Hamilton’s premier neighbourhoods. (id:2493) More detailsListed by Royal LePage State Realty Inc.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
1-3/3
Data was last updated May 13, 2026 at 09:45 AM (UTC)
REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR®
Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These
certification marks identify real estate professionals who are members of CREA and who
must abide by CREA’s By‐Laws, Rules, and the REALTOR® Code. The MLS® trademark and the
MLS® logo are owned by CREA and identify the quality of services provided by real estate
professionals who are members of CREA.
The information contained on this site is based in whole or in part on information that is provided by
members of The Canadian Real Estate Association, who are responsible for its accuracy.
CREA reproduces and distributes this information as a service for its members and assumes
no responsibility for its accuracy.
Website is operated by a brokerage or salesperson who is a member of The Canadian Real Estate Association.
The listing content on this website is protected by copyright and
other laws, and is intended solely for the private, non‐commercial use by individuals. Any
other reproduction, distribution or use of the content, in whole or in part, is specifically
forbidden. The prohibited uses include commercial use, “screen scraping”, “database
scraping”, and any other activity intended to collect, store, reorganize or manipulate data on
the pages produced by or displayed on this website.
My Featured Listings
113 NIAGARA Street
$429,900
Royal LePage State Realty Inc.
314 MAIN Street East
Royal LePage State Realty Inc.




