2264 Bleu Yacht Lane $949,800


    2264 Bleu Yacht Lane Union, KY 41091

    • 3 Beds
    • 5 Baths
    • Single-Family
    • MLS# 542337
    Favorite Share
    Views: 128 Days On Site: 55

    Go Tour This Home

    Schedule A Showing

    Property Details

    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!

    • General Features
      • Area Richwd/Un/Wal/Ver/SB
      • View Trees/Woods
      • View Y/N 1
      • Year Built 2006
    • Building Features
      • Appliances Dryer, Dishwasher, Disposal, Microwave, Oven, Range, Refrigerator, Washer, Humidifier
      • Architectural Style Traditional, Transitional
      • Basement Full,Finished,Walk-Out Access
      • Full Bathrooms 4
      • Half Bathrooms 1
      • Cooling Central Air
      • Exterior Features Deck, Porch, Patio
      • Cooling Y/N 1
      • Garage Spaces 6
      • Garage Y/N 1
      • Heating Geothermal
      • Heating Y/N 1
      • Interior Features Breakfast Bar, Ceiling Fan(s), Crown Molding, Cathedral Ceiling(s), Eat-in Kitchen, French Door(s)/Atrium Door(s), Granite Counters, Gourmet Kitchen, Great Room, High Ceilings, Kitchen Island, Main Level Master, Pantry, Stone Counters, Recessed Lighting, Solid Surface Counters, Cable TV, Vaulted Ceiling(s), Wired for Data, Wine Cellar, Natural Woodwork
      • Roof Composition, Shingle
    • Property Features
      • Lot Features 5-10 Acres, Cul-De-Sac, Wooded
      • Lot Size Acres 8.4
      • Sewer Septic Tank
      • Parking Features Attached, Driveway, Detached, Garage, Off Street, Oversized, Rear/Side/Off Street, Garage Door Opener
    • Room Features
      • Room1 Study
      • Level1 First
      • Dimensions1 12x10
      • Room2 Rec/Game/Play Room
      • Level2 Lower
      • Dimensions2 22x13
      • Room3 Other
      • Level3 First
      • Dimensions3 12x11
      • Room4 Media Room
      • Level4 Upper
      • Dimensions4 19x15
      • Room5 Master Bedroom
      • Level5 First
      • Dimensions5 18x14
      • Room6 Master Bathroom
      • Level6 First
      • Dimensions6 x
      • Room7 Living Room
      • Level7 First
      • Dimensions7 20x16
      • Room8 Laundry
      • Level8 First
      • Dimensions8 11x6
      • Room9 Kitchen
      • Level9 First
      • Dimensions9 18x16
      • Room10 Family Room
      • Level10 Lower
      • Dimensions10 26x17
      • Room11 Exercise Room
      • Level11 Lower
      • Dimensions11 11x10
      • Room12 Entry/Foyer
      • Level12 First
      • Dimensions12 16x16
      • Room13 Bedroom 3
      • Level13 Lower
      • Dimensions13 14x12
      • Room14 Bedroom 2
      • Level14 Lower
      • Dimensions14 18x14
      • Room15 Rec/Game/Play Room
      • Level15 Lower
      • Dimensions15 22x13
      • Room16 Other
      • Level16 First
      • Dimensions16 12x11
      • Room17 Media Room
      • Level17 Upper
      • Dimensions17 19x15
      • Room18 Living Room
      • Level18 First
      • Dimensions18 x
      • Room19 Laundry
      • Level19 First
      • Dimensions19 11x6
      • Room20 Family Room
      • Level20 Lower
      • Dimensions20 26x17
      • Room21 Exercise Room
      • Level21 Lower
      • Dimensions21 11x10
      • Room22 Dining Room
      • Level22 First
      • Dimensions22 16x14
      • Room23 Breakfast Room/Nook
      • Level23 First
      • Dimensions23 17x12
      • Room24 Bonus Room
      • Level24 Lower
      • Dimensions24 18x14


    • Cinch Home Services
    • HSA Home Warranty


    41091 (Union) Demographics

    37 Median Age
    365 Population Density (per sq. mile)
    55% College Educated
    $95,066 Estimated Median Income
    5,499 Estimated Total Home Owners
    636 Estimated Total Renters
    90% / 10% Estimated Owner / Renter Divide
    3 Estimated Average Household Size
    18,708 Total Population
    Community data courtesy of LiveBy, Inc.

    Market Last 30 Days In This Postal Code

    $353,424 Median Sales Price
    55 Homes Sold
    47 New On Market

    Average Days on Site

      Properties for Sale

        Calculations provided by Reliance Network

        Property History

        Date Event Price Percent Change
        -- Current Price Source New Value: $949,800
        10/1/2020 9:53:00 AM New in Database Source New Value: $949,800

        Payment Calculator

        $0 per month
        Year Fixed, Interest
        Principal and Interest
        Property Taxes
        Homeowners' Insurance

        Home Price
        Down Payment

        Home Valuation

        Get the Home Value Report
        *This Payment Calculator is intended for educational and planning purposes only.
        **Assumes 3.5% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information.
        Information is provided in part by the IDX program of the Northern Kentucky Association of REALTORSĀ® MLS. All information provided is deemed reliable but is not guaranteed and should be independently verified.

        Note: All room dimensions, including square footage data, are approximate and must be verified by the buyer. The information contained herein is furnished by the owner to the best of his/her knowledge but is subject to verification by the purchaser, and agent assumes no responsibility for the correctness thereof. The sale offering is made subject to errors, omissions, change of price, prior sale, or withdrawal without notice. In accordance with the Law, this property is offered without respect to race, color, creed, national origin, sex, familial status or disability. This is not intended to solicit property currently listed.