It's in the top 10% of views. Tour it before it's gone!
Today:
About this home
Set on over 24 beautifully maintained acres, this premier boarding facility—formerly a renowned hunter/jumper barn—has been completely renovated to meet the needs of modern equestrians. The mixed usage property combines both residential property and commercial zoning. Featuring expansive riding spaces, including a 110' x 240' outdoor arena and a spacious indoor arena. Recent upgrades include newly installed outdoor wash racks and perimeter fencing to elevate the functionality and safety of the grounds. There are 14 well-appointed paddocks, each equipped with water, electricity, run-in sheds, and hay huts. Additional amenities include a pole barn for hay storage and a large enclosed shed that accommodates over 100 yards of shavings. A designated concrete manure collection area ensures clean and efficient waste management, while a new drainage system has been installed throughout the property for optimal land care. Inside the barn, you'll find tack bays conveniently located in each aisle, multiple tack rooms, matted stalls with operable windows, and a spacious grain room. Recent additions include a brand-new observation room equipped with modern comforts such as heating, air conditioning, a washer/dryer, full kitchen, coffee bar, cozy lounge area, stone fireplace, and a flat-screen TV. The facility also offers a professional reception area and a generously sized back office. Throughout the barn and arena, paneled ceilings with new LED lighting create a bright and inviting atmosphere, complemented by a state-of-the-art sound system for seamless communication and entertainment. Current tenants run the business completely seperate from the real estate sale of the property and would love to continue successfully running the full barn. Any future buyer would act as the land lord and would only need to cover insurance and taxes if this so appeals to them.
Single-familyProperty Type
1965Year Built
24.13 acresLot Size
$76Price/Sq.Ft.
3 spacesParking
Listed by Sara Hillier• Sine & Monaghan Realtors LLC St Clair
Set on over 24 beautifully maintained acres, this premier boarding facility-formerly a renowned hunter/jumper barn-has been completely renovated to meet the needs of modern equestrians. The mixed usage property combines both residential property and commercial zoning. Featuring expansive riding spaces, including a 110' x 240' outdoor arena and a spacious indoor arena. Recent upgrades include newly installed outdoor wash racks and perimeter fencing to elevate the functionality and safety of the grounds. There are 14 well-appointed paddocks, each equipped with water, electricity, run-in sheds, and hay huts. Additional amenities include a pole barn for hay storage and a large enclosed shed that accommodates over 100 yards of shavings. A designated concrete manure collection area ensures clean and efficient waste management, while a new drainage system has been installed throughout the property for optimal land care. Inside the barn, you'll find tack bays conveniently located in each aisle, multiple tack rooms, matted stalls with operable windows, and a spacious grain room. Recent additions include a brand-new observation room equipped with modern comforts such as heating, air conditioning, a washer/dryer, full kitchen, coffee bar, cozy lounge area, stone fireplace, and a flat-screen TV. The facility also offers a professional reception area and a generously sized back office. Throughout the barn and arena, paneled ceilings with new LED lighting create a bright and inviting atmosphere, complemented by a state-of-the-art sound system for seamless communication and entertainment. Current tenants run the business completely seperate from the real estate sale of the property and would love to continue successfully running the full barn. Any future buyer would act as the land lord and would only need to cover insurance and taxes if this so appeals to them.
MiRealSource-MiMLS #50177041
Aug 13, 2026
Listing Removed
—
Jan 26, 2026
Price Changed
$1,890,000
$76/sq ft
Dec 10, 2025
Relisted
—
Dec 4, 2025
Listing Removed
—
Oct 23, 2025
Price Changed
$1,999,000
$80/sq ft
Oct 14, 2025
Price Changed
$1,900,000
$76/sq ft
Oct 14, 2025
Relisted
—
Oct 1, 2025
Listing Removed
—
Sep 8, 2025
Price Changed
$2,190,000
$88/sq ft
Sep 4, 2025
Relisted
—
Sep 4, 2025
Listing Removed
—
Jun 3, 2025
Listed
$2,300,000
$92/sq ft
REALCOMP #58050177041
Mar 31, 2026
Relisted
—
Mar 27, 2026
Listing Removed
—
Jan 26, 2026
Price Changed
$1,890,000
$76/sq ft
Dec 10, 2025
Relisted
—
Oct 22, 2025
Price Changed
$1,999,000
$80/sq ft
Oct 14, 2025
Relisted
—
Oct 14, 2025
Price Changed
$1,900,000
$76/sq ft
Oct 1, 2025
Listing Removed
—
Oct 1, 2025
Listing Removed
—
Sep 8, 2025
Price Changed
$2,190,000
$88/sq ft
Sep 4, 2025
Relisted
—
Sep 4, 2025
Listing Removed
—
Jun 3, 2025
Listed
$2,300,000
$92/sq ft
MiRealSource-MiMLS #50123166
Mar 14, 2025
Listing Removed
—
Mar 14, 2025
Relisted
—
Feb 18, 2025
Listing Removed
—
Feb 18, 2025
Relisted
—
Feb 15, 2025
Listing Removed
—
Feb 15, 2025
Relisted
—
Feb 14, 2025
Price Changed
$2,399,900
$96/sq ft
Feb 7, 2025
Listing Removed
—
Feb 7, 2025
Relisted
—
Dec 24, 2024
Listing Removed
—
Dec 24, 2024
Contingent
—
Dec 13, 2024
Listing Removed
—
Dec 13, 2024
Relisted
—
Dec 11, 2024
Listing Removed
—
Dec 10, 2024
Relisted
—
Sep 25, 2024
Listing Removed
—
Sep 25, 2024
Relisted
—
Jul 16, 2024
Listing Removed
—
Jul 16, 2024
Relisted
—
Jun 21, 2024
Listing Removed
—
Jun 21, 2024
Relisted
—
Jun 19, 2024
Listing Removed
—
Jun 19, 2024
Relisted
—
Jun 15, 2024
Listing Removed
—
Jun 15, 2024
Relisted
—
Jun 12, 2024
Listing Removed
—
Jun 12, 2024
Relisted
—
Jun 11, 2024
Price Changed
$2,199,900
$88/sq ft
Jan 12, 2024
Listing Removed
—
Jan 12, 2024
Relisted
—
Jan 3, 2024
Listing Removed
—
Jan 3, 2024
Relisted
—
Jan 2, 2024
Price Changed
$2,650,000
$106/sq ft
Nov 1, 2023
Listing Removed
—
Nov 1, 2023
Relisted
—
Sep 30, 2023
Listing Removed
—
Sep 30, 2023
Relisted
—
Sep 28, 2023
Listing Removed
—
Sep 28, 2023
Relisted
—
Sep 27, 2023
Listing Removed
—
Sep 26, 2023
Listed
$2,999,900
$120/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Oakland County
APN
—
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 3, 2025.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
2/10 Heat Factor
7 days above 97° expected this year, 15 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Leonard, MI • 48367
Average low and high temperatures (°F)
27
13
33
17
50
29
59
39
66
46
80
58
83
63
79
59
76
54
65
43
47
35
34
22
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
100/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.5 hrs
6.2 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 270 N Rochester Rd
$1,429,309
$461K under list price of $1.89M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $615K to $1.3M.