Office Listings
-
573 PARKSIDE Drive in Hamilton: Agriculture for sale : MLS®# 40766682
573 PARKSIDE Drive Hamilton L8B 0G7 
$6,300,000Agriculture- Status:
- Active
- MLS® Num:
- 40766682
- Bedrooms:
- 6
- Bathrooms:
- 3
- Floor Area:
- 2,785 sq. ft.
Welcome to 573 Parkside Drive! A truly rare offering with 116.5 acres of prime farmland on the outskirts of Waterdown. Featuring a 2,785 sq. ft. 2 storey brick farmhouse, and a beautiful old wood bank barn that was formerly used as a destination fruit and bake shop. This expansive property is just minutes from Burlington, Hamilton, and major commuter routes, with quick access to Hwy 6, the QEW, and the 403. Zoned A2 and P7, the land offers incredible versatility, ideal for continued agricultural use, a dream estate, horse and hobby farming, or even a wedding and event venue that takes advantage of the charming farmhouse and historic barn. The fertile acreage also supports cash crops, orchards, or farm-to-table opportunities. With steady growth in the Hamilton-Waterdown area and multiple subdivision proposals nearby, it also represents an exceptional long-term buy and hold investment (subject to approvals). Featuring established road frontage, proximity to municipal services, and surrounded by active development, 573 Parkside Drive is a one-of-a-kind opportunity that blends country charm, future potential, and unmatched location. (id:2493) More detailsListed by Royal LePage State Realty Inc.
- AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1041 CONCESSION 8 RR 3 W in Flamborough: Agriculture for sale : MLS®# 40765702
1041 CONCESSION 8 RR 3 W Flamborough N0B 2J0
$4,749,900Agriculture- Status:
- Active
- MLS® Num:
- 40765702
- Bedrooms:
- 4
- Bathrooms:
- 5
- Floor Area:
- 5,150 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
-
1467 BOOK Road W in Ancaster: Agriculture for sale : MLS®# 40724049
1467 BOOK Road W Ancaster L0R 1R0
$4,199,900Agriculture- Status:
- Active
- MLS® Num:
- 40724049
- Bedrooms:
- 7
- Bathrooms:
- 4
- Floor Area:
- 5,200 sq. ft.
Fall in love with this stunning custom built, 5200 sq. ft, 7 bedroom Country Estate on a sprawling 37.9 acres overlooking a pond, pastures & sunset views. This home is perfect for a large family and executive style living with 2800 sq. ft. on the beautifully appointed main level featuring a luxurious primary suite with a sitting room, fireplace & spa-like bathroom. Enjoy a gourmet kitchen open to a huge great room with floor to ceiling windows, a main level office and designer reading room with vaulted ceiling & custom wall unit. The impressively wide second level hallway leads to 6 large bedrooms and 2 bathrooms plus a second staircase to the kitchen.. Entertain in style in your private backyard oasis with inground salt water pool and hot tub, fire pit area, multi level deck & multiple lounging areas plus a multi purpose pole barn. 30 Acres leased to a local farmer. Located a short drive to shops, amenities and downtown Ancaster this home provides the best in Country Living. (id:2493) More detailsListed by Royal LePage State Realty Inc. - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
274 GERMAN SCHOOL Road in Brantford: Agriculture for sale : MLS®# 40769940
274 GERMAN SCHOOL Road Brantford N3L 3E1
$2,999,900Agriculture- Status:
- Active
- MLS® Num:
- 40769940
- Bedrooms:
- 5
- Bathrooms:
- 4
- Floor Area:
- 2,614 sq. ft.
Welcome to 274 German School Road! This stunning 5-bedroom, 4-bathroom home is situated on a beautifully landscaped 21-acre property just minutes from town and highway access. Thoughtfully designed for family living, this 2614 sq ft home features a walkout basement apartment with a separate entrance and polished concrete floors, ideal for multigenerational living or income potential. Step inside and you’ll find a bright, modern interior with open living spaces and in-floor heating throughout the house. Built in 2014 and set high on a hill overlooking fields and pasture, this home offers breathtaking views and privacy. The backyard is an entertainer’s dream with an inground pool and pool shed including a convenient bathroom, a 14x20 pavilion and a built-in natural gas BBQ and charcoal pit that is perfect for hosting and will make you feel like you're on vacation all year round. This property includes 13 acres of workable land and is a certified organic farm, a 36x60 replica post and beam barn with in-floor heat, and fenced pasture, making it the ideal gentleman's farm. Three owned water heaters and an in-law suite add even more value and functionality. Impeccable landscaping completes this incredible property. If you're seeking space, privacy, and versatility, 274 German School Road is the one you've been waiting for! (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
$2,395,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 - AMIR AHMADI
- ROYAL LEPAGE STATE REALTY, BROKERAGE
- 1 (905) 5123415
- Contact by Email
-
1396 54 Highway in Onondaga: Agriculture for sale : MLS®# 40751061
1396 54 Highway Onondaga N3W 2G9
$1,499,999Agriculture- Status:
- Active
- MLS® Num:
- 40751061
- Bedrooms:
- 3
- Bathrooms:
- 3
- Floor Area:
- 2,574 sq. ft.
Beautiful and secluded 19.9-acre rural estate in South Brant County near the Haldimand border. Just 10-15 minutes to Ancaster, Hamilton, and Hwy 403, with the Grand River just across the road. A winding laneway leads to a solid brick two-storey home with a walk-out balcony offering sweeping countryside views. Attached double garage plus a 1,344 sq ft board-and-batten garage with three insulated roll-up doors and separate 100-amp hydro. Inside, enjoy a cathedral-ceiling living room with hardwood floors and a Valor gas fireplace. The spacious kitchen (renovated 2023) features ceramic floors and leads to a formal dining room. Main floor includes a bedroom/den and 4-pc bath. Upstairs: primary with ensuite, two bedrooms, and another 4-pc bath. Upgrades include: new roof (2016), sunroom windows/door (2021), balcony/rails/flat roof/eaves (2022), new furnace (2018), A/C (2020), sump pump (2025), 2 ERVs, HEPA/UV filtration, Smartstrand carpet (2023), and water UV system (2022). Annual HVAC servicing. Outdoor features: Jacuzzi (2017), concrete walkways (2020), resurfaced driveway (2025), 2 fenced chicken coops, dog run, and 2 organic gardens. 13.5 acres are leased to GH VanSickle & Sons Ltd ($1,350/year) with no-till practices. In 2023, erosion control was added with GRCA: 3 grass waterways and full tile drainage into creek. (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 September 18, 2025 at 09:45 PM (UTC)
My Featured Listings
129 DUNDURN Street North
$599,900
Royal LePage State Realty Inc.
1 262 OTTAWA Street North
Royal LePage State Realty Inc.
