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. *Located just 9 minutes to Interstate I-75!
For sale
$2,200,000
9606 Piqua Lockington Rd, Piqua, OH 45356
6beds
9,360sqft
Est.:
Single Family Residence
Built in 2008
17.73 Acres Lot
$2,060,300 Zestimate®
$235/sqft
$-- HOA
What's special
Saltwater in-ground poolCommercial-style refrigeratorGazebo overlooking the waterLarge playroomBreathtaking lake viewsSweeping water viewsWorkout room
- 24 days |
- 1,814 |
- 56 |
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 REALTORSTour with a local agent
Facts & 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: $235/sqft
- Tax assessed value: $1,260,800
- Annual tax amount: $17,893
- Date on market: 4/24/2026
- Date available: 04/26/2026
Estimated market value
$2,060,300
$1.96M - $2.16M
$2,850/mo
Price history
| Date | Event | Price |
|---|---|---|
| 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 |
|---|---|---|
| 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$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 45356
Nearby schools
GreatSchools rating
- 6/10Wilder Intermediate Elementary SchoolGrades: 4-6Distance: 0.7 mi
- 7/10Piqua Junior High SchoolGrades: 7-8Distance: 2.4 mi
- 5/10Piqua High SchoolGrades: 9-12Distance: 2.3 mi
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.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Ohio
- Miami County
- Piqua
- 45356
- 9606 Piqua Lockington Rd
Nearby cities
Nearby zip codes
Other Piqua Topics
