Property Attributes
- MLS#646957
- TypeSingle Family
- Listing Status Active
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodOrleans North
- Zip41091
- StyleTraditional
- Year Built2005
- Price$ 414,900
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms1
- Sqr Footage2370
- Lot Size0.18 Acres
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
One of the larger homes in Treme at Orleans: about 2,370 sq ft above grade with 4 bedrooms and 2.5 baths, backing to the community pond with its new pier and walking path. The flat, fully fenced backyard and concrete patio look right out over the water. The main level has LVP flooring, a family room and a separate living room, a breakfast area, a refreshed powder room and first-floor laundry. Upstairs is a 19x13 primary suite with its own full bath, three more bedrooms and a 21x12 bonus room. The full, insulated walkout lower level adds about 1,000 sq ft, has a slider to the patio, and is ready to finish your way. The heat pump was replaced in 2022. Other features: a 2-car garage and Boone County Schools. You're minutes from US-42 and I-71/75. Space, a pond view and room to grow in one of Union's most walkable communities.
| Elementary School | Middle School | High School |
|---|---|---|
| Longbranch Elementary School | Ockerman Middle School Middle School | Cooper High School High School |
| Price History | |
|---|---|
| 9/25/2026 | Listed $414,900 |
General Features
| Living Area | 2370 |
|---|---|
| Sewer | At Street |
| Heating | Forced Air |
| Cooling | Central Air |
| Utilities | Cable Available,Sewer Available,Water Available |
| Roof | Shingle |
| HOA Fee | 155 |
| Garage Spaces | 2 |
| Patio/Porch Features | Deck |
| Architectural Style | Traditional |
| Security Features | Smoke Detector(s) |
| Construction Materials | Brick |
| Year Built | 2005 |
| 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 | 13 |
| Status | Active |
| Directions | I-75 to Exit 180 (Union/Florence), W on US-42, R on Old Union Rd, R on Orleans Blvd, R on Longbranch Rd, R on St. Louis Blvd, R on Rampart Way, L on Algiers St. |
| High School | Cooper High School |
| City | Union |
| MLS Area | K11 - Richwd/Un/Wal/Ver/SB |
| Lot Size Units | Acres |
| Lot Size Square Feet | 7975 |
| Elementary School | Longbranch |
| Property Attached Y/N | false |
| Middle/Junior High School | Ockerman Middle School |
| MLS Area Minor | K11 - Richwd/Un/Wal/Ver/SB |
| Living Area Units | Square Feet |
| Standard Status | Active |
Interior Features
| Interior Amenities | Laminate Counters,Double Vanity,Chandelier,Ceiling Fan(s) |
|---|---|
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Vinyl Frames |
| Fireplace Y/N | false |
| Laundry Features | Laundry Room,Washer Hookup |
| Total Baths | 3 |
Exterior Features
| Exterior Amenities | Private Yard |
|---|---|
| Fencing | Fenced |
| Parking Features | Attached,Driveway,Garage |
| Water Source | Public |
| Lot Size Area | 0.18 |
| Foundation Details | Concrete Perimeter |
| Building Area Total | 2370 |
| Lot Dimensions | 59x140 |
| Lot Size Acres | 0.18 |
| Lot Size Source | Assessor |
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
© 2026 Dayton Area Board of Realtors. All rights reserved. Information deemed to be reliable but not guaranteed. The data relating to real estate for sale on this website comes from Dayton Area Board of Realtors and the Broker Reciprocity Program.sm. Real estate listings held by brokerage firms other than Comey & Shepherd, REALTORS are marked with the BR logo and detailed information about them includes the name of the listing brokers. Listing broker has attempted to offer accurate data, but
The data relating to real estate for sale on this web site comes
in part from the Broker Reciprocity™ program of the Multiple
Listing Service of Greater Cincinnati. Real estate listings held by
brokerage firms other than Comey & Shepherd, REALTORS are marked with the MLS ™ logo
(the small logo to the left) and detailed information about them includes
the name of the listing brokers. The information herein is furnished by the property owner in
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
All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawl. Neither listing broker(s) nor SE IN BD REALTORS shall be held responsible for typographical errors, misinformation, misprints and shall be held totally harmless.