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

MLS: 456325   Type: Pending   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

Approx Sq Feet 0
Association Northern Kentucky Multiple Listing Service
Elementary School New Haven Elementary
High School Ryle High
Hoa Fee 2 0
Hoa Fee 3 0
Listing Area Richwd/Un/Wal/Ver/SB
Middle School Gray Middle School
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
New Construction No
Property Condition Yes
Property Sub Type Single Family
School District Boone County Public
Sic Union- Boone Cty
Sub Type Description Stick Built/Modular/Masonry
Subdivision Stoneyridge Farms
Suburb Union- Boone Cty
Virtual Tour Url https://vimeo.com/user41045231/review/172049644/78d70f8b6a
Year Built 0
Zoning Residential

Interior Features

# of Fireplaces 4
Appliances Included Dishwasher, Microwave, Oven/Range, Refrigerator
Basement Dimensions 73x45
Basement Features Full Bath Rough In, Unfinished, Walkout
Basement Level Basement
Basement Type Full
Baths 7
Cooling Central Air
Family Room Y/n Yes
Fireplace Brick, Gas, Marble, Wood
Formal Dining Rm Y/n Yes
Full Baths 5
Gas Propane
Half Baths 2
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 Features Ceramic Tile, Gourmet, Island, Marble/Granite/Slate, Pantry, Planning Desk, Wood Cabinets, Wood Floors
Laundry 10x8
Living Rm Feat Fireplace, Window Treatments, Wood Floors
Master Bedroom Features Bath Adjoins, Dressing Area, Fireplace, Walk-in Closet, Walkout, Window Treatments, Wood Floors
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 Features Bookcase, Fireplace, Wood Floors
Total Beds 5
Total Rooms 17
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 Dimensions 11.25
Lot Size Area 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 312K

Taxes $14,594 Avg $2,498

Acres 11.25 Avg 0.83

Visits 271 Avg 49

Days on Site 435 Avg 106

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