8397 Saint Louis Boulevard, Union, KY 41091

Union
Local realty services provided by:ERA Real Solutions Realty
8397 Saint Louis Boulevard,Union, KY 41091
$539,000
  • 4 Beds
  • 4 Baths
  • 3,486 sq. ft.
  • Single family
  • Pending
Listed by: kathy sandel
Office: coldwell banker realty fm
MLS#:643896
Source:KY_NKMLS

Price summary

  • Price:$539,000
  • Price per sq. ft.:$154.62
  • Monthly HOA dues:$49.58

About this home

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,

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2008
  • Subdivision & Development:French Quater/orleans Sub
  • Listing ID #:643896
  • Added:95 day(s) ago
  • Updated:September 18, 2026 at 07:52 AM

Rooms and interior

  • Bedrooms:4
  • Total bathrooms:4
  • Full bathrooms:3
  • Half bathrooms:1
  • Rooms Total:15
  • Dining Description:Breakfast Bar
  • Bathrooms Description:Soaking Tub
  • Kitchen Description:Dishwasher, Eat-in Kitchen, Electric Cooktop, Kitchen Island, Microwave, Pantry, Refrigerator
  • Basement Description:Finished, Full
  • Living area:3,486 sq. ft.

Heating and cooling

  • Cooling:Central Air, Zoned
  • Heating:Forced Air
  • Central air:Yes

Structure and exterior

  • Year built:2008
  • Building area:3,486 sq. ft.
  • Lot area:0.28 Acres
  • Lot Features:Level
  • Architectural Style:Traditional
  • Construction Materials:Brick, Stone, Vinyl Siding
  • Exterior Features:Deck, Patio, Porch
  • Foundation Description:Poured Concrete

Schools

  • High school:Cooper High School
  • Middle school:Ballyshannon Middle School
  • Elementary school:Longbranch

Utilities

  • Water:Public
  • Sewer:Public Sewer

Finances and disclosures

  • Price:$539,000
  • Price per sq. ft.:$154.62

Features and amenities

  • Appliances:Microwave, Refrigerator
  • Laundry features:Main Level, Washer Hookup
  • Amenities:Cathedral Ceiling(s), Ceiling Fan(s), Crown Molding, High Ceilings, Multi Panel Doors, Playground, Pool, Recessed Lighting, Vinyl Frames
  • Pool features:Pool

Parking

  • Garage:Yes
  • Garage spaces:2
Information Deemed Reliable but Not Guaranteed. The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than ERA Real Solutions Realty are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

New listings near 8397 Saint Louis Boulevard