3758 Upper River Rd

Surrounded by 10+ lushly landscaped acres with sweeping views of the Ohio River Valley, a residence of this stature and sophistication is a rare find. LimeRidge, inspired by a Belgian country estate, captivates from every angle. As you pass through the property gate, it is evident that no expense was spared in creating this exceptional indoor-outdoor retreat. An expansive open floor plan with walls of windows maximizes the panoramic views and sets up perfectly for large scale entertaining or everyday living. Walking through the front doors, you will be welcomed by soaring ceilings and a grand staircase. Through the foyer you will find a two-story formal living room overlooking the flat back yard with stunning infinity edge pool. Continuing your tour through the first level you will find a kitchen in which a chef would want for nothing, a large butler's pantry, comfortable and spacious keeping room, expansive dining room, bar, three offices, mud room and a luxurious secondary primary suite. Upstairs you'll find the spacious primary suite a welcome retreat with beautiful views of the river from the private terrace, dual full bathrooms, and stunning custom walk-in closets. A family room, 3 additional bedrooms, all well-appointed with large closets and gorgeous bathrooms, second laundry room and separate guest apartment outfitted with a living space, full kitchen, bedroom, and full bathroom complete the second floor. The walk-out lower level is an entertainer's delight with over 4,700 sq ft of living space. Featuring large rooms and tall ceilings, you'll find a handsome full bar, walk in wine cellar, gym, sauna, great casual living spaces, additional laundry room and two bathrooms. The backyard is an oasis. Here you will find an expansive covered porch and outdoor dining area overlooking the oversized pool and hot tub, green space for children and pets to roam. In the warmer months, fishing, relaxing or reading alongside the tranquil pond will surely become a special place to unwind. Gated drive, motor court, and two separate 3 car garages, one of which serving as a multifunctional "sports court" with basketball, volleyball, pickleball and more, complete the outside. Limeridge is a one-of-a-kind property with tremendous curb appeal, meticulous landscaping, securely located with most every amenity imaginable. Each detail inside and out has been thoroughly thought through and executed flawlessly for a timeless, elegant, and welcoming effect.