464 PIPER STREET, North Dumfries, Ontario, N0B1E0

Favourite
For sale, ID#: X13147520
464 PIPER STREET
North Dumfries Ontario
Share this Property
3 Beds
3 Bath (2 full, 1 half)
$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 (id:2471)

Representative
Charlotte McConkey
Charlotte McConkeySales Representative
McConkey Real Estate Corp. Brokerage
View My Profile
Virtual Tours
Click here for more information
Property Details
  • Property Address: 464 PIPER STREET, North Dumfries, Ontario, N0B1E0
  • Property Type: Single Family
  • Zoning Description: Z1
  • Title: Freehold
  • Lot Size: 311.1 x 611 FT
  • Acreage: 311.1 x 611 FT|5 - 9.99 acres
  • Sewage Type: Septic System
  • Driveway: Detached Garage, Garage
  • Total Parking Spaces: 18
Structure Details
  • Structure Style: House
  • Style: Detached
  • Storeys: 2
  • Floor Space: 3500 - 5000 sqft
  • Building Age: 100+ years
  • Bedrooms: 3
  • Bathrooms: 3-Total 1-Partial
  • Basement Type: Partial (Unfinished)
  • Heating Type: Natural gas, Forced air
  • Cooling: Central air conditioning
  • Exterior Type: Wood, Stone
  • Fireplace Present: True
  • Foundation Type: Stone
  • Appliances Included: Water softener, Water Treatment, All, Window Coverings
  • Structures: Deck
  • View: River view
Amenities / Features
  • In-Law Suite
  • Landscaped
External Documents
Room Details
Type Level Dimensions
Bathroom Second level 2.44 m x 2.06 m
Primary Bedroom Second level 6.91 m x 4.29 m
Bathroom Second level 1.6 m x 2.87 m
Bedroom 2 Second level 4.29 m x 4.44 m
Bedroom 3 Second level 4.29 m x 3.05 m
Great room Main level 10.08 m x 7.57 m
Bathroom Main level 1.96 m x 1.65 m
Kitchen Main level 7.77 m x 4.93 m
Living room Main level 4.93 m x 3.33 m
Dining room Main level 4.14 m x 4.72 m
Mud room Main level 2.84 m x 4.55 m
Laundry room Main level 3.02 m x 3 m
Neighbourhood Information

Listing Office: RE/MAX TWIN CITY REALTY INC.

This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association. REALTOR®, MLS® and the associated logos are trademarks of the Canadian Real Estate Association. This website is operated by a brokerage or salesperson who is a member of The Canadian Real Estate Association and is licensed to trade residential and/or commercialreal estate. Any out of province listing content on this website is not intended to solicit a trade in real estate. Any consumers interested in out of province listings must contact a person who is licensed to trade in real estate in that province. All information displayed on this website is believed to be accurate but is not guaranteed and should be independently verified. No warranties or representations are made of any kind.

464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0 464 PIPER STREET, North Dumfries, Ontario, N0B1E0
464 PIPER STREET, North Dumfries, Ontario, N0B1E0

This website is operated by a member of The Canadian Real Estate Association (CREA). The content on this website is owned or controlled by CREA. By accessing this website, the user agrees to be bound by these terms of use as amended from time to time, and agrees that these terms of use constitute a binding contract between the user, and CREA.

The content on this website is protected by copyright and other laws, and is intended solely for the private, non-commercial use by individuals. Any other reproduction, distribution or use of the content, in whole or in part, is specifically prohibited. Prohibited uses include commercial use, "screen scraping", "database scraping", and any other activity intended to collect, store, reorganize or manipulate the content of this website.

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks that are owned by REALTOR® Canada Inc. and licensed exclusively to The Canadian Real Estate Association (CREA). These certification marks identify real estate professionals who are members of CREA and who must abide by CREA's By-Laws, Rules, and the REALTOR® Code. The MLS® trademark and the MLS® logo are owned by CREA and identify the professional real estate services provided by members of CREA.

The information contained on this website is based in whole or in part on information that is provided by members of CREA, who are responsible for its accuracy. CREA reproduces and distributes this information as a service for its members, and assumes no responsibility for its completeness or accuracy.

We may at any time amend these Terms of Use by updating this posting. All users of this site are bound by these amendments should they wish to continue accessing the website, and should therefore periodically visit this page to review any and all such amendments.

By using our site, you agree to our Terms of Use

Sign into your account

Create an account

Reset Password