8397 Saint Louis Boulevard

Union, KY
$ 539,000 Beds 4 Baths 3.5 Sq 3,486
Monthly Estimate* How much can I afford?

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,

Pending

  • Price
  • $ 539,000
  • City
  • Union
  • Bedrooms
  • 4
  • Full Bathrooms
  • 3
  • County
  • Boone
  • Half Bathrooms
  • 1
  • Area
  • Richwd-Un-Wal-Ver-SB
  • Lot Size
  • 0.28 Acres
  • Zip
  • 41091
  • Sqr Footage
  • 3,486
  • Year Built
  • 2008
  • Style
  • Traditional
  • MLS#
  • 643896
Listed By: Coldwell Banker Realty FM - 859-341-9000
Data Source: Northern Kentucky MLS (NKAR)

Features

General

Living Area 3486
Sewer Public Sewer
Heating Natural Gas,Forced Air
Cooling Zoned,Central Air
Utilities Natural Gas Available
Roof Shingle
HOA Fee 595
Garage Spaces 2
Association Fee Includes Association Fees
Patio/Porch Features Deck,Patio,Porch
Architectural Style Traditional
Construction Materials Brick,Stone,Vinyl Siding
Year Built 2008
Electric 220 Volts,200+ Amp Service
View Neighborhood
Levels Two
Property Subtype Single Family Residence
Assoc Fee Paid Per Annually
County Boone
New Construction false
Property Type Residential
Association Amenities Playground,Pool,Management
HOA true
Attached Garage false
Subdivision Name French Quater/orleans Sub
Garage Y/N true
Total Rooms 15
Status Pending
Directions : 75 to US/42 West, right on Old Union Rd, right on Orleans, left on longbranch right on Saint louis Boulevard
High School Cooper High School
City Union
Zoning Description Residential
MLS Area K11 - Richwd/Un/Wal/Ver/SB
Lot Size Units Acres
Lot Size Square Feet 12064
Elementary School Longbranch
Property Attached Y/N false
Middle/Junior High School Ballyshannon Middle School
Property Condition Existing Structure
MLS Area Minor K11 - Richwd/Un/Wal/Ver/SB
Living Area Units Square Feet
Standard Status Pending

Interior Features

Interior Amenities 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
Basement Kitchen,Full Finished Bath,Full,Finished
Total Fireplaces 1
Fireplace Features Gas
Air Conditioning Y/N true
Heating Y/N true
Window Features Insulated Windows,Vinyl Frames
Fireplace Y/N true
Laundry Features Electric Dryer Hookup,Laundry Room,Main Level,Washer Hookup
Total Baths 4

Exterior Features

Fencing Fenced,Wood
Parking Features Driveway,Garage,Garage Door Opener,Garage Faces Front,Oversized
Lot Features Level
Water Source Public
Lot Size Area 0.28
Foundation Details Poured Concrete
Building Area Total 3486
Lot Dimensions 95'x150'x64'
Lot Size Acres 0.28
Lot Size Source Realist
Door Features Sliding Doors
Road Frontage Type City Street
Other Equipment Sump Pump

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Affordability Calculator

$3,786

Per Month

Based on the average sale price from the Cincinnati, OH office

  • Monthly Principal & interest $2,658
  • Monthly Property Taxes $1,062
  • Monthly Home Insurance $67
Adjust Payment Options
Agent Photo

Let's determine your purchasing power. Working with my mortgage partner, you'll have the information you need to shop for a home with confidence.

Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA, or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

Schools

Elementary School Longbranch Elementary School
Middle School Ballyshannon Middle School Middle School
High School Cooper High School High School

Price History

6/29/2026 Listed $549,000
7/8/2026 1% - $544,000
7/15/2026 1% - $539,000

Property vs Zip Code Average in 41091

Price
AVG $610K
$540K
Year Built
AVG 2014
2008

In The Neighborhood

Areas That We Cover

8397 Saint Louis Boulevard Union, KY is a Single Family Home for sale at $539000 with 3486 sqft and a lot size of 0.28 Acres Acre(s). 8397 Saint Louis Boulevard Union has 4 bedrooms, 3 baths and was built in 2008. The property's zip code is 41091 which is in Union, KY

*Information deemed reliable but not guaranteed.

Financial calculator disclaimer: Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

All information deemed reliable, but not guaranteed, and should be independently verified. The real estate information and related content displayed on this site is provided 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.

Your Agent
Lindsey Holland

Lindsey Holland

513-986-5767

Find your home's value