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 2
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,742,000
Beds: 6
Baths: Full: 4, ½: 2
Status: Active
SqFt: 4745 Square Feet
Agency: CENTURY 21 New Millennium
Agency Phone: (703) 753-7910

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Welcome to Willowbrook Estates, a prestigious neighborhood located near Vint Hill Road. Nestled in a cul-de-sac, this 3.07-acre property is one of the premier lots available for pre-sale. Prepare to be captivated by the Old Carolina model, a farmhouse design that exudes elegance. From the tin roof accents to the thoughtfully crafted details, every aspect of this home has been meticulously planned. Luxury finishes, including engineered hardwood and hardy siding comes standard. This to-be-built model will take your breath away. As you enter the foyer, you will feel a sense of grandeur. The office features stunning glass doors that can be transformed into a bedroom. With a walk-in closet and access to a half bath, this versatile space can adapt to your needs. The wide staircase allows for the transportation of furniture up and down. A spacious private dining room offers a warm and inviting ambiance for entertaining guests. The living room, with its large windows providing abundant natural light and picturesque views of the covered porch, is the perfect place to relax by the stone fireplace. The flow into the sunlit breakfast nook area, creates a delightful atmosphere. Step out onto the screened-in porch, where you can enjoy breakfast in a tranquil setting. The kitchen is a culinary enthusiast's dream come true. The massive island serves as the centerpiece, providing ample space for meal preparation and gatherings. With luxury appliances and a strategically placed microwave, you can overlook your lush yard while attending to your culinary creations. The main level offers an in-law suite complete with a walk-in closet and a full bath. This versatile space is perfect for guests or providing living arrangements for long-term residents. With a full and half bathroom and two bedrooms, the possibilities are endless. Practicality is met with an expansive mudroom, providing ample storage for all your needs. The side-entry two-car garage ensures easy access and adds to the overall functionality of the home. As you ascend to the upper level, be greeted by a generous loft area that can be utilized as a den, a second living room, or an entertainment space. A large laundry room, complete with a window, adds a touch of luxury to the everyday laundry task. Prepare to be enchanted by the primary bedroom, a haven of tranquility and relaxation. The luxury bathroom boasts two vanities, making morning routines a breeze. Indulge in the glamorous modern shower, featuring a full seat bench, and rain showerhead. This bedroom offers ample storage with two walk-in closets, and the added convenience of an extra linen closet located just outside the bathroom. The double doors that lead to a beautiful balcony, offer a private retreat for moments of reflection and serenity. The upper level also features three additional bedrooms, each with their own closet, providing comfortable and stylish living spaces for family members or guests. Another full bath adds convenience and ensures everyone's needs are met. Above the garage, you will find a storage space that has the option to be finished, allowing for even more versatility and customization. Descend to the basement and discover a vast and open space. The recreational area has been thoughtfully finished with luxurious vinyl planking, creating an inviting atmosphere for gatherings and relaxation. A half bath adds convenience, while the unfinished space offers endless potential. You can add the option to transform it into a cozy fireplace lounge, a stylish wet bar, or even a state-of-the-art theater. You can also add a full bath and a bedroom with a walk-in closet. The Old Carolina model is a testament to convenience, farmhouse elegance, and luxurious living. No space is wasted, and every detail has been meticulously planned to provide a home that exceeds expectations. Water Creek Homes is proud to present this exceptional opportunity to build your dream home on lot 2 at Willowbrook Estates.
MlsNumber: --
ListingId: VAFQ2013168


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