11240 US Highway 42 Union, KY 41091
5
Bed
3
Bath
5,480
Sq. Ft
3.2
Acres
$1,300,000
MLS# 628644
5 BR
3 BA
5,480 Sq. Ft
3.2 AC
Photos
Map
Photos
Map
Sale Pending
More About 11240 US Highway 42
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.
Connect with a loan officer to get started!
Directions to this Listing
: US 42 South, approximately 1 miles south of New Haven Elementary School on the left.
Information Refreshed: 5/06/2025 8:32 PM
Property Details
MLS#:
628644Type:
Single FamilySq. Ft:
5,480County:
BooneAge:
90Appliances:
Dishwasher, Dryer, Disposal, Microwave, Refrigerator, Washer, Double Oven, Stainless Steel Appliance(s), Electric RangeArchitecture:
Cape CodBasement:
Finished, Storage Space, Unfinished, Walk-Out AccessConstruction:
Cedar, See RemarksCooling:
Geothermal, Central AirFireplace:
Brick, Wood BurningGarage Spaces:
3Heating:
GeothermalInside Features:
Built-in Features, Attic Storage, Chandelier, Double Vanity, Crown Molding, Entrance Foyer, High Speed Internet, Soaking Tub, Walk-In Closet(s), Ceiling Fan(s), Pantry, Breakfast Bar, Granite Counters, Stone Counters, Master Downstairs, StorageLevels:
2 StoryLot Description:
562x212x223x285x238Outside:
Private YardParking:
Driveway, Garage, Door Opener, Garage Faces Rear, Garage Faces SideSchool District:
Boone CountySewer:
SepticWater:
Public
Rooms
Atrium:
25x19 (Level: )Bathroom 1:
26x9 (Level: First)Bathroom 2:
13x6 (Level: First)Bathroom 3:
17x8 (Level: Second)Bedroom 1:
25x13 (Level: First)Bedroom 2:
17x13 (Level: First)Bedroom 3:
25x24 (Level: Second)Bedroom 4:
25x19 (Level: Second)Bedroom 5:
26x22 (Level: Second)Dining Room:
18x18 (Level: First)Entry:
15x7 (Level: First)Gym:
31x25 (Level: Lower)Kitchen:
24x11 (Level: First)Living Room:
19x18 (Level: First)Loft:
39x16 (Level: Second)Media Room:
20x17 (Level: Lower)Office:
20x12 (Level: First)Solarium:
21x21 (Level: First)Utility Room:
11x6 (Level: First)
Online Views:
0This listing courtesy of Mike Parker (859) 647-0700 , Huff Realty - Florence (859) 525-7900
Explore Union & Surrounding Area
Monthly Cost
Mortgage Calculator
*The rates & payments shown are illustrative only.
Payment displayed does not include taxes and insurance. Rates last updated on 5/1/2025 from Freddie Mac Primary Mortgage Market Survey. Contact a loan officer for actual rate/payment quotes.
Payment displayed does not include taxes and insurance. Rates last updated on 5/1/2025 from Freddie Mac Primary Mortgage Market Survey. Contact a loan officer for actual rate/payment quotes.

Sell with Sibcy Cline
Enter your address for a free market report on your home. Explore your home value estimate, buyer heatmap, supply-side trends, and more.
Must reads

The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the Northern Kentucky Multiple Listing Service, Inc.Those listings held by brokerage firms other than Sibcy Cline, Inc. are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. Copyright© 2022 Northern Kentucky Multiple Listing Service, Inc. / All Information is believed accurate, but is NOT guaranteed.