Open New Doors Real Estate
1 of 50
$2,699,000

464 Piper Street

North Dumfries, N0B1E0

3 bd3+1 baDetachedListed 5 months ago

Listed by RE/MAX Twin City Realty Inc. · MLS® X13147520

Powered by REALTOR.ca
Get alerts for homes like this

About this home

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 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.

Details

Storeys
2
Lot
311.1 x 611 FT
Taxes
$9,020 (2025)
Parking
18 spaces · Detached Garage, Garage
Heating
Forced air, Natural gas
Cooling
Central air conditioning
Basement
Unfinished, Partial
Exterior
Wood, Stone
Fireplaces
1
Pool
Above ground pool
Appliances
All, Water softener, Water Treatment, Window Coverings
Sewer
Septic System
Ownership
Freehold

Features: In-Law Suite, Fireplace(s)

Rooms

LevelRoomSize
Main levelGreat room
Second levelBathroom
Main levelBathroom
Main levelKitchen
Main levelLiving room
Main levelDining room
Main levelMud room
Main levelLaundry room
Second levelPrimary Bedroom
Second levelBathroom
Second levelBedroom 2
Second levelBedroom 3

Location

Your Home Search Portal

See every listing and every sold price

This list is a good start. Your Home Search Portal shows every listing from every brokerage, plus sold prices, and emails you new matches as they are listed.

Concierge setup

Dave builds your search personally, no algorithms guessing what you meant.

Every listing, every brokerage

Your portal combines all available homes in our area, from any company and any REALTOR®.

Full property history and sold prices

See what homes actually sold for, the context that makes your offer smart.

Private, and ad free

Your contact info stays with us. No ads, no marketing lists, and your questions come straight to Dave.

Where are you looking?
Price range
Bedrooms (minimum)
Property types
When are you hoping to buy?

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA’s By-Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Listing data is provided under the REALTOR.ca Data Distribution Facility and is subject to our listing data terms.

Powered by REALTOR.ca