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

15619 Jillians Forest Way
Centreville, VA 20120

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,995,000
Beds: 5
Baths: 7
Status: Active
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2004
Notes: EXQUISITE, CUSTOM, CALIFORNIA-STYLE HOME NESTLED ON ALMOST 6 PRIVATE ACRES BACKING TO PARKLAND!! This ONE-OF-A-KIND HOME is an architectural masterpiece and includes luxurious features that will take your breath away****EXTERIOR: Tree-lined driveway & cobblestone paths of Pennsylvania bluestone and custom wrought iron gates****AWARD-WINNING LANDSCAPE!***The front, designed for all seasons has evergreens, Japanese Maples, pampas grasses, roses, & boxwoods****Ample parking in the 4-CAR GARAGE or long driveway****The resort like backyard includes boulders unearthed in construction, HEATED FREEFORM BLACK BOTTOM SALTWATER POOL, an in-ground hot tub, masonry walls, bluestone walkways, terraces, paver patios, an outdoor granite island with a built-in grill, & an outdoor stone fireplace****The SEPARATE 2-LEVEL POOL HOUSE features bifold patio doors, a custom barrel ceiling, loft space, a wet bar, a full bathroom, and garage storage space. (POOL HOUSE IS LARGE ENOUGH TO BE POTENTIAL LIVING QUARTERS-about 1,050 sq. ft.!)****MAIN LEVEL: Inside the home, you'll be greeted by a grand foyer and elegant staircase****The chef's kitchen offers HIGH-END APPLIANCES including a SubZero refrigerator, 6-burner Dacor stovetop, 2 Dacor convection ovens, a Meile dishwasher, & a deep fryer/steamer. There are also two granite islands, a pot filler, prep sinks, a walk-in pantry, and a breakfast bay****The kitchen flows into the sunlit family room featuring a floor-to-ceiling stone fireplace & built-ins****Banquet-sized dining room offers a butler's pantry****The main level library boasts custom cherry built-ins****MAIN LEVEL PRIMARY BEDROOM with sliding glass doors that open to a private 4-season room heated by a quaint gas fireplace****The primary bath offers a heated floor, dual vanities, a soaking /bubbling tub, a towel warmer, a separate shower with rain shower heads, and a 184 SQ. FT. WALK-IN CLOSET with custom shelving/drawers.****The 2nd family staircase landing has custom built-ins/cubbies and access from the garage or front****UPPER LEVELS: ****Private office between the 1st and 2nd floor****The 2nd floor features a playroom or 4th BR & 3 more spacious bedrooms with ample closet space****Three ensuite bathrooms complete the upper level, one with hall access****BASEMENT: Entertain in style with a CUSTOM BUILT STONE/WOOD WET BAR with storage, dishwasher drawer, & sink****The media room is equipped with movie chairs (seating for 9) and surround sound****STUNNING WINE TASTING ROOM with a barrel ceiling and a CLIMATE CONTROLLED WINE CELLAR creating a truly luxurious experience****OTHER FEATURES INCLUDE: ***50 zone irrigation system***tankless water system***3-zone heat pumps***400 amp service***whole house generator protects 200 amps****Conveniently located near shopping, parks, and restaurants. Believe it or not, there is MUCH MORE!! ****CHECK OUT THE 3-D INTERACTIVE TOUR!
MlsNumber: VAFX2172500


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Burke/Fairfax Station/Clifton
Office Phone: (888) 536-0216
Agent Name: Spencer R Marker
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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 = 3481 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 Kathy Worek
Kathy Worek
ASCIIRE/MAX Gateway
Call Today!: (703) 401-4376

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 = 3481 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 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