Discover
Sign in
Aerial View
See all 50 photos
See all 50 photos
Active
Detached
· Added 33 days ago
Listed for $2,699,000
464 Piper St
3
Beds
3
Baths
21
Parking
3500-5000
sqft
Key Facts
Tax
$9,020 / year
Property Type
Detached, 2-Storey
Building Age
100+
Size
3500-5000 sqft
Parking
3 Garage, 15 Driveway, Circular
Basement
Part Bsmt, Unfinished
MLS#
X13147520
Brokerage
RE/MAX TWIN CITY REALTY INC.
Days on Site
33
Property Details
Property
Type
Detached
Style
2-Storey
Year Built
100+
Exterior
Board & Batten
Roof
Asphalt Shingle, Metal
Foundation
Stone
Inside
Bedrooms
3
Bathrooms
3
Bath (2nd)
1 (4-pc)
Bath (2nd)
1 (3-pc)
Bath (Main)
1 (2-pc)
Kitchens
1
Basement
Part Bsmt, Unfinished
Den
Yes
Family Room
Yes
Utilities
Heating
Forced Air
Air Conditioning
Central Air
Sewer
Septic
Water
Well
Building
Size
3500-5000 sqft
Exterior
Board & Batten
Exterior (2nd)
Stone
Parking
Driveway
Circular
Garage Type
Detached
Garage Spaces
3
Parking Spaces
18
Driveway Spaces
15
Outdoor
Pool
Abv Grnd
Rooms
m
ft
Great Rm
Main
33.1 x 24.8 ft
Kitchen
Main
25.5 x 16.2 ft
Living
Main
16.2 x 10.9 ft
Dining
Main
13.6 x 15.5 ft
Mudroom
Main
9.3 x 14.9 ft
Laundry
Main
9.9 x 9.8 ft
Primary
2nd
22.7 x 14.1 ft
Bathroom
2nd
5.2 x 9.4 ft
4 Pc Ensuite
2nd Br
2nd
14.1 x 14.6 ft
3rd Br
2nd
14.1 x 10.0 ft
Bathroom
2nd
8.0 x 6.8 ft
Bathroom
Main
6.4 x 5.4 ft
2 Pc Bath
Room
Level
Dimensions
Features
Great Rm
Main
33.1 x 24.8 ft
—
Kitchen
Main
25.5 x 16.2 ft
—
Living
Main
16.2 x 10.9 ft
—
Dining
Main
13.6 x 15.5 ft
—
Mudroom
Main
9.3 x 14.9 ft
—
Laundry
Main
9.9 x 9.8 ft
—
Primary
2nd
22.7 x 14.1 ft
—
Bathroom
2nd
5.2 x 9.4 ft
4 Pc Ensuite
2nd Br
2nd
14.1 x 14.6 ft
—
3rd Br
2nd
14.1 x 10.0 ft
—
Bathroom
2nd
8.0 x 6.8 ft
—
Bathroom
Main
6.4 x 5.4 ft
2 Pc Bath
Description
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...
Extras
All appliances, window coverings, riding zero turn mower, great room table and stools
Location
Navigate
Listing History
Sign in to view listing history
Estimates
Home Value Estimate
This estimate may be unreliable due to limited comparable data in this area.
Estimated Value
$2,485,908
Range
$2,228,371
$2,743,444
Confidence
10%
Estimated Date
May 20, 2026
Value History
Estimated Value

Mortgage Calculator

Home Price
Amortization Term
25 years
Interest Rate
%
Down Payment
0%
50%
100%
Mortgage Payment
$12,724/mo
Principal
$1,988,726
Down Payment
$497,182
Total Interest
$1,828,474

Cash Flow Analysis

Mortgage Payment
$0/mo
(from calculator)
Monthly Payment (total costs)
$752/mo
Mortgage ($0) + Tax ($752)
Property Tax (Monthly)
Maintenance Cost
Rental Income
-$752
Cash Flow
Monthly Cash Flow
-$752
/mo
Rental Income
$0
Mortgage
-$0
Property Tax
-$752
Net Cash Flow
-$752
Comparables
Community
Schools & Demographics — Coming Soon
I'd like to book a viewing
Get immediate assistance from our team
437-748-8696
Available 7 days a week, 9am – 9pm EST
I'd like to book a viewing
Get immediate assistance from our team
437-748-8696
Available 7 days a week, 9am – 9pm EST