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 = 2842 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 2842 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 2842 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

10275 Mountain Run Lake
Culpeper, VA 22701

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,999
Beds: 3
Baths: 4
Status: Active
SqFt: 2660
Agency: RE/MAX Regency

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 1999
Notes: This stunning colonial home is nestled on 10.34 private serene acres less than ten minutes from the town of Culpeper and five minutes from Route 29 for commuters. Surrounded by lush woods this property offers privacy and no HOA restrictions. The main level offers spacious light filled living space with foyer entrance and gleaming hardwood floors. The traditional formal living room can be discreetly closed off with the French doors to be an office for private work space and the dining room seamlessly flows to the well appointed kitchen. The kitchen boasts abundant cabinet space, beautiful marble counters, pantry, a new refrigerator, gas range , microwave and dishwasher. Enjoy the window view of nature at the kitchen table the heart of the home. Adjoining the the kitchen is the comfortable family room with custom built brick fireplace for cozy relaxing. The upper level has the primary bedroom with wonderful tray ceiling, walk-in-closet and luxury primary bath. Two additional large bedrooms, second full bath and laundry area complete this level. A forth bedroom or recreational room can be found on the lower level this room has it's own full bath and private entrance. <br /> Outdoor living is everything when you have 10+ acres. incredible wrap-around front porch complete with porch swing, back area has the best screened in porch overlooking the cleared back yard with the cut-in trail through the woods. Property has a circular driveway, double door garage and concrete parking area as-well-as the front and side area have some fencing for pets. Private entrance road is shared with only one other home owner Maintenance agreement is in place.
MlsNumber: VACU2007472


Listing Provided By: RE/MAX Regency, original listing
Name: RE/MAX Regency
Phone: (540) 341-1075
Office Name: RE/MAX Gateway
Office Phone: (540) 341-1000
Agent Name: Kaye Inskeep
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App