$2,699,000
 $14,489 est/mo Sourced by Back At You

464 Piper Street,Ayr, ON N0B 1E0

Ayr, ON N0B 1E0

Share:

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

MLS #40831635
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusActive
Year1850
Days On Site130
Listing Provided ByRE/MAX Twin City Realty Inc. | Andy Naudi

Features

Bed(s)3
Bath(s) 3 Total
SQ Feet3,568
Garage3
BasementY
Story(s)2
Units1
Building(s)1
ZoningZ1
Acreage5.41
Water FrontYes

Interior

AppliancesBar Fridge, Water Softener, Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer
Rooms Total12
Interior FeaturesHigh Speed Internet, Auto Garage Door Remote(s), Bed & Breakfast, In-Law Floorplan
CoolingCentral Air
Cooling Yes / NoNo
HeatingForced Air, Natural Gas
Heating Yes / NoYes
Fireplaces Total1
Window FeaturesWindow Coverings
Laundry FeaturesMain Level

Exterior

Exterior FeaturesAwning(s), Balcony, Landscape Lighting, Landscaped
Lot FeaturesRural, Corner Lot, Highway Access
Construction MaterialsBoard & Batten Siding, Stone
RoofAsphalt Shing, Metal
Foundation DetailsStone
Waterfront FeaturesRiver/Stream
Patio And Porch FeaturesDeck, Porch

Parking

Garage Spaces3
Parking FeaturesDetached Garage, Garage Door Opener, Asphalt, EV Charging
Open Parking Yes / NoYes
Attached Garage Yes / NoNo

Utilities

UtilitiesFibre Optics, Natural Gas Connected
SewerSeptic Tank

Taxes

Tax Annual Amount9020

Area Information

ProvinceON
CountyWaterloo
CityAyr
Postal CodeN0B 1E0
Area16 N. Dumfries Twp. (W. of 24 Rural W.)
Subarea60 Ayr
Community Name60 Ayr
Listing VS Median (in 60 Ayr)
Price:
$2,699,000
low | high
Med:
$684,640
100% of Average
sqft:
3,568
low | high
Med:
1,731
100% of Average
$ / sqft:
$756
low | high
Med:
$404
96.599321161365% of Average
On site:
130
low | high
Med:
13.5
100% of Average
Sourced by Back At You

Market Activity N0B 1E0

Request a showing

Request a showing

Contact


Additional Information


Showing Information


Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from Coldwell Banker the Real Estate Centre at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
MLS Internet Data Exchange (IDX) information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the Information Technology of Southern Ontario MLS.

Contact

Learn More About This Property

ProvinceON
CountyWaterloo
CityAyr
Postal CodeN0B 1E0
Area16 N. Dumfries Twp. (W. of 24 Rural W.)
Subarea60 Ayr
Community Name60 Ayr
Listing VS Median (in 60 Ayr)
Price:
$2,699,000
low | high
Med:
$684,640
100% of Average
sqft:
3,568
low | high
Med:
1,731
100% of Average
$ / sqft:
$756
low | high
Med:
$404
96.599321161365% of Average
On site:
130
low | high
Med:
13.5
100% of Average
Sourced by Back At You
Listing Updated: September 6, 2026 at 9:39:36 AM PDT