464 Piper Street, North Dumfries

$2,699,000
464 Piper Street

$2,699,000

Extension
181d
Detached2-Storey

464 Piper Street, North Dumfries

Total Monthly Obligation $12,014

Beds
3
Baths
3
Park
15
Sqft
3500-5000
DOM
181d
Property Type-Detached
MLS® Number-X13147520
Beds-3
Bathrooms-3
Size-3500-5000 sqft
Lot Size-311.1 × 611 ft
Listed on site-May 20, 2026
Style-2-Storey
Building Type-Detached
Age-100+
Taxes-$9,020 (2025)
Parking-18 - Detached
Basement-Partial Basement, Unfinished
Heating-Forced Air (Gas)
Brokerage-RE/MAX TWIN CITY REALTY INC.
Cooling-Central Air
Laundry-No
Fireplace-Natural Gas
Pool-Above Ground
Facing-West
Exterior-Board & Batten , Stone
Roof-Asphalt Shingle, Metal
Foundation-Stone
Sewer-Septic
Possession-120 days +
Title-Residential Freehold

No agent assigned

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.

$
$
%
%
$
$
$
(utilities, internet...)
$
%
%

Closing Costs

Mortgage Amount
$2,159,200
Land Transfer Taxes$53,950
Legal Fees (Est.)
$
Total cash required for closing$595,250

Total Monthly Obligation

$12,014/mo
Mortgage $10,887
Monthly Loss $9,149
Principal$2,865
Interest$8,022
Property Tax$752
Home Insurance$125
Variable Costs$250

No rent estimate available. Enter a monthly rent in Assumptions & Inputs below to calculate.

Assumptions & Inputs
$/mo
%
$
yr
%

*This analysis is independently generated NOT provided by TREB or CREA.

Comparables

Properties near 464 Piper Street

Time

Comparables are calculated within a 3km radius based on properties sold or leased within the past 6 months. This helps you understand the current market value and potential rental yield with high precision.

Data is provided courtesy of PropTx.

The information provided herein must only be used by consumers who have a bona fide interest in the purchase, sale, or lease of real estate and may not be used for any commercial or other purpose.

Listing information is deemed reliable but not guaranteed accurate by PropTx or TRREB.

REALTOR®, REALTORS®, and the REALTOR® logo are certification marks owned by REALTOR® Canada Inc. and licensed exclusively to the Canadian Real Estate Association (CREA).

The MLS® trademark and MLS® logo are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.

Data last updated within the past 24 hours.