8397 Saint Louis Boulevard Union, KY 41091
Listing Courtesy of: NORTHERN KENTUCKY / Listed By: Kathy Sandel, Coldwell Banker Realty

  8397 Saint Louis Boulevard Union, KY 41091

Active (69 Days)
$539,000 (USD)
4
BED
4
BATH
3,486
SQFT
See Similar Listings

Description

Open House Sunday July 26 1-2 ;30 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
Lot Size
0.28 acres
Type
Single-Family Home
Year Built
2008
Style
Traditional
Views
True
County
Boone County
Community
French Quater/Orleans Sub

Listed By

Kathy Sandel, Coldwell Banker Realty
Source
NORTHERN KENTUCKY
Last checked Aug 26 2026 at 8:01 AM GMT+0000
Bathroom Details
  • Full Bathrooms: 3
  • Half Bathroom: 1
Interior Features
  • Dishwasher
  • Microwave
  • Refrigerator
  • Electric Cooktop
  • Double Oven
Subdivision
  • French Quater/Orleans Sub
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
Map View | Street View
   
Calculate drive times to this property
 
Powered by INRIX® Drive Time
Powered by Walk Score®
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 8/26/26 01:01

Coldwell Banker - Northern Kentucky

© 2023 Coldwell Banker Real Estate LLC

Terms Of Use | Privacy Policy

Accessibility Statement | Fair Housing Notice

©2022 Coldwell Banker. All Rights Reserved. Coldwell Banker and the Coldwell Banker logos are trademarks of Coldwell Banker Real Estate LLC. The Coldwell Banker® System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices which are independently owned and operated. The Coldwell Banker System fully supports the principles of the Fair Housing Act and the Equal Opportunity Act.