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
$2,200,000
9606 Piqua Lockington Rd, Piqua, OH 45356
6beds
9,360sqft
Single Family Residence
Built in 2008
17.73 Acres Lot
$2,005,300 Zestimate®
$235/sqft
$-- HOA
What's special
Saltwater in-ground poolGazebo overlooking the waterLarge playroomBreathtaking lake viewsWorkout roomGame roomGranite countertops
- 111 days |
- 1,310 |
- 67 |
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: $235/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
$2,005,300
$1.91M - $2.11M
$2,652/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 |
|---|---|---|
| 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
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.
- $153,1007 bd3 ba2.5k sqft307 Wood St, Piqua, OH 45356Off Market
- $--7,840 sqft203 S Downing St, Piqua, OH 45356Off Market
- $227,5003 bd2 ba2.5k sqft209 S Downing St, Piqua, OH 45356Off Market
- $151,6008 bd3 ba2.6k sqft315 Wood St, Piqua, OH 45356Off Market
- $14,1003 bd2 ba2.9k sqft327 Wood St #329, Piqua, OH 45356Off Market
- $158,3003 bd2 ba1.6k sqft219 S Downing St, Piqua, OH 45356Off Market
- $18,4006 bd-- ba3.5k sqft203-205 S Downing St, Piqua, OH 45356Off Market
- $102,9004 bd2 ba1.7k sqft223 S Downing St, Piqua, OH 45356Off Market
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $1,425,0006 bd7 ba8k sqft10568 Casstown Sidney Rd, Piqua, OH 45356For Sale
MLS ID #937395, Tricia Fellers, Coldwell Banker Heritage. DABR MLS - $1,479,0005 bd4 ba5.8k sqft5486 Worley Rd, Tipp City, OH 45371For Sale
MLS ID #964407, Carli Amlin, RE/MAX Alliance Realty. DABR MLS - $1,300,0008 bd9 ba8.5k sqft1550 Creekwood Dr, Troy, OH 45373For Sale
MLS ID #940535, Jenna Denlinger, Keller Williams Home Town Rlty. DABR MLS
