Sold for $313,000
$313,000
38074 Lime Kiln Rd, Middleburg, VA 20117
4beds
--baths
4,886sqft
Single Family Residence
Built in 2023
3 Acres Lot
$314,200 Zestimate®
$64/sqft
$5,473 Estimated rent
Home value
$314,200
$298,000 - $330,000
$5,473/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
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: 8 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
Price history
| Date | Event | Price |
|---|---|---|
| 12/9/2025 | Sold | $313,000-72.4%$64/sqft |
Source: Public Record Report a problem | ||
| 4/2/2025 | Sold | $1,135,000-5.4%$232/sqft |
Source: Public Record Report a problem | ||
| 11/19/2024 | Listing removed | $1,199,900-3.9%$246/sqft |
Source: | ||
| 10/28/2024 | Price change | $1,249,000-3.8%$256/sqft |
Source: | ||
| 10/16/2024 | Price change | $1,299,000-1.6%$266/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,299 -0.4% | $1,155,140 +7.1% |
| 2024 | $9,334 +364.2% | $1,079,020 +369.5% |
| 2023 | $2,011 +19% | $229,800 +21% |
Find assessor info on the county website
Neighborhood: 20117
Nearby schools
GreatSchools rating
- 5/10Banneker Elementary SchoolGrades: PK-5Distance: 5.7 mi
- 7/10Blue Ridge Middle SchoolGrades: 6-8Distance: 7.3 mi
- 8/10Loudoun Valley High SchoolGrades: 9-12Distance: 8 mi
Schools provided by the listing agent
- Elementary: Banneker
- Middle: Blue Ridge
- High: Loudoun Valley
- District: Loudoun County Public Schools
Source: HomeServices Property Management. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.

