Office Listings
-
1041 8TH CONCESSION Road W in Flamborough: Agriculture for sale : MLS®# 40796886
1041 8TH CONCESSION Road W Flamborough N0B 2J0 
$4,499,900Agriculture- Status:
- Active
- MLS® Num:
- 40796886
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 6,660 sq. ft.
108+ Acres and 25+ Acres of water nestled in the heart of Flamborough, this stunning 4-bedroom, 4+1-bathroom country estate blends historic charm with modern luxury. Extensively renovated in 2018, this property boasts over 6,000 sq. ft. of refined living space on 108+ acres featuring 7 picturesque bodies of water, including 3 connected to Bronte Creek. The home includes a walkaround porch, gourmet kitchen with Bosch appliances, a steam spa shower, two Rumford fireplaces, and a walk-out basement with in-floor heating. Outdoor living is unmatched with a pizza oven, a 4 ft fireplace, pool house with bar and drink fridge, and a swim spa / hot tub with an automatic Covana cover. A 60x40 workshop, complete with a 10,000 lb hoist, RV hookup, and framed second-level 2-bed apartment, offers endless possibilities. Modern amenities include high-speed fiber internet, a Kohler generator, and security cameras. With reduced property taxes and proximity to Waterdown, Cambridge, and Burlington, this property is the perfect private retreat or multi-functional family estate. Don’t miss this rare opportunity! (id:2493) More detailsListed by Royal LePage State Realty Inc.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1041 8TH CONCESSION Road W in Flamborough: Single Family for sale : MLS®# 40796874
1041 8TH CONCESSION Road W Flamborough N0B 2J0
$4,499,900Single Family- Status:
- Active
- MLS® Num:
- 40796874
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 6,660 sq. ft.
108+ Acres and 25+ Acres of water nestled in the heart of Flamborough, this stunning 4-bedroom, 4+1-bathroom country estate blends historic charm with modern luxury. Extensively renovated in 2018, this property boasts over 6,000 sq. ft. of refined living space on 108+ acres featuring 7 picturesque bodies of water, including 3 connected to Bronte Creek. The home includes a walkaround porch, gourmet kitchen with Bosch appliances, a steam spa shower, two Rumford fireplaces, and a walk-out basement with in-floor heating. Outdoor living is unmatched with a pizza oven, a 4 ft fireplace, pool house with bar and drink fridge, and a swim spa / hot tub with an automatic Covana cover. A 60x40 workshop, complete with a 10,000 lb hoist, RV hookup, and framed second-level 2-bed apartment, offers endless possibilities. Modern amenities include high-speed fiber internet, a Kohler generator, and security cameras. With reduced property taxes and proximity to Waterdown, Cambridge, and Burlington, this property is the perfect private retreat or multi-functional family estate. Don’t miss this rare opportunity! (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
-
29 GAINES Avenue in Dundas: Single Family for sale : MLS®# 40827139
29 GAINES Avenue Dundas L9H 7M4
$1,499,000Single Family- Status:
- Active
- MLS® Num:
- 40827139
- Bedrooms:
- 6
- Bathrooms:
- 5
- Floor Area:
- 5,398 sq. ft.
Welcome to 29 Gaines Avenue in Dundas, a spacious two-storey home ideal for growing or multi-generational families. The main floor features hardwood flooring, a bright eat-in kitchen with quartz countertops, updated cabinetry, stainless steel appliances, and a walkout to the upper deck. A double-sided gas fireplace connects the kitchen and Great Room. Separate living and dining rooms, a flexible office/den, powder room, and main-floor laundry with garage access complete the level. Upstairs offers five bedrooms and three full bathrooms. The primary suite includes a five-piece ensuite, two walk-in closets, and a gas fireplace. One bedroom has its own ensuite, and another has semi-ensuite access. The finished walk-out basement includes a kitchen, large recreation room w/ custom built ins & gas fireplace, bedroom, and full bathroom—ideal for extended family or guests or private home. The fully fenced backyard features a deck with Gazebo, gas BBQ hookup, hot tub, walkway to the relaxing koi pond, garden shed with power, and in-ground sprinkler system. Move-in ready with updated lighting, hardware, and finishes throughout. Perfectly located in a family-friendly Dundas neighbourhood, this home is just steps to top-rated schools, Memorial Park, conservation trails, parks, and all the amenities of downtown Dundas, offering the ideal balance of convenience and outdoor lifestyle. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
56 MCCAFFERY Crescent in St. Catharines: Single Family for sale : MLS®# 40835260
56 MCCAFFERY Crescent St. Catharines L2S 3Z5
$1,129,999Single Family- Status:
- Active
- MLS® Num:
- 40835260
- Bedrooms:
- 4
- Bathrooms:
- 4
- Floor Area:
- 2,719 sq. ft.
Located in the highly sought-after Vansickle neighbourhood of St. Catharines, this Rinaldi custom-built two-storey home sits on a picturesque pie-shaped lot surrounded by mature trees and beautifully landscaped grounds. Offering a total of 4 bedrooms and 3.5 bathrooms, this home has been thoughtfully updated and meticulously maintained. The bright main floor welcomes you with expansive windows that fill the spacious living room with natural light, highlighted by a cozy gas fireplace. The stunning new kitchen (2024) features quartz countertops, an undermount sink and an eat-in area overlooking the private backyard. Newly refinished flooring runs throughout the main and second floors, complemented by fresh paint throughout the entire home (2024), creating a clean modern feel. Updated bathroom vanities on the main floor and upper level add to the home’s stylish upgrades. Upstairs, the primary suite offers vaulted ceilings, a 3-piece ensuite, and a walk-in closet, along with three additional bedrooms, including a versatile bonus room over the garage that can serve as a fourth bedroom or home office. The fully finished basement provides additional living space with a large recreation room, bar area, 3-piece bathroom, cold cellar and ample storage. Step outside to your private backyard oasis featuring a large in-ground pool, mature landscaping and a spacious patio perfect for entertaining. A shed adds extra storage, while the impressive 6+ car driveway enhances the home’s curb appeal. The home also features a maintenance-free exterior paint completed in 2025, offering added peace of mind and long-term durability. A rare opportunity to own a beautifully updated family home in one of St. Catharines’ most desirable communities (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
12 DEGROW Crescent in Binbrook: Single Family for sale : MLS®# 40831352
12 DEGROW Crescent Binbrook L0R 1C0
$949,900Single Family- Status:
- Active
- MLS® Num:
- 40831352
- Bedrooms:
- 3
- Bathrooms:
- 3
- Floor Area:
- 1,853 sq. ft.
Don't miss out diving in the heated saltwater in-ground POOL this summer, the showstopping centerpiece of this exceptional 2009 John Bruce Robinson-built home in desirable Binbrook. Set on a premium 45' x 103' with no rear neighbours and direct access to parkland and forest, this backyard retreat also features an exposed aggregate patio and low-maintenance landscaping - the perfect blend for relaxation, and entertaining. This stunning two-storey home offers timeless curb appeal with its elegant combination of stone, brick, and siding. A spacious exposed aggregate double driveway leads to a charming covered front porch, creating a warm welcome. Located in a sought-after family-friendly neighbourhood, you're within walking distance to local shops and just 10-15 minutes to Hamilton, Stoney Creek amenities, the Linc, Red Hill, and QEW. Inside, approx 1900 sq. ft. to beautifully finished living space showcases 9-foot ceilings, crown molding, hardwood floors, upgraded tile and designer lighting. The inviting foyer offers inside access to the two-car garage and flows past a custom oak staircase and convenient two-piece bath into the formal dining room. The chef-inspired kitchen is loaded with premium FEATURES, including Barzotti maple cabinetry, granite countertops, breakfast bar, stainless steel appliances, and a stylish tile backsplash. A French door walkout provides seamless access to the backyard and POOL, ideal for indoor-outdoor entertaining. The adjacent great room impresses with vaulted ceilings, and a cozy natural gas fireplace. Upstairs, the spacious primary suite features a walk-in closet and luxurious four-piece Jacuzzi ensuite with separate shower. Two additional bedrooms and a four-piece main bath complete the level. The basement has excellent potential for future customization - it does includes laundry and a bathroom rough-in. With standout FEATURES including the POOL, premium park-backing lot, and no neighbours in front, this home offers it all! RSA (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
621 TOMAHAWK Crescent in Ancaster: Single Family for sale : MLS®# 40827661
621 TOMAHAWK Crescent Ancaster L9G 3T4
$934,900Single Family- Status:
- Active
- MLS® Num:
- 40827661
- Bedrooms:
- 5
- Bathrooms:
- 3
- Floor Area:
- 2,840 sq. ft.
Welcome Home! Discover this beautiful bright & spacious 3+2 bedroom & 2.5 bath home in Ancaster’s popular Mohawk Meadows neighbourhood! This well maintained home offers an open-concept layout with plenty of room to relax, entertain, and enjoy everyday life. The main floor is bright and welcoming, with a large living room that flows into a spacious kitchen and family room, complete with a gas fireplace and walk out to the back deck. You’ll also love the convenience of main-floor laundry with entry to the garage and a 2pc bath. Make your way upstairs to a primary suite with a wall to wall closet and 3 pc ensuite. This level is complete with two additional bedrooms and a 4c bath. The fully finished basement gives you more space to grow, featuring a large rec room w/gas fireplace, plus two extra bedrooms that could work perfect for guests, a home office, or a workout space. You will want to spend time in the fully fenced, private backyard that has been beautifully landscaped. The large composite deck is great for relaxing or entertaining family & friends. Enjoy a relaxing dip in the hot tub at the end of the day. Parking for five, including a single garage and a driveway with space for four more cars. A phantom screen door at the front adds a nice extra touch. Just a short walk to Rousseau School and close to parks, trails, public transit, Highway 403, the LINC, and local favourites like the Hamilton Golf & Country Club and Ancaster Memorial Arts Centre. You’re also just minutes from the Meadowlands and Ancaster Village for shopping, dining, and practically everything you need. This is a great opportunity to move into a solid home in a fantastic neighbourhood. Do not delay. Book your showing now, before this one is gone (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
39 TRENHOLME Crescent in Hamilton: Single Family for sale : MLS®# 40817529
39 TRENHOLME Crescent Hamilton L8W 2L4
$779,000Single Family- Status:
- Active
- MLS® Num:
- 40817529
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 2,670 sq. ft.
Welcome to 39 Trenholme Crescent, set in a quiet, family-friendly neighbourhood on Hamilton’s desirable East Mountain, close to parks, schools, and trails. A welcoming foyer leads into a bright main level featuring hardwood floors, a spacious living room, dining room, and an eat-in kitchen with plenty of cabinet space. Enjoy one-floor living with three spacious bedrooms showcasing updated flooring, along with a 4-piece bathroom on the main level. The finished lower level adds valuable living space with a recreation room featuring a rough-in for a wet bar. With a den, 3-piece bathroom, and separate entrance, there is in-law possibility. Additional features include an attached single garage with inside entry and an owned water purification system. The private backyard backs onto green space and features a generous deck with a hot tub and fire pit—perfect for relaxing or entertaining. Ideal for empty nesters, young families, or anyone seeking one-floor living with additional space. Located near Albion Falls, the Niagara Escarpment, the Twin Pad Arena, and nearby trails, this location supports an active, healthy lifestyle in a well-established community. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
20 KITTY MURRAY Lane Unit# 11 in Ancaster: Condo for sale : MLS®# 40834678
20 KITTY MURRAY Lane Unit# 11 Ancaster L9K 1L7
$739,900Single Family- Status:
- Active
- MLS® Num:
- 40834678
- Bedrooms:
- 2
- Bathrooms:
- 2
- Floor Area:
- 1,181 sq. ft.
Fantastic 2 Bedroom, 2 Bath End Unit Townhome in Meadowlands, Ancaster. Enjoy easy one-floor living in this bright and spacious end unit townhome located in the desirable Meadowlands area of Ancaster. This well-kept home features a large eat-in kitchen with ample storage and abundant natural light throughout. The living room showcases an electric fireplace and opens to a private patio garden, perfect for relaxing or entertaining. The primary bedroom includes a 4-piece ensuite, while the second bedroom benefits from ensuite privilege. Main floor laundry adds convenience. Beautiful hardwood flooring runs throughout the main level. An attached one-car garage with inside entry provides practical access. The unfinished basement with high ceilings offers endless possibilities for creating additional living space. Set in a peaceful, well-maintained complex, this home combines comfort, functionality, and opportunity in a prime location. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
157 LONGWOOD Road N in Hamilton: Single Family for sale : MLS®# 40824422
157 LONGWOOD Road N Hamilton L8S 3V8
$659,900Single Family- Status:
- Active
- MLS® Num:
- 40824422
- Bedrooms:
- 2
- Bathrooms:
- 2
- Floor Area:
- 1,502 sq. ft.
Charming 2-bedroom Westdale North bungalow with lovely olde world character and just steps from everything! Classic original features include a sunny living room bay window, decorative fireplace with leaded glass side lights, gleaming hardwood floors plus gorgeous gumwood trim & doors. Replacement windows & concrete drive. The basement has a private side entrance and downstairs there is a large family room, 3-piece bath, lots of storage plus a spacious workshop area. The long concrete drive leads to the oversized rear 20'x18' garage/workshop – perfect for the handyman, artist or hobbyist. The Westdale / Princess Point area is truly a nature lover’s dream. It boasts top-rated schools, beautiful parks (check out the new kids’ jungle gym and splash pad), miles and miles of RBG forests and just down the hill are extensive waterfront walking/biking trails leading all the way to Bayfront & Pier 4 Parks. Just a short stroll through the park will bring you to the Westdale shopping district with its wonderful boutiques, restaurants, foodie destinations, coffee shops, public library & traditional 1930's movie theatre. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
262 DUNDAS Street E Unit# 311 in Hamilton: Condo for sale : MLS®# 40838338
262 DUNDAS Street E Unit# 311 Hamilton L8B 1A9
$649,000Single Family- Status:
- Active
- MLS® Num:
- 40838338
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 1,322 sq. ft.
Welcome to a truly rare offering-this top-floor, end-unit condo delivers an exceptional level of privacy, quiet, and space that is seldom found. With no neighbours above or beside, this home offers a peaceful, almost penthouse-like experience (without the penthouse price tag), tucked away in a private section of a solid, well-built building. Thoughtfully renovated from top to bottom, this spacious unit features a flexible layout with 3 bedrooms or 2 bedrooms plus a den-ideal for families, downsizers, or anyone seeking room to live and work comfortably. The open-concept kitchen has been beautifully updated with modern cabinetry and appliances, seamlessly connecting to the bright living and dining areas. Soaring ceilings and large south-facing windows flood the space with natural light, while patio doors lead to two private balconies overlooking mature trees-creating a serene, retreat-like atmosphere rarely found in condo living. The home continues to impress with new hardwood floors, updated bathrooms (including an ensuite), in-suite laundry, large bedrooms, and a walk-in closet. Storage is exceptional, highlighted by an unusually large storage locker-perfect for seasonal items, sports equipment, or downsizing without compromise. Additional features include two underground parking spaces, access to a common room for gatherings, and low-maintenance living with landscaping, maintenance, and snow removal all taken care of. Located in a highly convenient, walkable neighbourhood close to shopping, downtown, and parks including Memorial Park, this home offers the perfect balance of tranquility and accessibility. Rarely do units like this become available-quiet, private, spacious, and move-in ready. A unique opportunity for those seeking the ease of condo living without sacrificing space, light, or lifestyle. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
255 MOUNT ALBION Road Unit# 22 in Hamilton: Condo for sale : MLS®# 40805865
255 MOUNT ALBION Road Unit# 22 Hamilton L8K 6P7
$639,900Single Family- Status:
- Active
- MLS® Num:
- 40805865
- Bedrooms:
- 3
- Bathrooms:
- 4
- Floor Area:
- 2,042 sq. ft.
Luxury South East Hamilton townhome featuring 2042 sq ft including the fully finished basement. 3 Bedroom end unit with spacious bedrooms and 3 and half baths, including master bedroom with ensuite bath, second bedroom with semi-ensuite privileges, fully finished basement, spiral staircase, long term owner home in immaculate move-in condition. One of the best townhomes in this very desirable location. Must be seen! (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 June 14, 2026 at 01:15 PM (UTC)
My Featured Listings
624 UPPER OTTAWA Street
$729,900
Royal LePage State Realty Inc.
3086 SWANSEA Drive
$1,595,900
Royal LePage State Realty Inc.
