Listing provided courtesy of Coldwell Banker Realty FM- MLS# 643896MLS Provider

8397 Saint Louis BoulevardUnion, KY 41091

Single Family · 4 Beds · 3 Full Baths · 1 Half Bath · 3,486 Sq. ft. | 0.28 Acres
$549,000 Active

8397 Saint Louis Boulevard Overview

Time on Site:
10 days
Visits:
1

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,

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
View Map

8397 Saint Louis Boulevard Facts & Features

  • Type Single Family
  • Sq. ft. 3,486
  • Price/Sq.ft. $157
  • Lot 0.28 Acres

Details

General

Association/HOA

  • Association Fee: 595.0
  • Association Fee Frequency: Annually
  • Association Fee Includes: Association Fees, Management
  • Association: Yes

School Information

  • Elementary School: Longbranch
  • Middle Or Junior School: Ballyshannon Middle School
  • High School: Cooper High School

Building Information

  • New Construction: No
  • Sewer: Public Sewer: true
  • Year Built: 2008

Location/Region

  • County Or Parish: Boone
  • MLS Area Major: K11 - Richwd/Un/Wal/Ver/SB
  • MLS Area Minor: K11 - Richwd/Un/Wal/Ver/SB

Parking Information

  • Parking Features: Garage Door Opener: true
  • Parking Features: Garage Faces Front: true

General Information

  • Parcel Number: 051.01-06-428.00
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Property Type: Residential

Interior

Building Information

  • Cooling: Central Air: true
  • Cooling: Zoned: true
  • Heating: Forced Air: true

Parking Information

  • Garage Spaces: 2.0
  • Garage: Yes

Beds/Baths

  • Bathrooms Full: 3
  • Bathrooms Half: 1
  • Bathrooms Total: 4
  • Bedrooms Total: 4

Building Interior

  • Building Area Total: 3486.0
  • Interior Features: Ceiling Fan: true
  • Interior Features: Crown Molding: true
  • Interior Features: High Ceilings: true
  • Interior Features: Open Floorplan: true
  • Interior Features: Recessed Lighting: true
  • Laundry Features: Electric Dryer Hookup: true
  • Laundry Features: Main Level: true
  • Laundry Features: Washer Hookup: true

General Information

  • Appliances: Electric Cooktop, Dishwasher, Double Oven, Microwave, Refrigerator
  • Electric: 220 Volts, 200+ Amp Service
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Fireplaces Total: 1
  • Foundation Details: Poured Concrete
  • Interior Features: Kitchen Island, Wet Bar, Walk-In Closet(s), Soaking Tub, Pantry, Open Floorplan, Entrance Foyer, Eat-in Kitchen, Double Vanity, Crown Molding, Chandelier, Breakfast Bar, Cathedral Ceiling(s), Ceiling Fan(s), High Ceilings, Multi Panel Doors, Recessed Lighting
  • Laundry Features: Electric Dryer Hookup, Laundry Room, Main Level, Washer Hookup
  • Living Area: 3486.0
  • Living Area Units: Square Feet
  • Rooms Total: 15

Exterior

Parking Information

  • Parking Features: Driveway, Garage, Garage Door Opener, Garage Faces Front, Oversized

Lot Information

  • Lot Features: Level
  • Lot Size Acres: 0.28
  • Lot Size Area: 0.28
  • Lot Size Dimensions: 95'x150'x64'
  • Lot Size Source: Realist
  • Lot Size Square Feet: 12064.0
  • Lot Size Units: Acres
  • Water Source: Public

Waterfront/View

  • View: Neighborhood
  • View: Neighborhood: true

Building Exterior/Construction

  • Attached Garage: No
  • Construction Materials: Brick, Stone, Vinyl Siding
  • Patio And Porch Features: Deck, Patio, Porch
  • Property Attached: No
  • Roof: Shingle

General Information

  • Fencing: Fenced, Wood
  • Road Frontage Type: City Street
  • Sewer: Public Sewer
  • Utilities: Natural Gas Available

8397 Saint Louis Boulevard Neighborhood

Community

41091 (UNION) Demographics

38
Median Age
411
Population Density (per sq. mile)
56%
College Educated
$120,826
Estimated Median Income
6,226
Estimated Total Home Owners
451
Estimated Total Renters
93% / 7%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.

Schools

School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

8397 Saint Louis Boulevard Monthly Cost

$
$ %
%
$
$
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

8397 Saint Louis Boulevard Market Data

Based on the last 30 days in this zip code

$589,119
Average List Price
$304
Average Price per Square Foot
49
Properties Sold
67
Average Days on Market
221
Properties for Sale
Calculations provided by Reliance Network

8397 Saint Louis Boulevard History

Date Event Value Agent
6/21/2026Source: Northern Kentucky MLS Added to Database
June 21, 2026
3/3/2025Source: Northern Kentucky MLS Status Change
Sold
1/12/2025Source: Northern Kentucky MLS Status Change
Pending
1/9/2025Source: Northern Kentucky MLS Added to Database
January 09, 2025