Estimated payment $3,716/month
5
Beds
3.5
Baths
3,096
Sq Ft
$205
Price per Sq Ft
Highlights
- In Ground Pool
- Clubhouse
- Traditional Architecture
- Longbranch Elementary School Rated A
- Recreation Room
- Cathedral Ceiling
About This Home
Rare opportunity in the French Quarter at Orleans, ideally situated at the end of a quiet cul-de-sac. This expansive home is defined by a true resort-style backyard featuring an Olympic-size inground pool-an exceptional amenity rarely found in Union. Inside, a dramatic two-story great room with a wall of windows fills the home with natural light. The kitchen offers granite countertops and abundant cabinetry. The spacious primary suite provides a private retreat. The finished lower level expands the lifestyle with a dedicated theater room, home gym, bedroom/office, and flexible recreation space. A standout combination of privacy, scale, and amenities in one of most desirable neighborhoods.
Open House Schedule
-
Saturday, July 11, 20262:00 to 4:00 pm7/11/2026 2:00:00 PM +00:007/11/2026 4:00:00 PM +00:00Add to Calendar
Home Details
Home Type
- Single Family
Year Built
- Built in 2007
Lot Details
- 20,298 Sq Ft Lot
- Cul-De-Sac
- Wood Fence
- Land Lease
HOA Fees
- $18 Monthly HOA Fees
Parking
- Driveway
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Vinyl Siding
- Stone
Interior Spaces
- 3,096 Sq Ft Home
- 2-Story Property
- Cathedral Ceiling
- 2 Fireplaces
- Gas Fireplace
- Family Room
- Living Room
- Breakfast Room
- Formal Dining Room
- Home Office
- Recreation Room
- Storage Room
- Utility Room
- Home Gym
Kitchen
- Double Oven
- Electric Cooktop
- Microwave
- Dishwasher
Flooring
- Wood
- Carpet
- Ceramic Tile
- Luxury Vinyl Tile
Bedrooms and Bathrooms
- 5 Bedrooms
Laundry
- Laundry Room
- Laundry Chute
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- In Ground Pool
- Patio
- Exterior Lighting
- Porch
Schools
- Longbranch Elementary School
- Ballyshannon Middle School
- Cooper High School
Utilities
- Central Air
- Heating System Uses Natural Gas
- Cable TV Available
Community Details
Overview
- Association fees include association fees
- Vertex Association, Phone Number (859) 491-5711
Amenities
- Clubhouse
Recreation
- Community Playground
- Community Pool
Map
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $3,450 | $414,900 | $50,000 | $364,900 |
| 2024 | $3,405 | $414,900 | $50,000 | $364,900 |
| 2023 | $3,193 | $385,000 | $44,000 | $341,000 |
| 2022 | $3,265 | $385,000 | $44,000 | $341,000 |
| 2021 | $4,195 | $385,000 | $44,000 | $341,000 |
| 2020 | $3,353 | $385,000 | $44,000 | $341,000 |
| 2019 | $3,382 | $385,000 | $44,000 | $341,000 |
| 2018 | $3,414 | $385,000 | $44,000 | $341,000 |
| 2017 | $3,363 | $385,000 | $44,000 | $341,000 |
| 2015 | $3,342 | $385,000 | $44,000 | $341,000 |
| 2013 | -- | $385,000 | $44,000 | $341,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 07/07/2026 07/07/26 | For Sale | $635,000 | -- | $205 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Quit Claim Deed | -- | None Listed On Document | |
| Quit Claim Deed | -- | None Listed On Document | |
| Quit Claim Deed | -- | None Listed On Document | |
| Interfamily Deed Transfer | -- | Stewart Title Co | |
| Quit Claim Deed | -- | Stewart Title Co | |
| Warranty Deed | -- | None Available | |
| Deed | $332,966 | None Available |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Previous Owner | $230,000 | VA | |
| Previous Owner | $230,000 | New Conventional | |
| Previous Owner | $265,550 | New Conventional |
Source: Public Records
About the Listing Agent
I’m Lena Keith, a former teacher turned full-time Realtor®—and I bring that same heart-first, service-driven approach into every part of the buying and selling process. After years in the classroom, I learned that people thrive when they feel supported, understood, and cared for. Real estate is no different.
My brand promise:
Care that guides. Clarity that empowers.
I’m here to make your next move feel informed, confident, and stress-light. When you work with me, you’re not
Lena's Other Listings
Source: Northern Kentucky Multiple Listing Service
MLS Number: 644393
APN: 051.01-06-424.00
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X 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.
Listing information is deemed reliable, but not guaranteed.
Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 8397 Saint Louis Blvd
- 8429 Saint Louis Blvd
- 10104 Lapalco Ct
- 2161 Antoinette Way
- 10156 Lapalco Ct
- 5048 Loch Dr
- 2727 Chateau Ct
- 2655 Longbranch Rd
- 7020 Oconnell
- 8640 Treeline Dr
- 2385 Ormond Dr
- 2435 Preservation Way
- 2381 Longbranch Rd-Lot 3 Rd
- 2381 Longbranch Rd-Lot 5 Rd
- 2381 Longbranch Rd-Lot 1 Rd
- 5125 Loch Dr
- 1887 Morningside Dr
- 8604 Treeline Dr
- 1894 Morningside Dr
- 7687 Big Cedar Ct
- 8511 Crozat St
- 2237 Antoinette Way
- 2005 Farmview Dr
- 2017 Terrace Ct
- 485 Colby Ct
- 1919 Promenade Cir
- 38 Rio Grande Cir Unit 2
- 7386 Sterling Springs Way
- 1811 Sumpter Ct
- 9302 Hardwicke Ln
- 1369 Retriever Way Unit 1B
- 1620 Corinthian Dr
- 3000 Affinity Fields
- 6259 Castle Oak Dr
- 9710 Soaring Breezes
- 239 Landon Ct
- 8488 Concerto Ct
- 2059 Arbor Springs Blvd
- 2243 Bluegrama Dr
- 1000 Tamarack Cir
Your Personal Tour Guide
Ask me questions while you tour the home.