Skip main navigation
Sold for $1,135,000 on 04/02/25
  • $1,135,000

    38074 Lime Kiln Rd, Middleburg, VA 20117

    4beds
    --baths
    4,886sqft
    Single Family Residence
    Built in 2023
    3 Acres Lot
    $1,628,100 Zestimate®
    $232/sqft
    $5,653 Estimated rent

    What's special

    Huge Price Reduction! MOVE IN READY! Beautiful Private Retreat! 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!

    Zillow last checked: 7 hours ago

    Listing updated: September 23, 2023 at 03:04am

    Source: HomeServices Property Management,MLS#: VALO2055306MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Heating
    • Heat Pump(s)
    Cooling
    • Ceiling Fan(s), Central A/C
    Appliances
    • Included: Built-In Microwave, Cooktop, Dishwasher, Icemaker, Stove, Stainless Steel Appliances, Refrigerator, Oven/Range - Electric, Range Hood, Oven - Double
    Features
    • Floor Plan - Open, Kitchen - Gourmet, Kitchen - Island, Kitchen - Table Space, Primary Bath(s), Recessed Lighting, Walk-in Closet(s), Wood Floors
    • Flooring: Luxury Vinyl Plank, Ceramic Tile
    • Basement: Interior Access,Outside Entrance,Windows,Fully Finished
    • Number of fireplaces: 1
    Interior area
    • Total interior livable area: 4,886 sqft

    Property

    Parking
    • Parking features: Detached Garage, Garage - Front Entry, Inside Access
    Lot
    • Size: 3 Acres
    • Features: Adjoins - Open Space, Backs to Trees, Front Yard, Landscaping, Partly Wooded, Private, Rear Yard, Rural, Trees/Wooded
    Details
    • Parcel number: 463205773000

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Detached
    • Property subtype: Single Family Residence
    Materials
    • Vinyl Siding, Stone
    Condition
    • New construction: Yes
    • Year built: 2023

    Utilities & green energy

    • Sewer: Septic = # of BR
    • Water: Well

    Community & neighborhood

    Location
    • Region: Middleburg
    • Subdivision: Middleburg

    Other

    Other facts
    • Ownership: Fee Simple
    Services availability
    Sell for more on Zillow
    Get a free Zillow Showcase℠ listing and you could sell for .
    $1,628,100
    2% more+ $32,562
    With Zillow Showcase(estimated)
    $1,660,662