Skip main navigation
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

    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

    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#: 629111MLS Logo

    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