Recently Viewed Properties
See This Home
Save This Listing
Close

$500,000

  • Sold
  • Closed
  • Single Family
  • 3 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 2,352 Sq. Ft.
  • 0.28 Acres
  • 2 Car Garage
  • Updated 7 days ago
See This Home
Save This Home
See This Home
Save This Home
This absolutely stunning Fischer built Cornell model original owner Orleans home has the beauty of a 2 story with the convenience of main floor living! Including front room with crown molding, office with double doors. Kitchen with wooden cabinetry, double oven, gas stove, eat in dining. Primary bedroom with tray ceiling and calming wooded view. Primary bath with jacuzzi tub and separate shower, elevated toilet, walk in closet. Upstairs, find 2 spacious bedrooms and full bathroom. Downstairs has a finished area with walk out, large windows, and full bathroom with the potential of a 4th bedroom. There is also a large unfinished area wide walk out for riding mower or motorcycle. Enjoy the semi-private wooded backyard and various wildlife from your deck, or the community park right across the street. With new carpet, fresh paint, and refinished wood floors, you just need to move in!

Full Property Details for 8474 St Louis Blvd

General

  • Sold For: $500,000
  • HOA FEE: $13/month
  • HOA FEE FREQ.: Annually
  • Status: Closed
  • Type: Single Family
  • Source: Northern_Kentucky
  • MLS ID: 640766
  • Added to Site: 61 day(s) ago

Interior

  • Number of Rooms: 5
  • Interior Features: Tray Ceiling(s), Pantry, Eat-in Kitchen, Crown Molding, Ceiling Fan(s), Natural Woodwork
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Gas
  • Appliances: Gas Cooktop, Double Oven

Rooms

Bathrooms

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

Bedrooms

  • Total Bedrooms: 3

Other Rooms

  • Laundry: Electric Dryer Hookup

Additional Information

  • Shared Amenities: Landscaping

Exterior

  • Porch/Patio/Deck: Deck

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 2
  • Parking Features: Attached, Driveway, Garage, Garage Faces Front

Location

  • County: Boone
  • Cross Streets: Longbranch
  • Driving Directions: From 42, take Orleans Blvd to Longbranch, turn right on Saint Louis. House will be on the left

School Information

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

Community

  • Community Name: K11 - Richwd/Un/Wal/Ver/SB
  • Association: Yes
  • Assoc. Fees Include: Maintenance Grounds, Management

Heating & Cooling

  • Central air: Yes
  • Air Conditioning: Yes
  • Cooling Type: Central Air Conditioning
  • Heating Type: Natural Gas

Utilities

  • Sewer: Public Sewer
  • Water: Public

Structural Information

  • Architectural Style: Craftsman
  • Construction: Brick
  • Basement Desc.: Full Finished Bath, Finished, Storage Space
  • Roof: Composition
  • Windows: Insulated Windows
  • Square Feet: 2,352
  • Living Area: 2,352 Sq. Ft.
  • Year Built: 2003
  • Property Condition: Existing Structure

Lot Features

  • Property View: Trees/Woods
  • Lot Size (Acres): 0.28
  • Lot Size (Sq. Ft.): 12,185
  • Lot Size: .28
  • Lot Dimensions: 80 x 151
  • Frontage: City Street, Paved
  • Lot Features: Wooded
  • Trees/Vegetation: Partially Wooded

Financial Considerations

  • Association Fee: $150
  • Assoc Fee Freq.: Annually

Disclosures and Reports

  • Property ID: 051.00-06-020.00

Meet the selling agent

Meet the selling agent
— 8474 St Louis Blvd —

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 8474 St Louis Blvd

School District:Boone County School District
NameGradesDistance
Longbranch Elementary School
2805 Longbranch Road, Union, KY 41091
K-50.8 mi
Ballyshannon Middle School
7515 Shamrock Avenue, Union, KY 41091
6-81.2 mi
Randall K. Cooper High School
2855 Longbranch Road, Union, KY 41091
9-121 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 8474 St Louis Blvd

Date
Details
Price
Change
Source
5/13/2026
Sold
$500,000
-4.76%
MLS
3/20/2026
Listed
$525,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Similar Properties near 8474 St Louis Blvd

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

12067 Old Lexington Pike, Walton, KY 41094 - Photo 1
$500,000

12067 Old Lexington Pike  Walton, KY 41094

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,291
    Sq. Ft.
8812 Marais Dr, Union, KY 41091 - Photo 1 Price Reduced
-$15,000 (-2.91%)
$499,900
Open House

8812 Marais Dr  Union, KY 41091

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
6817 Cloverfield Wy, Union, KY 41091 - Photo 1
$498,000

6817 Cloverfield Wy  Union, KY 41091

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,358
    Sq. Ft.
8429 St Louis Blvd, Union, KY 41091 - Photo 1
$505,000

8429 St Louis Blvd  Union, KY 41091

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths

Just Listed near 8474 St Louis Blvd

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2435 Preservation Way, Florence, KY 41042 - Photo 1 Just Listed
$634,900

2435 Preservation Way  Florence, KY 41042

  • Single Family
  • Active
  • Updated 5 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 3,184
    Sq. Ft.
Listed by Adam Hayhow (513) 315-1501
7401 Thunder Ridge Dr, Florence, KY 41042 - Photo 1 Just Listed
$387,900

7401 Thunder Ridge Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 9 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,426
    Sq. Ft.
1129 Cayton Rd, Florence, KY 41042 - Photo 1 Just Listed
$425,000

1129 Cayton Rd  Florence, KY 41042

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,004
    Sq. Ft.
624 Friars Ln, Florence, KY 41042 - Photo 1 Just Listed
$150,000

624 Friars Ln  #11  Florence, KY 41042

  • Condo
  • Active
  • Updated 6 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,010
    Sq. Ft.

Price Reduced near 8474 St Louis Blvd

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1837 Waverly Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$4,000 (-1.03%)
$385,000
Open House

1837 Waverly Dr  Florence, KY 41042

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,028
    Sq. Ft.
Listed by Liz Jacobs (859) 655-5818
713 Somerset Blvd, Florence, KY 41042 - Photo 1 Price Reduced
-$10,000 (-3.72%)
$259,000

713 Somerset Blvd  #9D  Florence, KY 41042

  • Condo
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,339
    Sq. Ft.
356 Cornwall Dr, Florence, KY 41042 - Photo 1 Price Reduced
-$2,500 (-0.88%)
$281,500

356 Cornwall Dr  Florence, KY 41042

  • Condo
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
528 Tristan Ln, Florence, KY 41042 - Photo 1 Price Reduced
-$2,500 (-0.87%)
$284,900

528 Tristan Ln  Florence, KY 41042

  • Condo
  • Active
  • Updated 5 days ago
  • 2
    Beds
  • 2
    Total Baths

Recent Sales near 8474 St Louis Blvd

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

10004 Audubon Ct, Union, KY 41091 - Photo 1 Sold
$434,999

10004 Audubon Ct  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 3,489
    Sq. Ft.
Sold by Sherry Clark Group
2731 Chateau Ct, Union, KY 41091 - Photo 1 Sold
$450,000

2731 Chateau Ct  Union, KY 41091

  • Single Family
  • Closed
  • 5
    Beds
  • 4
    Total Baths
  • 4,188
    Sq. Ft.
8426 St Louis Blvd, Union, KY 41091 - Photo 1 Sold
$443,500

8426 St Louis Blvd  Union, KY 41091

  • Single Family
  • Closed
  • Updated 9 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 3,562
    Sq. Ft.
8664 Eden Ct, Union, KY 41091 - Photo 1 Sold
$515,000

8664 Eden Ct  Union, KY 41091

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 3,216
    Sq. Ft.

8474 Saint Louis Boulevard, Union, KY 41091 (MLS# 640766) is a Single Family property that was sold at $500,000 on May 13, 2026. This property was sold by Gabriella DeAngelis from our Northern Kentucky Office.Want to learn more about 8474 Saint Louis Boulevard? Do you have questions about finding other Single Family real estate for sale in Union? You can browse all Union real estate or contact a Coldwell Banker agent to request more information.