See all 50 photos

$2,699,000

Est. payment - /mo

Save Virtual Tour

3 Beds

3 Baths

New

464 Piper ST North Dumfries, ON N0B 1E0

Save Virtual Tour

REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Kenneth Yim

ken@broadviewavenue.ca +1(416) 906-0080

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Detached

Listing Status Active

Purchase Type For Sale

Approx. Sqft 3500-5000

MLS Listing ID X13147520

Style 2-Storey

Bedrooms 3

Annual Tax Amount $9,020

Tax Year 2025

Property Sub-Type Detached

Lot Depth 611.0

Lot Front 311.1

Property Description

5.5-Acre Ayr Estate - step into a rare blend of pre-Confederation legacy and modern luxury at Stonehaven Estate. Nestled on manicured grounds within walking distance of Ayr, this mid-1800s stone farmhouse has been completely transformed into the ultimate family retreat and entertainer's paradise. Boasting over 3,000 sqft of living space, the main residence flawlessly marries heritage character with contemporary design. The heart of the home is a breathtaking 800 sq. ft. Great Room featuring soaring vaulted ceilings, wrap around windows/doors to pool deck, original exposed stone walls, a gas fireplace, and wide-plank flooring. A modernized showstopper kitchen, main floor is perfectly complemented by formal living/dining rooms and main floor laundry. Upstairs offers three bedrooms, a main 3-piece bath, and a vast Primary Suite with a stunning private ensuite. Beyond the main home, the property offers incredible outbuildings designed for utility and lifestyle. Capped by a striking red steel roof, the detached Coach House features a 3.5-bay garage. Above, a fully modernized 2-bedroom apartment reveals a gourmet kitchen, sprawling living space, and vaulted ceilings, with layout potential to add an extra bedroom on the main level. Adding to the estate's appeal is a custom-finished, heated shop ideal for hobbyists and entrepreneurs. This space features epoxy floors, a WETT-certified wood stove, electric heating, available water, and a large commercial roll-up door. Centered around a custom live-edge wood bar, it is the ultimate private pub, showroom, or home-business headquarters. Offering unparalleled privacy just minutes from Ayr's vibrant downtown amenities, Stonehaven Estate is truly a legacy property. The apartment's legal status and permits are currently being updated with the township to ensure full buyer confidence, and the property will also benefit from a brand-new septic system. Watch the YouTube video to truly see what this estate has to offer.

Location

Province ON

County Waterloo

Area Waterloo

Rooms

Family Room Yes

Basement Partial Basement, Unfinished

Kitchen 1

Interior

Interior Features Accessory Apartment, In-Law Suite, Water Softener, Water Treatment

Cooling Central Air

Fireplaces Type Natural Gas

Fireplace Yes

Heat Source Gas

Exterior

Exterior Feature Deck, Landscaped

Parking Features Circular Drive

Garage Spaces 3.0

Pool Above Ground

Waterfront Description None

View Forest, River

Roof Type Asphalt Shingle,Metal

Lot Frontage 311.1

Lot Depth 611.0

Total Parking Spaces 18

Building

Building Age 100+

Foundation Stone

Others

ParcelsYN No

Virtual Tour https://unbranded.youriguide.com/464_piper_st_north_dumfries_on/

Listed by RE/MAX TWIN CITY REALTY INC.

GET MORE INFORMATION

Kenneth Yim

Broker of Record | License ID: 9524831

+1(416) 906-0080

MORTGAGE CALCULATOR

Mortgage values are calculated by Lofty and are for illustration purposes only, accuracy is not guaranteed.

AFFORDABILITY CALCULATOR

Use this calculator to determine how much house you can afford. By entering details about your income, down payment, and monthly debts, you can estimate the mortgage amount that works with your budget.

You can afford a home up to: $0

Your debt-to-income ratio is 36%
Quite affordable.

View Affordable Properties

Payment Breakdown：

$0 Month

Get more info from a local expert!