38074 Lime Kiln Rd, Middleburg, VA, United States being shown by Long & Foster Real Estate Inc. with MLS # VALO2055306

LISTED WELL BELOW APPRAISED VALUE OF 1.8 MILLION. PRICED TO SELL!!!MOVE IN READY! Beautiful Private Retreat! Multi-generational home with potential rental income from the apartment in the detached carriage house!Versatile Stanley Martin Custom Home situated on a 3 acre wooded lot across from Goose Creek. Three finished levels and a separate carriage house apartment provide almost 5000 sq. ft of brand new space designed to accommodate multi-generational families and work-from-home living possibilities! Main level Owner's Suite! Beautiful open floor plan features upgraded gourmet kitchen with stainless steel luxury appliances and quartz countertops, a large center island with pendant lighting, recessed and under-cabinet lighting, soft-close white cabinets and a large walk-in pantry. Adjoining family and dining areas feature a gas fireplace and opens out to the rear porch, deck and stairs down to the yard. Also on the main level is a large laundry/storage/mudroom which opens out to the rear porch as well! Upper level features a full bath, 2 bedrooms, a loft and an office with loads of storage for all your business needs. Full finished walkout basement with a flexible-use floor plan designed for adult living - perfect office/den with separate entry & plenty of storage, full bath and wet bar complete with refrigerator, built-in microwave and dishwasher, plus rough-in for a stackable washer/dryer. A separate Rec Room for media/games/fitness - you choose! Detached 3 car garage ""carriage house""Â� features a full-size 1 bedroom apartment with full kitchen, great room, study, and full bath with rough in for stackable washer/dryer. All this gives you a flexible lifestyle with over 5000+ sqft of living space, 4 bedrooms, 4.5 baths plus loads of office/den, recreational and storage space!