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!
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
Zillow last checked: 7 hours ago
Listing updated: September 23, 2023 at 03:04am
Source: HomeServices Property Management,MLS#: VALO2055306

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