Property Attributes
- MLS#646500
- TypeSingle Family
- Listing Status Active
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodOrleans North
- Zip41091
- StyleCraftsman
- Year Built2018
- Price$ 625,000
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms1
- Sqr Footage3032
- Lot Size0.68 Acres
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
Former Drees Model Home -- Loaded with Upgrades! Welcome to this impressive Alden floorplan by Drees Homes, a former model home showcasing thoughtful upgrades and beautiful design throughout. Offering 4 bedrooms, 2.5 bathrooms and a 3-car garage, this home is ideally situated in the desirable French Quarter at Orleans. Step inside to an inviting open floorplan designed for both everyday living and entertaining. The fully equipped Kitchen features quartz countertops, a massive island with breakfast bar, spacious pantry and abundant workspace. The Kitchen flows seamlessly into the Breakfast Area, where you can step outside to the private deck with pergola--a perfect spot for outdoor dining or relaxing. The dramatic Living Room is a showstopper with soaring 18-foot ceilings, a wall of windows providing beautiful natural light and a cozy corner fireplace. Just a few steps down, you'll find a spacious Recreation Room, creating the perfect setting for movie nights, game days or entertaining family and friends. The Primary Suite truly feels like its own private wing, featuring an adjoining luxury bathroom and a massive walk-in closet with the added convenience of direct access to the Laundry Room. Upstairs, you'll find three additional spacious bedrooms and a full bathroom, providing plenty of room for family, guests or a home office. The unfinished walkout basement offers tremendous possibilities for future living space while currently providing excellent room for storage, a home gym, workshop or hobby area. Walk directly out to the backyard and imagine the possibilities! A 3-car garage provides plenty of room for vehicles, recreational equipment and additional storage. And the location makes it even better! Enjoy being within walking distance of the community pool, clubhouse, fishing pond and Orleans Park.
| Elementary School | Middle School | High School |
|---|---|---|
| Longbranch Elementary School | Ballyshannon Middle School Middle School | Cooper High School High School |
| Price History | |
|---|---|
| 9/9/2026 | Listed $625,000 |
General Features
| Living Area | 3032 |
|---|---|
| Sewer | Public Sewer |
| Heating | Natural Gas |
| Cooling | Central Air |
| Utilities | Cable Available,Sewer Available,Water Available |
| Roof | Shingle |
| HOA Fee | 635 |
| Garage Spaces | 3 |
| Patio/Porch Features | Covered,Deck,Patio,Porch |
| Architectural Style | Craftsman |
| Construction Materials | Vertical Siding,Stone,Vinyl Siding |
| Year Built | 2018 |
| View | Lake,Neighborhood,Trees/Woods,Valley |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Annually |
| County | Boone |
| New Construction | false |
| Property Type | Residential |
| Association Amenities | Lake Year Round,Pool,Management |
| HOA | true |
| Attached Garage | true |
| Subdivision Name | Orleans North |
| Garage Y/N | true |
| Other Structures | Pergola |
| Total Rooms | 16 |
| Status | Active |
| Directions | Longbranch to right on Barrone. House is on the left. |
| 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 | 29834.24 |
| Elementary School | Longbranch |
| Property Attached Y/N | false |
| Middle/Junior High School | Ballyshannon Middle School |
| Property Condition | Existing Structure |
| MLS Area Minor | K11 - Richwd/Un/Wal/Ver/SB |
| Structure Type | House |
| Living Area Units | Square Feet |
| Standard Status | Active |
Interior Features
| Interior Amenities | Kitchen Island,Walk-In Closet(s),Tray Ceiling(s),Storage,Stone Counters,Pantry,Open Floorplan,High Speed Internet,Entrance Foyer,Double Vanity,Crown Molding,Chandelier,Breakfast Bar,Built-in Features,Ceiling Fan(s),High Ceilings,Multi Panel Doors,Recessed Lighting |
|---|---|
| Basement | Full Bath Rough In,Full,Storage Space,Unfinished,Walk-Out Access |
| Total Fireplaces | 1 |
| Fireplace Features | Brick,Gas |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Insulated Windows,Double Hung,Vinyl Frames |
| Fireplace Y/N | true |
| Laundry Features | Electric Dryer Hookup,Laundry Room,Upper Level,Washer Hookup |
| Total Baths | 3 |
Exterior Features
| Parking Features | Attached,Driveway,Garage,Garage Door Opener,Garage Faces Front |
|---|---|
| Lot Features | Cleared,Sloped |
| Water Source | Public |
| Lot Size Area | 0.68 |
| Foundation Details | Concrete Perimeter,Poured Concrete |
| Building Area Total | 3032 |
| Lot Dimensions | 184x221x82x214 |
| Lot Size Acres | 0.68 |
| Road Surface Type | Paved |
| Lot Size Source | Realist |
| Door Features | French Doors,Sliding Doors |
| Road Frontage Type | City Street |
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
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 Two Sold It 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 good faith
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.