Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2873 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2873 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2873 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

39937 Charles Town Pike
Hamilton, VA 20158
Beckwith Bolle with Carter Braxton Preferred Properties, original listing - (703) 777-7772

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 7042 Square Feet
Agency: Carter Braxton Preferred Properties
Agency Phone: (703) 777-7772

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1985
Notes: LOCATION! LOCATION! And NO HOA!!! Welcome to this stunning ranch style home, conveniently located on a picturesque 5.6-acre lot in Hamilton! Perfect location with all paved private driveways and no HOA! You'll be amazed by the amount of care and updates that have been put into the property. Updated Anderson windows and French doors give this home bright natural lighting in every room. Well maintained Solid Oak Hardwood floors are through the foyer and formal dining room, hallways and bonus room/den. Huge Dining Room with wood burning fireplace, beautiful rustic chandelier, comes with beautiful solid cherry dining furniture with table seating for up to 12, two china cabinets and matching buffet that conveys to new owner. The bright large eat-in kitchen with beautiful tile floors, features custom cabinetry, large pantry, smaller utility closet, full extension pull out drawers throughout, 48” KitchenAid side by side refrigerator, double GE Profile Ovens, 5 burner induction cooktop built into the tiered island with granite countertop, and a pull out cabinet shelf with interior plug built for KitchenAid Mixer. The large kitchen opens to a cozy family room, with a wood burning fireplace. Updated butler’s pantry includes new built in clear ice maker and beverage refrigerator with bar sink all set in beautiful black galaxy granite countertops and custom cherry cabinets with upper glass cabinets and dimmable interior lighting. French doors in the family room lead to a large wood deck out back, along with large picture windows in the over sized kitchen provide beautiful views of an 11-acre lake and the short hill mountains. Featuring a washer/ dryer in laundry (convey) with ample cabinet and countertop space with a utility sink, also includes a glass pedestrian door to a small wood deck on the back of the home. This home includes a large sunroom with French doors that open to a beautiful Trex deck in the front of the house and another set of French doors that open to the back, perfect for enjoying the outdoors and cross winds. Great for open entertainment.<br /> <br /> This home features 22 ceiling fans throughout including the three car garage with in floor heating, floor drains and vinyl wainscoting so cars can be washed indoors even in the winter. Almost all interior walls are insulated providing sound proof living and quiet separate entertaining spaces.<br /> <br /> This huge ALL BRICK with a total 9,990 sq ft. home, 7300 sq ft. of climate controlled living area with 2690 sq ft. in garage space, comes with two master ensuites on opposite sides of the home both with his and her large custom closets. One suite includes a large corner soaking tub, separate shower, double vanity and tile floors. The other suite includes custom cherry cabinets with double vanity with granite counter top, large custom tile shower with seat and grab bars and matching tile floors with radiant floor heat. There are two other spacious bedrooms and a full bath featuring 5’ countertop with sink, tile floors and a bathtub shower combination. Also in this bath is a huge custom linen closet with double sliding mirrored doors. Loads of storage space! BONUS: This home comes with a two level newly updated bonus space with a separate pedestrian entry door, french doors to back yard, lovely dormer window areas and huge arch windows with awesome views. This area has 11 ceiling fans and all recessed lighting with each level featuring separate new HVAC units. Intended for an in-law suite and used for home office and over flow living and entertainment space, it could easily be used for a multi-generational private living area. Full list of improvements in Documents. Some of note include Kinetico 4 stage water filtration system with water softener, new upgraded electrical panels, 50 gal. water heater, new 40-year architectural roof, gutters/downspouts and
MlsNumber: --
ListingId: VALO2075358


Listing Provided By: Carter Braxton Preferred Properties, original listing
Phone: (703) 777-7772
Office Phone: (703) 777-7772
Agent Name: Beckwith Bolle
Disclaimer: Copyright © 2025 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2873 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Scottie Vosburgh
Scottie Vosburgh
ASCIIAtoka Properties
Call Today!: (703) 727-7838

Local Mortgage Pro

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2873 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Heritage Financial, Inc.
Call Today!: (410) 224-7250

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App