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

20149 Stonehaven Avenue
Jeffersonton, VA 22724

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,990
Beds: 4
Baths: 4
Status: Active
SqFt: 2352
Agency: Century 21 New Millennium

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: SUMMER 2024 DELIVERY! PLANNED MODEL HOME WITH SO MANY UPGRADES!! The plan for this home to be the Edenton II model has since been cancelled because the townhomes sold so fast!! The Townhomes at Stonehaven are almost sold out before the model home could even be fully decorated. This planned model has SO many upgrades that include the 10x18 deck and because this unit is an end unit, it has added brick on the side of the home, which also adds, additional windows. This home features an electric fireplace, added lighting package, LVP flooring and so much more!! SUMMER 2024 DELIVERY! Additional details in the floorplan description below!<br /> <br /> $10k in closing cost assistance with Lennar Mortgage! *Prices are subject to change without notice.*<br /> <br /> Welcome to Lennar at Stonehaven, a master planned community located just minutes from Old Town Warrenton. Come tour the Edenton! The first level of this three-story end unit townhome is host to a 4th bedroom or office space and a connected full bathroom. Upstairs, the living room, Great Room, half bathroom, and upgraded rear kitchen share a convenient and contemporary open floorplan with EVP flooring for a clean look. The kitchen boasts of a beautiful island, white Ellis PureStyle cabinets, white ornamental granite countertops, and pendant lights. Three bedrooms occupy the second level in addition to a laundry area for added convenience. Among the upstairs bedrooms is the luxe owner’s suite which is complemented by the en-suite bathroom and walk-in closet. A rear entry 2-car garage completes the home. Enjoy outdoor living, with a deck off of the rear of the townhome! You don't want to miss this opportunity!<br /> <br /> Standard Features include GE appliance package, Video Ring doorbell. Stonehaven is a master-planned community with new homes now selling, in Jeffersonton, Virginia. It features a 240-acre preservation buffer along the Rappahannock River and over 500 acres along Route 621. Planned amenities to be built include a future clubhouse, swimming pool, tennis courts, trails, a tot lot and more. This prime location is convenient for work and play! Photos are for illustrative purposes only.
MlsNumber: VACU2007724


Listing Provided By: Century 21 New Millennium, original listing
Name: Century 21 New Millennium
Phone: (703) 753-7910
Office Name: CENTURY 21 New Millennium
Office Phone: (703) 753-7910
Agent Name: Julia Foard Lynch
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