Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2092 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2092 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2092 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

9606 Piqua Lockington Road
Piqua, OH 45356
Nicole D Loudenback with Glasshouse Realty Group, original listing - (937) 890-9111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 13000 Square Feet
Agency: Glasshouse Realty Group
Agency Phone: (937) 726-5767

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 28 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: This is an incredible custom built home nestled on 17 acres within the exclusive Rocky Ridge Estates development, featuring only eight distinguished residences. Enjoy resort like living everyday of your life! This stunning 13,000 sq ft estate is a true masterpiece, showcasing a striking exterior of stone and brick, complemented by a captivating rock water feature and a sweeping circular driveway that enhances its curb appeal. <br /> The grand entrance with 30-ft ceilings that create an immediate sense of luxury and openness. The expansive design is accentuated by floor-to-ceiling windows that frame breathtaking views of the water. <br /> The gourmet kitchen is equipped with a pot filler, vegetable sink, and top of the line stainless steel appliances, including a gas stove, making it perfect for culinary creations and entertaining. <br /> The great room features a stone wood burning fireplace that serves as a stunning focal point, elegantly accented on the east wall. This expansive living area seamlessly flows into the rest of the home, making it ideal for both intimate gatherings and grand celebrations. The owners suite is extra grand including heated floors in the master bath with stone walk through shower and dual vanities. The walk-in closet is set up with California closet design and includes a stackable washer and dryer. This home includes 6 bedrooms each with it's private bath and walk in closet. Special features throughout the home. <br /> Step outside to discover your own private oasis, complete with a saltwater pool with sundeck and 5ft depth, perfect for relaxation and recreation. <br /> The 5 car garage includes steps that lead to the loft or the lower level of the home. <br /> The lower level includes a theater room, sauna room, wet bar with stainless steel appliances. The family room includes a gas fireplace. Also, on this level enjoy the sauna, workout room and game room. The Lani has tiled floors, stand up shower and more. Find a Home for Your Heart on the water.
MlsNumber: --
ListingId: 1035185


Listing Provided By: Glasshouse Realty Group, original listing
Phone: (937) 726-5767
Office Phone: (937) 890-9111
Agent Name: Nicole D Loudenback
Disclaimer: Copyright © 2024 Western Regional Information Systems and Technology, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App