Skip To Content

8397 Saint Louis Boulevard

Union, KY 41091
  • $525,000
  • STATUS: Pending
  • ON SITE: 3 Days
  • MLS #: 629111
Under Contract
UPDATED: 31 min ago
$525,000
  • 4
    BEDS
  • 0.28
    ACRES
  • 3
    BATHS
  • 1
    1/2 BATHS
  • 3,486
    SQFT
  • $151
    $/SQFT
Neighborhood:
Type:
Single-Family Home
Built:
2008
County:

School Information

Elementary School:
High School:
School District:

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

Monthly Payment Calculator



Northern Kentucky MLS logo © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2025-01-13T18:24:37.023.
www.jimsimpsonrealtors.com/homes/159313734
Print Image

8397 Saint Louis Boulevard Union, KY 41091

  • Price: $525,000
  • Status: Pending
  • On Site: 3 Days
  • Updated: 31 min ago
  • MLS #: 629111
4
Beds
3
Baths
1
½ Baths
0.28
Acres
3,486
SQFT
$151
$/SQFT
2008
Built
Neighborhood:
Richwd/Un/Wal/Ver/Sb
County:
Boone
Area:
Richwd/Un/Wal/Ver/Sb
Elementary School:
Longbranch
Middle School:
Ballyshannon Middle School
High School:
Cooper High School
School District:
Boone Co Public
Property 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
Exterior Features

Architectural Style Traditional Attached Garage YN No Construction Materials BrickVinyl Siding Foundation Details Poured Concrete Garage YN Yes Levels Two Parking Features DrivewayGarageGarage Faces Front Patio And Porch Features EnclosedPatioPorchTiered Deck Roof MetalShingle

Interior Features

Appliances Electric CooktopElectric OvenDishwasherMicrowaveRefrigerator Basement Finished Cooling Central Air Cooling YN Yes Fireplace Features Gas Fireplace YN Yes Fireplaces Total 1 Flooring Vinyl Heating Natural Gas Heating YN Yes Living Area 3486 Rooms Total 15 Window Features Insulated Windows

Property Features

Association Amenities Pool Association Fee 525 Association Fee Frequency Annually Association YN Yes Lot Size Dimensions 95'x150'x64' New Construction YN No Property Attached YN No Property Class Residential Property Sub Type Single Family Residence Sewer Public Sewer Utilities Natural Gas Available Water Source Public Zoning Description Residential

Northern Kentucky MLS logo Courtesy of Coldwell Banker Realty FM: 859-341-9000. © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. Information has not been verified, is not guaranteed, and subject to change.


Northern Kentucky MLS logo © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2025-01-13T18:24:37.023.
 
https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_629111-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_629111-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_1_629111-2.jpg
Logo
Jim Simpson Realtors Inc
39 Broadway
Dry Ridge KY, 41035