Extensively Updated 4BR/4.5BA Home with Mother-in-Law Suite, Heated Saltwater Pool, Creek & Mountain Views on 2.51 Acres Rarely does a property offer this much space, privacy, and natural beauty while remaining conveniently located within the city limits. Situated on an incredible 2.51-acre park-like setting with a strong-flowing creek and mountain views. 540 Old Shiloh Road delivers the perfect blend of country charm and city convenience. This beautifully maintained home features 4 bedrooms, 4.5 bathrooms, and a fully renovated mother-in-law suite, with extensive updates completed since 2022. The main living areas showcase hardwood flooring, while the upstairs area has new luxury vinyl flooring, fresh interior paint, updated bathrooms with new vanities, showers, and toilets, plus ceiling fans throughout the bedrooms. The spacious primary suite offers a luxurious walk-in shower with dual shower heads and an added linen closet for enhanced functionality. Additional improvements include 10 new double-hung windows upstairs, an updated laundry room with utility sink, new kitchen cabinet hardware, and updated door hardware throughout. The finished basement has been transformed into a private mother-in-law suite featuring new cabinetry, appliances, new luxury vinyl flooring, paint, a full bathroom, and washer/dryer hookup--ideal for multi-generational living, guests, or potential rental opportunities. Outdoor living is exceptional with a huge screened porch and additional covered deck space overlooking the mountains, countryside, heated pool, and creek. Recent improvements include new decking, stairs, railings, and a covered deck with a metal roof, creating the perfect setting for relaxing or entertaining. The 35' x 22' natural gas-heated pool has been extensively upgraded with a saltwater conversion, robotic cleaner, solar cover, and new filter system. The property also features extensive landscaping enhancements, professional lawn treatments, and a beautifully maintained yard that feels like a private retreat. Additional highlights include dual-zoned heat pumps, natural gas service through Atmos Energy, seven security cameras, LeafGuard gutters, freshly painted exterior doors, and a permanent brick stain applied to the home, retaining wall, front stoop, and pool stairs with a lifetime warranty through Creative Masonry. Move-in ready and loaded with upgrades, this exceptional property offers a rare opportunity to enjoy acreage, a creek, mountain views, a heated pool, and versatile living space--all in a convenient city location. All information taken from a third-party source (courthouse/tax records) and to be verified by the buyer/buyer's agent. Drawn in lines are approximate. Some elements (fires in fireplaces, twilight shading, lighting, etc.) have been added/modified digitally. Rooms noted have been virtually staged for decorating ideas only, not to scale or representative of any product.