This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$525,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
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
Full Property Details
Full Property Details for 8397 St Louis Blvd
General
- Sold For: $525,000
- HOA FEE: $44/month
- HOA FEE FREQ.: Annually
- Status: Closed
- Type: Single Family
- Source: Northern_Kentucky
- MLS ID: 629111
- Added to Site: 377 day(s) ago
Interior
- Number of Rooms: 15
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Gas
- Appliances: Electric Cooktop, Electric Oven, Dishwasher, Microwave, Refrigerator
- Flooring: Vinyl
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 3
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 4
Additional Information
- Shared Amenities: Pool
Exterior
- Porch/Patio/Deck: Enclosed, Patio, Porch, Tiered Deck
Parking
- Garage: Yes
- Garage Spaces: 2
- Parking Features: Driveway, Garage, Garage Faces Front
Location
- County: Boone
- Driving Directions: 75 to US/42 West, right on Old Union Rd, right on Orleans, right on Longbranch, right on Saint Louis
School Information
- Elementary School: Longbranch
- Middle School: Ballyshannon Middle School
- High School: Cooper High School
Community
- Community Name: K11 - Richwd/Un/Wal/Ver/SB
- Association: Yes
Heating & Cooling
- Central air: Yes
- Air Conditioning: Yes
- Cooling Type: Central Air Conditioning
- Heating Type: Natural Gas
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Natural Gas Available
Structural Information
- Architectural Style: Traditional
- Construction: Brick, Vinyl Siding
- Basement Desc.: Finished
- Roof: Metal, Shingle
- Windows: Insulated Windows
- Square Feet: 3,486
- Living Area: 3,486 Sq. Ft.
- Year Built: 2008
Lot Features
- Lot Size (Acres): 0.28
- Lot Size (Sq. Ft.): 12,064
- Lot Size: .28
- Lot Size Source: Realist
- Lot Dimensions: 95' x 150' x 64'
- Zoning: Residential
Financial Considerations
- Association Fee: $525
- Assoc Fee Freq.: Annually
Disclosures and Reports
- Property ID: 051.01-06-428.00
Get Pre-Approved Today
Schools
Schools serving 8397 St Louis Blvd
School District:Boone County School District
| Name | Grades | Distance |
|---|---|---|
Longbranch Elementary School 2805 Longbranch Road, Union, KY 41091 | K-5 | 0.6 mi |
Ockerman Middle School 8300 U.S. 42, Florence, KY 41042 | 6-8 | 2.4 mi |
Randall K. Cooper High School 2855 Longbranch Road, Union, KY 41091 | 9-12 | 0.7 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 8397 St Louis Blvd
Date
Details
Price
Change
Source
2/28/2025
Sold
$525,000
—
MLS
1/09/2025
Listed
$525,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
8397 Saint Louis Boulevard, Union, KY 41091 (MLS# 629111) is a Single Family property that was sold at $525,000 on February 28, 2025. This property was listed by Andre Bogle from our Northern Kentucky Office.Want to learn more about 8397 Saint Louis Boulevard? Do you have questions about finding other Single Family real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.



