8397 Saint Louis Boulevard, Union, KY 41091

• 4 beds |
• 4 baths |
• 3,486 sqft

Property Description

WOW! Welcome to your beautiful home... at the French Quarter, at Orleans in Union, KY! This Better than NEW, 4 Bedroom, 4 Bathroom, Two Story Dream Home is a rare opportunity that boasts 3 levels of living space. check out the Outdoor Private Deck, Outdoor living space w/paver patio large fenced in backyard, with upgraded landscaping Gourmet Kitchen, wet Bar, Sunroom, formal dining, breakfast area, oversized kitchen island, , grand primary bedroom w/ sitting area, primary remodeled bathroom Including designer's shower, oversized bedrooms, and walk in closets, large second story loft, area, full bathroom in lower level. Neighborhood amenities include community pool, wooded walking trails, community park w/ sand volley ball, tennis court, basketball court, picnic area, stocked ponds, and so much more! Coveted Union School district Cooper High, Ballyshannon Middle,

Listing Status:

Active

Data Last Updated:

June 25, 2026 at 12:37PM

Listing Office:

Coldwell Banker Realty FM : 859-341-9000

Listing Agent:

Kathy Sandel : 859-380-9442

MLS ID:

643896

Interior

• General: Ceiling Fan(s)Recessed LightingMulti Panel DoorsHigh CeilingsCrown MoldingCathedral Ceiling(s)Breakfast BarChandelierDouble VanityEat-in KitchenEntrance FoyerKitchen IslandOpen FloorplanPantrySoaking TubWalk-In Closet(s)Wet Bar
• Appliances: Double OvenDishwasherMicrowaveRefrigeratorElectric Cooktop
• Laundry: Electric Dryer HookupMain LevelWasher HookupLaundry Room
• Basement: FullFull Finished BathFinishedKitchen
• A/C: Central AirZoned
• Heating: Forced AirNatural Gas
• Fireplace: GasFireplaceFireplaces: 1

Exterior

• Style: Traditional
• Parking: DrivewayGarage Faces FrontOversizedGarage Door OpenerGarage

Construction

• Roofing: Shingle
• Windows: Insulated WindowsVinyl Frames
• General: BrickStoneVinyl SidingTwoPoured Concrete

Location

• Road/Access: City Street
• HOA Amenities: PoolPlaygroundAssociation FeesManagement595.0Annually
• Originating MLS: Northern Kentucky Multiple Listing Service
• School District: Boone Co Public
• County: Boone

Lot

• Zoning: 051.01-06-428.00
• View: NeighborhoodView
• Fencing: WoodFenced

Utilities

• Utilities: Natural Gas Available[01]
• Water: Public
• Sewer: Public Sewer

Financial

• Source: Northern Kentucky Multiple Listing Service