Listing Courtesy of: NORTHERN KENTUCKY / Listed By: Kathy Sandel, Coldwell Banker Realty
8397 Saint Louis Boulevard Union, KY 41091
Active (9 Days)
$549,000 (USD)
OPEN HOUSE TIMES
-
OPENSun, Jun 281:00 pm - 3:00 pm
Description
Open House Sun June 28 1-3 pm 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,
MLS #:
643896
643896
Lot Size
0.28 acres
0.28 acres
Type
Single-Family Home
Single-Family Home
Year Built
2008
2008
Style
Traditional
Traditional
Views
True
True
County
Boone County
Boone County
Listed By
Kathy Sandel, Coldwell Banker Realty
Source
NORTHERN KENTUCKY
Last checked Jun 28 2026 at 9:24 AM GMT+0000
NORTHERN KENTUCKY
Last checked Jun 28 2026 at 9:24 AM GMT+0000
Bathroom Details
- Full Bathrooms: 3
- Half Bathroom: 1
Interior Features
- Dishwasher
- Microwave
- Refrigerator
- Electric Cooktop
- Double Oven
Lot Information
- Level
Property Features
- Fireplace: Gas
- Foundation: Poured Concrete
Heating and Cooling
- Forced Air
- Natural Gas
- Central Air
- Zoned
Basement Information
- Full
- Finished
- Full Finished Bath
- Kitchen
Homeowners Association Information
- Dues: $595/ANNUALLY
Utility Information
- Sewer: Public Sewer
School Information
- Elementary School: Longbranch
- Middle School: Ballyshannon Middle School
- High School: Cooper High School
Parking
- Driveway
- Garage
- Oversized
- Garage Door Opener
- Garage Faces Front
Living Area
- 3,486 sqft
Location
Disclaimer: Copyright 2026 Northern Kentucky MLS. All rights reserved. This information is deemed reliable, but not guaranteed. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated 6/28/26 02:24
