368-3689910_homelife-bayside-realty-ltd-brokerage

Vikas Palan Sales Representative Homelife Super Stars Real Estate LTD

Call Now: 416-939-2500 Email: vikas@vikaspalan.com

464 Piper Street, North Dumfries, ON N0B 1E0

$2,699,000
  • Sale
  • Detached
  • 36 days ago
  • Updated: 2026-05-27

Property Overview

Property Type
Detached
Bedrooms
3
Bathrooms
3
Garage
Detached/15
Size
N/A
Age
100+
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

Key Details

  • X13147520
  • Detached/15
  • $2,699,000
  • Owner
  • Above Ground
  • 1 + 1
  • 2-Storey
  • 3
  • 3
  • 3500-5000 Sqft
  • 5.41 Acres
  • 100+
  • Detached
  • Sale

Additional Details

  • Forced Air / Gas
  • Z1
  • $9020
  • 2025
  • CON 8 PT LOT 38
  • N/A
  • N
  • 5.41
  • Partial Basement,Unfinished
  • 1
  • Central Air
  • Deck,Landscaped
  • Well
RoomLevelSize
Great RoomMain7.57 x 10.08 (m)
KitchenMain4.93 x 7.77 (m)
Living RoomMain3.33 x 4.93 (m)
Dining RoomMain4.72 x 4.14 (m)
Mud RoomMain4.55 x 2.84 (m)
LaundryMain3 x 3.02 (m)
Primary BedroomSecond4.29 x 6.91 (m)
BathroomSecond2.87 x 1.6 (m)
Bedroom 2Second4.44 x 4.29 (m)
Bedroom 3Second3.05 x 4.29 (m)
BathroomSecond2.06 x 2.44 (m)
BathroomMain1.65 x 1.96 (m)

Properties you may like

Est. monthly payment
Edit details
$
%
yr
%

Down payment
Loan amount
Land transfer tax
CMHC premium
Total upfront

Enter your expected mortgage, annual expenses, and rental income to calculate monthly cash flow for this investment property.

$
$
$
Monthly Cash Flow
net per month
Annual Cash Flow
net per year
Monthly Costs
mortgage + expenses
Cost Coverage
costs vs rent

Estimates only. Not financial or investment advice.

FAQ
  • What is the total square footage of the x13147520 - 464 Piper Street, North Dumfries, ON N0B 1E0?

    The total square footage of this property is 3500-5000 SqFt.

Book a Viewing or Contact Us

Ask a question or request a viewing, we’ll respond quickly

Or
Text (416-939-2500) me directly for fastest response
RoofUp
Logo