Skip To Content

11240 Us Highway 42

Union, KY 41091
  • $1,300,000
  • STATUS: Active
  • ON SITE: 65 Days
  • MLS #: 628644
UPDATED: 64 min ago
$1,300,000
  • 5
    BEDS
  • 3.2
    ACRES
  • 3
    BATHS
  • 0
    1/2 BATHS
  • 5,480
    SQFT
  • $237
    $/SQFT
Neighborhood:
Type:
Single-Family Home
Built:
1935
County:

School Information

Elementary School:
Middle School:
High School:
School District:

Description

Stunning home meticulously renovated*Set on 3.2 acres, this 5 BD home spans 5480sqft & showcases impeccable craftsmanship*A baker-inspired kitchen features top-of-the-line appliances & beautiful countertops*The 1st flr includes 2 spacious bedrooms, including an expansive Primary Suite that offers a spa-like ensuite featuring his & her walk-in closets, dual vanities, a soaking tub, a walk-in shower & a private walk-out to the patio*The Living Rm & Sunrm each feature a WBFP*All 5 BDs offer generous closet storage*One of the home's most remarkable features is the state-of-the-art music & recording studio, equipped with premium acoustics & soundproofing, this studio offers an exceptional environment for creativity*3-car garage with an unfinished studio/ loft with water & electric*Step outside to explore the meticulously landscaped grounds, featuring mature trees & a fully stocked pond with a filtration system making it safe for swimming while capturing rainwater*This lovely home offers the best of both worlds: a serene retreat steeped in history, yet fully equipped for modern living with its energy efficiency, solar panels, geothermal & Generac back-up power system*Reno list avail.

Monthly Payment Calculator



Northern Kentucky MLS logo © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2025-02-17T23:24:21.88.
www.jimsimpsonrealtors.com/homes/158769703
Print Image

11240 Us Highway 42 Union, KY 41091

  • Price: $1,300,000
  • Status: Active
  • On Site: 65 Days
  • Updated: 64 min ago
  • MLS #: 628644
5
Beds
3
Baths
0
½ Baths
3.2
Acres
5,480
SQFT
$237
$/SQFT
1935
Built
Neighborhood:
Richwd/Un/Wal/Ver/Sb
County:
Boone
Area:
Richwd/Un/Wal/Ver/Sb
Elementary School:
New Haven Elementary
Middle School:
Gray Middle School
High School:
Ryle High
School District:
Boone Co Public
Property Description
Stunning home meticulously renovated*Set on 3.2 acres, this 5 BD home spans 5480sqft & showcases impeccable craftsmanship*A baker-inspired kitchen features top-of-the-line appliances & beautiful countertops*The 1st flr includes 2 spacious bedrooms, including an expansive Primary Suite that offers a spa-like ensuite featuring his & her walk-in closets, dual vanities, a soaking tub, a walk-in shower & a private walk-out to the patio*The Living Rm & Sunrm each feature a WBFP*All 5 BDs offer generous closet storage*One of the home's most remarkable features is the state-of-the-art music & recording studio, equipped with premium acoustics & soundproofing, this studio offers an exceptional environment for creativity*3-car garage with an unfinished studio/ loft with water & electric*Step outside to explore the meticulously landscaped grounds, featuring mature trees & a fully stocked pond with a filtration system making it safe for swimming while capturing rainwater*This lovely home offers the best of both worlds: a serene retreat steeped in history, yet fully equipped for modern living with its energy efficiency, solar panels, geothermal & Generac back-up power system*Reno list avail.
Exterior Features

Architectural Style Cape Cod Attached Garage YN No Construction Materials See RemarksCedar Exterior Features Private Yard Foundation Details Poured ConcreteStone Garage YN Yes Levels Two Parking Features DrivewayGarageGarage Door OpenerGarage Faces RearGarage Faces Side Patio And Porch Features CoveredEnclosedPatioPorch Road Frontage Type Highway Road Surface Type Paved Roof Shingle Vegetation Partially Wooded View PondTrees/Woods View YN Yes

Interior Features

Accessibility Features Accessible DoorsAccessible Full Bath Appliances Stainless Steel Appliance(s)Electric RangeDishwasherDisposalDouble OvenDryerMicrowaveRefrigeratorWasher Basement FinishedStorage SpaceUnfinishedWalk-Out Access Cooling GeothermalCentral Air Cooling YN Yes Fireplace Features BrickWood Burning Fireplace YN Yes Fireplaces Total 2 Flooring CarpetConcrete Heating Geothermal Heating YN Yes Interior Features Walk-In Closet(s)StorageStone CountersSoaking TubPantryHigh Speed InternetGranite CountersEntrance FoyerDouble VanityCrown MoldingChandelierBreakfast BarBuilt-in FeaturesAttic StorageCeiling Fan(s)Master Downstairs Laundry Features Electric Dryer HookupLaundry ChuteLaundry RoomMain LevelWasher Hookup Living Area 5480 Rooms Total 20 Window Features Insulated WindowsDouble HungVinyl Frames

Property Features

Association YN No Lot Features Pond on LotLevelSprinklers In FrontSprinklers In RearWooded Lot Size Dimensions 562x212x223x285x238 New Construction YN No Property Attached YN No Property Class Residential Property Condition Existing Structure Property Sub Type Single Family Residence Security Features Closed Circuit Camera(s)Security System Sewer Septic Tank Structure Type House Utilities Cable AvailablePropaneWater Available Water Source Public Zoning Description Residential

Northern Kentucky MLS logo Courtesy of Huff Realty - Florence: 859-525-7900. © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. Information has not been verified, is not guaranteed, and subject to change.


Northern Kentucky MLS logo © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2025-02-17T23:24:21.88.
 
https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_628644-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_628644-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_628644-2.jpg
Logo
Jim Simpson Realtors Inc
39 Broadway
Dry Ridge KY, 41035