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 = 2877 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 = 2877 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 = 2877 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;

13154 Mill Creek Court
Reva, VA 22735

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 1960
Agency: Keller Williams Realty, Chantilly Ventures, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2003
Notes: Discover the epitome of mountain views and river front living at 13154 Mill Creek Ct, Reva, VA 22735-2339. This captivating Colonial-style home has been completely remodeled in 2022!! It's a beautiful combo marrying modern luxury with breathtaking natural country beauty. Nestled on a picturesque hillside, the property offers an incredibly rare feature – stunning mountain views from the back deck, and rear of the property also coupled with a serene backdrop of the Hazel River. As you step inside, you're greeted by an inviting space featuring an expansive covered Front Porch, perfect for soaking in the peaceful tranquility of the surroundings. The interior exudes elegance with an open formal living room den, Dining room, and a recently updated eat-in Kitchen boasting quartz counters and stainless steel appliances. Cozy up in the open family room with its fireplace, or enjoy the convenience of the Laundry-Mud Room and attached two-car side load garage. Retreat to the Owner's Suite with views of the mountains with its walk-in closet and private bathroom. The upstairs also features two additional spacious Bedrooms and a full bath The full unfinished walkout lower level offers potential for storage or future expansion, complete with a bath rough-in. Outside, revel in the privacy of the fenced back yard and a dog run on 5 peaceful acres, extending down to the Hazel River. Oh did we mention HIGH SPEED Comcast Internet!! Recent updates include a new roof in 2021, HVAC replacement in 2020, water heater replacement in 2018, and a new well pump. Enjoy easy access to Rt 29, making Culpeper or Madison just minutes away. Don't miss out on this rare opportunity to experience mountain living at its finest. Schedule a viewing today and make this your dream home before it's too late!
MlsNumber: VACU2007334


Listing Provided By: Keller Williams Realty, Chantilly Ventures, LLC, original listing
Name: Keller Williams Realty, Chantilly Ventures, LLC
Phone: (703) 815-5700
Office Name: Keller Williams Chantilly Ventures
Office Phone: (703) 815-5700
Agent Name: Mr. Gayle T Bailey II
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