Office Listings
-
858 KING Street W in Hamilton: Other for sale : MLS®# 40769311
858 KING Street W Hamilton L8S 1K3 
$2,298,900Other- Status:
- Active
- MLS® Num:
- 40769311
- Floor Area:
- 6,962 sq. ft.
Rare offering of 2 mixed use retail/commercial and residential buildings on one lot. High visibility and traffic street in Westdale. Close to parks, schools, religious institutions, dining and entertainment, McMaster U, Columbia College, McMaster Innovation Park, McMaster Pediatrics Hospital (HHS) & public transit, mins to QEW, Westdale Village and downtown Hamilton, Locke St shopping and dining. 856-858 King St W includes two retail units on the first floor and one spacious 2+1 bedroom residential unit on the second floor. 850-854 includes 3 retail units and one 4 bedroom residential unit above and 8 parking spaces at rear of the buildings for tenants. Plenty of street parking. The two buildings must be purchased together. (id:2493) More detailsListed by Royal LePage State Realty Inc.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
3 TURNER Avenue in Hamilton: Single Family for sale : MLS®# 40818003
3 TURNER Avenue Hamilton L8P 3K4
$2,199,900Single Family- Status:
- Active
- MLS® Num:
- 40818003
- Bedrooms:
- 6
- Bathrooms:
- 4
- Floor Area:
- 5,522 sq. ft.
Much-admired century home on a coveted and prestigious cul-de-sac nestled beneath the escarpment in Durand, Hamilton’s unique heritage enclave. This c.1910 beauty sits on an impressive 80x140ft lot, w. 6-bdrms, 4-bths & 5500+sqft. Soaring ceilings (10ft/main flr, 9.5ft/2nd), centre hall, hardwood floors, French & pocket doors, heated marble floors, clawfoot tub, one-of-a-kind fireplaces + upgrades galore (electrical, heat/a/c, concrete drive & patios, in-ground sprinklers & landscape lighting +++). Crystal chandeliers & tall dual-aspect windows flood principal rooms with light, while mature trees, an elevated position and deep front garden assure privacy. Irreplaceable craftsmanship throughout, notably in the large, Georgian-inspired dining room and serene main floor study with carved stone f/pl, ornate cornice & breathtaking panelling. Beautiful sunroom w. bespoke cabinetry & heated floor. Sunken family room w. skylight & walk-out to patio off sunny kitchen w. huge island & deck access for al fresco dining. Entertaining here is a dream, with further possibilities in the multiple garden areas. Spacious bedrooms, one w. anteroom, ideal for multigenerational living. Show-stopping staircase with window-lined landing sits to the side of the airy barrel-ceilinged foyer, enhancing flow & privacy, while a second stairway gives fast access to upper levels, incl. laundry room, teen/nanny/guest suite & gym. The quality of materials and details, from trim & mouldings to fine wood doors & hardware, imbue the home with a quiet elegance that must be seen to be appreciated. With private parking for 5 and a short walk to the GO train, this distinguished address offers a rare lifestyle balance: quiet, leafy tranquility within easy reach of the best schools, shops, cultural landmarks and parks. From waterfalls to cafes, this friendly, walkable neighbourhood has it all. Exceptional opportunity not to be missed to enjoy a true forever home on one of the city’s most desirable streets. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
14 NORTH RIDGE Terrace in Kitchener: Single Family for sale : MLS®# 40714630
14 NORTH RIDGE Terrace Kitchener N2A 2S5
$1,999,000Single Family- Status:
- Active
- MLS® Num:
- 40714630
- Bedrooms:
- 4
- Bathrooms:
- 6
- Floor Area:
- 4,720 sq. ft.
BRAND NEW MODERN LUXURY HOME backing onto Chicopee Park & Ski Resort! Proudly presented by Hanna Homes, a reputable high-end luxury builder with successful projects across Ontario. Only 14 homes will be built in this upscale subdivision accessed by a new private road ‘North Ridge Terrace’ surrounded by nature and lush forestry for optimal privacy. Lot 14 offers 3654 square feet of luxurious living space above grade. For a limited time, the builder is also including an additional 1066 square foot finished basement for a total of 4720 square feet. This spectacular two-storey walk-up home is elevator-ready and has a triple car (tandem) garage. Built with superior construction, exceptional quality and a pristine attention to detail using the highest level of materials and craftsmanship – designed for the most discerning buyers. The main level will feature impressive principal rooms with a gas fireplace and floor-to-ceiling windows allowing for beautiful natural light. A stunning gourmet kitchen designed for entertaining or culinary experts will be the perfect accompaniment. The upper level will feature 4 spacious bedrooms each with their own ensuite bathroom including an exquisite primary suite with a private glass balcony to enjoy breathtaking views of Chicopee Park. The Chicopee Heights neighbourhood is conveniently located with easy access to schools, shopping, restaurants, and highways (7, 8, 85 and 401). For outdoor enthusiasts, there is direct access to walking trails literally in your backyard as well as the Chicopee Ski and Tube Park. The private road will offer snow removal, private garage removal and common elements with a $185 per month road fee. This incredible Kitchener location is only an hour from Toronto. A full information package is available including approved home designs and drawings. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
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. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
347 QUEEN Street S in Hamilton: Single Family for sale : MLS®# 40821438
347 QUEEN Street S Hamilton L8P 3T8
$1,999,000Single Family- Status:
- Active
- MLS® Num:
- 40821438
- 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. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
397 KING Street W Unit# 215 in Dundas: Condo for sale : MLS®# 40816633
397 KING Street W Unit# 215 Dundas L9H 1W9
$1,995,000Single Family- Status:
- Active
- MLS® Num:
- 40816633
- Bedrooms:
- 2
- Bathrooms:
- 2
- Floor Area:
- 2,399 sq. ft.
Stunning penthouse-inspired luxury at the District Lofts! Circa 1929, this boutique building was completely rebuilt in 2013 and offers just 44 unique residences. Unit 215 is one of the largest in the building, presenting a rare opportunity for the discerning buyer. An oversized double-car garage and private entrance create a true home-like feel without the exterior maintenance. Experience the grandeur of this loft-style, two-storey condo featuring a spectacular open-concept living space filled with natural light, soaring 17-ft ceilings, and a dramatic Restoration Hardware chandelier, all complemented by breathtaking views of Dundas Peak. The gourmet kitchen is both elegant and functional, showcasing extended-height cabinetry, high-end appliances, quartz countertops, and a large island with seating for six—perfect for entertaining. This residence offers two spacious bedrooms and two spa-like bathrooms with upgraded fixtures. Additional features include two private balconies, full-sized laundry, and extensive custom closet storage. Premium upgrades throughout include custom trim and millwork, Swarovski crystal hardware, and motorized blinds. The building features state-of-the-art in-floor radiant heating, and this unit includes a brand-new A/C system. Amenities at the Lofts include a fitness studio, a large exclusive locker, and a rooftop patio—ideal for entertaining or relaxing while enjoying the views and tranquil sounds of the nearby waterfall. Ideally located at the foot of Dundas Peak, just steps to the Bruce Trail, Webster’s Falls, Dundas Valley Golf & Curling Club, and the historic downtown core, offering a vibrant mix of shops and restaurants. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
521 BAPTIST CHURCH Road in Brantford: Single Family for sale : MLS®# 40723370
521 BAPTIST CHURCH Road Brantford N3W 2G9
$1,900,000Single Family- Status:
- Active
- MLS® Num:
- 40723370
- Bedrooms:
- 5
- Bathrooms:
- 1
- Floor Area:
- 2,229 sq. ft.
Discover the perfect blend of charm and functionality on this picturesque 99-acre hobby farm, featuring a delightful Century frame home. Approximately 75 acres of workable land are currently leased, offering both beauty and income potential. The gently rolling landscape is enhanced by a meandering creek and mature trees, including majestic blue spruce and white pine. A 30' x 50' implement shed provides ample space for equipment and storage. Nestled in a peaceful rural setting, this property enjoys a central location with easy access to Ancaster, Caledonia, and Brantford. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
521 BAPTIST CHURCH Road in Brantford: Agriculture for sale : MLS®# 40730227
521 BAPTIST CHURCH Road Brantford N3W 2G9
$1,900,000Agriculture- Status:
- Active
- MLS® Num:
- 40730227
- Bedrooms:
- 5
- Bathrooms:
- 1
- Floor Area:
- 2,229 sq. ft.
Discover the perfect blend of charm and functionality on this picturesque 99-acre hobby farm, featuring a delightful Century frame home. Approximately 75 acres of workable land are currently leased, offering both beauty and income potential. The gently rolling landscape is enhanced by a meandering creek and mature trees, including majestic blue spruce and white pine. A 30' x 50' implement shed provides ample space for equipment and storage. Nestled in a peaceful rural setting, this property enjoys a central location with easy access to Ancaster, Caledonia, and Brantford. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
6128 HIGHWAY 3 in Canfield: Agriculture for sale : MLS®# 40803637
6128 HIGHWAY 3 Canfield N0A 1C0
$1,799,900Agriculture- Status:
- Active
- MLS® Num:
- 40803637
- Bedrooms:
- 6
- Bathrooms:
- 4
- Floor Area:
- 3,620 sq. ft.
Set on over 107 acres in the heart of Canfield, this property includes multiple natural ponds and approximately 80 acres of workable farmland, making it well suited for agricultural use, livestock, or those seeking significant acreage with long term flexibility. Improvements include a 50 x 100 steel building with concrete floor, a 50 x 95 coverall building, and two fenced paddocks, supporting a wide range of farming or storage needs. The beautifully renovated bungalow features a 3 bedroom, 2 bathroom main floor with an attached 2 car garage. The lower level is fully framed and roughed in with electrical, plumbing, and HVAC, offering the potential for an additional 3 bedrooms, 2 bathrooms, and a large family room with a wood burning fireplace and separate entrance. With three wells on the property and substantial future living space already in place, this rural estate offers multi-family functionality, and room to grow. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
6128 HIGHWAY 3 in Canfield: Single Family for sale : MLS®# 40803606
6128 HIGHWAY 3 Canfield N0A 1C0
$1,799,900Single Family- Status:
- Active
- MLS® Num:
- 40803606
- Bedrooms:
- 6
- Bathrooms:
- 4
- Floor Area:
- 3,620 sq. ft.
Set on over 107 acres in the heart of Canfield, this property includes multiple natural ponds and approximately 80 acres of workable farmland, making it well suited for agricultural use, livestock, or those seeking significant acreage with long term flexibility. Improvements include a 50 x 100 steel building with concrete floor, a 50 x 95 coverall building, and two fenced paddocks, supporting a wide range of farming or storage needs. The beautifully renovated bungalow features a 3 bedroom, 2 bathroom main floor with an attached 2 car garage. The lower level is fully framed and roughed in with electrical, plumbing, and HVAC, offering the potential for an additional 3 bedrooms, 2 bathrooms, and a large family room with a wood burning fireplace and separate entrance. With three wells on the property and substantial future living space already in place, this rural estate offers multi-family functionality, and room to grow. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
100 WATERSHORE Drive Unit# 7 in Stoney Creek: Single Family for sale : MLS®# 40817642
100 WATERSHORE Drive Unit# 7 Stoney Creek L8E 0C1
$1,758,000Single Family- Status:
- Active
- MLS® Num:
- 40817642
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 3,721 sq. ft.
Brand-New Lake-Facing Home in Project of the Year Award-Winning Community- The Residences at Watershore! Don’t miss this rare opportunity to own a stunning 4-bedroom, 4.5-bathroom, 4 car driveway home on premium corner lot just steps from Lake Ontario. This home features a custom layout that has been professionally designed with elevated finishes. The bright, open-concept main level features 12x24 tiles, engineered hardwood flooring, oak stairs to both the upper and lower levels, and a thoughtfully designed main floor den with reeded glass door. At the heart of the home, the chef-inspired kitchen is a true statement featuring a striking two-tone cabinet design, extended height cabinetry, quartz countertop with full-height quartz backsplash. Premium details like the panel-ready fridge and dishwasher with decorative hood fan complete the kitchen’s timeless and elevated aesthetic. The large living and dining areas are anchored by a gas fireplace with custom wood mantle, perfect for relaxing or entertaining. A dedicated mudroom adds convenience and function. Upstairs, retreat to the lake-facing primary suite, complete with private balcony, walk-in closet with custom organizers, and a spa-like ensuite featuring a freestanding tub, custom glass shower, double sinks & quartz counters. The second bedroom includes its own ensuite with a roll-top shower and quartz vanity. Two additional spacious bedrooms share easy access to a well-appointed main bath. The second-floor laundry room includes a washer, dryer and built-in cabinetry and counter space for added function. The fully finished basement features 9-foot ceilings, larger windows for increased natural light, vinyl plank flooring and 3-piece bathroom—ideal for a home gym, guest retreat, or family room. Located just minutes from the QEW, top-rated schools, shopping, and everyday amenities. Take advantage of the temporary HST exemption on new homes- Price shown is exclusive of HST and assumes HST rebate eligibility. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
483 VALRIDGE Drive in Ancaster: Single Family for sale : MLS®# 40819001
483 VALRIDGE Drive Ancaster L9G 0B2
$1,699,999Single Family- Status:
- Active
- MLS® Num:
- 40819001
- Bedrooms:
- 4
- Bathrooms:
- 4
- Floor Area:
- 3,782 sq. ft.
Stunning 4-bed home in Ancaster's coveted Parkview Heights with an incredible backyard oasis featuring a heated inground saltwater pool. tiki bar, covered decks, and sunny patios overlooking greenspace, pond, and woods. Inside, a soaring foyer leads to the chef's kitchen with maple cabinetry, gas cooktop, double wall ovens, pantry, and 8' island, open to the breakfast area and covered deck. The family room offers a modern gas fireplace, built-ins, hardwood floors, and automated blinds. Dining room with tray ceiling, office with California shutters, laundry, and powder room complete the main level. The spacious principal suite includes a walk-in closet and ensuite with glass shower, separate tub, and double vanities plus serene views. Three additional bedrooms and full bath serve the family. The finished walk-out basement adds a second kitchen, large family room with gas fireplace, gym area, 3-pc bath, and storage. Outdoor living shines with multiple covered spaces and a resort-style pool and hot tub. A rare offering in a premium location .RSA Don't delay, arrange your viewing today! (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
Data was last updated May 13, 2026 at 09:15 AM (UTC)
My Featured Listings
113 NIAGARA Street
$429,900
Royal LePage State Realty Inc.
314 MAIN Street East
Royal LePage State Realty Inc.
