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
Sold for $525,000 on 02/28/25
$525,000
8397 Saint Louis Blvd, Union, KY 41091
4beds
3,486sqft
Single Family Residence, Residential
Built in 2008
0.28 Acres Lot
$534,400 Zestimate®
$151/sqft
$2,949 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: March 30, 2025 at 10:17pm
Listed by:
Andre Bogle 859-638-3885,
Coldwell Banker Realty FM
Bought with:
Kathy Sandel, 182808
Coldwell Banker Realty FM
Source: NKMLS,MLS#: 629111

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Carpet Flooring, Bath Adjoins, Vaulted Ceiling(s)
- Level: Second
- Area: 396
- Dimensions: 18 x 22
Bedroom 2
- Features: Carpet Flooring
- Level: Second
- Area: 168
- Dimensions: 12 x 14
Bedroom 3
- Features: Carpet Flooring, Walk-In Closet(s)
- Level: Second
- Area: 156
- Dimensions: 12 x 13
Bedroom 4
- Features: Carpet Flooring, Walk-In Closet(s)
- Level: Second
- Area: 156
- Dimensions: 12 x 13
Other
- Features: Carpet Flooring
- Level: First
- Area: 168
- Dimensions: 12 x 14
Breakfast room
- Features: Tile Flooring
- Level: First
- Area: 104
- Dimensions: 8 x 13
Dining room
- Features: Chandelier, Chair Rail
- Level: First
- Area: 231
- Dimensions: 11 x 21
Entry
- Features: Entrance Foyer
- Level: First
- Area: 104
- Dimensions: 8 x 13
Exercise room
- Description: Unfinished, French doors, used as a sauna room
- Features: See Remarks
- Level: Lower
- Area: 529
- Dimensions: 23 x 23
Family room
- Features: Luxury Vinyl Flooring
- Level: Lower
- Area: 1023
- Dimensions: 31 x 33
Laundry
- Description: also mudroom
- Features: Tile Flooring
- Level: First
- Area: 84
- Dimensions: 7 x 12
Living room
- Features: Fireplace(s), Carpet Flooring
- Level: First
- Area: 480
- Dimensions: 24 x 20
Loft
- Features: Carpet Flooring
- Level: Second
- Area: 440
- Dimensions: 20 x 22
Other
- Description: Sun Room
- Features: Walk-Out Access
- Level: First
- Area: 204
- Dimensions: 17 x 12
Other
- Description: Wet Bar
- Features: Built-in Features, Luxury Vinyl Flooring
- Level: Lower
- Area: 108
- Dimensions: 12 x 9
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Included: Electric Cooktop, Electric Oven, Dishwasher, Microwave, Refrigerator
Features
- Flooring: Vinyl
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 3,486
- Total interior livable area: 3,486 sqft
Property
Parking
- Total spaces: 2
- Parking features: Driveway, Garage, Garage Faces Front
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Enclosed, Patio, Porch, Deck
Lot
- Size: 0.28 Acres
- Dimensions: 95' x 150' x 64'
Details
- Parcel number: 051.0106428.00
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Brick, Vinyl Siding
- Foundation: Poured Concrete
- Roof: Metal,Shingle
Condition
- Year built: 2008
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Available
Community & neighborhood
Location
- Region: Union
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $525 annually
- Amenities included: Pool
Services availability

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$534,400
2% more+ $10,688
With Zillow Showcase(estimated)
$545,088