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

0 Greenwich Rd, Lot 3
Nokesville, VA 20181
Joshua Geyer with CENTURY 21 New Millennium, original listing - (703) 753-7910

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,579,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 3535 Square Feet
Agency: CENTURY 21 New Millennium
Agency Phone: (703) 753-7910

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Welcome to Willowbrook Estate, an exclusive luxury neighborhood to be built! Homesite/Lot 3 is a premier lot spanning 2.377 acres, situated in a cul-de-sac for added privacy. This exceptional lot offers a spacious yard and the opportunity to build the stunning Bellview model home.<br /> As you step inside, you'll be greeted by a charming porch with two beautiful pillars. The foyer opens up to a spacious dining room, featuring large windows that overlook the front porch. Down the hallway, you'll find a convenient powder room and a private office with double doors and windows, providing a pleasant view of the front yard.<br /> The home is thoughtfully designed to create a cozy and inviting atmosphere. The wide-set stairs, tucked away from the foyer, lead to the great room. This open floor plan encompasses an eat-in breakfast area, a stylish island, a walk-in pantry, and a beautiful fireplace. Adding to its allure, the home boasts a Butler's pantry, conveniently located between the formal dining area and the breakfast nook.<br /> The main level also includes a primary bedroom suite, featuring a luxurious primary bath with a tub, a shower, and two elegant vanities. Adjacent to the primary suite, you'll find a private laundry room, providing maximum convenience and functionality.<br /> Step outside from the great room and kitchen area onto the open deck, where abundant windows and lighting create a bright and airy ambiance. The Bellview floorplan offers the option (not include) to add a fifth bedroom and a fifth full bath on the first floor, providing flexibility to accommodate your needs.<br /> The main level showcases high-quality finishes, including engineered hardwood in the main living areas and luxury appliances. Every detail of this design has been meticulously considered to ensure a truly exceptional living experience.<br /> As you ascend the wide-set stairs to the second floor, you'll be captivated by the view of the great room from the catwalk. The upstairs features four spacious bedrooms, each with its own full bath and generous closet space. Additionally, there is the option (not included) to add a loft and create a sixth bedroom, offering versatility to suit your preferences.<br /> The lower level of the home features a spacious finished basement with luxury vinyl planking, perfect for entertaining. There is also a finished half bath, and the potential to further enhance this space with a wet bar, additional bedrooms, bathrooms, or even an exercise or media room (not included). Water Creek Homes, the esteemed luxury custom homebuilder, will guide you through the process and help you customize the basement to your liking.<br /> Overall, the Bellview model offers a stunning main level living experience with convenience for all. The homesite, located in the prestigious Evergreen Meadows exclusive community built by Water Creek Homes, provides a fantastic backdrop for outdoor entertainment and relaxation.<br /> Don't miss the opportunity to secure Lot 3 with the Bellview model, crafted with the utmost quality and integrity by Water Creek Homes, a renowned builder. Experience luxury living at its finest in this remarkable neighborhood.
MlsNumber: --
ListingId: VAFQ2013170


Listing Provided By: CENTURY 21 New Millennium, original listing
Phone: (703) 753-7910
Office Phone: (703) 753-7910
Agent Name: Joshua Geyer
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 = 2899 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;
Real Estate Expert Photo for Dee Thomasson
Dee Thomasson
ASCIILong & Foster Real Estate, Inc.
Call Today!: (229) 563-8330

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 = 2899 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;
Real Estate Expert Photo for Dejoun Lee, NMLS#2524637
Dejoun Lee, NMLS#2524637
ASCIIThe Money Store
Call Today!: (703) 336-9767

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App