$1,295,000 2240 Bleu Yacht Lane Union, KY

MLS: 456325   Type: Single Family   County: Boone   City: Union   Area: Richwd-un-wal-ver-sb   Neighborhood: Union- Boone Cty   Zip: 41091   Style: Traditional   # Rooms: 17    Stories: 3   Taxes: $14,594

Mortgage $6,080 /mo



Half Baths

Sqr Footage









Look 1st Before Building! $600K below Reproduction Cost! Custom Home on 11+ Private Acres*Impeccable Attention to Detail*6,255 Sf above Grade*3584 in LL*Fiberglass Pool w.Waterfall Spa*Custom Amish Designer Cabinetry/Built-Ins*Sub Zero Fridge/Wolf Gas Stove*1st Flr Owner's Retreat*Geothermal HVAC*5+ Car Garage w.Layout for Apartmt Above*Pool Kitchen/Full Bath*Private Gated Entry

Elementary School

Middle School

High School

New Haven Elementary
Distance: 0.89 Miles
Distance: 1.51 Miles
Ryle High
Distance: 1.65 Miles

Price History

6/10/2016 Listed $1,550,000
7/1/2016 4% - $1,499,000
11/5/2016 9% - $1,375,000
3/10/2017 6% - $1,295,000

Association Northern Kentucky Multiple Listing Service
Listing Area Richwd/Un/Wal/Ver/SB
Misc. Air Cleaner, Cable TV, Ceiling Fan, Fountain, Garage Door Opener, Handicap Use, Home Warranty, Hot Tub/Spa, Humidifier, Pets Allowed, Recess Lights, Security System, Smoke Alarm
Property Ownership Consumer
Property Sub Type Single Family
Sub Type Description Stick Built/Modular/Masonry
Subdivision Stoneyridge Farms
Suburb Union- Boone Cty
Zoning Residential

Interior Features

Appliances Included Dishwasher, Microwave, Oven/Range, Refrigerator
Basement Features Full Bath Rough In, Unfinished, Walkout
Basement Level Basement
Basement Type Full
Basementdim 73x45
Bath 1 Lvl 1
Bath 1 Type Full
Bath 2 Dim 12x8
Bath 2 Level 2
Bath 2 Lvl 2
Bath 2 Type Full
Bath 3 Dim 10x7
Bath 3 Level 2
Bath 3 Lvl 2
Bath 3 Type Full
Bath 4 Dim 6x5
Bath 4 Level 1
Bath 4 Lvl 1
Bath 4 Type Full
Bath 5 Dim 6x5
Bath 5 Level 1
Bath Lvl 1 Type Full
Bathroom On Level 1 1
Bedroom 2 Dimensions 16x12
Bedroom 3 Dimensions 16x13
Bedroom 4 Dimensions 16x13
Bedroom 5 Dimensions 13x13
Bedroom On Level 1 1
Bedroom2 Level 2
Bedroom3 Level 2
Bedroom4 Level 2
Bedroom5 Level 2
Bonus Rm Dim 16x15
Bonus Rm Level 1
Bonus Room Name Kitchenette & Full Bath for Outdoor Pool*
Breakfast Rm Dim 15x13
Breakfast Room Level 1
Cooling Central Air
Dining Rm Feat Chandelier, Fireplace, Window Treatments, Wood Floors
Dining Room Dimensions 16x14
Dining Room Level 1
Exercise Rm Level Lower
Family Rm Feat Wall-to-Wall Carpet
Family Room Dimensions 16x15
Family Room Level 1
Family Room Y/n 1
Fireplace Brick, Gas, Marble, Wood
Fireplaces 4
Formal Dining Rm Y/n 1
Game Rm Dim 25x16
Game Rm Level 3
Gas Propane
Great Rm Dim 22x16
Great Room Level 1
Heating Geothermal
Inside Features 9Ft + Ceiling, Beam Ceiling, Bonus Room, Crown Molding, French Doors, Great Room, Loft, Multi Panel Doors, Natural Woodwork, Recess Ceiling
Kitchen Dimensions 19x16
Kitchen Features Ceramic Tile, Gourmet, Island, Marble/Granite/Slate, Pantry, Planning Desk, Wood Cabinets, Wood Floors
Kitchen Level 1
Laundry 10x8
Laundry Rm Level 1
Levels 3 Story
Living Rm Feat Fireplace, Window Treatments, Wood Floors
Living Room Dimensions 16x15
Living Room Level 1
Loft Dim 25x14
Loft Level 2
Master Bath 1 Dim 16x11
Master Bath 1 Feat Ceramic Tile, Double Vanity, Marble/Granite/Slate, Shower, Tub, Window Treatments
Master Bath 1 Level 1
Master Bedroom Dim 21x18
Master Bedroom Features Bath Adjoins, Dressing Area, Fireplace, Walk-in Closet, Walkout, Window Treatments, Wood Floors
Master Bedroom Level 1
Other Rm Dim 10x12
Other Room Level 1
Other Room Name Relaxing Screened Deck*Huge Drop Zone w.Custom Cubbies/Racks
Room Type Basement, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Bonus Room, Breakfast Room, Dining Room, Entry, Family Room, Game Room, Great Room, Kitchen, Laundry Room
Study Dim 16x12
Study Features Bookcase, Fireplace, Wood Floors
Study Level 1
Utility Rm Dim 14x8
Utility Rm Level 1
Windows Casement, Insulated

Exterior Features

Accessible Transport City Street, County Road
Architecture Traditional
Buildings Gazebo, Guest House, Pool House
Exterior Finish Brick
Foundation Poured
Garage 5
Land Description 10 to 19 Acres
Lot Area 11.25
Lot Dimensions 11.25
Lot Square Footage 490050
Outside Features Balcony, Cul-de-sac, Encl Porch/Patio, Patio, Pool In-Ground, Porch, Wood Fence, Wooded Lot, Yard Lights
Parking Driveway
Roof Shingle
Sewer Septic
Topography Level, Rolled
Trees Heavily Wooded
View Woods
Water Source Public

Property Schools

Direct Link:


Gallery (30 photos)

Ask Your Agent a Question

Property vs Zip Code Avg (41091)

Price 1.29M Avg 444K

Taxes $14,594 Avg $3,882

Acres 11.25 Avg 0.69

Visits 250 Avg 43

Days on Site 381 Avg 80

Ask How to Finance this Property

Download Our Mobile App

Download Millions Mapped

Listing Provided Courtesy Of: Realty Executives Select

Back to Search

Chat is Now Online! Ask Away!

In the Neighborhood

Find Your Home's Value Instantly

Saved Properties

This is a list of your favorite properties. We will email you if a property is reduced or leaves the market.

Click 'Save' to add a property to this list.

Register / Login

New & returning visitors please enter your information to login.

By clicking 'register' you are agreeing to our terms of use & giving us expressed written consent to contact you.

Questions? Comments? Complaints?

This message will go directly to the head of our team.

Location & Address

Keller Williams Realty Services
2216 Dixie Hwy ste 100
Fort Mitchell, KY