Aspen-inspired resort living with breathtaking lake views on approximately 28 private acres (2 parcels), with an additional 27 adjacent acres available for purchase. This original-owner custom estate in exclusive Rocky Ridge Estates offers 9,360 square feet of luxury living in a truly one-of-a-kind setting. A long private drive leads to the home, where a dramatic 30-foot foyer with an exterior stunning rock water feature creates an unforgettable first impression. Designed with natural stone, brick, wood, the home blends timeless architecture with its spectacular surroundings. Expansive windows, many floor-to-ceiling, capture panoramic lake views from multiple living spaces on both the main level & finished walkout lower level. The home features 6 bedrooms, 6.5 baths, with each bedroom offering a private full bath/walk-in closet. The gourmet kitchen includes Thermador stainless appliances, a 6-burner gas cooktop, commercial-style refrigerator, built-in freezer, vegetable sink, pot filler, granite countertops, refrigerator drawers, & a large walk-in pantry. The kitchen opens to the two-story great room with a wood-burning fireplace & sweeping water views. The main-level owner's suite overlooks the lake, includes a spacious bath, two large walk-in closets, & a private exercise area. The finished walkout lower level is ideal for entertaining with a wet bar that functions as a second kitchen, family room with gas fireplace, theater room, sauna, workout room, game room, nanny/in-law suite, (multigenerational design) & large playroom. Outdoor amenities include a saltwater in-ground pool & gazebo overlooking the water. Additional highlights include a heated 5-car side-entry garage with loft storage, whole-house generator, tankless water heater, 8-foot interior doors, mudroom/ dog wash station. A rare opportunity to own a private lakefront estate with unmatched luxury, acreage, & views. Equestrian possibilities. Only 9 min. to I-75! Some photos digital staged.
Single-familyProperty Type
2008Year Built
17.73 acresLot Size
$214Price/Sq.Ft.
4 car garageParking
Listed by Philip Herman• RE/MAX Real Estate Specialists
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
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
Miami County
APN
J27000310
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 22, 2026.
A-2
General Agricultural District
This district is composed of certain land being used for agricultural activities, open recreational uses, and other open land use. Sub-marginal lands having no principal uses also are included in this district.
Climate risks
9/10 Flood Factor
Estimated 80%+ chance 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
3/10 Heat Factor
7 days above 100° expected this year, 18 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Piqua, OH • 45356
Average low and high temperatures (°F)
31
15
40
24
59
37
67
46
70
52
82
64
86
68
81
60
82
55
69
46
52
37
40
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
Try the sun simulator tool to see how light moves across the property at different times of day and year.
Provided by Shadowmap
Redfin Estimate for 9606 Piqua Lockington Rd
$1,843,048
$157K under list price of $2.00M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $275K to $550K.