**Stunning Custom-Built Home for Sale in Limestone | Herscher** Don't miss this extraordinary opportunity to own a fully updated 3,150-square-foot residence nestled in the sought-after River Bend Subdivision. Spanning 1,850 square feet on the main level, this home boasts three- four generous bedrooms and two exquisite custom bathrooms, both beautifully remodeled in 2023 with luxurious heated floors. The home features a brand-new HVAC system and water heater, along with a dedicated water heater for the heated floors. Additional enhancements include a new roof, a Vac-U-Flo central vacuum system, an irrigation system, a radon mitigation system, and a whole-house generator-each installed in 2023 for peace of mind. Step into the open-concept kitchen and living area, where luxury vinyl flooring exudes elegance. The inviting eat-in kitchen is a chef's dream, outfitted with top-of-the-line appliances, a spacious island perfect for family gatherings, a modern backsplash, and charming, unique decor. The main bedroom and living room are adorned with new carpeting, creating a cozy yet sophisticated ambiance. The expansive basement offers a remarkable 1,300 square feet of entertaining space, featuring heated floors, soaring 8-foot tray ceilings, and a full bar that will impress. Complete with three beverage coolers, an ice maker, and stylish bar stools, it's the ideal spot for gatherings. An advanced audio-video system with multiple televisions and a stunning video wall allows for simultaneous viewing of up to five programs, ensuring every entertainment option is at your fingertips. The property includes a spacious three-car heated garage with a ceramic-tiled floor and ample cabinetry for all your storage needs. Step outside to discover a backyard oasis. Enjoy outdoor living with a lovely patio, a chic bar, and an inviting 18x36 heated pool, all surrounded by secure fencing. The fully equipped outdoor bar is perfect for gatherings, featuring three beverage coolers and an AV system, along with a convenient porta-potty and a 12'x14' shed. This beautifully appointed home is ready for immediate occupancy and offers an unparalleled lifestyle opportunity for discerning buyers. Don't let this rare gem slip away!