8474 Saint Louis Boulevard, Union, KY 41091

Local realty services provided by:ERA Real Solutions Realty
8474 Saint Louis Boulevard,Union, KY 41091
$525,000
  • 3 Beds
  • 4 Baths
  • 2,352 sq. ft.
  • Single family
  • Active
Upcoming open houses
  • Sat, Mar 21
    11:00 am - 12:30 pm
  • Sun, Mar 22
    12:30 pm - 02:00 pm
Listed by: jessica reeves
Office: sibcy cline, realtors-florence
MLS#:640766
Source:KY_NKMLS

Price summary

  • Price:$525,000
  • Price per sq. ft.:$223.21
  • Monthly HOA dues:$12.5

About 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!

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:2003
  • Listing ID #:640766
  • Added:1 day(s) ago
  • Updated:March 20, 2026 at 08:48 PM

Rooms and interior

  • Bedrooms:3
  • Total bathrooms:4
  • Full bathrooms:3
  • Half bathrooms:1
  • Rooms Total:5
  • Kitchen Description:Eat-in Kitchen, Gas Cooktop, Pantry
  • Basement Description:Finished
  • Living area:2,352 sq. ft.

Heating and cooling

  • Cooling:Central Air
  • Central air:Yes

Structure and exterior

  • Year built:2003
  • Building area:2,352 sq. ft.
  • Lot area:0.28 Acres
  • Lot Features:Wooded
  • Architectural Style:Craftsman
  • Construction Materials:Brick
  • Exterior Features:Deck
  • 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:$525,000
  • Price per sq. ft.:$223.21

Features and amenities

  • Amenities:Ceiling Fan(s), Crown Molding, Landscaping, Natural Woodwork

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.