Property Attributes
- MLS#647555
- TypeSingle Family
- Listing Status Pending
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodOrleans North
- Zip41091
- StyleTransitional
- Year Built2003
- Price$ 349,900
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms2
- Sqr Footage1810
- Lot Size0.16 Acres
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
Welcome to this beautifully refreshed 4-bedroom home in the desirable Orleans community of Union, Kentucky! Nestled on a peaceful, wooded lot, this home offers the perfect blend of comfort, style, and functional living space. Fresh paint, new carpet, and refinished hardwood floors give the interior a fresh, inviting feel. The spacious layout features 4 bedrooms, 2 full baths, and a convenient half bath in the lower level. The primary suite offers his-and-hers closets, while the second-floor laundry adds everyday convenience. Enjoy additional living and entertaining space in the walk-out finished basement, complete with easy access to the patio and backyard. Step outside to relax on the deck or patio and take in the natural beauty of the wooded setting. Major updates include new windows in 2025, HVAC in 2020, and a roof installed in 2017. With its inviting spaces, thoughtful updates and tranquil setting, this home is ready for its next owner. Don't miss your opportunity to make this Orleans home your own!
| Elementary School | Middle School | High School |
|---|---|---|
| Longbranch Elementary School | Ockerman Middle School Middle School | Cooper High School High School |
| Price History | |
|---|---|
| 10/14/2026 | Listed $349,900 |
General Features
| Living Area | 1810 |
|---|---|
| Sewer | Public Sewer |
| Heating | Forced Air |
| Cooling | Central Air |
| Utilities | Sewer Available,Water Available |
| Roof | Shingle |
| HOA Fee | 155 |
| Garage Spaces | 2 |
| Patio/Porch Features | Covered,Deck,Patio |
| Architectural Style | Transitional |
| Security Features | Smoke Detector(s) |
| Construction Materials | Brick,Vinyl Siding |
| Year Built | 2003 |
| View | Neighborhood,Trees/Woods |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Annually |
| County | Boone |
| New Construction | false |
| Property Type | Residential |
| HOA | true |
| Attached Garage | true |
| Subdivision Name | Orleans North |
| Garage Y/N | true |
| Total Rooms | 8 |
| Status | Pending |
| Directions | 42 to Old Union, R onto Longbranch, R onto St. Louis, R onto Rampart, R on Antoinette Way. |
| 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 | 7000 |
| Elementary School | Longbranch |
| Property Attached Y/N | false |
| Middle/Junior High School | Ockerman Middle School |
| Property Condition | Existing Structure |
| MLS Area Minor | K11 - Richwd/Un/Wal/Ver/SB |
| Structure Type | House |
| Standard Status | Pending |
Interior Features
| Interior Amenities | Laminate Counters,Kitchen Island,Track Lighting,Built-in Features,Ceiling Fan(s),Multi Panel Doors,Recessed Lighting |
|---|---|
| Basement | Finished |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Insulated Windows |
| Fireplace Y/N | false |
| Laundry Features | Laundry Room,Upper Level |
| Total Baths | 4 |
Exterior Features
| Exterior Amenities | Private Yard |
|---|---|
| Fencing | Fenced,Split Rail |
| Parking Features | Attached,Driveway,Garage |
| Lot Features | Wooded |
| Water Source | Public |
| Lot Size Area | 0.16 |
| Foundation Details | Poured Concrete |
| Lot Dimensions | Irreg |
| Lot Size Acres | 0.16 |
| Road Surface Type | Paved |
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
Data last updated: November 7, 2026 4:34 PM UTC and updating occurs daily
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of Metro Search, Inc. Real estate listings held by brokerage firms other than United Real Estate Louisville are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about each listing includes the name of the listing broker.
© 2026 Metro Search, Inc.
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information 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. The data relating
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program. Real estate listings held by IDX Brokerage firms other than United Real Estate Louisville 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 IDX Brokers. This information is provided exclusively for personal, non-commercial use and may not be used for any purpose other than to
REALTOR® Association of Southern Kentucky All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
Heart of Kentucky Association of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating