Description
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,...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.
- Listed by Philip L Herman • Brokerage DRE #398732 • RE/MAX Real Estate SpecialistsP: (937)-305-4838 C: (937)-305-4838 Phil@philherman.com
Property Details for 9606 Piqua Lockington Road
Architectural Style
Other
Has WaterfrontYes
ZoningResidential
Zoning DescriptionResidential
LISTING UPDATED: 05/24/2026 01:05 PM
Property Details for 9606 Piqua Lockington Road
| Status | Active |
|---|---|
| MLS # | 957550 |
| Days on Market | 40 |
| Taxes | - |
| HOA Fees | - |
| Condo/Co-op Fees | - |
| Property Type | Single Family |
| MLS Type | Residential / Single Family Residence |
| Year Built | 2008 |
| Lot Size | 17.73 AC / 772,319 SF |
| County | Miami County |
Location
Listing Courtesy of RE/MAX Real Estate Specialists
Add your commute
Building Information for 9606 Piqua Lockington Road
Stories1Year Built2008Building Size-Lot Size17.73 AC / 772,319 SF
Payment Calculator
$10,963 per month
30 year fixed, 6.36% Interest
Principal and Interest
$10,963
Property Taxes
$0
HOA Dues
$0
The Payment Calculator is for illustrative purposes only.
Know your buying power with a preapproval and custom rate in minutes
1Property Information for 9606 Piqua Lockington Road
Summary
Location and General Information
- Latitude: 40.17848
- Longitude: -84.24406
Taxes and HOA
- Association: No
- Parcel Number: J27000310
- Tax Legal Description: 12-1-32 SE PT NW TR J
School Information
- Elementary School District: Piqua
- High School District: Piqua
- Middle Or Junior School District: Piqua
Parking
- Attached Garage: Yes
- Garage Spaces: 4.0
- Garage: Yes
- Parking Features: Attached, Garage, Garage Door Opener, Heated Garage, Storage
Property
Lot Information
- Lot Features: Waterfront
- Lot Size Acres: 17.73
- Lot Size Area: 772319.0
- Lot Size Dimensions: irregular
- Lot Size Source: Assessor
- Lot Size Square Feet: 772319.0
- Lot Size Units: Square Feet
Property and Assessments
- Below Grade Finished Area: 4190.0
- Building Area Total: 9360.0
- Living Area: 9360.0
- Living Area Source: Assessor
- Property Sub Type: Single Family Residence
- Property Type: Residential
- Year Built: 2008
Building Features
- Construction Materials: Stone, Wood Siding
- Levels: One
Farm Information
- Other Equipment: Generator
Utilities
- Sewer: Septic Tank
- Utilities: Water Available
- Water Source: Public, Private, Well
Interior and Exterior Features
Exterior Features
- Patio And Porch Features: Deck, Patio, Porch
- Pool Features: Outdoor Pool, In Ground
- Stories: 1
Interior Features
- Appliances: Oven, Cooktop, Dryer, Dishwasher, Disposal, Microwave, Refrigerator, Water Softener, Washer, Tankless Water Heater
- Basement: Full, Finished, Walk-Out Access
- Has Basement: Yes
- Full Bathrooms: 6
- Half Bathrooms: 1
- Total Integer Bathrooms: 7
- Total Bedrooms: 6
- Cooling: Central Air
- Has Cooling: Yes
- Fireplace Features: Gas, Wood Burning
- Total Fireplaces: 2
- Has Fireplace: Yes
- Heating: Propane
- Has Heating: Yes
- Interior Features: Wet Bar, Cathedral Ceiling(s), Granite Counters, Kitchen Island, Pantry, Sauna, Vaulted Ceiling(s), Bar, Walk-In Closet(s), Central Vacuum
- Main Level Bathrooms: 4
- Total Rooms: 16
- Security Features: Security System, Smoke Detector(s)
- Has Spa: Yes
- Window Features: Insulated Windows
Room Information
Room 1
- Room Dimensions: 15 x 13
- Room Length: 15.0
- Room Level: Lower
- Room Type: Bedroom
- Room Width: 13.0
Room 2
- Room Dimensions: 30 x 18
- Room Length: 30.0
- Room Level: Main
- Room Width: 18.0
Room 3
- Room Dimensions: 17 x 13
- Room Length: 17.0
- Room Level: Main
- Room Type: Dining Room
- Room Width: 13.0
Room 4
- Room Dimensions: 32 x 16
- Room Length: 32.0
- Room Level: Lower
- Room Type: Media Room
- Room Width: 16.0
Room 5
- Room Dimensions: 28 x 21
- Room Length: 28.0
- Room Level: Main
- Room Type: Master Bedroom
- Room Width: 21.0
Room 6
- Room Dimensions: 25 x 17
- Room Length: 25.0
- Room Level: Lower
- Room Type: Great Room
- Room Width: 17.0
Room 7
- Room Dimensions: 21 x 20
- Room Length: 21.0
- Room Level: Lower
- Room Width: 20.0
Room 8
- Room Dimensions: 12 x 8
- Room Length: 12.0
- Room Level: Main
- Room Type: Office
- Room Width: 8.0
Room 9
- Room Dimensions: 15 x 13
- Room Length: 15.0
- Room Level: Main
- Room Type: Bedroom
- Room Width: 13.0
Room 10
- Room Dimensions: 21 x 16
- Room Length: 21.0
- Room Level: Lower
- Room Type: Bedroom
- Room Width: 16.0
Room 11
- Room Dimensions: 25 x 25
- Room Length: 25.0
- Room Level: Main
- Room Type: Family Room
- Room Width: 25.0
Room 12
- Room Dimensions: 11 x 10
- Room Length: 11.0
- Room Level: Main
- Room Type: Utility Room
- Room Width: 10.0
Mobile Home
Mobile Home Information
- Model: Colorado/Aspen inspired Architectural
Rental
Rent Information
- Lease Considered: No
Property History for 9606 Piqua Lockington Road
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| May 29, 2026 | Temporarily Off Market Dayton REALTORS #922338 | — | |
| Apr 24, 2026 | Listed (Active) Dayton REALTORS #957550 | $2,200,000 | — |
| Oct 22, 2024 | Listed (Active) Dayton REALTORS #922338 | $2,500,000 | — |
| Date | Event & Source | Price |
|---|---|---|
| 05/29/2026 | Temporarily Off Market Dayton REALTORS #922338 | — |
| 04/24/2026 | Listed (Active) Dayton REALTORS #957550 | $2,200,000 |
| 10/22/2024 | Listed (Active) Dayton REALTORS #922338 | $2,500,000 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Schools near 9606 Piqua Lockington Road
This home is within Piqua City School District.
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | K to 3 | |||
| Public - | 4 to 6 | |||
| Public - | 7 to 8 | |||
| Public - | 9 to 12 |
Rating | School | Distance |
|---|---|---|
Springcreek Primary Elementary School PublicK to 3 | ||
Wilder Intermediate Elementary School Public4 to 6 | ||
Piqua Junior High School Public7 to 8 | ||
Piqua High School Public9 to 12 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Explore Nearby Homes
- Brown Township - Miami County Homes for Sale
- Concord Township - Miami County Homes for Sale
- Green Township - Shelby County Homes for Sale
- Lockington Homes for Sale
- Loramie Township - Shelby County Homes for Sale
- Lostcreek Township - Miami County Homes for Sale
- Newberry Township - Miami County Homes for Sale
- Orange Township - Shelby County Homes for Sale
- Springcreek Township - Miami County Homes for Sale
- Staunton Township - Miami County Homes for Sale
- Washington Township - Miami County Homes for Sale
- Washington Township - Shelby County Homes for Sale
- Newton Township - Miami County Homes for Sale
- Clinton Township - Shelby County Homes for Sale
- Turtle Creek Township - Shelby County Homes for Sale
- Piqua Homes for Sale
- Fletcher Homes for Sale
- Covington Homes for Sale
- Troy Homes for Sale
- Sidney Homes for Sale
- Houston Homes for Sale
- Pleasant Hill Homes for Sale
- Conover Homes for Sale
- Russia Homes for Sale
- Casstown Homes for Sale
- Bradford Homes for Sale
- St. Paris Homes for Sale
- Christiansburg Homes for Sale
- Versailles Homes for Sale
- Ludlow Falls Homes for Sale
- 45373 Homes for Sale
- 45318 Homes for Sale
- 45326 Homes for Sale
- 45333 Homes for Sale
- 45365 Homes for Sale
- 45312 Homes for Sale
- 45317 Homes for Sale
- 45363 Homes for Sale
- 45359 Homes for Sale
- 45308 Homes for Sale
- 45845 Homes for Sale
- 45339 Homes for Sale
- 43072 Homes for Sale
- 45380 Homes for Sale
- 45337 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.
Listing Courtesy of RE/MAX Real Estate Specialists
The data relating to real estate for sale on this website comes in part from the Internet Data exchange program of Dayton REALTORS®. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed. Copyright © 2026 Dayton REALTORS®. All rights reserved.
