Skip to main content
464 PIPER Street

464 PIPER Street

Ayr, Ontario

3 bed • 3 bath • Single Family

$2,699,000

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

Price History

Property

Lot Size
5.41 acres

Schools

Elementary

  • St Brigid Catholic Elementary School1.1 km

    Catholic · Waterloo CDSB · 355 students

    Grade 3 reading: 84% met the provincial standard · Grade 6 math: 67% met the provincial standard

  • Ayr Public School1.7 km

    Public · Waterloo Region DSB · 205 students

    Grade 3 reading: 62% met the provincial standard · Grade 6 math: 20% met the provincial standard

  • Cedar Creek Public School2.4 km

    Public · Waterloo Region DSB · 565 students

    Grade 3 reading: 71% met the provincial standard · Grade 6 math: 46% met the provincial standard

Straight-line distance. Nearby schools are not necessarily the assigned schools — confirm catchment with the school board. Scores are EQAO provincial test results for 2024-2025.

Community

Postal area N0B

Population
86,919
Private dwellings
31,269
Median age
42.8
Average household size
2.9
Median household income
$120,000

Source: Statistics Canada, 2021 Census of Population, catalogue 98-401-X2021013. Adapted from Statistics Canada. This does not constitute an endorsement by Statistics Canada of this product.

Local market

Single Family in Ayr · last 12 months

Median sold price
$0
Homes sold
0
Median days on market
0
Sale-to-list price
0.0%

Based on 0 recorded sales of single family properties in Ayr over the last 12 months.

Location

Mortgage Calculator

$539,800

Estimated Monthly Payment

$13,259

Investment Analysis

No recent nearby lease data. Enter a rent to see the numbers.

Mortgage: $13,259/mo (20% down, 5.5%)

Taxes: $0/mo · Insurance: $675/mo

Estimates only. Consult a financial advisor.

R

Reita | Assistant

Online

Reita said:

Reita is an automated assistant, not a licensed real estate agent. I can help you explore neighbourhoods, understand the market, and find our free tools. What are you looking for?

Interested in this property?

By submitting this form you consent to REintel, operated by Direct Realty Ltd. (6992 Hwy 62, Belleville, ON K8N 0L7) contacting you to respond to your inquiry and send you relevant property listings, market updates, and real-estate information. You can withdraw your consent at any time using the unsubscribe link in every email, or by contacting us at the mailing address above.

Cookie Preferences