$2,699,000
Unlock Price Rating!

464 Piper Street, Ayr on N0B 1E0, Ayr, ON N0B 1E0

 Contact
3 Beds
3 Baths
3,568 Sq Ft

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 entertainers 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. OPEN HOUSE SAT 2-4

Listing By: Andy Naudi - RE/MAX Twin City Realty Inc. cnitso Realty.com
  • MLS® 40831635
  • Date Listed05/20/2026
  • Days on Realty 14 Days
  • Bedrooms 3
  • Bathrooms 2 Full baths, 1 Half baths
  • Lot Size 5.41 acres (235,660 sq. ft)
  • Sewer Septic Tank
  • County Waterloo
  • Year Built 1850
  • Square Feet 3,568 sq. ft
  • Price Per Sq. Ft $756.45

Interior Features

  • Appliances Bar Fridge, Water Softener, Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer
  • Cooling Central Air
  • Heating Forced Air, Natural Gas

Exterior / Lot Features

  • Exterior Awning(s), Balcony, Landscape Lighting, Landscaped
  • Roof Metal
  • Lot Size Acres 5.41
  • Lot Size SQFT 235,659.60
  • Lot Features Rural, Corner Lot, Highway Access

Directions

Hwy 97 to Northumberland St, right on Piper St about 1 mile to 464

Sales & Tax History

Source: Public Records

Local Neighborhood Highlights for N0B 1E0

Discover key demographics, population statistics, and environmental insights for the Ayr, ON area.

Walkability in ON / N0B 1E0

Source: Walk Score

3/100

Car-Dependent

Walk Score ®

0/100

Minimal Transit

Transit Score ®

23/100

Bikable

Bike Score ®

Overview

Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.

Walkability averages in the surrounding area

The average walkability score in the surrounding area is Walk Score: 9/100, Transit Score: 0/100, Bike Score: 23/100.

Points of Interest near 464 Piper Street, Ayr ON N0B 1E0, Ayr, ON N0B 1E0

Frequently Asked Questions for 464 Piper Street, Ayr ON N0B 1E0

Source: Realty.com

464 Piper Street, Ayr ON N0B 1E0, Ayr, ON N0B 1E0 in Ayr, ON N0B 1E0 is a single family residence listed at $2,699,000. Highlights include 3 bedrooms, 3 bathrooms, 3,568 sq. ft., built in 1850, 5.41 acre lot, $756 per sq. ft.. Realty.ca has 50 photos, sales history, school insights, and mortgage tools for this listing.

Realty.com has 50 photos of 464 Piper Street, Ayr ON N0B 1E0.

Our records indicate that 464 Piper Street, Ayr ON N0B 1E0 was built in 1850.

The full address for this home is 464 Piper Street, Ayr ON N0B 1E0, Ayr, ON N0B 1E0.

464 Piper Street, Ayr ON N0B 1E0 has been listed on Realty.com since Wed May 20, 2026

Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.

The average walkability score in the surrounding area is Walk Score: 9/100, Transit Score: 0/100, Bike Score: 23/100.

Listing provided courtesy of: Re/max Twin City Realty Inc. - itso - 1304438 (tel: 519-579-4110)
Listing agent: Andy Naudi (tel: 226-789-7193)

This content last refreshed on 2026-06-03 22:21:50. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.