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.
For sale
Price cut: $200.1K (9/10)
$1,999,900
9606 Piqua Lockington Rd, Piqua, OH 45356
6beds
9,360sqft
Single Family Residence
Built in 2008
17.73 Acres Lot
$1,817,800 Zestimate®
$214/sqft
$-- HOA
What's special
Saltwater in-ground poolGazebo overlooking the waterLarge playroomBreathtaking lake viewsWorkout roomGame roomGranite countertops
- 162 days
- 1,674
- 103
Zillow last checked:
Listing updated:
Listed by:
Philip L Herman (937)436-9900,
RE/MAX Real Estate Specialists
Source: DABR MLS,MLS#: 957550
Originating MLS: Dayton Area Board of REALTORS
Originating MLS: Dayton Area Board of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 7
- Full bathrooms: 6
- 1/2 bathrooms: 1
- Main level bathrooms: 4
Primary bedroom
- Level: Main
- Dimensions: 28 x 21
Bedroom
- Level: Lower
- Dimensions: 15 x 13
Bedroom
- Level: Main
- Dimensions: 15 x 13
Bedroom
- Level: Main
- Dimensions: 15 x 12
Bedroom
- Level: Lower
- Dimensions: 21 x 16
Bedroom
- Level: Main
- Dimensions: 15 x 12
Dining room
- Level: Main
- Dimensions: 17 x 13
Entry foyer
- Level: Main
- Dimensions: 30 x 18
Exercise room
- Level: Lower
- Dimensions: 25 x 16
Family room
- Level: Main
- Dimensions: 25 x 25
Family room
- Level: Lower
- Dimensions: 17 x 13
Great room
- Level: Lower
- Dimensions: 25 x 17
Media room
- Level: Lower
- Dimensions: 32 x 16
Office
- Level: Main
- Dimensions: 12 x 8
Recreation
- Level: Lower
- Dimensions: 21 x 20
Utility room
- Level: Main
- Dimensions: 11 x 10
Heating
- Propane
Cooling
- Central Air
Appliances
- Included: Built-In Oven, Cooktop, Dryer, Dishwasher, Disposal, Microwave, Refrigerator, Water Softener, Washer, Tankless Water Heater
Features
- Wet Bar, Cathedral Ceiling(s), Granite Counters, Hot Tub/Spa, Kitchen Island, Kitchen/Family Room Combo, Pantry, Second Kitchen, Sauna, Vaulted Ceiling(s), Bar, Walk-In Closet(s), Central Vacuum
- Windows: Insulated Windows
- Basement: Full,Finished,Walk-Out Access
- Number of fireplaces: 2
- Fireplace features: Two, Gas, Wood Burning
Interior area
- Total structure area: 9,360
- Total interior livable area: 9,360 sqft
Property
Parking
- Total spaces: 4
- Parking features: Attached, Four or more Spaces, Garage, Garage Door Opener, Heated Garage, Storage
- Attached garage spaces: 4
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck, Patio, Porch
- Exterior features: Deck, Pool, Porch, Patio
- Pool features: In Ground
- On waterfront: Yes
Lot
- Size: 17.73 Acres
Details
- Parcel number: J27000310
- Zoning: Residential
- Zoning description: Residential
- Other equipment: Generator
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence
Materials
- Stone, Wood Siding
Condition
- Year built: 2008
Details
- Builder model: Colorado/Aspen inspired Architectural
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Septic Available, Water Available
Community & HOA
Community
- Security: Smoke Detector(s), Surveillance System
HOA
- Has HOA: No
Location
- Region: Piqua
Financial & listing details
- Price per square foot: $214/sqft
- Tax assessed value: $1,676,600
- Annual tax amount: $20,895
- Date on market: 4/24/2026
- Date available: 04/26/2026
Estimated market value
$1,817,800
$1.73M - $1.91M
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 9/10/2026 | Price change | $1,999,900-9.1%$214/sqft |
Source:  DABR MLS #957550 Report a problem | ||
| 4/25/2026 | Listed for sale | $2,200,000$235/sqft |
Source: DABR MLS #957550 Report a problem | ||
| 4/18/2026 | Listing removed | $2,200,000$235/sqft |
Source: DABR MLS #922338 Report a problem | ||
| 3/3/2026 | Price change | $2,200,000-12%$235/sqft |
Source:  WRIST #1035185 Report a problem | ||
| 10/22/2024 | Listed for sale | $2,500,000$267/sqft |
Source: DABR MLS #922338 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $20,895 +16.8% | $586,820 +33% |
| 2024 | $17,893 +13% | $441,280 |
| 2023 | $15,842 -3.5% | $441,280 |
| 2022 | $16,413 +8.6% | $441,280 +20% |
| 2021 | $15,117 +2% | $367,710 |
| 2020 | $14,815 -0.3% | $367,710 |
| 2019 | $14,858 +6.6% | $367,710 +25.7% |
| 2018 | $13,933 -1.2% | $292,470 |
| 2017 | $14,098 +1.2% | $292,470 |
| 2016 | $13,928 +1.3% | $292,470 +4.2% |
| 2015 | $13,747 | $280,690 |
| 2014 | $13,747 -0.3% | $280,690 |
| 2013 | $13,792 -10.5% | $280,690 -14.2% |
| 2012 | $15,404 +1.5% | $327,250 |
| 2011 | $15,178 +12.3% | $327,250 |
| 2010 | $13,510 +97.6% | $327,250 +85.8% |
| 2009 | $6,836 +16215.6% | $176,160 +17875.5% |
| 2008 | $42 -30.3% | $980 |
| 2007 | $60 -96.7% | -- |
| 2006 | $1,825 | -- |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 45356
Nearby schools
Schools provided by the listing agent
- District: Piqua
Source: DABR MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
