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

5725 Turner Road
Broad Run, VA 20137
Mark Willemsen with RE/MAX Gateway, original listing - (540) 341-1000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4708 Square Feet
Agency: RE/MAX Gateway
Agency Phone: (540) 341-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Are you looking for a private setting close to Haymarket, Gainesville and Warrenton with convenient access to 66 or 15/29? Then you must see this Gorgeous Contemporary "Move-in-Ready" Farmhouse! This Beautiful New Home features a large primary suite with 9-foot ceilings on the main level with dual vanities, a beautiful white soaking tub and walk-in shower. The Custom Ceramic Tile bathroom floors lead you to a large walk-in closet and one of two laundry rooms that are in this home! In the center of the home is the “Great Room”. The first thing you notice is the abundance of natural light coming through the triple glazed oversized windows. The “Great Room” provides three focal points. The first is a beautiful electric fireplace with a tastefully done wooden mantel that was harvested from the property when the home site was cleared. The second is the beautiful outdoors! If you choose to sit in the “Great Room” and enjoy nature or sit out on the beautiful TREX covered deck, it’s up to you. Lastly, you can face the beautiful open Kitchen and Dining area. The Amazing White Quartz Kitchen countertops and large 96"x 48" Island look spectacular with the three smartly chosen pendant lights. The White Soft-Close Shaker Cabinets complement the KitchenAid Stainless Steel Appliances. The Electric Range is a 5-Element Electric Slide-In Even-Heat™ True Convection and the kitchen also boasts a Combination Microwave/Wall Oven with Air Fry Mode. Off the kitchen is a large walk-in pantry with plenty of shelving! The main level also has mud room when heading into the three-car garage and a den/office by the primary bedroom. When heading to the upper level you notice the beautiful stairway with wooden steps and easy grip railing. The upper level has a loft space, laundry room, office and 3 bedrooms. Two of the bedrooms share a jack-in-jill bathroom with double sinks, beautiful white quartz vanity tops, walk-in shower, and custom ceramic tile. The third bedroom has direct access to another full bath with walk-in shower. The large office has a walk-in closet and plenty of natural light. The lower level is also amazing with its 9-foot ceilings! The lower level has a huge recreational room with walk-out, office, full bath, and tons of storage space. The recreational room is fully carpeted and has enough space for a pool table, ping pong table and even some video games. Let your imagination run wild. The full bathroom with walk-in shower also boasts ceramic tile and quartz vanity tops. The 14x12 office is also carpeted and has a large closet. The lower level also has a very large unfinished storage area for a gym or holiday decorations. This Beautiful 5,000 plus square foot home with an 8-person septic on 5 acres features so many Upgrades we provided a list in the document section for you see. So come by the Open House or schedule your showing today!
MlsNumber: --
ListingId: VAPW2080716


Listing Provided By: RE/MAX Gateway, original listing
Phone: (540) 341-7812
Office Phone: (540) 341-1000
Agent Name: Mark Willemsen
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.


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 = 2848 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;
Dan Radtke
ASCIIRE/MAX Gateway
Call Today!: (703) 283-9540

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 = 2848 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;
Heritage Financial, Inc.
Call Today!: (410) 224-7250

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App