8397 Saint Louis Boulevard Union, KY 41091
Listing Courtesy of: NORTHERN KENTUCKY / Coldwell Banker Realty / Andre Bogle

  8397 Saint Louis Boulevard Union, KY 41091

Active (2 Days)
$525,000
4
BED
4
BATH
3,486
SQFT

Description

WOW! Welcome to your beautiful French style 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. Dreaming of warmer weather? Well check out the Outdoor Private Deck, Outdoor living space w/stone patio, large fenced in backyard, with upgraded landscaping package... Come inside, & get warm by the fire place, & be the Mecca of entertaining, with ample space, Gourmet Kitchen, wet Bar, Sunroom, formal dining, breakfast area, stone counter tops, oversized kitchen island, chef's kitchen, grand primary bedroom w/ sitting area, primary bathroom w/ his and her vanity and sink!!! Including designer's shower, oversized bedrooms, and walk in closets, large second story loft, recreation/game 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, YOU HAVE GOT TO SEE THIS HOME! Fall in love, & Make this YOUR DREAM HOME

MLS #:
629111
Lot Size
0.28 acres
Type
Single-Family Home
Year Built
2008
Style
Traditional
County
Boone County

Listed By

Andre Bogle, Coldwell Banker Realty
Source
NORTHERN KENTUCKY
Last checked Jan 10 2025 at 7:30 AM GMT+0000
Bathroom Details
  • Full Bathrooms: 3
  • Half Bathroom: 1
Interior Features
  • Refrigerator
  • Microwave
  • Dishwasher
  • Electric Oven
  • Electric Cooktop
Property Features
  • Fireplace: Gas
  • Foundation: Poured Concrete
Heating and Cooling
  • Natural Gas
  • Central Air
Basement Information
  • Finished
Homeowners Association Information
  • Dues: $525/ANNUALLY
Flooring
  • Vinyl
Utility Information
  • Sewer: Public Sewer
School Information
  • Elementary School: Longbranch
  • Middle School: Ballyshannon Middle School
  • High School: Cooper High School
Parking
  • Garage Faces Front
  • Garage
  • Driveway
Living Area
  • 3,486 sqft
Location
   
Calculate drive times to this property
 
Powered by INRIX® Drive Time

Powered by Walk Score®
Disclaimer: Copyright 2025 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 1/9/25 23:30