OFFICE LISTINGS
-
10 HUISMAN Lane in Hamilton: Single Family for sale : MLS®# 40830883
10 HUISMAN Lane Hamilton L8N 2Z7 
$2,090,000Single Family- Status:
- Active
- MLS® Num:
- 40830883
- Bedrooms:
- 4
- Bathrooms:
- 2
- Floor Area:
- 2,119 sq. ft.
Set on approximately 10 acres in the heart of desirable Flamborough, this distinguished country estate offers a rare blend of refined rural living and a fully equipped equestrian facility. The four-bedroom bungalow is thoughtfully positioned to take in the surrounding pastoral landscape, offering privacy, comfort, and an authentic countryside lifestyle. Purpose-built for the discerning equestrian, the property showcases an impressive 70' x 110' indoor riding arena complete with four box stalls, a heated tack room, and wash stall. Complementing the indoor facilities are a 200' x 85' outdoor riding arena, 70' x 65' lunging paddock, and four well-maintained paddocks designed for efficient rotational grazing. A 25' x 40' detached garage/workshop further enhances the functionality of the estate. The land offers a harmonious balance of open, usable acreage and naturalized areas, providing both operational flexibility and exceptional privacy. This is a turnkey opportunity for equestrian professionals, hobby farm enthusiasts, or those seeking a true rural estate lifestyle. The property is subject to A2 (Agricultural) zoning with portions designated under P8 (Conservation/Hazard Land) overlay. A2 zoning support rural residential and agricultural/equestrian uses, while P8- regulated areas are environmentally protected and not available for development. Ideally located within easy reach of Waterdown, Ancaster, and Hamilton, and offering convenient access to Highway 403 and the QEW, this estate delivers an exceptional balance of country seclusion and commuter accessibility. (id:2493) More detailsListed by Royal LePage State Realty Inc.
- GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- 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.- GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- 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. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- 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. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- 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.- GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
-
521 BAPTIST CHURCH Road in Brantford: Single Family for sale : MLS®# 40837013
521 BAPTIST CHURCH Road Brantford N3W 2G9
$1,900,000Single Family- Status:
- Active
- MLS® Num:
- 40837013
- 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. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
-
521 BAPTIST CHURCH Road in Brantford: Agriculture for sale : MLS®# 40837003
521 BAPTIST CHURCH Road Brantford N3W 2G9
$1,900,000Agriculture- Status:
- Active
- MLS® Num:
- 40837003
- 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. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
-
0 HIGHWAY 5 in Troy: Vacant Land for sale : MLS®# 40838494
0 HIGHWAY 5 Troy L0R 2B0
$1,800,000Vacant Land- Status:
- Active
- MLS® Num:
- 40838494
Rare opportunity to acquire 56.46 acres of highly productive farmland in sought-after West Flamborough. This parcel is available separately or in conjunction with the adjoining 107.83-acre property located at 1523 Highway 5, creating a combined holding of approximately 164 acres. Featuring productive clay loam soil and a large workable field configuration, this property offers excellent crop production potential. Multiple building opportunities may be available, subject to applicable approvals. An excellent opportunity for farmers, investors, or those looking to expand their land base. (id:2493) More detailsListed by Royal LePage State Realty Inc. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
-
0 HIGHWAY 5 in Troy: Agriculture for sale : MLS®# 40838486
0 HIGHWAY 5 Troy L0R 2B0
$1,800,000Agriculture- Status:
- Active
- MLS® Num:
- 40838486
Rare opportunity to acquire 56.46 acres of highly productive farmland in sought-after West Flamborough. This parcel is available separately or in conjunction with the adjoining 107.83-acre property located at 1523 Highway 5, creating a combined holding of approximately 164 acres. Featuring productive clay loam soil and a large workable field configuration, this property offers excellent crop production potential. Multiple building opportunities may be available, subject to applicable approvals. An excellent opportunity for farmers, investors, or those looking to expand their land base. (id:2493) More detailsListed by Royal LePage State Realty Inc. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
-
176 WEIRS Lane in Dundas: Single Family for sale : MLS®# 40827427
176 WEIRS Lane Dundas L9H 5E1
$1,799,900Single Family- Status:
- Active
- MLS® Num:
- 40827427
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 3,241 sq. ft.
Remarkable 4 bdrm, 5 bath, 3241 sq ft POST & BEAM residence offering a rare blend of architectural character, craftsmanship, privacy & breathtaking natural surroundings. Perched on a spectacular 1.064-A property w/ panoramic SE views stretching across Dundas, Ancaster, & Hamilton. Winding drive climbs a gentle hill, revealing a stunning structure positioned proudly atop the landscape. The property is framed by numerous native Carolinian trees, incl indigenous fruit trees, creating an incredibly special setting that changes beautifully through every season. Built in '98 w/ 8x8 white pine, the home showcases exposed beams, structural posts, vaulted ceil, large expanses of glass, skylights, & the unmistakable look/scent of natural pine. Main lvl feat incl an updated kitch w/ maple cab/quartz/S/S app, formal din rm, lounge, spectacular liv rm w/ soaring ceil/wall of windows overlooking the valley/metal spiral staircase leading to loft. Rough-ins for a previous kitchenette remain in the liv rm, offering flex for future use. Upper-lvl feat incl 2 bdrms w/ ensuite baths. The lwr lvl offers versatility w/ 2 sep entrances, a spacious rec rm w/ an elec FP, a 3-pc bath w/ laund, 2 add bdrms, incl one w/ a 4-pc ensuite, & utility/storage. In approximately '00, the N side of the home was expanded to accommodate a fully self-cont in-law suite. While the connecting walls were later removed to create a seamless open-concept layout, the potential for in-law capability may exist. Outside feat incl multi terrace/patio areas overlooking the valley, perennial gardens, a pond, fire pit area, mature landscaping & more. Noteworthy additional feat incl natural gas service, updated furnace ('24), updated well pump & associated pressure tank ('26) & more. This is more than a home - it is a property w/ soul, history, architectural significance, & an irreplaceable connection to the landscape around it. A truly rare opportunity to own one of rural Dundas’ most distinctive residences. (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: 1047 MEREDITH Avenue in Mississauga: Single Family for sale : MLS®# 40843446
1047 MEREDITH Avenue Mississauga L5E 2C6 OPEN HOUSE: Jul 12, 202602:00 PM - 04:00 PM EDTOpen House on Sunday, July 12, 2026 2:00PM - 4:00PM
$1,799,900Single Family- Status:
- Active
- MLS® Num:
- 40843446
- Bedrooms:
- 6
- Bathrooms:
- 5
- Floor Area:
- 3,086 sq. ft.
Exceptional custom-built residence just a short walk to Lake Ontario, offering an outstanding blend of contemporary architecture, premium craftsmanship, & luxe finishes throughout. Situated in Mississauga's sought-after Lakeview neighbourhood, this stunning home feat 4+2 bdrms, 5 baths, a detached dbl grg, & beautifully fin liv space across all 3 levels. Entering through a stately front door, you are welcome to the main lvl, showcasing 10' ceil, wide-plank hrdwd flrs, an open-concept layout, a dramatic staircase w/ glass railings & a striking multi-level 3D feature wall & oversized Euro-style patio doors. The chef-inspired kitch offers custom cab, upgraded counters, an o/s island, luxe app incl a Liebherr fridge, Wolf range/oven, Bosch d/w, built-in Bosch wall oven, built-in microwave, & premium fixtures throughout. A spectacular flr-to-ceil glass wine display w/ lockable doors serves as a stunning focal point. Upstairs, the primary retreat feat custom built-in closet cabinetry, o/s windows, & a spa-inspired ensuite w/ heated flrs, freestanding soaker tub, o/s glass shower, skylight, & dbl vanity. 3 add bdrms - 1 w/ a beautifully appointed e-bath & the other 2 sharing a luxe Jack & Jill bath - plus laund facilities, complete the upper lvl. The prof fin lower lvl offers exceptional flex w/ a spacious rec rm feat a projector & associated screen, wet bar w/ bev fridge, 2 add bdrms, 4 pc bath, 2nd laundry facilities, & a bonus walk-up ext entrance leading to the yard - in-law potential. Outside, enjoy tastefully landscaped grounds, mature trees, expansive stone walkways, an elevated deck w/ glass railings, & the detached dbl-car grg + bonus parking for 4. Ideally located min from the lake, waterfront trails, parks, marinas, Lakeview Village redevelopment, Port Credit, schools, shopping, restaurants, GO Transit, Pearson Airport, the QEW, Hwy 427/403, & downtown Toronto. A rare opp to own a custom home in a growing lakeside community. (id:2493) More detailsListed by Royal LePage State Realty Inc. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- 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. - GIRARD TEAM
- ROYAL LEPAGE STATE REALTY
- 1 (905) 574-7441
- Contact by Email
Data was last updated July 10, 2026 at 09:45 AM (UTC)
Girard Team
Get in touch
Girard Team
1122 Wilson Street West
Ancaster,
ON,
L9G 3K9
