$699,923
 $4,657 est/mo Sourced by Back At You

2524 Three Trees Lane,Union, KY 41091

Union, KY 41091

Share:

Description

Summer starts the moment you walk out back. A sparkling in-ground pool, glowing at night, sets the stage for long evenings with friends -- hot tub soaking, fire pit stories, and a wooded backyard reached by a stone stairway that makes the whole property feel like a private retreat in Red Stone Village. Inside, life is built for ease. The main-level primary suite sits steps from the kitchen, laundry, and covered screened deck -- no stairs between you and your morning coffee or your evening wind-down. Three additional bedrooms, each with walk-in or step-in closets, give everyone room to spread out. Head downstairs and the fun continues: a tiered-seating theater room with 140 inch screen and professionally installed audio/video ready for movie night, plus a fitness/yoga room with egress making a potential 5th bedroom, just needs a closet. Walk straight out to the pool deck, so pool days never require a trip through the house. A 3-car garage, fenced yard, geothermal HVAC, New Haven, Gray, & Ryle High schools round out a home that's as practical as it is fun. This is where families gather, kids grow up, and weekends actually feel like weekends. Built 2012 by Drees | 2,942 sq ft above grade | 4 BR, 3.5 BA | .42-acre lot

Details

MLS #644138
Listing TypeFor Sale
StyleHouse
HOA Dues$640
Sub-TypeResale
StatusPending
Year2012
Days On Site55
Listing Provided Byexp Realty, LLC | Aaron Smith

Features

Bed(s)4
Bath(s) 4 Total
SQ Feet3,735
Garage3
BasementY
PoolYes
Story(s)2
ZoningResidential
Acreage0.42
Property ViewTrees, Woods

Area Information

StateKY
CountyBoone
CityUnion
Zip Code41091
AreaK11 Richwd | Un | Wal | Ver | SB
SubareaRichwd | Un | Wal | Ver | SB
School DistrictBoone Co Public
Elementary SchoolNew Haven Elementary
High SchoolBoone Co Public
Listing VS Median (in 41091)
Price:
$699,923
low | high
Med:
$536,818
73.303206209826% of Average
sqft:
3,735
low | high
Med:
3,057
68.152610441767% of Average
$ / sqft:
$187
low | high
Med:
$179
54.46494246461% of Average
On site:
55
low | high
Med:
87.5
62.857142857143% of Average
Sourced by Back At You

Market Activity 41091

Request a showing

Request a showing

Contact


Additional Information


Showing Information


Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from e-Merge Real Estate at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
The information is being provided by Northern Kentucky MLS. Information deemed accurate but not guaranteed. Information is provided for consumers personal, non-commercial use, and may not be used for any purpose other than the identification of potential properties for purchase. Copyright 2026 Northern Kentucky MLS. All Rights Reserved.

Contact

Learn More About This Property

StateKY
CountyBoone
CityUnion
Zip Code41091
AreaK11 Richwd | Un | Wal | Ver | SB
SubareaRichwd | Un | Wal | Ver | SB
School DistrictBoone Co Public
Elementary SchoolNew Haven Elementary
High SchoolBoone Co Public
Listing VS Median (in 41091)
Price:
$699,923
low | high
Med:
$536,818
73.303206209826% of Average
sqft:
3,735
low | high
Med:
3,057
68.152610441767% of Average
$ / sqft:
$187
low | high
Med:
$179
54.46494246461% of Average
On site:
55
low | high
Med:
87.5
62.857142857143% of Average
Sourced by Back At You
Listing Updated: August 10, 2026 at 5:25:13 PM PDT