Public Remarks: Family ready 2 story home nestled at the end of a cul-de-sac with a large, fenced yard and walking distance from Orleans Park. 9ft ceilings on the first floor really make the home welcoming. Large kitchen with an island, hardwood floors in the dining room and parlor and gas fireplace in the family room add to the comfort. 4 bedrooms / 2 full baths / 2 half baths. Master suite features a tray ceiling, large shower and organized walk-in closet. 2 of the children's bedrooms include walk-in closets. Convenient 2nd floor laundry room. Basement includes an additional 598 sq/ft finished area with 9ft ceilings, covered deck and patio with sitting wall are all great for entertaining. New roof and HVAC within the last 5 years. Perfect home in a quiet neighborhood and only minutes away from shopping and entertainment.
Single-familyProperty Type
2007Year Built
0.32 acresLot Size
$131Est. Price/Sq.Ft.
2 car garageParking
Listed by Anthony Giglio• ListWithFreedom.com
Contact: 855-456-4945
Bought with Jessica Kirkpatrick• Horan Rosenhagen Real Estate
Appliances: Electric Range, Dishwasher, Disposal, Microwave
Has Fireplace
Room Information
Basement: Partial
Room Information 1
Room Type: Living Room
Room Dimensions: 10 x 12
Room Length: 10.00
Room Width: 12.00
Room Information 2
Room Type: Kitchen
Room Dimensions: 18 x 15
Room Length: 18.00
Room Width: 15.00
Room Information 3
Room Type: Primary Bedroom
Room Dimensions: 17 x 17
Room Length: 17.00
Room Width: 17.00
Room Information 4
Room Type: Bedroom 2
Room Dimensions: 11 x 15
Room Length: 11.00
Room Width: 15.00
Room Information 5
Room Type: Bedroom 3
Room Dimensions: 12 x 13
Room Length: 12.00
Room Width: 13.00
Room Information 6
Room Type: Bedroom 4
Room Dimensions: 10 x 11
Room Length: 10.00
Room Width: 11.00
Room Information 7
Room Type: Family Room
Room Dimensions: 17 x 23
Room Length: 17.00
Room Width: 23.00
Room Information 8
Room Type: Dining Room
Room Dimensions: 10 x 12
Room Length: 10.00
Room Width: 12.00
Exterior
Building Information
Levels: Two
Structure Type: House
Construction Materials: Aluminum Siding, Brick
Building Area Total: 0.0
Exterior Features
Patio And Porch Features: Covered, Patio
Year Built: 2007
Double Hung
Fenced
Full, Wood
Shingle
Property Type
Single Family Residence
Property Features
Property Condition: Existing Structure
Property Information
Property Type: Residential
Land Information
Road Surface Type: Paved
Lot Information
Lot Size Units: Acres
Lot Size Sq. Ft.: 13,807
Lot Size Dimensions: 23X119X190X124
Lot Size Area: 0.31
Lot Size Acres: 0.31
Lot Features: Cul-De-Sac
Utilities
Utility Information
Water Source: Public
Sewer: Public Sewer
Utilities: Cable Available, Natural Gas Available, Sewer Available, Water Available
Location
HOA Information
Has Association
School Information
Middle Or Junior School: Ockerman Middle School
Elementary School: Erpenbeck Elementary
High School District: Boone Co Public
High School: Ryle High
Location Information
Directions: US 42 to right on Old Union Rd. Right on Orleans Blvd. Straight through circle. Continue onto Longbranch Rd. Right on St. Louis Blvd. Right on Rampart Way. Right on Chateau Ct. Left on Mardi Gras Way. Left on Jackson Rue.
Public facts
Beds: 4
Baths: 3.0
Sq. Ft.: 2,529
Stories: 1.0
Lot Size: 0.32 acres
Style: Single Family Residential
Year Built: 2006
Year Renovated: —
County: Boone County
APN: 051.00-06-429.00
Home facts updated by county records on Jul 30, 2026
Around this home
Schools
Longbranch Elementary School
Public PreK-5 • Assigned • 0.9mi
8/10
Ballyshannon Middle School
Public 6-8 • Assigned • 1.3mi
6/10
Randall K. Cooper High School
Public 9-12 • Assigned • 1.1mi
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
1% 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
71
83
65
82
60
70
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
$418,000 – $506,000
Reach more buyers when you sell with Redfin. Save up to $4,398 in fees.3 minutes to get started.