Title Page Background
DEBUG FN args: Array ( [0] => 2899 [1] => [2] => [3] => agent ) BEFORE: Site: 2899 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2899 Igate: njhud LocID: 2899 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2899 AND i.igate IN ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2899 [1] => [2] => [3] => lender ) BEFORE: Site: 2899 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2899 Igate: njhud LocID: 2899 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2899 AND i.igate IN ('vahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2899 [1] => [2] => [3] => other ) BEFORE: Site: 2899 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2899 Igate: njhud LocID: 2899 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2899 AND i.igate IN ('vahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

4564 Dodds Mill Drive
Haymarket, VA 20169

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,799,999
Beds: 5
Baths:
Status: Active
SqFt: 8995 Square Feet
Agency: Weichert, REALTORS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: Stunning Hollister Model from the Estate Collection located in Award-Winning Dominion Valley Country Club. *A Gated Community with Resort Style Amenities including a Renovated Clubhouse*This beautiful Estate home is situated on a premium Cul-de-sac lot that backs to Conservation*This Immaculate home features nearly 9000 Sq Ft of Finished Living space with 5 bedrooms and 6.5 baths on Three Fully Finished Levels with Soaring 10 ft ceilings*Beautiful front porch with Flagstone Pavers*Two Story Foyer with Dual Staircase opens up to Formal Dining Room and Formal Living Room with Crown Molding* Five Inch Engineered Hickory Hardwood Flooring*Amazing Gourmet Kitchen with Professional 6 Burner Gas Range with Griddle, Double Oven, Wall Mounted Hood, and Overhead Heat Lamp*GE Monogram Built-in Wall Oven and Microwave Oven*Stainless Steel Appliances*Gorgeous Granite Countertops with Beautiful Glass Tile Backsplash*Oversized Mediterranean PorcelainTile Floors*Expansive Center Island with Tons of Storage and Glass Pendant Lights*Butler's Pantry leads to Formal Dining Room*Supersized Walk-In Shelved Pantry*Large Breakfast Area with Access to Enclosed Outdoor Living Space with Trex Deck*Large Mud Room off the Kitchen leads to 3 car Garage and features Large Mediterranean Porcelain Tile Floors, Storage Closet and Wash Tub*Huge Great Room with Fireplace and Engineered Hardwood Floors*Light Filled Sun Room off the Great Room with Oversized Mediterranean Porcelain Tile Floors*Expansive Office with Double Doors and Engineered Hardwood Floors*Primary Bedroom Suite with Tray Ceiling,Ceiling Fan, Sitting Area and Three Expansive Walk-In Closets one with Center Island with Granite and Storage*Spa Like Primary Bath with Double Vanities with Granite*Porcelain Ceramic Tile*Sconces*Freestanding Soaking Tub*Shower with Built In Bench Seat Enclosed in Tile*Princess Bedroom Suite with Walk-In Closet, Ceiling Fan, and En Suite Bathroom with Cultured Marble countertop, Tub/Shower, Engineered Hardwood Floors*Secondary Bedroom 3 with Gorgeous Wall of Built-Ins, Walk-In Closet, Ceiling Fan, and En Suite Bath with Quartz Countertops with Tub/Shower, Engineered Hardwood Floors*Massive Secondary Bedroom 4 has Two Walk-In Closets, Engineered Hardwood Floors,Ceiling Fan, En Suite Bath with Quartz Countertops and Tub/Shower* Secondary Bedroom 5 has En Suite Bath with Cultured Marble Countertops, Tub/Shower and Engineered Hardwood Floors, Ceiling Fan*Upper Level Laundry Room includes Ceramic Tile Floor, Built In Cabinets and Wash Tub*Fully Finished Walk Out Basement with Amazing Entertaining Space with Built In Bar with Quartz Countertops, Double Sink, Stainless Steel Dishwasher, Second Stainless Steel Refrigerator, Upgraded Cabinets Surrounded by Custom Colorado Style River Rock Wall and Luxury Vinyl Flooring* Full Bathroom In Basement with Stand Alone Shower with Floor to Ceiling Tile, Ceramic Tile Floor *Full Dance/Yoga Studio with Ballet Bar, Special Flooring with Extra Cork Padding and Mirrored Wall*Enormous Exercise Room with Rubberized Flooring, Large Closets and Windows this could be 6th Bedroom.*Storage Closets Galore*CAT 6 Internet Cable*Sonos Sound System with Speakers in Kitchen, Screened in Porch and Deck*Gorgeous Stone Paver Patio with Built In Fire Pit and Walkway*Professionally Landscaped*Aluminum Fenced Rear Yard*Garage has Built In Overhead Shelving*Excellent Schools Located Inside Community*Minutes to Major Commuting Routes Including I-66, 29, and 50*DVCC Amenities Include: Beautiful Clubhouse*Sports Pavilion with Indoor Sports Court*Fitness Center*4 Outdoor Swimming Pools*Indoor Pool*Tennis/Pickleball Courts*Basketball Courts*Sand Volleyball*Scenic Walking Trails*Tot Lots* 2 Stocked Fishing Ponds*Trash and Snow Removal* Fitness and Full Golf Memberships available* Arnold Palmer Championship Golf Course*Owner has VA and DC active RE license.
MlsNumber: --


Listing Provided By: Weichert, REALTORS, original listing
Phone: (703) 368-1184
Office Phone: (703) 368-1184
Agent Name: Catherine Woodson
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => prince-william [3] => VA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: prince-william State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: prince-william State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2899 AND i.igate IN ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Caryl Dawson
Caryl Dawson
ASCIISamson Properties
Call Today!: (703) 598-7801

Local Mortgage Pro

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => prince-william [3] => VA [4] => lender [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: prince-william State: VA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: prince-william State: VA Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2899 AND i.igate IN ('vahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Firas Bannourah, Loan Officer, NMLS#1671349
Firas Bannourah, Loan Officer, NMLS#1671349
ASCIIMovement Mortgage
Call Today!: (703) 489-3433

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App