Skip To Content
    Return to Previous Page

    2264 Bleu Yacht Lane

    Union, KY 41091
    • $949,800
    • STATUS: Active
    • ON SITE: 27 days
    • MLS #: 542337
    UPDATED: 11 min ago
    $949,800
    • 3
      BEDS
    • 8.4
      ACRES
    • 4
      BATHS
    • 1
      1/2 BATHS
    Neighborhood:
    Type:
    Single-Family Home
    Built:
    2006
    County:

    School Information

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

    Description

    Remarkable ESTATE Living Offering the Ultimate LIFESTYLE w/8.4 Lush ACRES & Exceptional Architecture! This Upscale, One of a Kind Ranch, 6 Car Garage Masterpiece is Perfectly Appointed on the Cul-De-Sac of an Incredibly Picturesque Street in an Affluent Neighborhood w/an Award Winning School District! Low County Tax Rate/Bright Home w/Open, Airy Floorplan/Elaborate Handcrafted Appointments/Customized Amish Cabinetry/Pub Room/Billiard Room/Wine Tasting Room/Theater Room/Geothermal Heating & Cooling Along w/Superior Construction Warrant Extremely Low Utility Bills/+ More! The BEST of EVERYTHING!

    Monthly Payment Calculator



    © 2020 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 Mike Parker Real Estate LLC | HUFF Realty 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: 2020-10-29T12:49:28.937.
    www.searchnkyhomes.com/homes/110570321
    Print Image

    2264 Bleu Yacht Lane Union, KY 41091

    • Price: $949,800
    • Status: Active
    • Updated: 11 min ago
    • MLS #: 542337
    3
    Beds
    4
    Baths
    1
    ½ Baths
    8.4
    Acres
    2006
    Built
    Neighborhood:
    Stoney Ridge Farms
    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 County Public
    Property Description
    Remarkable ESTATE Living Offering the Ultimate LIFESTYLE w/8.4 Lush ACRES & Exceptional Architecture! This Upscale, One of a Kind Ranch, 6 Car Garage Masterpiece is Perfectly Appointed on the Cul-De-Sac of an Incredibly Picturesque Street in an Affluent Neighborhood w/an Award Winning School District! Low County Tax Rate/Bright Home w/Open, Airy Floorplan/Elaborate Handcrafted Appointments/Customized Amish Cabinetry/Pub Room/Billiard Room/Wine Tasting Room/Theater Room/Geothermal Heating & Cooling Along w/Superior Construction Warrant Extremely Low Utility Bills/+ More! The BEST of EVERYTHING!
    Exterior Features

    Architectural Style TraditionalTransitional Attached Garage YN No Construction Materials Brick Entry Level 1 Exterior Features DeckPorchPatio Foundation Details Poured Levels One Lot Size Dimensions 8.40 Acres! Parking Features AttachedDrivewayDetachedGarageOff StreetOversizedRear/Side/Off StreetGarage Door Opener Patio And Porch Features DeckPatioPorch Roof CompositionShingle View Trees/Woods View YN Yes

    Interior Features

    Appliances DryerDishwasherDisposalMicrowaveOvenRangeRefrigeratorWasherHumidifier Basement FullFinishedWalk-Out Access Building Features Fountain Cooling Central Air Cooling YN Yes Door Features French DoorsPanel Doors Fireplace Features GasBasement Fireplace YN Yes Fireplaces Total 2 Flooring Wood Garage YN Yes Heating Geothermal Heating YN Yes Interior Features Breakfast BarCeiling Fan(S)Crown MoldingCathedral Ceiling(S)Eat-In KitchenFrench Door(S)/Atrium Door(S)Granite CountersGourmet KitchenGreat RoomHigh CeilingsKitchen IslandMain Level MasterPantryStone CountersRecessed LightingSolid Surface CountersCable TvVaulted Ceiling(S)Wired For DataWine CellarNatural Woodwork Laundry Features Main Level Rooms Total 16 Window Features Casement Window(S)Insulated WindowsDisplay Window(S)

    Property Features

    Association YN Yes Electric 220 Volts Lease Considered YN No Lot Features 5-10 AcresCul-De-SacWooded New Construction YN No Ownership Consumer Property Attached YN No Property Sub Type Single Family Residence Security Features Security SystemSmoke Detector(S) Sewer Septic Tank Utilities Propane Water Source Public Zoning Description Residential

    Courtesy of Re/Max Affiliates. © 2020 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. Information has not been verified, is not guaranteed, and subject to change.


    © 2020 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 Mike Parker Real Estate LLC | HUFF Realty 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: 2020-10-29T12:49:28.937.
     
    https://bt-photos.global.ssl.fastly.net/nkmls/orig_boomver_1_542337-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/orig_boomver_1_542337-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/orig_boomver_1_542337-2.jpg
    Logo
    Mike Parker Real Estate LLC | HUFF Realty
    60 Cavalier Blvd.
    Florence KY, 41042