Skip main navigation
For sale
  • C$2,699,000

    464 Piper St, North Dumfries, ON N0B 1E0

    3beds
    3,568sqft
    Single Family Residence, Residential
    Built in 1850
    5.41 Acres Lot
    $-- Zestimate®
    C$756/sqft
    C$-- HOA

    What's special

    Manicured groundsSoaring vaulted ceilingsOriginal exposed stone wallsGas fireplaceWide-plank flooringModernized showstopper kitchenMain floor laundry
    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
    81 days
    |
    27
    |
    2
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Andy Naudi, Salesperson,

    RE/MAX Twin City Realty Inc.

    Source: ITSO,MLS®#: 40831635Originating MLS®#: Cornerstone Association of REALTORS®

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      • Main level bathrooms: 1
      Other
      • Level: Second
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Bathroom
      • Features: 3-Piece
      • Level: Second
      Bathroom
      • Features: 2-Piece
      • Level: Main
      Other
      • Features: 4-Piece
      • Level: Second
      Dining room
      • Level: Main
      Eat in kitchen
      • Level: Main
      Great room
      • Level: Main
      Laundry
      • Level: Main
      Living room
      • Level: Main
      Mud room
      • Level: Main
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Bar Fridge, Water Softener, Dishwasher, Dryer, Range Hood, Refrigerator, Stove, Washer
      • Laundry: Main Level
      Features
      • High Speed Internet, Auto Garage Door Remote(s), Bed & Breakfast, In-Law Floorplan
      • Windows: Window Coverings
      • Basement: Partial,Unfinished
      • Number of fireplaces: 1
      Interior area
      • Total structure area: 3,568
      • Total interior livable area: 3,568 sqft
      • Finished area above ground: 3,568

      Property

      Parking
      • Total spaces: 18
      • Parking features: Detached Garage, Garage Door Opener, Asphalt, Outside/Surface/Open
      • Garage spaces: 3
      • Uncovered spaces: 15
      Features
      • Stories: 2
      • Patio & porch: Deck, Porch
      • Exterior features: Awning(s), Balcony, Landscape Lighting, Landscaped
      • Waterfront features: River/Stream
      • Frontage type: West
      • Frontage length: 311.10
      Lot
      • Size: 5.41 Acres
      • Dimensions: 311.1 x
      • Features: Rural, Corner Lot, Highway Access
      • Topography: Flat
      Details
      • Additional structures: Gazebo, Shed(s), Storage, Workshop
      • Additional parcels included: 22718010
      • Parcel number: 038530057
      • Zoning: Z1

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence, Residential
      Materials
      • Board & Batten Siding, Stone
      • Foundation: Stone
      • Roof: Asphalt Shing, Metal
      Condition
      • 100+ Years
      • New construction: No
      • Year built: 1850

      Utilities & green energy

      • Sewer: Septic Tank
      • Water: Drilled Well
      • Utilities for property: Fibre Optics, Natural Gas Connected

      Community & HOA

      Location
      • Region: North Dumfries

      Financial & listing details

      • Price per square foot: C$756/sqft
      • Annual tax amount: C$9,020
      • Date on market: 5/20/2026
      • Inclusions: Dishwasher, Dryer, Garage Door Opener, Range Hood, Refrigerator, Stove, Washer, Window Coverings
      A

      Andy Naudi, Salesperson

      (226) 789-7193

      By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.

        Price history

        DateEventPrice
        7/7/2026Listed for saleC$2,699,000C$756/sqft
        Source: TRREB #X13147520 Report a problem
        6/25/2026ContingentC$2,699,000C$756/sqft
        Source: ITSO #40831635 Report a problem
        5/20/2026Listed for saleC$2,699,000C$756/sqft
        Source: ITSO #40831635 Report a problem

        Public tax history

        Tax history is unavailable.

        Climate risks

        Neighborhood: N0B

        Getting around

        7 / 100
        Car-Dependent
        18 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        No schools nearby

        We couldn't find any schools near this home.

        Similar homes