S a n d a l R e a l E s t a t e S e r v i c e s I n c , B r o k e r a g e
  • Contact Us
  • Knowledge Base
    Add Listing

    464 Piper Street, North Dumfries, ON N0B 1E0

    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    464 Piper Street, North Dumfries, ON N0B 1E0
    For Sale Active Residential Freehold

    464 Piper Street, North Dumfries, ON N0B 1E0

    $2,699,000

    icon
    464 Piper Street, North Dumfries, ON N0B 1E0, North Dumfries, ON
    • icon
      Bed 3
    • icon
      Bath 3

    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

    Property Highlights

    For Sale
    • icon

      MLS NO.

      X13147520

    • img

      Type

      Residential Freehold

    • img

      Sub Type

      Detached

    • img

      Bedrooms

      3

    • img

      Bathrooms

      3

    • img

      Parking

      18.0

    • img

      Garage

      Yes

    Complete Property Details

    Property Type Residential Freehold
    Sub Type Detached
    Transaction Type For Sale
    Status Active
    Contract Status Available
    MLS® Number X13147520
    Living Area Range 3500-5000
    Total Bedrooms 3
    Bedrooms Above Grade 3
    Total Bathrooms 3
    Total Kitchens 1
    Kitchens Above Grade 1
    Rooms Above Grade 13
    Interior Features Accessory Apartment, In-Law Suite, Water Softener, Water Treatment
    Fireplace Yes
    Fireplace Features Natural Gas
    Central Vacuum Yn No
    Construction Board & Batten , Stone
    Roof Asphalt Shingle, Metal
    Lot Width 311.1
    Lot Size 5.41
    Lot Size Units Acres
    Parking Features Circular Drive
    Parking Total 18.0
    Covered Spaces 3.0
    Garage Type Detached
    Garage Yes
    Pool Above Ground
    Direction Facing West
    Cooling Central Air
    Heat Source Gas
    Heat Type Forced Air
    Internet Address Display Yn Yes
    Internet Entire Listing Display Yn Yes
    Full Address 464 Piper Street, North Dumfries, ON N0B 1E0
    City North Dumfries
    County / Region Waterloo
    Province / State ON
    Postal Code N0B 1E0
    Cross Street Gladstone
    Directions Hwy 97 to Northumberland St, right on Piper St about 1 mile to 464
    List Price $2,699,000
    Annual Taxes $9,020
    Tax Year 2025
    Legal Description CON 8 PT LOT 38
    Possession Type Other
    Possession Details 120 days +
    Listing Office RE/MAX TWIN CITY REALTY INC.
    Board Toronto Regional Real Estate Board
    Original Entry 2026-05-20T10:39:07Z
    Media Updated 2026-05-28T14:13:53Z
    Photos Updated 2026-05-28T14:13:53Z
    Last Modified 2026-07-07T12:42:15Z
    System Modified 2026-07-07T12:42:24.574293Z
    MLS Status New
    Architectural Style 2-Storey
    Basement Partial Basement, Unfinished
    Ddfyn Yes
    Expiration Date 2026-10-01
    Foundation Details Stone
    Heat Source Multi Gas
    Heat Type Multi Forced Air
    Hstapplication Not Subject to HST
    Link Yn No
    Occupant Type Owner
    Originating System Id A00001796
    Parcel Number 038530057
    Parking Spaces 15
    Public Remarks 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
    Showing Requirements Showing System
    Street Name Piper
    Street Number 464
    Street Suffix Street
    Vendor Property Info Statement No
    Virtual Tour Urlunbranded https://unbranded.youriguide.com/464_piper_st_north_dumfries_on/
    Washrooms Type1 1
    Washrooms Type1 Level Second
    Washrooms Type1 Pcs 4
    Washrooms Type2 1
    Washrooms Type2 Level Second
    Washrooms Type2 Pcs 3
    Washrooms Type3 1
    Washrooms Type3 Level Main
    Washrooms Type3 Pcs 2