Listing provided courtesy of RE/MAX Real Estate SpecialistsMLS# 957550MLS ProviderContact Information: (937) 436-9900
  • 65 days on site
  • 0 views

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.

Source: Dayton MLS, MLS#: 957550

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
  • Property Type
    Residential
  • Lot
    17.73 acres

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

Create a profile so you can receive updates on this property as soon as they happen!

  • Median Age
    41
  • Population Density
    323
  • College Educated
    24%
  • Estimated Median Income
    $50,435
  • Estimated Total Home Owners
    6,449
  • Estimated Total Renters
    3,623
  • Owner / Renter Divide
    64% / 36%
  • Estimated Average Household Size
    2
  • Total Population
    24,918
  • Community data courtesy of LiveBy, Inc.

Owning this Home

$
$ %
%
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Life at 9606 Piqua Lockington Road


Schools


School data courtesy of LiveBy, Inc.
Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date Event Value Agent
4/25/2026Source: Dayton MLS Added to Database
April 25, 2026