Public Remarks: Great outdoor living space on the oversized deck & stunning view from back of this lovely home! Just 9 years new & boasting neutral decor, 2nd floor laundry room, hardwood floors, abundant closet space, lots of natural light, walk-out lower level ready for your finishing touches, extended garage, more! When can you move in?
Single-familyProperty Type
2009Year Built
0.26 acresLot Size
2 car garageParking
Listed by Janell Stuckwisch• Coldwell Banker Realty FM
Middle Or Junior School: Ballyshannon Middle School
Elementary School: Longbranch
High School District: Boone Co Public
High School: Cooper High School
Location Information
Directions: US 43 to Old Union Rd to R on Orleans Blvd, L on Longbranch, R on St Louis Blvd, R on Rampart, R on Chateau to L on Mardi Gras to R on Jackson Rue.
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 2,268
Stories: 2.0
Lot Size: 0.26 acres
Style: Single Family Residential
Year Built: 2009
Year Renovated: —
County: Boone County
APN: 051.00-06-409.00
Home facts updated by county records on Oct 30, 2026
Around this home
Schools
K - 12
Preschool & daycare
Longbranch Elementary School
Public PreK-5 • Assigned • 1.1mi
8/10
Ballyshannon Middle School
Public 6-8 • Assigned • 1.4mi
6/10
Randall K. Cooper High School
Public 9-12 • Assigned • 1.3mi
8/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 102° expected this year, 19 days in 30 years
2/10 Wind Factor
2% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 3 days in 30 years
Provided by First Street
Historical weather
Union, KY • 41091
Average low and high temperatures (°F)
35°
19°
44°
27°
62°
41°
70°
49°
72°
54°
83°
65°
87°
70°
83°
65°
82°
59°
68°
49°
55°
40°
44°
30°
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.1 hours in
June and 3.2 hours in December, placing it below the
U.S. average for solar exposure.
9.1 hrs
3.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$362,000 – $439,000
Reach more buyers when you sell with Redfin. Save up to $3,809 in fees.3 minutes to get started.