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 = 1006 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1006 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1006 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

405 Iron Works Road
Paris, KY 40361
Robert Milam with The Brokerage, original listing - (859) 983-7365

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,475,000
Beds: 7
Baths: Full: 8, ½: 2
Status: Active
SqFt: 15000 Square Feet
Agency: The Brokerage
Agency Phone: (859) 983-7365

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 19 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: This gorgeous colonial style custom home sits on nearly 20 picturesque acres with amazing views of rolling hills and horse farms! With approximately 15,000 sq ft of livable space, this custom estate is truly one-of-a-kind! This house features a primary on the main level with an elegant ensuite bath, make-up room, and dual walk-in closets, a second primary, five additional bedrooms, ten baths, a great room, a study, a twelve person formal dining room, a butler pantry, a helm, a theatre, a bonus room, and much more. The house's focal point is an elegant floating spiral staircase with a large ceiling dome. Only the best... Wolf, Sub-Zero, and Cove appliances, inset custom cabinets, wide plank hardwoods throughout the home, exquisite custom trim work, three coffered ceilings, and a truss-beamed bonus room exude classical elegance. This home's estate columns, dry-stacked stone accents, white painted Hardie siding, custom grand entrance iron door, and sheer size of this property elevate the home to mansion caliber. Grand balconies and patios are accessible from each side and level of the house. Anderson doors and windows, spray foam insulation throughout the home, five indoor fireplaces, and zoned high-efficiency Rudd HVAC units provide efficient and balanced heating and cooling, all controlled by Google Smart Home technology. An outdoor kitchen with a stacked stone fireplace, granite worktop island, and grilling wall provides an outdoor living space you and your guests won't want to leave.<br /> <br /> GUEST HOUSE AND 4-STALL BARN - Perched atop the 6-car garage (12-car capacity), the beautiful "White Dove" guest house is 2,200 sq ft and includes two bedrooms, two full bathrooms, a den, a family room, and a kitchen and dining area. If you are a horse lover, this estate comes with a 4-stall barn and tractor bay and is complete with electric and spray foam insulation. The entire property is fenced and ready for your dream farm. <br /> <br /> COUNTRY ESTATE LIVING WITH CITY AMENITIES - This amazing home is ideally situated between Lexington, Paris, and Winchester. It is just a 15-minute drive in each direction to local shopping and fine dining. It is located off the coveted Iron Works Rd in Paris, KY, and has convenient "work-from-home" high-speed internet access with AT&T Fiber, Starlink satellite, and a Wi-Fi hot spot available. The house is on public water with weekly trash service. Propane gas and a high-capacity septic system are installed and operational. The house is certified for occupancy and is wired for a whole-house generator.
MlsNumber: --
ListingId: 25001274


Listing Provided By: The Brokerage, original listing
Phone: (859) 421-1712
Office Phone: (859) 983-7365
Agent Name: Robert Milam
Disclaimer: Copyright © 2025 Lexington-Bluegrass Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1006 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App