464 Piper Street Ayr, Ontario N0B 1E0
$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 completely 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. (id:52468)
Property Details
| MLS® Number | 40831635 |
| Property Type | Single Family |
| Communication Type | High Speed Internet |
| Features | Corner Site, Paved Driveway, Country Residential, Gazebo, Automatic Garage Door Opener, In-law Suite |
| Parking Space Total | 18 |
| Structure | Workshop, Shed, Porch |
Building
| Bathroom Total | 3 |
| Bedrooms Above Ground | 3 |
| Bedrooms Total | 3 |
| Appliances | Dishwasher, Dryer, Refrigerator, Stove, Water Softener, Washer, Hood Fan, Window Coverings, Garage Door Opener |
| Architectural Style | 2 Level |
| Basement Development | Unfinished |
| Basement Type | Partial (unfinished) |
| Constructed Date | 1850 |
| Construction Style Attachment | Detached |
| Cooling Type | Central Air Conditioning |
| Exterior Finish | Stone |
| Fireplace Present | Yes |
| Fireplace Total | 1 |
| Foundation Type | Stone |
| Half Bath Total | 1 |
| Heating Fuel | Natural Gas |
| Heating Type | Forced Air |
| Stories Total | 2 |
| Size Interior | 3,568 Sqft |
| Type | House |
| Utility Water | Drilled Well |
Parking
| Detached Garage | |
| Open |
Land
| Access Type | Highway Access |
| Acreage | Yes |
| Sewer | Septic System |
| Size Frontage | 311 Ft |
| Size Irregular | 5.41 |
| Size Total | 5.41 Ac|5 - 9.99 Acres |
| Size Total Text | 5.41 Ac|5 - 9.99 Acres |
| Zoning Description | Z1 |
Rooms
| Level | Type | Length | Width | Dimensions |
|---|---|---|---|---|
| Second Level | 3pc Bathroom | 8'0'' x 6'9'' | ||
| Second Level | Bedroom | 14'1'' x 10'0'' | ||
| Second Level | Bedroom | 14'1'' x 14'7'' | ||
| Second Level | Full Bathroom | 5'3'' x 9'5'' | ||
| Second Level | Primary Bedroom | 22'8'' x 14'1'' | ||
| Main Level | 2pc Bathroom | 6'5'' x 5'5'' | ||
| Main Level | Laundry Room | 9'11'' x 9'10'' | ||
| Main Level | Mud Room | 9'4'' x 14'11'' | ||
| Main Level | Dining Room | 13'7'' x 15'6'' | ||
| Main Level | Living Room | 16'2'' x 10'11'' | ||
| Main Level | Eat In Kitchen | 25'6'' x 16'2'' | ||
| Main Level | Great Room | 33'1'' x 24'10'' |
Utilities
| Natural Gas | Available |
https://www.realtor.ca/real-estate/29774850/464-piper-street-ayr
Contact Us
Contact us for more information
Andy Naudi
Salesperson
andynaudi.rtccore.com/
www.facebook.com/AndyNaudiReMax
www.instagram.com/andynaudi_sellingkw/
901 Victoria Street N., Suite B
Kitchener, Ontario N2B 3C3
(519) 579-4110
www.remaxtwincity.com/
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)
May 20 2026 06:00:38
REALTORS® Association of Hamilton-Burlington
RE/MAX Twin City Realty Inc.