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;

2518 Northumberland Drive
Jeffersonton, VA 22724
Julia Foard Lynch with CENTURY 21 New Millennium, original listing - (703) 753-7910

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $879,330
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5135 Square Feet
Agency: CENTURY 21 New Millennium
Agency Phone: (703) 753-7910

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: This ESTATE Series home has it ALL!! May 2025 Delivery!!<br /> <br /> Welcome to Lennar at Stonehaven, a master planned community located just minutes from Old Town Warrenton. This GRAND three-story home exudes elegance from the moment of entry. The first floor features a two-story Great Room with a stone fireplace that flows seamlessly into the upgraded gourmet kitchen, which features white cabinetry and iced white quartz countertops, overlooking the sunny morning room in an open design. Additional upgrades include open rails in lieu of a half wall on the staircase and an oak overlay on the stairs leading to the 2nd level. A home office with French Doors is situated off the foyer, and a 5th bedroom with 4th full bathroom is off the kitchen for a private guest suite. The second-floor hosts four bedrooms including a luxe owner’s suite, with private access to the laundry room (with tub!) from the spacious walk-in closet plus the upstairs hallway for the entire family's convenience! The finished basement includes a huge recreation room, 6th bedroom, and 5th full bathroom as well an areaway for easy access to the back yard plus the rough in for a wet bar. <br /> <br /> *Pricing and incentives are subject to change without notice. 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 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: --
ListingId: VACU2009352


Listing Provided By: CENTURY 21 New Millennium, original listing
Phone: (703) 753-7910
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.


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 = 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;
Real Estate Expert Photo for Norma Gibbs
Norma Gibbs
ASCIILong & Foster Real Estate
Call Today!: (540) 229-9026

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App