x
Showing 1 of 0
X
Save

1737 Coachtrail Drive
Hebron KY 41048 US

$1,398,000

Active Listing ID 639872
bed icon
3 bed
bath icon
4.00 Bath (3 Full , 1 Half)
lot icon
Lot: 2.00 Acres
home icon
Single Family Residence

$1,398,000

Active Listing ID 639872
Save

1737 Coachtrail Drive An Entertainer's Dream designed for those who appreciate exceptional craftsmanship and unforgettable gatherings. This meticulously appointed, custom-built Jobe ranch is gracefully positioned on over two private acres, offering more than 7, 500 finished square feet of refined living. A grand granite entry introduces coffered ceilings, rich hardwood flooring, intricate moldings, and handsome built-ins that define the home's timeless elegance. The gourmet kitchen, complete with Butler's pantry, was designed to impress-equally suited for intimate dinners or grand-scale celebrations. The walk-out lower level rivals private clubs, featuring a secluded speakeasy with wine alcove, an expansive pub-style bar, two bedrooms, two full baths, and a substantial workshop with secondary garage access. Enjoy four-season entertaining in the enclosed veranda or unwind beside one of three fireplaces. Evenings are best spent on the covered paver patio overlooking a serene wooded backdrop enhanced by professional outdoor lighting. Full brick construction, a 3-car garage, and a premier location near Downtown Cincinnati and the airport complete this extraordinary estate.

Collapse all

Property Features

  • Facts
  • Lot Size: 2.00 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air, Wall Unit(s), Multi Units
  • Exterior Finish: Lighting
  • Roof Type: Composition, Shingle
  • Heating Fuels: Forced Air, Natural Gas
  • Additional Features
  • Basement
  • Fireplace
  • Patio

School Information

  • School
  • North Pointe Elementary(Elementary)
  • Conner Middle School(MiddleSchool)
  • Conner Senior High(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1398000
  • unparsedaddress: 1737 Coachtrail Drive
  • postalcity: Hebron
  • stateorprovince: KY
  • country: US
  • postalcode: 41048
  • bathroomsfull: 3
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 2
  • lotsizeunits: Acres
  • lotsizearea: 2
  • livingarea: 7556
  • livingareaunits: Square Feet
  • latitude: 39.12533
  • longitude: -84.725389
  • listagentfullname: Ben Schreiber
  • listagentemail: ben@serviceplusre.com
  • listagentkey: 3yd-NKARKY-432505129
  • listagentmlsid: 432505129
  • listagentpreferredphone: 8599911800
  • listagentofficephone: 8596001397
  • listofficekey: 3yd-NKARKY-o432501863
  • listagentstatelicense: 204810
  • listofficemlsid: o432501863
  • disclaimer: Copyright © 2026 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: NKARKY
  • yearbuilt: 2003
  • listingcontractdate: 2026-02-13
  • listagentfax: 5136180132
  • listagenturl: https://ky.exprealty.com/
  • countyorparish: Boone
  • parcelnumber: 034.00-02-086.00
  • elementaryschool: North Pointe Elementary
  • highschool: Conner Senior High
  • elementaryschooldistrict: Boone Co Public
  • middleorjuniorschooldistrict: Boone Co Public
  • highschooldistrict: Boone Co Public
  • appliances: Wine Cooler, Gas Cooktop, Dishwasher, Disposal, Double Oven, Ice Cooler, Microwave, Refrigerator
  • cooling: Central Air, Wall Unit(s), Multi Units
  • constructionmaterials: Brick, Wood Siding
  • heating: Forced Air, Natural Gas
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 1
  • parkingtotal: 0
  • parkingfeatures: Open, Driveway, Garage
  • roof: Composition, Shingle
  • waterfrontyn: False
  • franchiseaffiliation: None
  • interiorfeatures: Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Storage, Soaking Tub, Pantry, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Dry Bar, Crown Molding, Coffered Ceiling(s), Chandelier, Bookcases, Breakfast Bar, Built-in Features, Butler's Pantry, Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recessed Lighting, Wired for Data, Wired for Sound, Master Downstairs
  • exteriorfeatures: Lighting
  • windowfeatures: Wood Frames, Insulated Windows
  • architecturalstyle: Other
  • rooms: Bonus Room, Bathroom 3, Bedroom 1, Bathroom 4, Bedroom 2, Game Room, Laundry Room, Bathroom 2, Dining Room, Basement, Bedroom 3, Bathroom 1, Family Room
  • otherstructures: Storage
  • utilities: Cable Available
  • patioandporchfeatures: Porch, Patio
  • basement: Walk-Out Access, Full, Finished
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -84.72539, 39.12533
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"eXp Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"ben@serviceplusre.com", "ListBrokerageCity":"Prospect", "ListBrokerageCountry":"US", "ListBrokerageEmail":"ky.broker@exprealty.net", "ListBrokerageLogoUrl":null, "ListBrokerageName":"eXp Realty", "ListBrokeragePhone":"(188) 862-4644", "ListBrokeragePostalCode":"40059", "ListBrokerageStateOrProvince":"KY", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"5964 Timber Ridge DR", "ListBrokerageWebsiteUrl":"https://ky.exprealty.com/", "ListOfficeAddress1":"7000 Houston Rd Ste 32 ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"o432501863", "ListOfficeCity":"Florence, KY", "ListOfficeCountry":"USA", "ListOfficeEmail":"ky.broker@exprealty.net", "ListOfficePostalCode":"41042", "ListOfficeStateOrProvince":"KY", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Other - Hebron, KY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/1737-Coachtrail-Dr_Hebron_KY_41048_M41096-40248?f=listhub&s=NKARKY&m=639872&c=rexren", "MLSModificationTimestamp":"2026-02-13 22:03:32", "Neighborhoods":[{"Description":null, "Name":"K10 - Burlgt/Hebrn/BeBo/Peters/NB"}], "PostalCode":null, "RoomCount":12, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 2/13/2026 10:12:31 PM GMT
Source Updated Date: 2/14/2026 6:53:47 PM GMT

Courtesy of: Ben Schreiber, eXp Realty, LLC, ben@serviceplusre.com

Copyright © 2026 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.